I would like to access my SAP Database (its on oracle) using ODBC or Oracle Drives so that i can directly connect it using Crystal Report or any Application that can get data directly to report i design using the tables and relationship.
I think i have not made it clear that i don't want to make any changes to SAP Database, what i want is just to have read only or Select data from sap Database directly so that i can use external reporting tools for doing analysis and reporting as per my requirement.
The tools like crystal reports or xcelcius do not connect to the SAP DB directly. In case you have a standalone DB then maybe you can connect. The standard procedure is to connect your Crystal reports to SAP BO, which in turn connects to the SAP BW( or any) Application and you can read the data present in DB. You can also use the Universal builder tool to build your universe.
In case you have further doubts kindly raise your queries in BO forums. You will get better responses there.
For your prompt response but i wanted to know the driver or adapter for direct connection to SAP Oracle database. As the application that i am using can connect using ODBC to any database.
if you want data from SAP BW from crystal reports it is possible through mdx query connection crystal reports but you can access this data through info cueb,dso's, multi providers, quires
And also you can directly get the data of sap r3 system(oltp) from crystal report using sap drivers that is advantage of crystal report it can access data from oltp system also
Could you advise is there any posibility of having ODBC connection to SAP database (Oracle 11g) or any reference doc that can specify the procedure or method.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.