Open Database Connectivity (ODBC) is an open standard, Application Programming Interface (API) for accessing a database.

Connection String

To Connect to ODBC, set the DSN Name Property.

Connection String Parameters

Parameter Description
DSN Set this to the Data Source name of the ODBC.

Connecting to ODBC

The quickest solution for making a connection is by setting up a Data Source Name (DSN) Administrator, which handles the authentication of connections, based on the context of your request. Setting up a DNS Administrator will not be covered in this tutorial. Once set up, all that need be placed into the connection string is the DSN label.

Data Migrations

To check for the data migrations:

  1. Add a new connection in Loome Integrate as shown.

    • Go to tasks and click on Connections.

    • Add a new connection Using Add New Connection Option.

    • Choose ODBC Connector from the available Connector Options.

  2. Using the connection string parameters created (You can Specify the Username and password either in the connection string or in the box Shown Below), Verify the connection using the VERIFY CONNECTION Option in Loome Integrate. Once the Connection is verified, Insert the Connection Using Insert Option.

  3. Create a Job Using ADD A JOB option in Loome Integrate, add a data migration task to the job.

  4. Create a New Task by right clicking job list and then Add a New Task Option. If you want to edit an Existing Task Use Edit Task.

  5. Choose a Data Migration Task.

  6. Choose the source and the destination for the migration of data. Name the Task.

  7. Choose the Tables or the data that need to be migrated from the source to the destination. You can Copy all Tables by checking Copy all tables box.

  8. Execute the Job. Check for results and the details of the data migrated in Execution History.