ODBC Connector > Introduction to ODBC Connector > Prerequisites to configure serverless runtime environment with ODBC Connector
  

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:
  1. 1. Create the following structure for the serverless agent configuration in AWS: <Supplementary file location>/serverless_agent_config
  2. 2. Add the ODBC drivers in the Amazon S3 bucket in the following location in your AWS account: <Supplementary file location>/serverless_agent_config/ODBC
  3. 3. Copy the following code snippet to a text editor and specify the driver filenames and DSN entries:
  4. 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.
    Note: 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
  5. 4. 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
  6. 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.