skip to main content
Quick Start: Progress DataDirect for ODBC for Apache Cassandra Driver for Windows : Configuring a Data Source
  

Try DataDirect Drivers Now

Configuring a Data Source

To configure a basic data source to test your connection:
1. Start the ODBC Administrator by selecting its icon from the Progress DataDirect for ODBC program group.
ODBC Data Source Administrator
2. Click either the User DSN, System DSN, or File DSN tab to display a list of data sources.
*User DSN: If you installed an Apache Cassandra data source as part of the installation, select Apache Cassandra from the list of data sources and click Configure to display the driver Setup dialog box.
If you did not install an Apache Cassandra data source during installation, click Add to display a list of installed drivers. Select the Apache Cassandra driver and click Finish to display the driver Setup dialog box.
*System DSN: To configure a new system data source, click Add to display a list of installed drivers. Select the Apache Cassandra driver and click Finish to display the driver Setup dialog box.
*File DSN: To configure a new file data source, click Add to display a list of installed drivers. Select the Apache Cassandra driver and click Advanced to specify attributes; otherwise, click Next to proceed. Specify a name for the data source and click Next. Verify the data source information; then, click Finish to display the driver Setup dialog box.
3. The General tab of the Setup dialog box appears by default.The General tab for ODBC Apache Cassandra driver
Note: The General tab displays only fields that are required for creating a data source. The fields on all other tabs are optional.
On the General tab, provide the following information; then, click Schema Map tab.
*Data Source Name: Type a string that identifies this data source configuration, such as Accounting.
*Description: Type an optional long description of a data source name, such as My Accounting Database.
*Host Name: Type the name or IP address of the server to which you want to connect.
*Port Number: Type the port number of the server listener.
*Keyspace Name: Type the name of the keyspace to which you want to connect.
4. The Schema Map tab appears. The Schema Map tab for ODBC Apache Cassandra driver
On the Schema Map tab, provide the following information; then, click Apply:
*Schema Map: Type the name and location of the configuration file where the relational map of native data is written.
The driver looks for this file when connecting to a server. If the file does not exist, the driver creates the following file:
application_data_folder\Local\Progress\DataDirect\Cassandra_Schema\host_name.config.
5. Your driver is now configured with the basic settings necessary to connect your driver. Choose from the following:
*If you would like to test the connection, proceed to Testing the Connection.
*If you would like to tune your driver for performance, proceed to Tuning for Performance .
*If you would like to save the values you have specified and close the setup dialog, click OK. These values will be used as the default settings when you connect to a data source.