By using ODBC or OLEDB you can have read access for all the ERP or Transaction Data or Database .
But at one time you have to call only 1 Database then pass another connection string to fetech another database and so on.
In you script suppose in first attemp you connect to SQL server using ODBC and ur script will fetch data from SQL then you will paste another connection string for another database that may be oracle and so on.
Finaly you can concatenate or marge your result or QVD to use in your application.
Please find out the code given below fetching data from two different server.
1ST SERVER CONNECTIONRACLE
CONNECT TO [ORACLE-old-2008-09] (XUserId is
State_Type into [..\DataSources\QVDOLD\State.QVD](qvd
Country into [..\DataSources\QVDOLD\Country.QVD](qvd
Full discloure: I am the CEO of DataRoket and we are doing a pilot right now to feed Qlikview. Our platform outputs xml or to any target DB.
We, for instance, are pulling information fromOracle 11G, SAP and a Business Objects Universe and feeding a target location (MS SQL Server). You do NOT need a staging database though since DR is also its own partitioned and high performance data repository that could feed Qlikview that way as well. We would be very interested in a pilot to show this.