ODBC Connector

Back Next

Prerequisites to configure serverless runtime environment with ODBC Connector

You can use the serverless runtime environment with ODBC Connector to connect to ODBC-compliant databases.

Before you use a serverless runtime environment with ODBC Connector, complete the following prerequisite tasks to add the ODBC driver to the serverless runtime location:

Create the following structure for the serverless agent configuration in AWS:

<Supplementary file location>/serverless_agent_config

Add the ODBC drivers in the Amazon S3 bucket in the following location in your AWS account:

<Supplementary file location>/serverless_agent_config/ODBC

Copy the following code snippet to a text editor and specify the driver filenames 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.

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 location:

<Supplementary file location>/serverless_agent_config

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

odbc.ini

file.

Introduction to ODBC Connector

Download Guide

Watch

Comments

Web Page