Search
Apr 27, 2019
How can i process DMLs (including INSERT, UPDATE statements) at remote MYSQL db to via HANA Studio?
How can i process DMLs (including INSERT, UPDATE statements) at remote MYSQL db to via HANA Studio?
2 comments
0
Follow excellence with sheer passion
SAP system running in SQL Server 2003.
DB CONNECTION --> AFIS
DBMS --> MSS
user name --> xxxxxx
DBpass -->xxxxxx / xxxxxx
Conn Info -->MSSQL_SERVER=192.168.1.233 MSSQL_DBNAME=alliance OBJECT_SOURCE=alliance
Thank you for your reply Shiv Kumar. But I did it using OData as suggested by Anubhav. But only issue is that it is taking more than 1 hour for passing and inserting 4 lakhs records there in MYSQL.
Appreciate any suggestions for reducing time of insertion.