How to get DMETL data Exchange Information

This article mainly shows you "how to obtain DMTL data exchange information". The content is simple and easy to understand, and the organization is clear. I hope it can help you solve your doubts. Let Xiaobian lead you to study and learn this article "how to obtain DMTL data exchange information".

phenomenon description

The customer has a requirement to obtain DMTL data exchange information

[Description]

The customer proposes to do the exchange display of web interface in his own system to monitor the status of data exchange. Because DMTL does not provide relevant program interfaces, this requirement cannot be realized by interface.

processing method

Through the external library of DMTL, users can obtain information about data exchange.

First, deploy a DM7 database on the installation server of DMTL, and create a new user DMTL for storing the system table of DMTL;

Then when installing DMTL, select "Use external database", database IP select the IP address of dm7 deployed in the previous step, enter the correct values for port, username and password, and finally complete the installation;

After the installation is completed, execute a data transformation task, and query the data exchange information of DMTL under the DMTL mode in the deployed external database;

The following query statements exchange information:

select * from DMTL_FLOW_SCHEDULE; --schedule information of the transformation

select * from DMTL_RUN_LOG; --ETL running log, view job start time, end time and job running status

select * from DMTL_ALERT; --ETL's operational alert table

select * from DMTL_RUN_STAT; --View statistical information of data processing, number of items inserted, updated, deleted and read

select * from DMTL_OP_LOG; --ETL operation log table, auditing ETL operations, such as etl start, stop, create, modify, delete and other information

The above is "How to get DMTL data exchange information" all the content of this article, thank you for reading! I believe that everyone has a certain understanding, hope to share the content to help everyone, if you still want to learn more knowledge, welcome to pay attention to the industry information channel!