Working with the Altair ODBC Drivers

The ODBC Drivers included with Monarch Classic are very similar to the data connectors in Data Prep Studio in that both connector types allow you to access data from a number of database types. Monarch's ODBC drivers support access to the following database types:

  • Amazon RedShift Hive Wire Protocol

  • Cassandra

  • Impala

  • DB2

  • Google BigQuery

  • Greenplum

  • Apache Hive

  • HubSpot

  • Informix

  • MySQL

  • NetSuite

  • Oracle

  • PostgreSQL

  • SharePoint

  • SparkSQL

  • SQL Server

  • SQL Azure

  • Sybase

  • Sybase IQ

  • Teradata

 

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.

 

Known issues

  • Tables from Cassandra may not display correctly when imported into Monarch Classic via the ODBC import function if they contain numeric values with decimal figures. This issue is not observed in the ODBC and Cassandra connectors of Data Prep Studio.

  • Some drivers currently have issues supporting passwords containing special characters (e.g., semi-colon, single quote, double quotes, etc.). These drivers include:

    • Active Directory

    • Apache Cassandra

    • Google BigQuery

    • HubSpot

    • NetSuite

    • OData

    • SharePoint

    • Spark SQL

 

 

 

© 2024 Altair Engineering Inc. All Rights Reserved.

Intellectual Property Rights Notice | Technical Support