-
Verify that Microsoft Visual C++ Redistributable for Visual Studio 2015(x64) (if you want to install 64-bit Aster ODBC Driver) and Microsoft Visual C++ Redistributable for Visual Studio 2015(x86) (if you want to install 32-bit Aster ODBC Driver) is installed on the system where you want to install the driver. You can do this by looking at installed programs from the Control Panel.
If the supported version is not installed, download it from: https://www.microsoft.com/en-in/download/details.aspx?id=48145.
- If you are upgrading, use the Windows Add/Remove Programs tool to uninstall the old Aster ODBC version.
-
Double click on the Aster ODBC .msi file to install it. The actual file name depends on your operating system:
- Windows 32-bit: nClusterODBCInstaller_i386.msi
- Windows 64-bit: nClusterODBCInstaller_x64.msi
-
A setup wizard walks you through the installation of Aster Database ODBC as one of the available data sources on your computer. The default installation directory will be something like:
- For 32-bit Windows: C:\Program Files\Teradata Aster\Aster ODBC Driver (x86)\
- For 64-bit Windows: C:\Program Files\Teradata Aster\Aster ODBC Driver (x64)\
For AC 5.0.2 and before, the ODBC driver name is Aster Data ODBC Driver for nCluster
- From the Windows Control Panel, double click Administrative Tools to open the Administrative Tools window.
- Double click the Data Sources (ODBC) option to open the ODBC Data Source Administrator dialog box.
- Click the System DSN tab.
-
Click Add to open the Create New Data Source dialog box.
- Select the Aster ODBC Driver data source from the list.
- Click Finish. The Aster Database Login window appears.
-
In the Aster Database Login window, enter the following information:
- Data Source: Use this field to give this database connection an easy-to-recognize name.
- Server: The hostname or IP address of your Aster Database queen.
- Port: The port on which your Aster Database queen listens for client connections. The default is 2406.
- Database: The name of the database in Aster Database you want to connect to. Default system database is beehive.
- Username: Database user name.
- Password: Database user password.
- Fetch Count: See Throttle Query Results in ACT and Aster Database.
- SSL Settings: See SSL Basics for ODBC.
- SSO Settings: See ODBC with SSO Client-Side Settings.
- enable_quoted_identifiers: See Quoted-Identifier Handling.
- enable_backslash_escapes: See Escape Character Handling.
- Map NUMERIC/DECIMAL to DOUBLE: This option can be set to force all NUMERIC and DECIMAL columns to be described as DOUBLE. Teradata Aster recommends that you turn this feature on. The flag’s default is to be unset. If left unset, you cannot use the NaN value in the Numeric data type because Aster ODBC does not support NaN values for the Numeric data type. If you do not use NaN, and care about data precision, you can leave the flag unset.
- Click OK to save the data source information.
-
Depending on your Windows operating system:
- If you are using a Windows 64-bit system, go to Specifying the DSN Manager for Windows 64-bit.
- If you are using a Windows 32-bit system, continue with this procedure.
- Click Test Connection to test the connectivity to the database.
- If the connection is working, a confirmation window appears. Click OK.
Your ODBC setup is complete. Now, in your applications that will query Aster Database, you may connect to Aster Database as an ODBC data source.