Question:
I need to load data from 3 different systems in BW, which databases are in Microsoft ACCESS. Had anybody done it before or known how to connect both systems (BW-Microsoft ACCESS)? It is possible? Is there a protocol or way to do the connecting between BW and Microsoft ACCESS. I don´t know, but If BW can work with EXCEL could it work with ACCESS?.
Please if somebody can help me I will appreciate it a lot.
Thanks in advance.
Meyling.
Answer:
Create InfoPackage to a file load (MSAccess?)
Answer:
I looked at DB-Connect but it does not seem to support Access databases.
How about extracting data from Access to a text file and then upload that to BW?
Just as you save Excel data to a .csv file and then upload to BW.
Answer:
I looked at DB-Connect but it does not seem to support Access databases.
How about extracting data from Access to a text file and then upload that to BW?
Just as you save Excel data to a .csv file and then upload to BW.
--------------------------------------------------
It's exactly the way that we won't want to use, it's because there are many source system and it will be so complecated to maintain routines that extract information from Access, then put the información in flat files and then send them to BW server in order to be load in BW system. We are looking for an automatyc way to do it. We thought if BW can connect with Microsoft EXCEL... why not with Access? We will continuing searching ... if you now something... let it knows... meanwhile... thank you very much.
Answer:
BW interaction with DB-Connect and Excel is Apples to Oranges. BW interacts w/ Excel on Output, DB-Connect is input.
DB-Connect does not support Access, but it does support SQL Server (MSSQL).
It sounds as if you have many Access databases, and that the information is important. So you have a couple of options.
1. You could automate extraction from the various databases via DTS packages in MSSQL. (You would have to setup DSN's to access each of the Access databases.)
2. You could migrate your Access database to MSSQL, which would allow you to automate even more via DTS and either DB-Connect or Flat File loads into BW. You could still have the Access front-ends using linked tables in Access.
3. You could create a VB application which automated the pulls from Access to Flat file.
4. Open Hub???? - I don't know much about this, but I know there are some options here.
In any of the cases, to get the data from Flat file (or DB-Connect) you can use DTS or the VB app to fire SAPEVT to trigger Process Chains to pull the data into BW.
I would recomend highly that if the data is important, it would be best to move it into a real DBMS.
My .02
- Stephen
Answer:
thank you very much!! this is the way that we want to work.
About your comment of EXCEL is Output and Access is input you are absolutely right, I made the comment just because Access and Excel are form the same branch "Microsoft" and for that reason I thought it could be routines and other tools to connect then automaticaly. In our project we just need to load data in BW from Access and then showed them in HTML or Excel, not to put them or visualized in Access again.
About your suggestion of VB we are seriously think about that, but the thing that more keep my attention is DTS packages and the setup DSN's in order to access earch of the Access Databases, Could you please tell me where can I find more information about the uses of those tools? I have never heard about DSN and DTS package.
Thank you very much.
Best Regards
Meyling.
Answer:
http://www.microsoft.com/sql/
Thats a start.
DTS - Data Transformation Services. It is part of Microsoft SQL Server. If you want a comparison, it is like BW Process chains but much, much broader.
DSNs - Can't remember the acronym, but what it is simply a configured name referencing a database. It supports just about any DB type from Access to Oracle. For Windows you want to download the latest MDAC which can be installed on client or server.
Any Microsoft Access book should cover DSN's in the detail you need. Books online (installed w/ SQL Server generally) will give you the background you need on DTS.
There's way to much to go into here.
- Stephen
Answer:
Thank YOU VERY MUCH!! I have right now something to do!!
Thanks again for your help!!!