# Setting up a database connection

To create a database connection from scratch, expand Metadata in the Repository tree view, right-click Db Connections and select Create connection from the contextual menu to open the database connection setup wizard.

To select the type of the database to which you want to connect, type in the name of the database in the Find text box or scroll down directly in the list, and then, click the desired database. ![Database Connection dialog box.](https://help.qlik.com/talend/en-US/studio-user-guide/Resources/images/database-connection-microsoft.png)

To centralize database connection parameters you have defined in a Job, click ![Save the property to Metadata](https://help.qlik.com/talend/en-US/studio-user-guide/Resources/images/save.svg) in the Basic settings view of the relevant database component with its Property Type set to Built-in to open the database connection setup wizard.

To modify an existing database connection, right-click the connection item from the Repository tree view, and select Edit connection to open the connection setup wizard.

Then define the general properties and parameters of the connection in the wizard.

Information noteNote: To avoid connection failure to the Impala database with Kerberos authentication, do the following steps:

1. Create a configuration file, for example impala\_cdp71.conf, with the following structure:
   ```
   Client {
   com.sun.security.auth.module.Krb5LoginModule required
   useKeyTab=true
   keyTab="/PathToTheClusterKeytabInYourMachine.keytab"
   principal="automation@BIGDATA.COM"
   doNotPrompt=true;
   };
   ```
2. Edit the <TALEND\_HOME>/configuration/config.ini directory with the following properties that links to the created configuration file:
   ```
   java.security.auth.login.config=/Users/Desktop/impala_cdp71.conf
   java.security.krb5.kdc=sur-qa-017.talend.lan
   java.security.krb5.realm=BIGDATA.COM
   ```

### In this section

* [Defining general properties](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2024-11/defining-general-properties?id=850)
* [Defining connection parameters](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2024-11/defining-connection-parameters)