Running Quincy Funds on Oracle

The default ATG installation uses a SOLID database for storing Quincy Funds data. You may want to test Quincy funds on Oracle to see how an application performs on a production-ready database. To run Quincy Funds on an Oracle database, complete the following tasks:

Before you begin, you need to install an Oracle database and client, which you can use to manipulate the data contained within the database. For instructions on installing and setting up Oracle products, see the manuals that accompany the software.

Note that running the Quincy Funds demo on any database other than SOLID or Oracle is not supported.

Preparing to Import Data to Oracle

Before you can populate your Oracle database, you need to copy the Quincy Funds data from SOLID to a neutral file. The export process generates all.xml in <ATG2007.3dir>\home to hold the exported data. You also need to generate the Oracle schema.

  1. Start SOLID, then ATG 2007.3.

  2. From a SQL Plus Client, run the following scripts to generate the schema:

    @C:\<ATG2007.3dir>\DAS\sql\install\oracle\das_ddl.sql
    @C:\<ATG2007.3dir>\DPS\sql\install\oracle\dps_ddl.sql
    @C:\<ATG2007.3dir>\DSS\sql\install\oracle\dss_ddl.sql
    @C:\<ATG2007.3dir>\DSSJ2EEDemo\sql\install\oracle\dssdemo_ddl.sql

  3. From a command prompt, run the export command to create all.xml and copy data from SOLID to it:

    <ATG2007.3dir>\home\bin> startSQLRepository -m DSSJ2EEDemo
     -exportRepositories all
    all.xml -repository /atg/userprofiling/ProfileAdapterRepository

Configuring ATG 2007.3 to Use Oracle

After you’ve installed ATG 2007.3, you need to set two components so that they correspond with your Oracle database:

  1. Launch the ATG Control Center.

  2. In the Pages and Components > Components by Path task area, navigate to /atg/dynamo/service/jdbc.

  3. Double-click the FakeXADataSource component so it opens in the Component Browser. Change the Configured values for these properties if you’re using an Oracle thin client:

  4. Be sure to save your changes to the live site.

If you want to revert to using SOLID, change these properties back to their original values:

Populating the Database and Testing the Result

After you’ve imported the data from all.xml, test the database to ensure that it does in fact contain the data you intended to import.

  1. From a command prompt, run the import command to populate Oracle with the data from all.xml:

    <ATG2007.3dir>\home\bin> startSQLRepository -m DSSJ2EEDemo -import all.xml
    -repository /atg/userprofiling/ProfileAdapterRepository

  2. Start the Oracle database and restart ATG 2007.3.

  3. From a SQL Plus client, run the following command to query the database for user data:

    select * from DPS_USER;