ODBC Connector

Back Next

Configure the elastic runtime environment

You can use an elastic runtime environment hosted on AWS to connect to ODBC-compliant databases.

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

Deploy the elastic runtime environment on AWS to make the Kubernetes cluster available to process data from Informatica Intelligent Cloud Services.

For more information about deploying an elastic runtime environment, see Deploy an elastic runtime environment.

Ensure that the elastic agent is up and running and enable the required connectors.

To enable connectors in the elastic agent, perform the following steps:

In Administrator, select Runtime Environments
.

Right-click the Secure Agent group and select Enable or Disable Services and Connectors
.

A dialog box listing all the services and connectors for the Secure Agent group is displayed.

On the Connectors
tab, enable the required connectors.

Click OK
.

Create a data disk in the same environment where the elastic runtime cluster is running to store the custom binaries.

On the master node, create a directory and mount the EFS or data disk to that directory.

Place the custom binaries on the mounted disk and copy the exact path to the binaries.

This path is used in POST API calls.

Make a POST call to the REST API, passing the session ID, runtime environment ID, and the binary file path to register the binaries. You can add multiple DSN drivers in the same POST call.

For more about information about making the POST calls, see Supplementary files in the REST API Reference guide.

The following is an example of the POST request:

POST <base URL>/api/v3/RuntimeEnvironment/<runtime environment ID>/ElasticConfig
Content-Type: application/json
Accept: application/json
INFA-SESSION-ID: <SessionId>
{
  "rteId": "rte-12345",
  "specification": {
    "agent": {
      "dataIntegrationServer": {
        "odbc": {
                    "drivers": [
                                    {
                            "sourcePath": "/<path of driver in data disk>/DWsqls18.so"
                        }      
                    ],
                    "dsns": [
                        {
                            "name": "ODBC_SQLServer",
                            "entries": [
                                {
                                    "key": "Driver",
                                    "value": "DWsqls18.so"
                                },
                                {
                                    "key": "Description",
                                    "value": "Test Connection"
                                },
                                {
                                    "key": "HostName",
                                    "value": "<>"
                                },
                                {
                                    "key": "PortNumber",
                                    "value": "1234"
                                },
                                {
                                    "key": "Database",
                                    "value": "cloud_DB"
                                },
                                {
                                    "key": "QuotedId",
                                    "value": "No"
                                },
                                {
                                    "key": "AnsiNPW",
                                    "value": "Yes"
                                }
                            ]
                        }

Ensure that the key-value pairs are same as the key-value pairs in the odbc.ini file.

The POST call triggers a restart of the Data Integration Server.

Verify that the elastic runtime environment is running by checking the status of the Data Integration Server in Administrator.

Test a connection or run a mapping to confirm that the elastic runtime environment can access and use the custom binaries.

For more information about how to configure and use the elastic runtime environment, see

Elastic Runtime Environments

in the Administrator help.

Connections for ODBC

Download Guide

Watch

Comments

Cloud Connectivity Homepage