Help Required -- Can we use SQL Query to READ data from SAP MDM Tables

[Former Member]

Hi All,

Please help.........

Can we use SQL Query to READ(No Creation/Updation/Deletion just Read) Data from SAP MDM tables directly, without using MDM Syndicator.

Or direct SQL access to SAP MDM tables is not possible. Only through MDM Syndicator can we export data.

Thanks in Advance

Regards

[Former Member · Accepted solution]

Hi Rono,

I am confused. Is this question different than the one you have already asked ? Thanks. Siva k.

[Former Member · Accepted solution]

All the tables you create in Repository comes under A2i_CM_Tables in Database named as your repository name. So the tables names are fields of table A2i_CM_Tables. Now i tried it but cant make it.

Now, I dont think its possible to extract all fields in tables and there values using select query. May be pure sql guy can do that or not.

But there is no relation of data extraction and syndicator. Data is viewed in Data Manager. and you can also store data in a file from DM also.

BR,

Alok

[michael_theis]

Hi Rono,

yes, you can do this. But it'll be not an easy way to go. MDM stores the field and table data in generated database tables. To find a field in a table, you'd have to analyze the A2i_CM_Tables and A2i_CM_Fields tables first, to find out the correct internal field ID which is then a link to the data tables...

Why don't you use the standard API? It is available for C, Java and ABAP and helps you to easily retrieve data for your own programs...

BR Michael