Configure access to Vertica

Use Campaign Federated Data Access (FDA) option to process information stored in an external database. Follow the steps below to configure access to Vertica.

  1. Configure Vertica on CentOS, Windows or Debian
  2. Configure the Vertica external account in Campaign
NOTE

Vertica connector is available for hybrid and on-premise deployments. For more on this, refer to this page.

Vertica on CentOS

To configure Vertica on CentOS, follow the steps below:

  1. Download the ODBC drivers for Vertica. Click here and download the latest Linux RPM.

  2. You then need to install unixODBC with the following command:

    yum search unixODBC
    yum install unixODBC.x86_64
    
  3. If you have previously installed the Vertica Server, an ODBC driver will already be installed. In this case, update the drive as follows:

    #Switch to root
    sudo su
    
    #Install the package (add --force to update it)
    rpm -Uvh vertica-client-x.x.x-x.x86_64.rpm [--force]
    
    #Open odbcinst.ini
    vi /etc/odbcinst.ini
    
    #Add a section for Vertica and save
    [Vertica]
    Description = Vertica ODBC Driver
    Driver = /opt/vertica/lib64/libverticaodbc.so
    
    #Open odbc.ini
    vi /etc/odbc.ini
    
    #Add your DSN in ODBC Data Sources section, for example:
    [ODBC Data Sources]
    VMart = "VMart database on Vertica"
    
    #Add a DSN definition section below, for example:
    [VMart]
    Description = Vmart Database
    Driver = Vertica
    Database = VMart
    Servername = # The name of the server where Vertica is installed. Use localhost if Vertica is installed on the same machine.
    UID = dbadmin
    PWD = <password>
    Port = 5433
    
    #Cleanup
    #Remove the ODBC package
    rm vertica-client-x.x.x-x.x86_64.rpm
    
  4. In Adobe Campaign, you can then configure your Vertica external account. For more on how to configure your external account, refer to this section.

Vertica on Windows

  1. Download the ODBC driver for Windows. To install the driver for Windows, you will need to enable .NET Framework 3.5 or the installation wizard will try to automatically enable and download it.

  2. Configure the ODBC driver in Windows. For more on this, refer to this page

  3. In Adobe Campaign, you can then configure your Vertica external account. For more on how to configure your external account, refer to this section.

Vertica on Debian

  1. Download the ODBC drivers for Vertica. Click here start downloading.

  2. You then need to install unixODBC with the following command:

    apt-get install unixODBC
    
  3. If you have previously installed the Vertica Server, an ODBC driver will already be installed. In this case, update the drive as follows:

    #Switch to root
    sudo su
    
    #Move or copy the downloaded file and change to /root
    mv vertica_9.3..xx_odbc_x86_64_linux.tar.gz /
    cd /
    
    #Uncompress the file you downloaded
    tar vzxf vertica_9.3..xx_odbc_x86_64_linux.tar.gz
    
    #Remove the tar.gz since it is not needed anymore
    rm vertica_9.3..xx_odbc_x86_64_linux.tar.gz
    
    #Open odbcinst.ini
    vi /etc/odbcinst.ini
    
    #Add a section for Vertica and save
    [Vertica]
    Description = Vertica ODBC Driver
    Driver = /opt/vertica/lib64/libverticaodbc.so
    
    #Open odbc.ini
    vi /etc/odbc.ini
    
    #Add your DSN in ODBC Data Sources section, for example:
    [ODBC Data Sources]
    VMart = "VMart database on Vertica"
    
    #Add a DSN definition section below, for example:
    [VMart]
    Description = Vmart Database
    Driver = Vertica
    Database = VMart
    Servername = # The name of the server where Vertica is installed. Use localhost if Vertica is installed on the same machine.
    UID = dbadmin
    PWD = <password>
    Port = 5433
    
  4. In Adobe Campaign, you can then configure your Vertica external account. For more on how to configure your external account, refer to this section.

Vertica external account

You need to create a Vertica external account to connect your Campaign instance to your Vertica external database.

  1. From Campaign Explorer, click Administration ‘>’ Platform ‘>’ External accounts.

  2. Click New.

  3. Select External database as your external account’s Type.

  4. Configure the Vertica external account, you must specify:

    • Type: Vertica Analytics

    • Server: URL of the Vertica server

    • Account: Name of the user

    • Password: User account password

    • Database: Name of the database

On this page