• Contents
  • Index

Altair® Monarch®

 

Working with the Altair ODBC Drivers

The Altair ODBC Drivers are very similar to the Altair Data Connectors in that both connector types allow you to access data from a number of database types. The Altair ODBC drivers support access to the following database types:

  • IBM Cloudant

  • DB2

  • Hadoop Hive

  • Informix

  • MySQL

  • Cloudera Impala

  • Oracle

  • PostgreSQL

  • Salesforce

  • SQL Server

  • Amazon Redshift

  • OData

  • Splunk

  • MongoDB

  • Altair Monarch Server - Content

  • Sybase IQ

  • Teradata

  • OData

  • OLEDB

  • ODBC

  • Business Objects Universe

  • Greenplum

 

The Altair ODBC Drivers are only available in Monarch Classic.

Setting up the Altair ODBC Drivers

The Altair ODBC Drivers are set up using Windows' ODBC Data Source Administrator.

 

  1. Select Start > Control Panel > Administrative Tools > Data Sources (ODBC).

     

  2. Select Add.

  3. From the Create New Data Source dialog that displays, select an Altair Driver to set up. A setup dialog for this driver displays.

     

  4. Provide a data source name so that you can easily identify this driver from a list.

  5. Type in the host name and the database name you wish to gain access to.

  6. Select Test Connect to check whether or not you have the credentials necessary to access the database you named in Step 4.

  7. Enter your user name and password into the appropriate fields of the Login dialog that displays.

  8. Click OK. A message box displays to inform you of the status of your connection.

  9. Select OK on the setup dialog if you are satisfied with the test connection results.

 

Notes on the Salesforce Driver Connection

When setting up the Salesforce driver, the ODBC Salesforce Driver Setup dialog displays. After confirming a connection to the database you desire, select the Web Service tab of the setup dialog.

 

The Statement Call Limit field has a default value of 20 – this limit results in a maximum number of 40,000 rows returned when the database is accessed. To remove this limit, set the Statement Call Limit value to 0.