I am interested to know the advantages and disadvantages of using SAP DBCON Methodology to connect to MS SQL and update data to the same.
We have a home grown application which needs data from SAP, currently they are manually downloading data from SAP to a network drive and uploading to MS SQL using a custom program written in ASP.
I am thinking to automate this process by using DBCON to update SQL database.
directly from a ABAP Program.
We don't have SAP Business Connector or SAP XI Implemented so those ideas are ruled out!!!.
I am not considering to use SAP Webservices for ABAP as there could be issues tranferring bulk data (>15 MB) in the form of XML.
Please let me know your thoughts on it.