To use the Extract Data to Database feature, you must configure a data source name (DSN) to provide a connection between the database server and application server. The DSN specifies the database server name and other database-related information, such as the username and password of a user with full access rights to the database server.
To create a DSN:
Select Navigate, then Administer, and then Consolidation Administration.
From Admin Tasks, double-click Configure DSN.
Click Create Data Source.
Enter a Data Source Name for the destination database.
From the Database Type drop-down list, select a database type: Oracle, SQL Server, or DB2.
Enter a username and password.
Ensure that the user is granted privileges to create, update, and delete tables.
Enter the server Host name.
Enter the Port number.
Optional: Enter a default tablespace or filegroup name.
Optional: Enter an index tablespace or filegroup name.
Click Test Connection.
When the system displays the “Successful” confirmation, click Save to save the DSN.
Click Refresh to display the updated DSN information.
After you have created and saved a connection, it is displayed on the Configure DSN page. If you need to edit it at a later time, you can edit it by clicking Edit DSN, or you can delete it when it is no longer needed.