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.