on 05-27-2014 6:17 AM
Hi All,
I'm using BO 4.1 SP 2. By using IDT I was able to create a Relational connection to SAP CRM system using Jco (Java Connector). When i created the Data Foundation on top of that, i was not able to see the SAP CRM tables. It says Tables (0) and Joins (0). Is there any additional step that i need to do?
My requirement is i need to report using custom table that is created in SAP CRM.
I was under the impression we can directly connect to/ visible to SAP ECC or CRM and do reporting on top of that. Is there any other way to achieve my requirement?
Regards,
DTD
Hi
You can use relation connection to connect the SAP ERP Systems.
And to access the SAP ERP We can now use the Universe on top of SAP ERP Supported data sources.
–Classic InfoSets
–ABAP Functions
–ABAP Queries
So you need to include your custom tables in any of the supported data source according to your requirements and then able to see the tables related fields.
Please refer below steps for more info.
http://wiki.scn.sap.com/wiki/display/BOBJ/SAP+ERP+Connectivity+in+BI+4.0
http://wiki.scn.sap.com/wiki/display/BOBJ/SAP+ERP+Connectivity+in+BI+4.0
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Yes we did solve it.
Please follow the following links. This should solve it. Let me know if you have any questions.
http://wiki.scn.sap.com/wiki/display/BOBJ/SAP+ERP+Connectivity+in+BI+4.0
http://wiki.scn.sap.com/wiki/display/BOBJ/SAP+ERP+Connectivity+in+BI+4.0
Regards,
DTD
Hi De Silva,
I can able to create relational connection to CRM and can also able to see the following data sources.
–Classic InfoSets
–ABAP Functions
–ABAP Queries
But can you please give me clear details of what tou have done to see the CRM tables in the UDT. Say for example I want to use CRMD_ORDERADM_H table in the UDT so how can we get that table at the UDT.
Kindly help.
Thanks!
Sumanth
Hi,
I Heard that For CRM Data connecticivity need to use DataDirect Connect XE for ODBC driver .
For more info on this refer below :
SAP Business Objects Universe to Salesforce CRM, database.com, force.com
Regards,
Seshu.P
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.