Skip to main content

LTMC Staging Table Load

Answered

Comments

7 comments

  • Best answer
    John Danos

    Achin, Here is an article on connecting to LTMC to populate tables in HANA DB Staging.

     

    https://support.syniti.com/hc/en-us/articles/5915267493015-LTMC-Migration-Cockpit-Loading-Staging-Tables-with-OpenQuery 

    0
  • Achin Kimtee

    Thanks John!! Will check and get back for follow-up questions

    0
  • Achin Kimtee

    Hi John/All,

    We have setup LTMC project and staging tables. We are getting an error while inserting BLOB data to HANA DB from SQL server. - query insert of blob value not supported. This field is present in header long text data for Sales Order object.

    Any suggestion to handle this?

     

    1
  • Ben Bauer

    Hi Achin,

    Thank you for reaching out. I have notified the team of your question. With the US holiday weekend, I expect we might not have an answer for you until Tuesday. I do appreciate your understanding.

    0
  • Eric Weldon

    Hi Achin,

    Are you able to convert the data to NVARCHAR MAX in HANA when inserting it into MSSQL?

    0
  • John Danos

    Andrew Lund, any ideas on this topic? 

    0
  • Achin Kimtee

     Eric Weldon Below is the workaround we are doing as of now.

    We have created a temp table in HANA with datatype Nvarchar(1000). First we are inserting the data in the temp table and then we are directly running an insert statement from temp table to actual staging table in HANA Studio.

    Regards

    Achin Kimtee

     

     

    0

Please sign in to leave a comment.