A space for data analytics & AI related technical resources and discussions.
In order to connect to a Teradata server from a Windows operating system you will need to: 1. Install a 64bit Windows Teradata client 14.10 or later via the Teradata client installation kit "TeradataToolsAndUtilitiesBase" (TTU). At the minimum you need: [ ] ODBC Driver for Teradata [ ] Teradata Parallel Transporter Base.…
These notes relate to the SQLSERVER libname rather than the ODBC libname which can also be used to connect to SQL Server databases. To connect to a Microsoft SQL server using a Windows operating system you will need to install SQL Server Native Client 11.0. See https://www.microsoft.com/en-us/download/details.aspx?id=29065…
Install a Netezza client (32-bit or 64-bit to match SLC. This example uses 64-bit. (1) Execute nzodbcsetup.exe Select English Click OK New Dialog. First 'introduction' pane. Click Next Select 32bit (or the bit size of your choice). Set the "Optimize for ASCII character set". Click Next Depending on your bit size selection…
To connect to a DB2 database you will need to install a DB2 ODBC client from IBM. We believe version 9.1 works well. (Make sure you select the 64-bit connector to match your 64-bit Altair SLC installation as we no longer support 32-bit.) You will need to update or create a odbc.ini file to define the driver, host and…
In you receive the message ERROR: Catalogs are not presently supported for SAS7BDAT libraries ERROR: The macro was not compiled then this is probably because you have changed the default engine in a Altair SLC configuration file using something of the form –ENGINE SAS7BDAT. This would mean that any LIBNAME statement would…
Under Window->Preferences, General->Editor->Text Editors at the bottom there is "Appearance color options" with an option for "Background colour". Select the Color: box to see a palette of colors. You may have to change "Selection Background Color". If you change to Grey it has right effect on editor. This method does not…
You should be able to change the font size in the Workbench editor by opening Windows->Preferences. In the tree on the left select General->Appearance->Colors and FontsType "text font" in the search dialog at the top. Select "Text font" under "basic".Select the "Edit..." button. Pick your font. Select OK, then Apply. Font…
Altair SLC is able to read/write SAS7BDAT data set files but not SAS7BCAT catalog files. Altair SLC catalogs are saved into WPCCAT files. If you have access to the SAS language code that was used to compile the catalog, then that can be used to generate the equivalent Altair SLC catalog files. Alternatively, if you have…
Issue: The Log window in Altair Analytics Workbench may be cleared if the program crashes. We want to keep a record of every job run regardless if the program crashes or completes normally. Solution: Use the -ALTLOG system option, along with the -LOGPARM option to ensure that all log entries are flushed immediately. For…
In the upgrade from version 3 to version 4 and version 2023 of Altair SLC, a new set of multithreaded database engines were introduced. Multi-threaded engines are able to work faster by carrying out multiple database interactions at the same time. The non-threaded (single-threaded) engines were retained and the…
There's a wealth of content waiting for you to explore! Need support or have a question? Login or join our community.