|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
Attunity Replicate 22.214.171.1247
|Windows||Windows Server 2012 R2|
Vertica ODBC 9.2.0-0
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:
- Go to the Attunity Replicate website.
- Click Free Trial.
- 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:
- Navigate to the Client Drivers page on the Vertica website.
Download the Vertica client package that is compatible with the architecture of your operating system and Vertica server version.
For details about client and server compatibility, see Client Driver and Server Version Compatibility in the Vertica documentation.
Follow the installation instructions.
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.
Open a browser and type the following to start Attunity Replicate:
https://<IPAddress or HostName>/attunityreplicate
Click the Manage Endpoint Connection tab:
In the Manage Endpoint Connection dialog box, click New Endpoint Connection to create a source/target data source:
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.
- Click Test Connection to test the source connection.
To define the target:
- Type a target connection name.
- For the connection role, click Target.
Provide the database credentials:
- Click Test Connection to test the target connection.
Replicate Data from Vertica to Vertica
Follow these procedures to create a replication task:
- Click New Task from the left-hand side of the interface:
The New Task dialog appears:
- Type VerticatoVertica in the Name field, or use a name that best suits your organization's needs.
- Select the Unidirectional radio button from the Replicate Profile field.
- Select Full Load from the Task Options field.
- Click OK to create the new replication task VerticatoVertica.
- Open the VerticatoVertica task:
- Drag and drop your source and target (Vertica_Src and Vertica_TGT in our example) to their correct positions in the Task Designer Window:
- Click Table Selection to the right of the Task Designer Window:
The Select Tables/Views dialog appears:
- Select the tables for which you want to replicate data to the Target database and click OK.
- Click Run to execute the replication process:
- Click the Monitor button to check that the replication was successful. A list of completed tables appears at the bottom.
- 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.