How to create a Connection for ODBC Connector

Create a new connection to connect to an ODBC connector.

To create a connection for ODBC connector:

  1. Click the Integrations Manager module on the left side pane.
  2. Click the Add button in the Connections section on the left side.
    Figure 1. Add ODBC Connection


  3. In the Add Connection window, do the following:
    1. Select ODBC Connector from the Select Connector drop-down.
    2. Enter the connection alias name in the Connection Alias field.
    3. Enter the host address in the DB Hostname field.
    4. Enter the username in the Username field.
    5. Enter the password in the Password field.
    6. Enter the database name in the Database Name field.
    7. Enter the port number in the Database Port field.
    8. Select the database type from the Database Dialect drop-down.
    9. Click Test Connection to test the connection.
    10. Click Save Connection if the connection is successful.

    The Connection is created successfully and you can see it in the Connections section.

    In this section, you can,
    • Click the More icon next to the connection and select View Details to see the connection details.
    • Click the More icon next to the connection and select Edit Connection to edit the connection details.
    • Click the More icon next to the connection and select Delete Connection to delete the connection.