Working with DataFlux Business Data Network :: SAS(R) Data Integration Studio 4.6: User's Guide

Overview

DataFlux Web Studio is a web-based application with separately licensed modules that enable you to perform data management tasks. One of these modules, DataFlux Business Data Network, enables you to manage relationships between business terms and technical information, such as the metadata for data sources and business rules. The relationships between business terms and technical information provide an important starting point for data governance projects.

If your site has licensed DataFlux Business Data Network, then you can use the following features in SAS Data Integration Studio:

You can select jobs in the Export Lineage window and export metadata about SAS Data Integration Studio jobs and related objects to DataFlux Web Studio. DataFlux Business Data Network users can then link terms to these jobs and related objects.
You can right-click a table in the Folders tree or the Inventory tree, and then you can select Analyze in Web Viewer. If you provide the appropriate credentials, and if metadata for the selected table was previously exported to DataFlux Web Studio, then you can view any relationships that have been defined for that table in DataFlux Business Data Network.

Prerequisites

You must meet the following prerequisites in order to use the Export Lineage window and the Analyze in Web Viewer option:

Your site must license DataFlux Web Studio and DataFlux Business Data Network.
The URL for DataFlux Web Studio must be specified in the Impact Analysis/Lineage web viewer URL field on the ToolsOptionsGeneral tab in SAS Data Integration Studio. The URL must be in the following format: http://network_name:port_number. Example URL: http://mycomputer.com:2079.
You must have a login ID and password for a DataFlux Business Data Network user.

For more information about DataFlux Business Data Network, see the “DataFlux Business Data Network” chapter in the DataFlux Web Studio User’s Guide.

Using the Lineage Export Window for Jobs

The Export Lineage window enables you to export metadata about SAS Data Integration Studio jobs and related objects to DataFlux Web Studio. You can export job metadata directly to DataFlux Business Data Network. Alternatively, you can export job metadata to a local XML file or remote XML file. You must then manually copy the file to a folder where a DataFlux Business Data Network user can import it.

Perform the following steps to export job metadata for use in DataFlux Business Data Network.

Select ToolsExport Lineage from the main menu in SAS Data Integration Studio. The Export Lineage window appears, as shown in the next display.

Export Lineage Window
Use the Folders tab or the Inventory tab to navigate to the job or jobs that you want to export to DataFlux Business Data Network.
Use the selection arrow to move one or more jobs from the Available pane to the Selected pane. Alternatively, you can double-click a job to move it to the Selected pane.
Use one of the following methods to export job metadata:

To export to an XML file to a local folder, specify the full path to a local XML file in the Output file field. You can use the Browse Local button to identify an appropriate folder. The default location for a local file is your My Documents folder. Click Start to export the job metadata. Go to Step 5.

To export to an XML file to a remote folder, specify the full path to a remote XML file in the Output file field. You can use the Browse Remote button to identify an appropriate folder. Click Start to export the job metadata. Go to Step 5.

To export job metadata directly to DataFlux Business Data Network, select the Export to web check box. Specify the full path to a local or remote XML file in the Output file field, as described above. Enter the user name and password for a DataFlux Business Data Network user. Click Start to export the job metadata. This is the last step that is required for this method. Skip Steps 5 and 6.
After you have you exported an XML file to a local or remote file system, manually copy the file to a folder where a DataFlux Business Data Network user can import it.
Notify a DataFlux Business Data Network user that you have exported job metadata from SAS Data Integration Studio. Identify the location of the file to be imported.

Using the Analyze in Web Viewer Option for Tables

If the metadata for a table was previously exported to DataFlux Web Studio, then you can view any relationships that have been defined for that table in DataFlux Business Data Network. Right-click a table in the Folders tree or the Inventory tree, and then select Analyze in Web Viewer. SAS Data Integration Studio will open a web browser and will attempt to connect to DataFlux Web Studio. Provide the login ID and password for a DataFlux Business Data Network user. You can then view any relationships that have been defined for that table in DataFlux Business Data Network.

In order to understand the relationships, you might want to become familiar with the relationship interface in DataFlux Business Data Network. For more information, see the “Importing Relationship Data and Reviewing Relationships” topic in the “DataFlux Business Data Network” chapter in the DataFlux Web Studio User’s Guide.