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.
To centralize database connection parameters you have defined in a Job, click 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:
Create a configuration file, for example
impala_cdp71.conf, with the following
structure:
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.