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 on UNIX and Linux platforms. 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, and yy represents the extension. The values for the options are samples and are not necessarily the ones you would use.

[ODBC Data Sources]
Apache Cassandra=DataDirect 8.0 Apache Cassandra

[Apache Cassandra]
Driver=ODBCHOME/lib/xxcsndr28.yy
...
HostName=CassandraServer
...
KeyspaceName=CassandraKeyspace2
...
LogonID=John
...
Password=S3cr3t
...
PortNumber=9042
..
SchemaMap=/home/users/jsmith/Progress/DataDirect/Cassandra_Schema/CassandraServer.config
...

Connection Option Descriptions:

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

KeySpaceName: The name of the keyspace to which you want to connect. The default is system.

LogonID: The default user ID that is used to connect to your database. Your ODBC application may override this value or you may override it in the logon dialog box or connection string.

Password: Specifies the password to use to connect to your database.

PortNumber: The port number of the server listener. The default is 9042.

SchemaMap: The name and location of the configuration file where the relational map of native data is written. The driver either creates or looks for this file when connecting to the database. The default is:

users_home_directory/Progress/DataDirect/Cassandra_Schema/host_name.config

See "Schema Map" for details.