Change Tracking - API

[Former Member]

Hi all,

I would like to know if it is possible to retrieve the change tracking information using MDM Java or MDM ABAP API. I quickly had a look at the Java API but didn't find anything relevant to this.

Is there an alternate way to retrieve the information through API?

If SAP didn't provide any API to retrieve this, Is it a suggested approach to directly query the database (XXXXX_Z000) and retrieve the information through the standard JDBC API?

Any suggestions are highly appreciated.

Thanks.

[Former Member]

The Change Tracking application provided by SAP uses JDBC and SQL to retrieve the data from the change tracking (_Z000) databases. At present the MDM API's do not expose functionality for retrieving change tracking information.

Walter

[Former Member]

Maybe someone should file a "feature request" for the next version?

[former_member496675]

Hi Suman,

There's a change tracking application available with SP05 patch0 onwards that you can deploy on EP. It will display all the information from the change tracking table. Internally, it must be using java/JDBC calls to get that data. But, that API is not yet exposed.

In the absence of any API, the only other approach is to by pass MDM and get information directly from the table.

Regards,

TS

[Former Member]

Hi TS,

Thanks for the information.

I have already tried the change tracking application you suggested. But I need to add a few more fields and customize the report on the Enterprise Portal. That's the reason I was exploring the possibilities of doing it using some API. I got a chance to look at the source code of the change tracking application that SAP provided. It does make use of JDBC calls to retrieve the information.

Thanks

Suman

[Former Member]

Hi guys,

Is there really a place where we can get the source of the Change Tracking webdynpro from? How did you send the request for the source code to SAP? We could also use that to improve the performance of the Change Tracking. We currently have 27 million records in the tables and we're looking into implementing new indexes in Oracle, etc...

Regards,

Boris

[Former Member]

Currently there's no way to retrieve the change tracking information using the MDM Java API. You can use the JDBC to access the information but direct access to the DBMS is normally discouraged and is not supported.

[Former Member]

Then how does the WebUI access the change tracking information?

After all, it's Java-based...