Flow Connections

Last updated: 09 Jan 2023

Loading Data from Data Connections

Prior to configuring/using a:

• Database node
• Planning Analytics node
• Anaplan node

you first need to create a Data Connection and add it to your flow.

To configure a connection, click on Data Connections in the Connections menu.

You can also click on Connections in the top menu bar.

Creating a New Flow Data Connection

Flow Connections are saved to the flow file itself.

In the Data Connections window, a new connection can be added by clicking Add.

This will bring up the Add Data Connection dialog. Select the type of data connection to be created, and then click Next. This will bring up the Edit Data Connection dialog.

The currently support types of Data Connections are: Relational Database, Planning Analytics Local, Planning Analytics Cloud, and Anaplan.

The Test Connection button can be used to test the newly created connection.

Clicking the Add to User Saved button will allow the database connection to be easily reused over other flows.

Any nodes that require a Data Connection can now use this newly created connection.

Creating a New Flow Database Connection

DataWORQ uses JDBC connection protocol, so any database that can connected to via JDBC can also be connected to by DataWORQ.

There are additional fields that can be updated: