This website is not affiliated with, sponsored by, or approved by SAP AG.

Oracle, MaxDB and ODBC

Basis (Basis Technology Modules: Basis Component/System Administration, GUIs)

Moderators: Snowy, thx4allthefish

Oracle, MaxDB and ODBC

Postby Martin_US » Thu Jan 29, 2015 10:59 am

Hi Guys,

has anyone a working example of an ODBC connection string into a SAP MaxDB and Oracle?

This should ideally work to pull SAP tables into an Access/MSSQL database.

Thanks a bunch
Martin
Martin_US
 
Posts: 663
Joined: Thu Nov 07, 2002 9:40 am
Location: Walking amidst the Stars

Re: Oracle, MaxDB and ODBC

Postby Snowy » Mon Feb 02, 2015 3:32 pm

you want an MSSQL database to connect through ODBC to MaxDB and Oracle.

Right?
SapFans Moderator

Search: http://www.sapfans.com/forums/search.php
Notes: http://service.sap.com/notes
Help: http://help.sap.com
Rules: http://www.sapfans.com/forums/viewtopic.php?t=344127
Snowy
 
Posts: 28767
Joined: Mon Oct 21, 2002 2:33 pm
Location: 3.1415926535

Re: Oracle, MaxDB and ODBC

Postby Martin_US » Mon Feb 02, 2015 10:07 pm

Yes and I would assume the connection string would work like wise with Access.
We consolidate two SAP systems into one and I want to filter out unused configuration based on transactional data from the past two years.

My hope is to get only active configuration.

My goal is to download transactional tables into MSSQL and not having to create reports in SAP and having a fairly heavy load on the PRD system.

The client would like to use Access and download to do some reporting before they eventually go BI.

I would assume that there might also be an authorization requirement on the SAP side, thus a solution should be comprehensive and not sliced bread :)
Martin_US
 
Posts: 663
Joined: Thu Nov 07, 2002 9:40 am
Location: Walking amidst the Stars

Re: Oracle, MaxDB and ODBC

Postby Snowy » Tue Feb 03, 2015 9:23 am

first things first.

if you acquired your Oracle license through SAP, you are not allowed to connect to Oracle with anything else than SAP products. This being said, it is probably easy to connect through ODBC.
As for MAxDB. This is proprietary to SAP, so, go see at maxdb.sap.com to see if an ODBC driver exists.
I am unsure that using MsAccess to access SAP data is a wise choice. SAP has many tools for reporting such as BW, Business objects tools, ABAP, etc...
SapFans Moderator

Search: http://www.sapfans.com/forums/search.php
Notes: http://service.sap.com/notes
Help: http://help.sap.com
Rules: http://www.sapfans.com/forums/viewtopic.php?t=344127
Snowy
 
Posts: 28767
Joined: Mon Oct 21, 2002 2:33 pm
Location: 3.1415926535

Re: Oracle, MaxDB and ODBC

Postby Martin_US » Fri Feb 13, 2015 11:07 am

Der Snowy,

that was the classic Indian answer to a problem.
i.e. No answer.

I didn't ask about license or authority or anything the like.
I clearly asked for guidance in connection strings.
Martin_US
 
Posts: 663
Joined: Thu Nov 07, 2002 9:40 am
Location: Walking amidst the Stars

Re: Oracle, MaxDB and ODBC

Postby Snowy » Mon Feb 16, 2015 3:53 pm

Ok,

I hope you get more helpful answers from other Indians.

good luck.
SapFans Moderator

Search: http://www.sapfans.com/forums/search.php
Notes: http://service.sap.com/notes
Help: http://help.sap.com
Rules: http://www.sapfans.com/forums/viewtopic.php?t=344127
Snowy
 
Posts: 28767
Joined: Mon Oct 21, 2002 2:33 pm
Location: 3.1415926535

Re: Oracle, MaxDB and ODBC

Postby jrcygcm1 » Thu Apr 02, 2015 3:51 pm

Have you tried RFCs? you Can use them to update, delete, read any table in SAP DB (Oracle, MaxDB, DB2 .....)
jrcygcm1
 
Posts: 1
Joined: Thu Apr 02, 2015 3:42 pm


Return to Basis

Who is online

Users browsing this forum: No registered users and 7 guests





loading...


This website is not affiliated with, sponsored by, or approved by SAP AG.