We are about to go life with HANA on a Customer.

And as you might Know there is some Tool posted some time a go to help  SAPB1 teams with the translation of queries and Formatted searches.

Although the tool is really nice it takes an additional effort to take your SQL Server queries, formatted searches and views and SBO_Transaction_Notification to the real string that will actually work on HANA.

There’s a manual review process that a Human should do, before having your Queries running smoothly on HANA.

When I was actually translating my 320 Queries I realized 2 things:

  1. There’s a priorization need to be done (The users might not be using some of the queries…)
  2. I Need something to save the time I take to update manually the queries after the ConverterLib translates them…
  3. We could save lots of time due to the fact that the only 2 things that might not work in HANA but Will on SQL Server is the IFNULL and Convert. So I could have saved lots of time by changing some of the syntaxis details over SQL Server even before Migrating to HANA!!!!!!!!!!!.
  4. When you are about to go live you need to Know what is working on HANA and what is not other wise you’ll be caught on a big Excel Jungle (there’s a tiny little possibility of having to translate Queries after going live, )

After reaching point Number 2, I couldn’t help myself and I started writing code to make my life a little bit easier than before, using the Library called ConverterLib. I create an Add-on wich helped me to.

  1. Priorize the queries I want to translate
  2. A tool where I can actually make all the changes after using ConverterLib
  3. A tool where I can translate my queries on the SQL Server Infraestructure
  4. A tool where I will be able to track what has and/or has not been translated.

Take a Look on Youtube: The idea that saved me when Migrating SAP B1 to HANA – YouTube

I’m on the first version of it… I have more new ideas ..

I can’t help myself I need to write more code….

Still working on adding views and Stored Procedures….(Coming Soon!!!)

Hope you like this… and if you have more

please send me more ideas!!
sky is the limit…

Happy Migration to HANA

To report this post you need to login first.

4 Comments

You must be Logged on to comment or reply to a post.

    1. Gabriela López Post author

      Dear Ali

      It’s an idea actually!!
      I haven’t shared it yet, but I’m asking authorization of my Company to do it.

      Kind Regards,

      Gabriela

      (0) 
  1. Yatsea Li

    Hi Gabriela,

    That is a great idea about the tool to automate all the translation of query related customzation in B1. Just wonder if you’re willing to share the tool or not. That will be helpful to the community.

    If you’re willing to share, I can help to publish the tool on SCN for you.

    And also of coz feel free to say not too. 🙂

    Very helpful insight about the query migration practice. Thanks.

    Kind Regards, Yatsea

    (0) 

Leave a Reply