on 04-10-2006 2:06 PM
Dear Gurus,
After getting data out of ODS objects/cubes to a table on BW server (using infospoke), If I would like to distribute that data to other applications, what are the technologies available to do that? What are their relative advantages & disadvantages?
For eg, I know of the Open hub extract pack of Acsential Data Stage which does the same. Any other such options? Thanks a lot for your help.
regards
atlaj
Hi atlaj,
1- you can also create an rfc-enabled function-module.
The external system calls the FM and this provides the data.
2 - the proposed csv-soultion of the colleague is ok and works absolutely sturdy.
3 - High fly solution: The XI component. But small customers won't be amused ...
If the solution should work in delta-mechanism (e.g. daliy scheduled), do not underestimate the efforts you have to put into corrections to the delta-handling.
by the way: 1 and 2 are proprietary solutions.
Actually, i'm afraid, no easy-to-use standard-components are available.
hth
cheers
Sven
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Gurus, Thanks a lot for your inputs. One more related question:
After dumping data to a table on the BW server using infospoke, Instead of pushing data to external systems, I would like to allow certain external systems to "PULL" data from this table. What are the options you see to perform (or facilitate) this pull?
Thanks,
atlaj
Dear Atlaj,
Another option instead of using Open Hub is to use the Reporting Agent + Download Scheduler.
You could still schedule the time you want the data to be extracted with the advantage of
having more flexibility to choose data slices (as you will be using BEX Analyzer).
The disadvantage is the need to develop a script (in VB, for instance) to get the data from
the generated xls file by the Download Scheduler tool.
Regards,
LFSS
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
one option could be generate an csv file from infospoke instead of putting to dbtable and send this csv file to other application.
or else read the db table to a csv file and send this file to other application.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.