Implementation Guide › Implementation › Data Gathering (Data Source Expert) › How to Configure Adapters and Translations › SQL Adapters

SQL Adapters

SQL Adapters are basically the use of the SQL Adapter generic component (SQL Adapter executable) with the appropriate settings in the configuration file. The SQL Adapter can connect to all data sources that support ODBC and OLEDB. Connection is established via connection string. The appropriate driver should be installed on the server on which the Adapter is installed.

Data sources examples:

• Oracle
• SQL Server
• Access
• Excel
• Text files, CSV files (these could also be connected to via the TEXT adapter, but ODBC connection often provides extra filtering/querying capabilities).

SQL Adapter workflow:

• Open the connection.
• Replace local variables with the last key field values.
• Auto-complete, build the where clauses of the queries and concatenate to the end of the queries.

  Execute the query and get recordset.

  For each record in the recordset returned by the query:

  • Find the correct InputFormat.
  • Build the Event record.
  • Translate the record.
  • Update the key fields value in the control file.
• Close the connection.
• Go to sleep.