How to: |
The Connect to Data page provides a process for connecting to data and creating a base synonym or cluster synonym. It can be used to create metadata for different types of data sources. Some of options and parameters vary depending on the type of data source. The Connect to Data pate enables you to:
When you complete a task, you can click Next on the ribbon to move to the next step.
To return to the full console, click X at the top right of the page.
Access the wizards by clicking Connect to Data on the sidebar.
The combined Upload and Connect to Data page opens, as shown in the following image.
The Desktop files section is used to upload local files. For more information, see Uploading Files.
The Server Datasources section is used to configure adapters, create connections for existing adapters, and create metadata for these data sources. For more information, see Connecting to Data.
In the Server Datasources section of the Connect to Data page, you can perform one of the following tasks.
The Connection Parameters page opens. Enter the connection parameters.
Note: Connection parameters for each adapter are described in the Adapter Administration manual.
The Add Connection page opens. Enter the connection parameters.
The Change Connect Parameters page opens. Change the connection parameters.
The Duplicate Connection page opens with parameters entered for the same adapter and the same server as the original connection. You can use this to connect to a different database than the one in the original connection, or use a different type of security model.
After completing the Connection step, you can create synonyms for configured adapters and connections.
For an SQL adapter, the Available Objects page opens, as shown in the following image.
The ribbon is shown in the following image:
The Show DBMS Objects page has been designed so that you can enter all the parameters needed to create or update base synonyms or create a cluster synonym on a single page.
The options are specific to the type of adapter. Synonym creation parameters for each adapter are described in the Adapter Administration manual.
You can search for objects by entering a term in the search text box and clicking Search.
The DBMS objects list enables you to select objects to add to the cluster and assign them as facts or dimensions.
You can select each fact and each dimension manually, or you can right-click a fact or dimension table name and select one of the following options, which are available if foreign key to primary key information is available in the RDBMS:
When you have selected the fact and dimension tables, click Next on the ribbon to open the Save As dialog box, so you can save the synonym.
After the synonym is saved, the Applications page opens. You can edit the synonym by right-clicking the synonym on the application tree and clicking Open. For detailed information about enhancing the synonym, see Using Data Assist.
After you import metadata, you can open one or more synonyms in the Synonym Editor. Each synonym opens in its own tab (at the bottom of the window). Depending on the structure of the synonym you open, this step creates a logical view of the synonym using Business View or Dimension View templates.
The Edit Metadata page opens, as shown in the following image for a cluster. The Business View (logical view) of the data is open by default.
The Join Editor is open showing the joins included in the cluster, with a Data pane you can use to add tables to the cluster.
The Output pane is open to show sample data.
Note that each data item has an icon that indicates the data type of that item.
All of the options are described in Using Data Assist.
You can show the Table/Column (physical) view by clicking the icon on the sidebar.
The Save As dialog box opens.
The Test Query page has three panes, as shown in the following image.
The Metadata pane lists the metadata available for the query. The Query pane has categories in which you can place the data for summation, sorting, and filtering.
The ribbon provides Undo and Redo actions.
WebFOCUS | |
Feedback |