This step creates the Reporting Center data source, which is used by ACI to connect to the ATG data warehouse. Configuration information may differ depending on your database vendor; the steps that follow assume you are using the SQL native data source.
Note: A Reporting Center data source is not the same as an ATG datasource component.
As a prerequisite to this step, you must have the Microsoft SQL Server client installed.
To create the data source:
Go to the ATG Reporting Center (
http://server/arc/cgi-bin/cognos.cgi) and log in as the administrator :User name: admin
Password: adminFrom the Reporting Center, go to: Launch > Reporting Center Administration, and then click the Configuration tab.
From the Configuration tab, click the New Data Source icon (
).From the New Data Source page, type the name for the new data source:
Name: ATGDW
Note: You must use ATGDW as the name for the data source. Additional information (such as Description) is optional.
Click Next.
Select the Type. For example: Microsoft SQL Server (SQL Native Client)
Click Next.
Provide the Server Name and Database Name.
Under Signons, select Signons and if desired, provide a User ID and Password. This will allow automatic login to the database for all users. Credentials entered here should be the same as those created for your data warehouse.
Under Testing, click the Test the connection link.
From the Test the Connection page, click the Test button. Verify that the test completes successfully, and then click Close.
Click Finish.
