I am a new user of SAP.
The system works on DB2 database.
Our installation is small, there are only around 50 users.
Our support is not meeting all my needs, so I am looking for help here.
I wonder if I can connect to the database using ODBC?
Is it possible directly or do I need 3rd party tools?
When I was working with another ERP system (SQL server based),
there were no problems with connecting to the database using ODBC.
If 3rd party tools are needed (it seems so), what are your recommendations?
please provide rough prices as I do not have a big budget available.
So far I have found this:
but it seems that it requires SAP NetWeaver
which is probably not available with SAP R3 but is something extra that must be purchased additionally?
If I manage to connect to the database, is the database structure very complicated?
The database structure of our prior ERP system was not trivial, but I could figure out a lot even without documentation.
Naming of tables and fields was reasonable and it was giving clues what kind of data you could expect.
Is it the same with SAP?
Is the documentation of database structure available?
In case direct access to SAP database is not feasible for some reasons, whan can you recommend?
I could always create an own small data warehouse by exporting manually needed reports from SAP to Excel and importing them to the DW.
Is it a good idea?
what are the alternatives?
Commercial solutions of course are also acceptable, but please remember our installation is small (50 users) and we cannot afford the most expensive solutions.
thanks a lot for help!