Preparing Actian Vector user data source for Campaign

On Windows

  1. 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
  2. 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.
  3. 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.
  4. 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.
  1. 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.
  2. 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

  3. 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