on 11-03-2009 2:23 PM
Hi All,
I want to know what are the backend database and tables name where MDM repository data is stored and how to read them.
My intention is to write MS access query to perform a search to retrieve material parts as it is very difficult to do so through front end.(Data manager)
As in front end i need to search one part at a time through free form search.
I am on MDM 5.5 and i use SQL server as my Database.
Please help
Thanks
AJ
Hi Amruta,
It is very difficult to get the entire Table data because there would be few tables corresponding to one MDM table in database hence i will suggest you to try with Expression (part of FreeForm Search) which allows you to write expressions similar to validations and in addition you can use other search parameters of free form search as well.
If you want you can share what kind of search you are looking for, so that we can try with Data Manager only.
Regards,
JItesh Talreja
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jitesh,
My requirement is I want to search multiple material numbers.
The material numbers in my data model is a text field and so i m not sure how to run a query to find out say if 100 mat exist in mdm ?
If you can think of a feasible expression plz help.
Vinay,
As per you,i should not face any major problem to using Access to run this query at the database level.
If so ill be happy to use your suggestion.But plz tell me on which database table should I query and how to get the above result.
If i query on the A2i-CM_tables will i get the extract of the 100 mat i want to search.
Please guide.
Thanks
AJ
Hi Amruta,
Say you want to search whether Material Numbers 100, 300, 500 and 900 exists or not then your Expression would be
Material Number = 100 OR Material Number = 300 OR Material Number = 500 OR Material Number = 900
Click on Browse button of Expression field present under Free Form Search and select the Material Number field from the Fields dropdown (don't write it)
Regards,
Jitesh Talreja
Hi Amruta,
A2i_CM_Tables contains all the tables in Repository . Note the table name or Table ID. Eg.Main table name - Products
A2i_CM_Fields contains all the fields in a given table. Select the table name/id to get the list of all fields in the table .
Note the Field name or field Id that you are looking for .Eq. Product Name.
Write a simple query using above table and field names to search field values.
Hope this helps.
Regards,
Vinay M.S
Hi Amrutha,
Each repository on your DB server will get stored in Databases Folder . Repo can be identified by RepositoryName_m000.
Under this folder tree, 2 folders A2i_CM_Tables and A2i_CM_Fields exist which store the table and field names.
You can read these DB tables from below mentioned options.
1.MS Access > Connect to SQL Source > Define DB Server name > Select Repository name>Choose the table
2. Use SQL Server Enterprise manager > Navigate to required table (table names mentioned above).
Regards,
Vinay M.S
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The backend database name for a MDM repository is derived from the repository name (with non-alphanumneric characters removed. A repository named "products" would have an database called "products_M000".
Hope this helps,
Chris
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
9 | |
9 | |
7 | |
7 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.