Connections Manager
The Multi Data Source (MDS) Connection Manager allows administrators to create, edit, delete and test connections to data sources other than Oracle e-Business Suite instance that Wands for Oracle is installed on. It will also allow users to add specific database login credentials and local driver details to a connection they may need to run any MDS reports they have access to.
Important: Before creating a new connection, please ensure the JDBC drivers are available on the user’s machine in an accessible folder.
MDS Connections Informati
| Field | Description |
|---|---|
| Id | Connection identifier. |
| Description | Information about the connection. |
| Connection String | Connection String used to connection to the database. |
| Username | Username for database. |
| Password | Password for database. |
| Database Type | Type of database that the connection is for. |
| Public | Is the connection public and can be configured and used by other Reports Wand users. |
Driver Folder |
The folder on the local users PC where the JDBC database driver resides. |
| Driver Class | Once the Driver Folder has been selected, a list of valid Driver Classes will be made a available for selection. |
| Owner | Who owns the connection, i.e. who originally created the connection. An Administrator will see user connections, and who owns them. |
| Updated By | The user who last updated the connection. |
| Update Date | The date the connection was last updated on. |
MDS Connection Access
The Connection Manager Dialog has different access levels for Administrators and Users.
Important: Public Connections have been created by a Reports Wand Administrator, and are available for update with user specific details. User connections are connections that have been updated on a user level, and will share a connection Id with a public connection.