Before you begin
About this task
To export a database or a file connection as a context, do the following:
- In the DQ Repository tree view, expand Metadata.
Item To... a database connection open it in the connection editor, and then click Edit... in the Connection information panel to open the connection wizard. a file connection open the connection wizard.
You can perform one of the following actions:
In the Database Connection wizard, do any modifications in the connection information, if necessary and click Next.Make sure that the database name, the schema name or the catalog name is defined in the wizard. This enables you to retrieve the correct database structure when you switch between different contexts. For further information about switching between contexts, see Switching between different contexts of the same connection.
In the file connection wizard, do any modifications in the connection information, if necessary, and click Next.
Click Export as context.
The Create/Reuse a context group wizard is displayed.
- Select to create a new context and save it in the repository, or to use a context group that is already centralized in the repository, and click Next.
If you select to create a new context, set the context metadata and then click
.The variables and values of the selected database or file connection are automatically defined in the wizard and the new context is named as Default.
- Click the [+] button at the top right corner of the wizard and modify the context name as required. Click OK.
Click Finish to close the Create/Reuse a
context group wizard.
In the Database Connection wizard, all connection settings are set as context and are read-only.In the file connection wizard, all connection settings are set as context and are read-only.You can open the context group to edit it from the Contexts node in the DQ Repository tree view.
Click Finish to close the wizard.
You can always click Revert Context at the bottom of the connection wizard to switch the current database or file connection back to its initial state.A message is displayed prompting you to propagate the change in the connection type to all the Jobs and analyses that use the connection, if any.
- Click Yes to confirm the operation and close the message and the dialog box.
The database or file connection is exported as a context and listed as a context item under the Contexts node in the DQ Repository tree view.