Configuring a Data Source in the System Information File

The default odbc.ini file installed in the installation directory is a template in which you create data source definitions. You enter your site-specific database connection information using a text editor. Each data source definition must include the keyword Driver=, which is the full path to the driver.

The following examples show the minimum connection string options that must be set to complete a test connection, where xx represents iv for 32-bit or dd for 64-bit drivers, yy represents the driver level number, and zz represents the extension. The values for the options are samples and are not necessarily the ones you would use.

[ODBC Data Sources]
Apache Spark SQL Wire Protocol=DataDirect 8.0 Spark SQL Wire Protocol Driver

[Apache Spark SQL Wire Protocol]
Driver=ODBCHOME/lib/xxsparkyy.zz
Database=Sparkdb1
HostName=SparkServer
PortNumber=10000

Connection Option Descriptions:

Database: The name of the database to which you want to connect by default.

HostName: Either the name or the IP address of the server to which you want to connect.

Port Number: The port number of the server listener. The default is 10000.

MaxStringSize: (This option is required only for Microsoft Access and Tableau users.) The maximum size of columns of the String data type that the driver describes through result set descriptions and catalog functions. Specify the following value that corresponds to your environment:

For Microsoft Access users, specify a value of 255.

For Tableau users, specify a value from 255 to 4000 that suits your environment.