Follow excellence with sheer passion

  • Home

  • Offerings & Downloads

  • FAQ

  • Testimonials

  • Contact Us

  • Testimonials

    1. SAP UI5/Fiori Forum
    2. How can i process DMLs (including INSERT, UPDATE statements) at remote MYSQL db to via HANA Studio?
    Search
    Nidhi
    Apr 27, 2019

    How can i process DMLs (including INSERT, UPDATE statements) at remote MYSQL db to via HANA Studio?

    2 comments
    0
    Shiv Kumar
    May 25, 2019

    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

    0
    Nidhi
    May 25, 2019

    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.

    0