Contents x
    Data Connections
    • 05 May 2023
    • 1 Minute to read
    • Print
    • Dark
      Light
    Contents

    Data Connections

    • Updated on 05 May 2023
    • 1 Minute to read
    • Print
    • Dark
      Light
    Article summary

    Loading Data from Data Connections

    Before configuring/using a:

    • Database node
    • Planning Analytics node
    • Anaplan node

    you first need to create a Data Connection.

    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 Data Connection

    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, Pigment, and Anaplan.

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

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


    Creating a Database Connection

    DataWORQ uses JDBC connection protocol. DataWORQ can connect to any database that supports JDBC.

    DataConnections1


    These are the required settings:

    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
    URLThe JDBC 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 cloud connections.

    Planning Analytics Local

    AddPALocal1


    These are the required settings:

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

    Planning Analytics Cloud

    AddPACloud1


    These are the required settings:

    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 an Anaplan Connection

    AddAnaplan1


    These are the required settings:

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