-
Find these four files:
- Install.cmd
- Install.vbs
- Install.reg
- Aster.xsl
These files can be found in the folder where the .NET Data Provider for Aster is installed, typically something like C:\Program Files (x86)\Teradata Aster\Aster .NET Data Provider (x86).
-
Install the files manually.
When installed, these files enable the .NET Data Provider for Aster to appear as an option within Microsoft Visual Studio and Microsoft Analysis Services.
To install the files, run the Install.cmd file from the command line with the /codebase option. The /codebase option should have the full path to the Simba.Net.dll file. The syntax to run the command is:
Install.cmd /codebase <full path>\Simba.Net.dllFor example, the command will look similar to:
Install.cmd /codebase "C:\Program Files (x86)\Teradata Aster \Aster .NET Data Provider (x86)\Simba.Net.dll"If you are installing the .NET Data Provider for Aster to work with SQL Server 2005, you must use the /vs2005 option, as in:
Install.cmd /vs2005 /codebase <full path>\Simba.Net.dll -
Put the Aster Database cartridge (the file Aster.xsl) into the corresponding directory for SSAS. This file should be placed into all the cartridge directories for SSAS, which may include all of the following directories, though the directories on your Windows machine may differ slightly:
SQL Server 2008
C:\Program Files\Microsoft Analysis Services\AS OLEDB\10\Cartridges C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP \bin\Cartridges C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\ IDE\DataWarehouseDesigner\UIRdmsCartridge C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE \PrivateAssemblies\DataWarehouseDesigner\UIRdmsCartridge
SQL Server 2005
C:\Program Files\Microsoft SQL Server\MSSQL.3\OLAP\bin\Cartridges C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7 \IDE\DataWarehouseDesigner\UIRdmsCartridge C:\Program Files\Microsoft Visual Studio 8\Common7\IDE \PrivateAssemblies\DataWarehouseDesigner\UIRdmsCartridge
It is recommended to install SQLServer and SSAS before installing the .NET Data Provider for Aster. When you install the .NET Data Provider for Aster, the installer checks the Windows registry to see if SSAS is installed. Then the correct files are installed and configured automatically. But in cases where the .NET Data Provider for Aster is already installed before SSAS/SQL Server, you will need to do the following steps before they can work together: