Page 1 of 1

Reporting tool doc_tool.mdb location

Posted: Mon Jul 05, 2004 5:37 pm
by Neil C
Can the location of the standard doc_tool.mdb database be changed from the default C: drive directory to another local drive or network drive? Failing this, I could try to find an Oracle database somewhere with enough space free.

If so, how can I do this? If not, I may get my disk partitioning changed to have more than the current 4G on the C: drive.

Cheers,
Neil

Posted: Mon Jul 05, 2004 6:12 pm
by ray.wurlod
Yes and yes.

If you move doc_tool.mdb, simply edit (configure) the ODBC data source DSReporting

To use an Oracle database, there's a bit of setting up. In the DataStage client directory (C:\Program Files\Ascential\DataStage\Documentation Tool) you will find oracle.sql, which is a script to create the required tables in Oracle. You also need to configure an ODBC data source name to connect to that Oracle database. When using the Reporting Assistant, select the Options tab and select that DSN rather than DSReporting.