DataFlux Data Management Studio 2.7: User Guide

Data Connections Folder

As described in Data Connections, you can use the Data Connections folder in the Data riser bar to create new data connections and review existing data connections. Data connections are used to access data in jobs, profiles, data explorations, and data collections.

The Data Connections folder contains the following elements:

Data Connections Tree - Enables you to perform tasks that are appropriate for either all data connections or for a specific data connection. The following display shows a sample Data Connections tree:

When you select the New Data Connection element at the top of the Data riser bar, you can create a new ODBC or non-ODBC data connection. When you select a specific data connection, you can perform the following tasks:

• Create a new ODBC or non-ODBC data connection
• Edit the selected data connection
• Filter the selected data connection
• Create a data exploration based on the selected data connection

Data Connections Pane - Enables you to review either a list of all of your connections or the folders in a selected connection. The following display shows a sample Data Connections pane:

When you click Data Connections in the Data Connections tree, you can review the All Data connections pane. This pane contains a list of all of the data connections available in your DataFlux Data Management Studio implementation. You can use the toolbar above the list to create a new ODBC or non-ODBC data connection and print the list of connections. When you select a data connection in the list, you can perform the following additional tasks:

• Edit the data connection
• Filter the data connection
• Create a data exploration based on the data connection
• Locate the data connection in the data tree

You can also double-click a data connection in the list. The selected connections pane appears, as shown in the following display:

This pane contains the following elements:

• Filter - Specifies the filter settings that have been applied to the selected connection
• Tables and Files - Displays the tables and files that are available with the current filter settings
• Toolbar - Enables you to print the list of tables in the data connection. If you select a table in the list, you can perform the following additional tasks:
  • Open the table for viewing in the Table View pane
  • Create a query based on the selected table
  • Create a data exploration based on the selected table
  • Create a new profile
  • Open a profile report (available for tables included in a profile)
  • Locate the table in the data tree

Finally, you can right-click a data connection in the data tree to access a pop-up menu. The available items vary by connection type, but they can include the following functions:

• Create a new data connection
• Edit the selected data connection
• Delete the selected data connection
• Filter the selected data connection
• Save or clear user credentials for the selected data connection
• Create a data exploration based on the selected data connection