To export a database or a file connection as a context, do the following:
In the DQ Repository tree view, expand Metadata.
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.
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 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.
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.
If you want to edit the context group, you must switch to the Integration perspective where you can open the context group to edit it.
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 Integration perspective of your Studio.