Preparing Actian Vector user data source for Campaign
On Windows
- Install ODBC driver:
- Open link -> https://esd.actian.com/product/Vector
- Choose appropriate driver and download .zip format file. Please note that 'community' type includes both db server as well as client.
- Unzip it and Install driver by running '<extracted_path>\setup.exe' file with default options.
- Confirm that 'Actian Vector [VW]' db server service is running under windows service lists.
- At installation location you will find below directories:
- Director - the actian vector db client
- Vector Documentation X.X
- VectorVW - the actian vector db server
- Use Director db client to connect to server instance
- Run<ActianInstallationPath>\Director\director.exe client
-
For a new connection to the actian instance running on your machine, Select Connection tab and click on Connect option.
- On 'Connect to instance' dialog
- Use hsedemo as password and click on Connect button.Note: On your machine Instance name should be different, it should match with your machine's hostname.
- You can see that its connected successfully to actian db instance running on your machine.
- Create ODBC DSN
- Open ODBC Data Source Administratior and click on Add… button.
- You can see that installed Ingres and Ingres VW actian db odbc drivers in the list.
- Select Ingres VW from the list and click on Finish button.
- Fill all the required information, click on Apply button and then
click on Test button. It will allow you to fill only Data Source and
Database field values.Note: Here it will take user name and password of currently logged in user.
- If you tried to change Host Name field value it will ask you to provide Listen Address field value too. Valid values for Host Name fields are localhost / <machine hostname> / (LOCAL) Valid value for Listen Address field is VW / II. This time it will ask you to enter user name and password on clicking Test button.
- Enter User Id: demo and Password: hsedemo. Click on OK button.
- Open ODBC Data Source Administratior and click on Add… button.
- Create Campaign Data Source
- Use SQLServerTemplate.xml as there is no separate template created for Actian Vector database.
- Import above mentioned .xml file in Campaign using config tool and set DisallowTempTableDirectCreate = TRUE. This is important.
- Fill other fields as per requirements.
On Linux
Note: Use actian db server installed on windows machine using above steps
and install actian db client on linux machine using,
actian-vector-client-6.0.0-129-free-linux-ingbuild-x86_64.tgz.
- Install ODBC driver
- Download actian-vector-client-6.0.0-129-free-linux-ingbuild-x86_64.tgz
and run following commands:
- $>tar -xf actian-vector-client-6.0.0-129-free-linux-ingbuild-x86_64.tgz
- $>cd actian-vector-client-6.0.0-129-free-linux-ingbuild-x86_64
- Swtich to root user
- $>sudo su
- $>./client_install.sh <ENTER>
- Answer to the asked questions accordingly.
- Download actian-vector-client-6.0.0-129-free-linux-ingbuild-x86_64.tgz
and run following commands:
- Create ODBC DSN
- Edit odbc.ini file and add DSN for actian db in it as shown in following
example
[abc]
Driver=/opt/Actian/Vector_Client/ingres/lib/libiiodbcdriver.1.so
Description=
Vendor=Actian Corporation
DriverType=Ingres
HostName=< machine name on which actian db server is running >
ListenAddress=< running instance name of actian db server >
Database=< db name >
ServerType=ACTIAN
- Edit odbc.ini file and add DSN for actian db in it as shown in following
example
[abc]
- Create Campaign Data Source
- Use SQLServerTemplate.xml as there is no separate template created as such for Actian Vector database.
- Import above mentioned .xml file in Campaign using config tool and set DisallowTempTableDirectCreate = TRUE. This is important.
- Fill other fields as per requirements.Note: Before running campaign listener on LINUX platform, please run following command on same console/terminal where you want to run listener. Below commands need not be run on windows platform
- $>cd /opt/Actian/Vector Client/ingres
- $>. ./.ingCLsh
- $>cd <CAMPAIGN_HOME>/bin
- $>./rc.unica_ac start