An Odbc connection can be used when you want to create for instance a connection on an Oracle database.

Select the Odbc connection type and click Create. In the Odbc Connection dialog box click Build.

 

In case the ODBC data source does not exist yet on your system, create a new data source by clicking New...

 

Select the type User Data Source or System Data Source according to the desired availability.

 

Select a driver for your data source. In this example an Oracle driver (OraClient 11g_home1) is selected that was installed together with the Oracle client.

 

Create the Data Source Name, the Service Name as well as the User ID. Subsequently test the connection by clicking Test Connection.

 

When testing the connection you will be prompted to enter the password. Type the password and then click OK.

 

The connection string is displayed in the connection string window. The connection string contains some redundant attributes that you cannot remove.

 

The Connection String for the ODBC connection on the Oracle database must contain following parameters: DSN / UID / PWD / DBQ

 

Subsequently click Test to check whether the connection could be successfully built.