on 07-14-2015 2:30 PM
Hi All,
Please let me know Information Steward repository table names which stores the metedata information ?
Regards,
Krishna
Any repository tables created during IS installation contain metadata on different types of IS objects;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Here's the query to list all the integrator sources defined in CMC.
Table MMT_Configuration is available in Information Steward repository DB
select business_name,technical_name from MMT_Configuration
where technical_name like '%Integrator'
I just wanted to record this in SCN though the original question is old.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Magesh,
Is there a list of "MMT" tables and their descriptions anywhere? I am unable to find documentation on the different MMT tables to do further querying within the Information Steward Repository. Do you happen to have any helpful document. Apperciate your help and input on the matter.
Hi All,
Thanks for you reply.
Let me clear you on what details are required.
In SAP Information steward we can create Metadata Integrator sources for different types of systems through CMC in order to analyse different relationships reports as Impact, Lineage reports etc. After running these integrator sources we can see these relationships in Metadata management tab in Information steward. It means SAP Information Steward is storing all these integrator sources metadata in some Information steward repository tables due to that we are able to see all these relationships in metadata management tab.
So I want the details of table which stores metadata information for these type of integrator sources.
Can anyone help me on this.
Do reply.
Thanks,
Krishna
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Dirk,
Can you let know if we have way to automate the process of exporting view result set on IS.
We can manually save then in .CSV format but my intend is to have that process automated where in we have more than 2K views setup on IS.
I am 99 percent sure we cannot pull the views setup on IS level on to BODS and then pump in the fetch result set to .CSV files...( as targets )
Any thoughts...
Thanks,
Sid
I assume you are looking for tables which stores failed records in IS Repo. If this the case then this existing doc might be helpful which have listed important tables generally we use for reporting.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.