cancel
Showing results for 
Search instead for 
Did you mean: 

file-xi-jdbc scenario

Former Member
0 Kudos

Hi

If anybody come across the business rek for the scenario like file-xi-jdbc (Basically JDBC on the receiver side) could you plz explain me the same ??

Regards

Kumar

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

I'm sorry, I don't delve to far into what the SAP systems do here, but what I do know is that our company uses them for most of our information management. The problem is that this company has been in operation long enough that older parts of the business are still using legacy systems, while newer parts are using SAP systems, the legacy systems still require the DB for usage. So to keep all our systems up do date, we use the DB as a central storage, where systems can retreive up to date information. Also there's a possibility that our SAP systems might have memory issues if we were to store all this data on them, whereas a DB2's main function is to store information.

Also what Aamir is talking about is very important for real time scenarios, we do back up a lot of data onto the DB tables. I believe these backups are done once daily at our business and because of the large amount of data being processed they are done at night. I've personally written an interface that does this.

I hope this gives you a better idea, I'm sorry, I don't know which legacy systems are requiring the DB2, but I assure you, there are a lot of them.

Former Member
0 Kudos

The Business scenario: Supose sap sending the data using proxy that data they want to load a database for allocation purpose or back up purpose depending on situvation. you can use XI - JDBC.

2) if suppose any data coming from File that data we can use XI (JDBC) Load into the tables for back up(depends).

3) For this depending on your third party database we have to load the drivers for JDBC.

Answers (2)

Answers (2)

Former Member
0 Kudos

We have our SAP systems the take in part orders from many locations, but these orders are stored in a DB2 system. So we have to update the DB2 with these part orders at the end of every day with XI. They need to be on the DB2 because other systems are configured to use that as the part information source.

Former Member
0 Kudos

Hi Paul,

This is what I am expecting. Really appreciaed your reply ! Could you plz tell me what are all other systems that use DB2 as information source ?? Just like to know the business rek ?? If you have SAP for example R/3 you can use itself as a information source right ?? Even you can transfer to BW system ??

Just evaluating the JDBC adapter use in real time scenario ??

thanks

Kumar

Former Member
0 Kudos

Hey

it can be any scenario,suppose you want to send sales date from some FTP based legacy system to a newer version of data base system,then you can use File to JDBC scenario.

Thanx

Aamir suhail

Former Member
0 Kudos

Hi Aamir,

If you have SAP system on the receiver side either you can use proxy or idoc even right ?? If I am not wrong even most of the non-sap systems also have the capability to directly process the flat file. So I am looking for soem real world business rek that compells to use JDBC on the receiver side!

Regards

Ravindra

Former Member
0 Kudos

hey

>>So I am looking for soem real world business rek that compells to use JDBC on the receiver side

thats why i said you are sending message from legacy system to database system,its a possibility that you want back up all the data to the database system.as a matter of fact i have worked on a similar scenario so its real world:)

Thanx

Aamir suhail