Using a Connection String

For some applications, you might need to use a connection string to connect to your data source. For detailed information about how to use a connection string in an ODBC application, refer to the documentation for the application that you are using.

The connection strings in the following sections are examples showing the minimum set of connection attributes that you must specify to successfully connect to the data source. Depending on the configuration of the data source and the type of connection you are working with, you might need to specify additional connection attributes. For detailed information about all the attributes that you can use in the connection string, see Connector Configuration Options

DSN Connection String Example

The following is an example of a connection string for a connection that uses a DSN:

[DataSourceName] is the DSN that you are using for the connection.

You can set additional configuration options by appending key-value pairs to the connection string. Configuration options that are passed in using a connection string take precedence over configuration options that are set in the DSN.

DSN-less Connection String Examples

Some applications provide support for connecting to a data source using a connector without a DSN. To connect to a data source without using a DSN, use a connection string instead.

The placeholders in the examples are defined as follows, in alphabetical order:

• [AccessToken] is your access token for authenticating the connection through the OAuth 2.0 protocol.
• [AOSS_Endpoint] is the IP address or host name of the DataStax AOSS endpoint.
• [AOSS_Port] is the number of the TCP port that the DataStax AOSS endpoint uses to listen for client connections.
• [DomainName] is the fully qualified domain name of the Spark server host.
• [PortNumber] is the number of the TCP port that the Spark server uses to listen for client connections.
• [Server] is the IP address or host name of the Spark server to which you are connecting.
• [ServerURL] is the partial URL corresponding to the Spark server.
• [YourPassword] is the password corresponding to your user name.
• [YourUserName] is the user name that you use to access the Spark server.

Connecting to a Shark Server Instance

The following is the format of a DSN-less connection string that connects to a Shark Server instance:

For example:

Connecting to a Standard Spark Thrift Server Instance

The following is the format of a DSN-less connection string for a standard connection to a Spark Thrift Server instance. By default, the connector is configured to connect to a Spark Thrift Server instance. Most default configurations of Spark Thrift Server require User Name authentication. When configured to provide User Name authentication, the connector uses anonymous as the user name by default.

For example:

Connecting to a Spark Thrift Server Instance Without Authentication

The following is the format of a DSN-less connection string that for a Spark Thrift Server instance that does not require authentication.

For example:

Connecting to a Spark Server that Requires Kerberos Authentication

The following is the format of a DSN-less connection string that connects to a Spark Thrift Server instance requiring Kerberos authentication. By default, the connector is configured to connect to a Spark Thrift Server instance.

For example:

Connecting to a Spark Server that Requires User Name And Password Authentication

The following is the format of a DSN-less connection string that connects to a Spark Thrift Server instance requiring User Name and Password authentication. By default, the connector is configured to connect to a Spark Thrift Server instance.

For example:

Connecting to a Spark Server in Windows Azure HDInsight Emulator

The following is the format of a DSN-less connection string that connects to a Spark Thrift Server instance running in Windows Azure HDInsight Emulator. By default, the connector is configured to connect to a Spark Thrift Server instance.

For example:

Connecting to a Spark Server that Requires OAuth 2.0 Authentication

The following is the format of a DSN-less connection string that connects to a Spark Thrift Server instance requiring OAuth 2.0 authentication. By default, the connector is configured to connect to a Spark Thrift Server instance. Browser based authentication workflow only works when SSL is enabled.

Token pass-through

For example, using token pass-through authentication:

Driver=Simba Spark ODBC Driver;Host=192.168.222.160;
Port=10000;AuthMech=11;Auth_Flow=0;Auth_AccessToken=P9QcyQ7prK2LwUMZMpFQ4R+6jd;ThriftTransport=2;

Browser based

Driver=SimbaSparkODBC Driver;Host=[Server];

Port=[PortNumber];AuthMech=11;Auth_Flow=2;ThriftTransport=2;SSL=1;

For example, using browser based authentication:

Driver=SimbaSpark ODBC Driver;Host=192.168.222.160;

Port=10000;AuthMech=11;Auth_Flow=2;ThriftTransport=2;SSL=1;