ODBC provides a method for specifying connection information via a connection string and the SQLDriverConnect API. This section provides examples of connection strings configured to use common features and functionality. You can modify and/or combine these examples to create a connection string for your environment.

In addition to the connection strings for DSN-less connections demonstrated in this section, the driver supports DSN and File DSN connection strings. See "Using a connection string" for syntax and detailed information for supported connection string types.

Note: The options and values described in this section apply to all configuration methods.

Connection strings for the Autonomous REST Connector can take a few different forms. Typically, the composition of the string is dependent on whether you want to use a Model file, which requires configuring the Rest Config File (RESTConfigFile) option, or specify a single endpoint, which requires the Rest Sample Path (RestSamplePath) option. However, these options are not required in all scenarios, such as when the driver is executing dynamically created stored procedures or functions.

For sessions using a Model file (sessions that use multiple endpoints, POST requests, or other customizations supported by the Model file):
DRIVER=DataDirect 8.0 Autonomous REST Connector;HostName=host_name;
       RestConfigFile=model_file;[attribute=value[;...]]
For sessions using the REST Sample Path option: 
DRIVER=DataDirect 8.0 Autonomous REST Connector;RestSamplePath='sample_path';
       [attribute=value[;...]]

Note that all the examples in this section use the Model file.

Basic authentication

This string includes the options used to connect using a Model file and basic authentication.

DRIVER=DataDirect 8.0 Autonomous REST Connector;AuthenticationMethod=0;
       RestConfigFile=C:/path/to/myrest.rest;User=jsmith;Password=secret;

For more information on these options and values, see Basic authentication.

AWS credentials authentication

This string includes the properties used to connect to using a Model file with AWS credentials authentication. 
DRIVER=DataDirect 8.0 Autonomous REST Connector;AccessKey=ABCDEFGHIJKL1EXAMPLE;
        AuthenticationMethod=43;Region=us-east-2;RestConfigFile=C:/path/to/myrest.rest;
        SecretKey=aBcdeFGhiJKLM/N1OPQRS/tUvWxyzYEXAMPLEKEY
For more information on these options and values, see AWS credentials authentication.

Bearer token authentication

This string includes the options used to connect using a Model file and bearer token authentication. 
DRIVER=DataDirect 8.0 Autonomous REST Connector;AuthenticationMethod=34;
       RestConfigFile=C:/path/to/myrest.rest;
       SecurityToken=C3TQH9zjwek4CgJCU-4Mxb2DxLNfI2LB3a-dNfpWYx;
For more information on these options and values, see Bearer token authentication.

Digest authentication

This string includes the options used to connect using a Model file and digest authentication. 
DRIVER=DataDirect 8.0 Autonomous REST Connector;AuthenticationMethod=30;
       RestConfigFile=C:/path/to/myrest.rest;User=jsmith;Password=secret;
For more information on these options and values, see Digest authentication.

HTTP header authentication

This string includes the options used to connect using a Model file and HTTP header authentication. 
DRIVER=DataDirect 8.0 Autonomous REST Connector;AuthenticationMethod=25;
       RestConfigFile=C:/path/to/myrest.rest;SecurityToken=XaBARTsLZReM;
       [attribute=value[;...]]
For more information on these options and values, see HTTP header authentication.

URL parameter authentication

This string includes the options used to connect using a Model file and URL parameter authentication. 
DRIVER=DataDirect 8.0 Autonomous REST Connector;AuthenticationMethod=14;
       AuthParam=apikey;RestConfigFile=C:/path/to/myrest.rest;
       SecurityToken=XaBARTsLZReM;
For more information on these options and values, see URL parameter authentication.

Access token

This string includes the options used to connect using a Model file and access token flow authentication. 
DRIVER=DataDirect 8.0 Autonomous REST Connector;
       AccessToken=C3TQH9zjwek4CgJCU-4Mxb2DxLNfI2LB3a-dNfpWYx;
       AuthenticationMethod=50;RestConfigFile=C:/path/to/yelp.rest;
For more information on these options and values, see Access token flow.

Authorization code grant

This string includes the options used to connect using a Model file and authorization code grant authentication. 
DRIVER=DataDirect 8.0 Autonomous REST Connector;AuthenticationMethod=51;
       OauthCode=xyz123abc;ClientID=abcdefghij1k2lmn3o4p5qr67s;
       RestConfigFile=C:/path/to/box.rest;TokenURI=https://api.box.com/oauth2/token;
For more information on these options and values, see Authorization code grant.

Client credentials grant

This string includes the options used to connect using a Model file and client credentials authentication. 
DRIVER=DataDirect 8.0 Autonomous REST Connector;AuthenticationMethod=53;
       ClientID=123456789876-a1bc2de3fgh4ij567klmn8opqr.apps.googleusercontent.com;
       ClientSecret=FaZBFRsGXTaR;RestConfigFile=C:/path/to/googleanalytics.rest;
       TokenURI=https://accounts.google.com/o/oauth2/token;
For more information on these options and values, see Client credentials grant.

JWT bearer grant

This string includes the options used to connect using a Model file and JWT bearer grant authentication. 
DRIVER=DataDirect 8.0 Autonomous REST Connector; 
        RestConfigFile=C:/path/to/salesforce.rest;AuthenticationMethod=55;
        ClaimsIssuer='1a2b3c4d5e_6f7g8h9g';ClaimsSubject=jsmith@example.com;
        JWTCertStore=jwtcert.jks;JWTCertPassword=secret;JWTCertAlias=myAlias;
For more information on these options and values, see JWT bearer grant.

Password grant

This string includes the options used to connect using a Model file and password grant authentication. 
DRIVER=DataDirect 8.0 Autonomous REST Connector;AuthenticationMethod=52;
       RestConfigFile=C:/path/to/zendesk.rest;
       TokenURI=https://accounts.google.com/o/oauth2/token;User=jjones@example.com;
       Password=secretstuff;
For more information on these options and values, see Password grant.

PKCE grant

This string includes the options used to connect using a Model file and PKCE grant authentication. 
DRIVER=DataDirect 8.0 Autonomous REST Connector;RestConfigFile=C:/path/to/box.rest;
       AuthenticationMethod=56;ClientID='abcdefghik2lmn3o5qr67s';
       ClientSecret=FaZBFRsGXTaR;AuthURI=https://accounts.spotify.com/authorize;
       RedirectURI=https://localhost:8080;
       TokenURI='https://accounts.spotify.com/api/token';SQLEngineMode=2
For more information on these options and values, see PKCE grant.

Refresh token grant

This string includes the options used to connect using a Model file and refresh token grant authentication. 
DRIVER=DataDirect 8.0 Autonomous REST Connector;AuthenticationMethod=54;
       ClientID=1234567898-a1bc2de3fgh4ij567klmn8opqr9stu.apps.googleusercontent.com
       Clientsecret=FaZBFRsGXTaR;RestConfigFile=C:/path/to/googleanalytics.rest;
       RefreshToken=1/abCD0F1GHijkLmNOPqrs_T2VWx3Y-Zabc45dE6FGh;
       TokenURI=https://accounts.google.com/o/oauth2/token;
For more information on these options and values, see Refresh token grant.