Contents x
    Flow Connections
    • 09 Jan 2023
    • 2 Minutes to read
    • Print
    • Dark
      Light
    Contents

    Flow Connections

    • Updated on 09 Jan 2023
    • 2 Minutes to read
    • Print
    • Dark
      Light
    Article summary

    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.

    MenuConnections1

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

    TopBar1


    Creating a New Flow Data Connection

    Flow Connections are saved to the flow file itself.

    DataConnections2


    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.

    AddDataConnection1

    AddDataConnection2

    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.

    DataConnections1


    There are additional fields that can be updated:

    SettingDescription
    Connection NameFriendly name of the database connection
    UserUser to connection as
    PasswordPassword to connect with
    Driver ClassDatabase driver used to connect to the database
    URLJDBC connection string to connect to. Varies based on the database server.

    Creating a New Flow Planning Analytics Connection

    There is support for both PA local, and PA cloud connections.

    Planning Analytics Local

    AddPALocal1


    There are additional fields that can be updated:

    SettingDescription
    Connection NameFriendly name of the PA connection
    Host NameServer where the PA instance is located
    PortHTTPPortNumber that the PA instance is using
    SSLWhether or not to connect with SSL. Determined by UseSSL setting on the PA instance
    Security ModeBasic and CAM security modes are supported
    CAM NamespaceNamespace to use if CAM is selected
    UserUser to connect as
    PasswordPassword to connect with

    Planning Analytics Cloud

    AddPACloud1


    There are additional fields that can be updated:

    SettingDescription
    Connection NameFriendly name of the PA connection
    IBM Cloud URLCloud URL to connect to
    IBM Cloud ModelName of the PA cloud model to connect to
    UserUser to connect as
    PasswordPassword to connect with

    Creating a New Flow Anaplan Connection

    AddAnaplan1


    There are additional fields that can be updated:

    SettingDescription
    Connection NameFriendly name of the Anaplan connection
    UserUser to connect as
    PasswordPassword to connect with
    Was this article helpful?
    What's Next