I need to send customization tables (T tables) data to an SQL database. There are nearly 40tables that need to be sent. We are thinking of two approaches:
1. RFC to JDBC Communication --> We created a program which sends selected table metadata and table data to XI. Can a dynamic target structure be created based on the metadata and data sent from R/3? If so how will the mapping look like?
2. File to JDBC Communication --> Create a common file structure through single file adapter and map the structures to target structure.
Can you please let me know which approach is fine and also answer RFC to JDBC query. Any help is greatly appreciated.