MicroStrategy ONE
ODBC Driver for Aster Database for Linux
The ODBC driver for Aster Database is not a MicroStrategy-branded driver. The following steps show how to configure the ODBC driver for Aster Database for Linux.
You must modify the odbc.ini
file to create the DSN for Aster.
The third-party product(s) discussed in the procedure below is manufactured by vendors independent of MicroStrategy. MicroStrategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability.
To Configure ODBC Driver for Aster Database
Begin by installing the Aster ODBC Driver for the Linux operating system. For information on installation, refer to the product documentation provided by the database vendor.
- The path to the installation location you choose for the ODBC driver is used later in this procedure as the value for the Driver parameter in the
odbc.ini
file. - For exact version numbers of Aster drivers certified with MicroStrategy, refer to the MicroStrategy General Information Readme.
The following set of instructions are divided into two sections: how to configure the environment and how to modify the odbc.ini file.
To Configure the Environment
- In a Linux console window, browse to
HOME_PATH
whereHOME_PATH
is the specified home directory during installation. Browse to the folderenv
. - Add Write privileges to the
ODBC.sh
file by entering the following command:chmod u+w ODBC.sh
- Edit the
ODBC.sh
file and provide the location of the Aster library installation. Within theODBC.sh
file, the following definition is included:ASTER_PATH='<ASTER_PATH>'
Replace this
<ASTER_PATH>
placeholder with the location of the Aster library installation.Do not modify any other occurrences of
<ASTER_PATH>
withinodbc.sh
. - Save the
ODBC.sh
file and remove Write privileges from the file by entering the following command:chmod a-w ODBC.sh
To Modify the odbc.ini File
- In a Linux console window, browse to
HOME_PATH
whereHOME_PATH
is the specified home directory during installation. - Open the
odbc.ini.example
file and search for the section that starts with[Aster Database]
. - Open the MicroStrategy
odbc.ini
file. - Copy and paste the contents from the
odbc.ini.example
file for your Aster ODBC driver. You should paste the contents of the DSN exactly as they appear in the example file. - Make the following changes to the copied sample file:
- Modify the driver location to match the location of the installed Aster ODBC Driver.
- Change the database, server name, user name, password, and any other relevant parameters to match the information for your database. For information on the available parameters, refer to your third-party Aster Database driver documentation. This can often be found along with the driver installation.
Ensure that there is no white space between the equals sign (=) which separates the parameter and its value.
- Save the
odbc.ini
file.
This completes the steps to create a DSN and configure an ODBC driver for Aster Database.