cancel
Showing results for 
Search instead for 
Did you mean: 

DB Views on MDM

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Thomas,

I am getting an path error in step 3, think I am missing out the pre-requsites.

Pls tell me from where I can download type2 jdbc driver for MSSQL.

also need to install the Java API.

also can you please help with the config parameters( set class path )

Rgds,

venu

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

Thanks for all your answers..... got resolved

Answers (4)

Answers (4)

Former Member
0 Kudos

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.

Former Member
0 Kudos

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

Former Member
0 Kudos

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)

Former Member
0 Kudos

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

Former Member
0 Kudos

any thoughts ....... Pls share