Manage Data Connections

Data Management Studio (Studio) enables you to create and maintain data source name (DSN) connections, which are also referred to as data connections. Data connections can be used to access ODBC, localized DSN, SAS data set, and custom non-ODBC connections. For data connections that require credentials, you can save your credentials. If you are deploying jobs from the Studio client to the Data Management Server, contact your server administrator to create, or duplicate, the required data connections for the jobs on the server.

Note: Data connections on the Data Management Server are created and managed by your server administrator. While Studio users can create data connections within Studio, they do not have the permissions to manage data connections at the server level.

The data connections available from the Data Management Server are:

ODBC Connections are created using the ODBC Data Source Administrator available through the Control Panel or Administrative Tasks on the Server. ODBC connections created through Data Management Studio are 32-bit connections that might need to be duplicated to the Data Management Server if the server is running a 64-bit platform. e.g. MS Access Database connections. This is handled by your Data Management Server Administrator.