Skip to Content
Author's profile photo Former Member

The SAPB1 Add-on that save me, Migrating SQL Server to HANA

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

Assigned tags

      5 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo ALI SHARIFF
      ALI SHARIFF

      Hi Gabriela,

      Is this addon available to download?

      Please let me know.

      Thanks,

      Ashok

      Author's profile photo Former Member
      Former Member
      Blog 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

      Author's profile photo Yatsea Li
      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

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you Yatsea

      I'll ask my boss

      I really would like to share it!!

      KR

      Gabriela

      Author's profile photo Vladimir Mladenović
      Vladimir Mladenović

      Hi all,

      Is it possible to download above mentioned tool?

       

      Thank you!!!