on 08-10-2012 6:55 PM
Hi,
we would like to bring reporting on MDM(7.1 sp08) and thought of using DB Views for this.
Can anyone pls list out the activities that has to be done to get this achieved......like
where to get this software licence,
any versions in specific,
how to deploy, integrate with mdm
any other information that could be helpful ........please share
If anyone has implemented DBviews in you project, pls share your thoughts
Thanks,
venu.
Hello,
I have implemented DB views. It is a very simple task. You need to do the following:
1. Get the tool (it is actually an advanced script) from SAP. We contacted our SAP KAM
2. Create a repository slave
3. Run the script on a client computer meeting the prerequisites. This will create the actual views on the database
4. You are done
To access the DB Views directly in the database you just need a db user. You don't have to use SAP BODS to pull the data. But you can of course.
Regards,
Thomas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The driver can be found here: http://developers.sun.com/product/jdbc/drivers
Info on class path:
http://en.wikipedia.org/wiki/Classpath_(Java)
Regards,
Thomas
Hi Thomas,
.................I got little delayed with some authorization issues.
Now I have set all the parameters and installed the jre & jdbc
I am now getting an error when executing the "generateviews.cmd"
Error->"Could not find or load main class E:\data\......sqljdbc.jar"
In the document, it says to install the Install MDM Java API.
How to install the mdm java API. looks like this(java API's) can only be deployed if their is a java server in place.
kindly hep me.
regards,
venu
Hi Vladimir/Abhishek,
Thanks for your help
We have already decided to go with DB Views and what we exactly want is that
1) where to find this software
2) how to integrate on top of mdm
3) any version related challanges etc.
> Valadimir
your approach looks to be an alternate approach with portal development, which looks good when considering portal.
> Abishek
I have gone thru these links before posting, can you pls share any thoughts for startup as mentioned above.
Thanks,
venu.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Venu,
To find the software, you need to contact SAP Directly, as SAP Provides this on case to case basis, so you will have to speak with you SAP Client Partner or CIO, To understand the license cost and all.
To integrate this, you will require SAP BODS as suggest in the documents and follow the steps as mentioned in the document
As far as i know, there haven't much version related issues, if you speak to the SAP guys,and tell them, the version of SAP MDM you are using, they will guide you in the same, or you can access the Product Availability Matrix on service market place, SMP login required.
Hope this solves the query.
Regards,
Abhishek
Hi
as I understnd you want to use standard MDM views to create report.
if it is so,
create on the page resultSet iVew and search views,
see here here how:
http://help.sap.com/saphelp_mdm550/helpdata/en/45/c9cfa2cdaa4ebbe10000000a11466f/frameset.htmhave
so you have filtering capabilities on MDM tables,
and very basic report.
If you want advanced report with aggregated data,
you can do it programatically:
read desired data by MDM Java API, aggreagte in your code, and output this data to webDynPro table,
so you can have any complexity report.
If you do not want to program,
you can use 3-party tools like DataIntegrator, gettiing data from MDM web-services,
or any tool that understand web-services.
If you want to use database data under MDM, it is complex, due format of this data is not same as you see in MDM tables but reverted to single common data table, so that getting data from it
is very complex SQL Queries,
as well, direct access to this is not approved by SAP and subject to change as internal SAP format.
any more questions ?
(if what written is not relevant)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Venu,
you may check the below thread,
http://scn.sap.com/thread/1815174 for more details on the DB
you may also refer the following document, http://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/c03bbeb6-dd5b-2d10-7bb6-85655f343...
for more details
Regards,
Abhishek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
any thoughts ....... Pls share
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
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.