Re-configuring the Reporting Tool?

fridge · Post by **fridge** » Thu Sep 23, 2004 3:37 am

Hi folks.

I have been using DS for a couple of months and have only just discovered the Reporting Assistant tool and the corresponding Access DB in the client directory.

I am interested in the possibilty of moving this access DB to a shared drive. Besides copying the access DB to the relevant directory I assume I will need to configure the target schema DSN 'DSReporting' (the option at the moment which passes the data to the access DB in my client directory) to point to the right place. Will there be a file called 'DSReporting' existing somewhere in /DataStageApp/Ascential/DataStage/DSEngine/..... ?

Please note my intention is not to amend anything as yet. I just want to know what would be involved and what any unforseen implication may be.

Thanks in advance for any advice.

kduke · Post by **kduke** » Thu Sep 23, 2004 9:10 am

I would not change your DSN. Just update the local one and archive onto a shared drive. I have macros which will truncate all the tables and then I compact and repair it. Next I populate it with a new project or the same project with new data. If you keep these access files small they performa better. Then I copy it and name it something like doc_tool_project_yyyymmdd.mdb.

fridge · Post by **fridge** » Thu Sep 23, 2004 9:32 am

Thanks for the help Kim.

Is there anyway to schedule/automate the loading of the access database?

kduke · Post by **kduke** » Thu Sep 23, 2004 11:39 am

Not that I know of, maybe Ray knows.

ray.wurlod · Post by **ray.wurlod** » Thu Sep 23, 2004 4:10 pm

Unfortunately the answer is (definitely) no.

Further, the readme for 7.1 (or 7.5, not 100% sure) states that there will be no further development of the Documentation Tool (so we'll never see it picking up Job Sequences, for example); Ascential want you to buy MetaStage to generate the same reports.

fridge · Post by **fridge** » Fri Sep 24, 2004 1:03 am

Thanks very much for the information Kim and Ray.