LTMC Staging Table Load

Answered

Achin Kimtee

• May 06, 2022 10:42
• Edited

Hi,

I need to use LTMC Staging table load method for Sales Orders object. I would like to know how to populate data from SQL DB tt tables to HANA DB staging tables?

Thanks

Achin

0

• Best answer

  

  John Danos

  • May 06, 2022 14:30

  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

  • May 06, 2022 14:31

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

  0
• 

  Achin Kimtee

  • May 27, 2022 13:36
  • Edited

  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

  • May 27, 2022 16:58

  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

  • May 31, 2022 18:43

  Hi Achin,

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

  0
• 

  John Danos

  • May 31, 2022 18:43

  @..., any ideas on this topic? 

  0
• 

  Achin Kimtee

  • June 22, 2022 12:29

   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.