Share this article:

Vertica Integration with Attunity Replicate: Connection Guide

To read this document in PDF format, click here.

About Vertica Connection Guides

Vertica connection guides provide basic instructions for connecting a third-party partner product to Vertica. Connection guides are based on our testing with specific versions of Vertica and the partner product.

Vertica and Attunity Replicate: Latest Versions Tested

Software Version
Attunity Replicate

Attunity Replicate 6.1.0.407

Windows Windows Server 2012 R2
Vertica Client

Vertica ODBC 9.2.0-0

Vertica Server

Vertica Database 9.2.0-0

Attunity Replicate Overview

Attunity Replicate provides automated, real time and universal data integration across all major data lakes, streaming systems, databases, data warehouses and mainframe systems, on premises and in the cloud.

Attunity Replicate empowers organizations to accelerate data replication, ingest and streaming across a wide range of heterogeneous databases, data warehouses and Big Data platforms. For more information about Attunity, visit the Attunity Website.

For information about Attunity Replicate, visit the Attunity website.

Install Attunity Replicate

To install Attunity Replicate:

  1. Go to the Attunity Replicate website.
  2. Click Free Trial.
  3. Follow the installation instructions in the Attunity Replicate documentation.

Install the Vertica Client Driver

Before you can connect to Vertica using Attunity Replicate, you must install the Vertica client package. This package includes the ODBC client driver that Attunity Replicate uses to connect to Vertica. Follow these steps:

  1. Navigate to the Client Drivers page on the Vertica website.
  2. Download the Vertica client package that is compatible with the architecture of your operating system and Vertica server version.

    Note  

    For details about client and server compatibility, see Client Driver and Server Version Compatibility in the Vertica documentation.

  3. Follow the installation instructions.

  4. Create a DSN as described in Creating an ODBC Data Source Name (DSN).

Connect Attunity Replicate to Vertica

Follow the procedure below to connect Attunity Replicate to Vertica. These steps create a source and target for Vertica data.

  1. Open a browser and type the following to start Attunity Replicate:

    https://<IPAddress or HostName>/attunityreplicate
  2. Click the Manage Endpoint Connection tab:

  3. In the Manage Endpoint Connection dialog box, click New Endpoint Connection to create a source/target data source:

  4. To define the source:

    • Type a source connection name.
    • For the connection role, click Source.
    • For the connection type, select ODBC.
    • Click DSN, then click Browse to locate your DSN.

  5. Click Test Connection to test the source connection.
  6. To define the target:

    • Type a target connection name.
    • For the connection role, click Target.
    • Provide the database credentials:

      Server
      Port
      User Name
      Password
      Database Name

  7. Click Test Connection to test the target connection.

Replicate Data from Vertica to Vertica

Follow these procedures to create a replication task:

  1. Click New Task from the left-hand side of the interface:



    The New Task dialog appears:



  2. Type VerticatoVertica in the Name field, or use a name that best suits your organization's needs.
  3. Select the Unidirectional radio button from the Replicate Profile field.
  4. Select Full Load from the Task Options field.
  5. Click OK to create the new replication task VerticatoVertica.
  6. Open the VerticatoVertica task:

  7. Drag and drop your source and target (Vertica_Src and Vertica_TGT in our example) to their correct positions in the Task Designer Window:

  8. Click Table Selection to the right of the Task Designer Window:


    The Select Tables/Views dialog appears:

  9. Select the tables for which you want to replicate data to the Target database and click OK.
  10. Click Run to execute the replication process:

  11. Click the Monitor button to check that the replication was successful. A list of completed tables appears at the bottom.


Known Limitations

  • LongVarChar data is loaded up to 4096 characters. Data can be loaded correctly up to 65000 characters when the size of Limit LOB Size to (kb) is changed to 256 from 8(default) under Target Metadata of Task Settings.
  • Long VarBinary data is not loaded.
  • For Time and TimeTz data types, the millisecond and TimeZone values are truncated.
  • For the Double data type, NaN values are loaded as 0.0.

For More Information

Share this article: