on 06-04-2009 6:04 AM
Hi Guys,
I have a requirement where a legacy database sends data close to 4000 records (via a script) to a MS access database.
of the four thousand, the script is such that it fetches data upto 2 yrs old..where as when the interface runs in XI it will be run on daily basis..how can i filter the above in XI?..ther is not even a time stamp in the antiquated legacy database..
Also , could u throw light on how i should get the details for connection from XI to MS access?
Hi
For MS ACCESS
/people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn
In MSACCESS add extra field Status and ask script to populate by default "F"
When picked by Sender JDBC Adapter make it to update "T"
Rgds
srini
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Do with Server proxies
http://help.sap.com/saphelp_nw04/helpdata/en/2b/f49b21674e8c44940bb3beafd83d5c/content.htm
/people/siva.maranani/blog/2005/04/03/abap-server-proxies
/people/ravikumar.allampallam/blog/2005/03/14/abap-proxies-in-xiclient-proxy
rgds
srini
FYI~~
if the concern is on the number of records being pulled by JDBC adapter, I have had scenarios where over 50 thousand records were being polled into XI. Without any complex mapping or BPM it took under 20 min to process the whole data.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
ABAP server proxy is ok..but i was keen on finding out if ther is any info available on Sender JDBC using MS access DB?
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 | |
25 | |
12 | |
9 | |
7 | |
6 | |
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.