Configuring Your Workflow Connections

Perform this procedure to configure your workflow connection to your database.

  1. While in Workflow Manager, from the Connections list box, select Relational.

  2. From the Relational Connection Browser dialog box, select your Vertica connection object and click and click New.
  3. From the Select Subtype dialog box, select VerticaConnection and click OK.

  4. Fill in the details within the Connection Object Definition dialog box.

    1. Fill in the Name, User Name, and Password.
    2. Enter the connection string, which must have the format: jdbc:vertica://<ip>:<port>/<dbname>
    3. In the JDBC Driver Name field, enter com.vertica.jdbc.Driver
    4. 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.
    5. 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).

    6. Click OK.

Next you configure your source and target for the workflow.  Follow the procedure in, Configuring Source and Target and Starting Your Workflow.