Skip to Content
0
Former Member
Jan 16, 2009 at 01:05 PM

Dynamic Table insertion using JDBC

23 Views

Hi!!!

I am using SAP XI to insert data from SAP database To oracle database.

I have to insert data into 40 different tables.

Is there any possible way through which I can insert data to these 40 different tables using same scenario.

Since we can define TABLE NAME as a variable.. is it possible to define fields as variable?

I have successfully configured a scenario using the following blog:

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

but the problem is we have to give table field names as constants... Is it possible to declared it dynamically.

Thanks in advance