ODBC credentials enable connections to data source. The credentials contain connection
information, so they do not need to be stored inside the job, or entered when job
is run. This allows for better protection and management of security, increased confidentiality,
and a more versatile way to handle access to data sources that require authentication.
To manage ODBC credentials, complete the following steps:
-
In DataFlux Data Management
Studio, click the DataFlux Data Management Servers riser
bar.
-
Select the name of the
DataFlux Data Management Server for which you want to manage connections.
If you are prompted to do so, enter your user ID and password, and
then click Log On.
-
In the information pane,
select the Data Connections tab and click the Manage
ODBC Credentials icon.
-
To create ODBC credentials in the
Manage ODBC Credentials dialog
box, click
New ODBC Credentials. Enter the ODBC
DSN, user name, and password. Review your entries, and then click
OK.
-
To edit ODBC credentials, select a name from the list and click the Edit ODBC Credentials icon.
In the ODBC Credentials dialog box, change the user name or password that will be used to access the ODBC
DSN. Click OK to close the dialog box. Note that
the Edit ODBC Credentials icon is available
only when credentials have been saved for an ODBC DSN.
-
To delete ODBC credentials, select a name and click Delete ODBC Credentials.
You can use Ctrl + left click to
select more than one name. Click OK to close
the Manage ODBC Credentials dialog box when
you are finished. Use caution when deleting an ODBC credential. When
a name is deleted from the list, clicking Cancel will
not reverse the deletion.