Skip to main content Skip to complementary content
Announcements

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 the database connection or file connection you want to export.
  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.
      Configuration example in the file connection wizard.
  4. Click Export as context.
    The Create / Reuse Context wizard is displayed.
  5. Select to:
    • Create a new context and save it in the repository.
    • Use a context group that is already centralized in the repository.
  6. Click Next.
  7. 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.
  8. To modify the context name, click Manage environments.
  9. Select the context and click Rename....
  10. Rename the context and click Finish.
  11. Click Finish to close the Create / Reuse context wizard.
    In the Database 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.
  12. 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.
  13. 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.
Contexts node containing the new context.

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 – let us know how we can improve!

Leave your feedback here