Configuring Your Workflow Connections
Perform this procedure to configure your workflow connection to your database.
-
While in Workflow Manager, from the Connections list box, select Relational.
- From the Relational Connection Browser dialog box, select your Vertica connection object and click and click New.
-
From the Select Subtype dialog box, select VerticaConnection and click OK.
-
Fill in the details within the Connection Object Definition dialog box.
- Fill in the Name, User Name, and Password.
- Enter the connection string, which must have the format:
jdbc:vertica://<ip>:<port>/<dbname
> - In the JDBC Driver Name field, enter com.vertica.jdbc.Driver
-
If you are connecting to a database that is running Vertica Release 8.1.x, select EnableStreamingBatchInsert.
Important: If you are running Vertica Release 7.x on either source or target database, enable (check off) EnableStreamingBatchInsert. Note that if you are running a previous version of Vertica you can still check EnableStreamingBatchInsert; previous versions will not experience the performance improvements, but setting the option has no detrimental impact. -
If your Vertica database is SSL enabled, check EnableSSLConnection, and enter a Trust Store Path and Trust Store Password.
Note: You must enter a complete path for Trust Store Path (e.g., C:\Users\Administrator\Desktop\verticastore). - Click OK.
Next you configure your source and target for the workflow. Follow the procedure in, Configuring Source and Target and Starting Your Workflow.