Question:

Could you guide me on setting up automated report generation in DTM Schema Reporter Professional?

Answer:

Ensure you have DTM Schema Reporter Professional installed on your system. It supports a range of Windows versions, including XP/Vista/7, 8/10 (desktop), and Server 2003/2008/2012/2016.

Step 2: Connect to Your Database

Open DTM Schema Reporter and establish a connection to your database. The tool supports various database interfaces like ODBC, IDAPI, OLE DB, or Oracle Call Interface.

Step 3: Select Database Objects

Choose the database objects you want to include in your report. You can select all objects by default or customize the selection according to your needs.

Step 4: Annotate Your Objects

You can add comments or annotations to your database objects. These notes can be manually entered or automatically extracted from the database if supported by your DBMS.

Step 5: Choose Output Format and File Name

Decide on the output format for your report. DTM Schema Reporter Professional offers several formats, including RTF, HTML, XML, CHM, PDF, Excel, and plain text. Specify the file name and location where the report will be saved.

Step 6: Schedule the Report Generation

To automate the report generation, you’ll need to use an external scheduler like Windows Task Scheduler. Set up a new task that runs DTM Schema Reporter with the necessary command-line arguments to execute the predefined project.

Step 7: Monitor and Maintain

After setting up the automated process, monitor it for the first few cycles to ensure everything runs smoothly. Maintain the scheduler tasks as needed, adjusting the frequency or parameters according to your reporting requirements.

By following these steps, you can efficiently set up automated report generation in DTM Schema Reporter Professional, saving time and ensuring consistent documentation of your database schema. Remember to check the official documentation or support resources if you encounter any issues or need more detailed instructions.