ODBC Connector

Back Next

Use the serverless runtime environment

You can use a serverless runtime environment hosted on AWS or Azure to connect to ODBC-compliant databases.

Before you configure an ODBC connection using the serverless runtime environment, perform the following tasks:

Add the ODBC drivers in the Amazon S3 bucket or Azure container in your AWS or Azure account.

Configure the .yml serverless configuration file.

Add the ODBC drivers in the Amazon S3 bucket or Azure container in your AWS or Azure account: Perform the following steps to use a serverless runtime environment in an ODBC connection:
Create the following structure for the serverless agent configuration in AWS or Azure:
<Supplementary file location>/serverless_agent_config

Add the ODBC drivers in the Amazon S3 bucket or Azure container in the following location in your AWS or Azure account:
<Supplementary file location>/serverless_agent_config/ODBC

Configure the .yml serverless configuration file: Perform the following steps to configure the .yml serverless configuration file in the serverless runtime environment:
Copy the following code snippet to a text editor and specify the driver file names and DSN entries:
version: 1 agent: dataIntegrationServer: autoDeploy: odbc: drivers: - fileCopy: sourcePath: ODBC/<Driver_filename> - fileCopy: sourcePath: ODBC/<Driver_filename> dsns: - name: "<Name of the ODBC database>" entries: - key: Driver value: <Driver_filename> - key: Description value: "<Description of the driver>"

where the source path is the directory path of the ODBC drivers in AWS or Azure.

The DSN entries vary based on the driver you want to add to the serverless runtime location.

The following example shows the DNS entries for the Microsoft SQL Server driver:
version: 1 agent: dataIntegrationServer: autoDeploy: odbc: drivers: - fileCopy: sourcePath: ODBC/DWdb227.so - fileCopy: sourcePath: ODBC/DWdb227.so dsns: - name: "<SQL server>" entries: - key: Driver value: DWsqls227.so - key: Description value: "SQL Server 2014 Connection for ODL" - key: HostName value: INVW16SQL19 - key: PortNumber value: 1433 - key: Database value: adapter_semantic - key: QuotedId value: No - key: AnsiNPW value: Yes

Ensure that the syntax and indentations are valid, and then save the file as
serverlessUserAgentConfig.yml
in the following AWS or Azure location:
<Supplementary file location>/serverless_agent_config

When the .yml file runs, the ODBC drivers are copied from the AWS or Azure location to the serverless agent directory and the DNS entries are updated in the
odbc.ini
file.