ETL and Data Integration tools - Modern ETL software for everyone

I need to know if this product can be used to produce a document that describes the ETL process that you create when using the product. A document like this could be used to review the process with clients or QA before the process is run. Some products generate these docs directly, and with some products you can write code (SQL) to extract and format the information from the repository to produce the doc.

Thanks very much for any help with this!

There is no such functionality a the moment
However we are planning to add it to the future releases

Thanks for the information. I understand that the product does not yet provide this feature directly. But until it does, could I write code (SQL) to query the database and extract the information about the transformations, and then use the results to produce my own report?

Yes, I think you should be able to write simple reports
Have a look at C:\Program Files\DB Software Laboratory\Repository\VImpRepository.mdb file.
It will give an idea about repository structure.
<span class=&#39;smallblacktext&#39;>[ Edited Wed Jun 29 2005, 02:40PM ]</span>

I have looked at the repository structure as you suggest. At this point it looks like the mapping information would be within the OBJECT_DATA column of the OBJECTS table, which is a binary data type. So far I cannot figure out how I could write a query to obtain usable information from this column.

Am I correct that this column holds the actual mapping information, and if so, is there some way a query can extract usable information? Otherwise, is there some other place in the repository I should be examing?

Thanks.

It is a binary field which stores spripts/packages text defintions.

Depending on your database(repository) you may use different functions to display data from OBJECT_DATA field for example you may use to_char function for oracle.