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 a binary (TCP mode) or HTTP 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.
Database: The name of the Apache Hive database to which you want to connect by default. The database must exist, or the connection attempt will fail.
HostName: Either the name or the IP address of the server to which you want to connect.
LogonID: The default user ID that is used to connect to your database.
PortNumber: The port number of the server listener. The default port number for the Apache Hive server 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.
Database: The name of the Apache Hive database to which you want to connect by default. The database must exist, or the connection attempt will fail.
HostName: Either the name or the IP address of the server to which you want to connect.
HTTPPath: The path of the HTTP/HTTPS endpoint used for connections. The default is cliservice.
LogonID: The default user ID that is used to connect to your database.
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.
PortNumber: The port number of the server listener. The default port number for the Apache Hive server is 10000.
TransportMode: Specify a value of 1 to enable HTTP mode.
For Microsoft Access users, specify a value of 255.