Skip to main content Skip to complementary content

Exporting a connection as a context

Before you begin

A database connection or a file connection has been created.

Procedure

  1. In the DQ Repository tree view, expand Metadata.
  2. Double-click:
    Item To...
    a database connection open the Database Connection wizard.
    a file connection open the connection wizard.
  3. Optional: 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. When you switch between different contexts, this enables you to retrieve the correct database structure.

    • In the file connection wizard, do any modifications in the connection information, if necessary, and click Next.
  4. Click Export as context.
    The Create/Reuse a context group wizard is displayed.
  5. 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.
  6. If you select to create a new context, set the context metadata and then click Next > Finish.
    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.
  7. Click the [+] button at the top right corner of the wizard and modify the context name as required. Click OK.
  8. 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.
  9. 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.
  10. Click Yes to confirm the operation and close the message and the dialog box.

Results

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.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here