Oracle to SAP Hana Online Presentation


Demo presentation text:

Hello,

In this video Ispirer Systems shows you how Ispirer Migration and Modernization Toolkit 2015 (MnMTK 2015) can automatically migrate Oracle data base to SAP HANA.

I will show you how to migrate objects directly from Oracle database and how to make script conversion.

In Oracle database I prepared a special user “Oracle to Hana”. It contains different tables, views, indexes and a package. This package contains two procedures which will be migrated to Sap Hana. It also contains procedures, a function and triggers.

To make migration from Oracle database we will use SQLWays Wizard tool. In this tool we’ll specify the ODBC connection to the source database, user and a password.

On the next page we’ll specify the target, it’s Sap Hana in our case, all the necessary information for importing the source objects to Sap Hana, user name and a password. Also we’ll specify the direction to HDBclient tool. Using this tool we’ll import all our objects to Sap Hana.

Also we can specify an option for migration of source Oracle tables into Sap Hana Column Store.

I will choose this option and will show you how it works.

We click next and then we can see all the object in the source database. I will choose the objects which are to be migrated. Tables, views, stored procedures, function, triggers and the package. Now we’ve chose all the necessary objects.

On this page you can specify different options. For example we can choose “Omit schema names”. In this case the source schema will be omitted and all the objects will be created in the default Sap Hana schema.

Also we can specify termination string for statements. On this page we can also specify database data type mapping and a lot of other different options.

We click next. Here we should specify export directory. In this directory SQLWays Wizard will generate ddl files, bat files with commands for loading objects into Sap Hana database and report files.

Then we click next and SQLWays Wizard tool starts exporting the objects. So ddls have been exported and generated. Actually you can see the information about the export process in this log.

So all the objects have been exported: function, triggers, and package. Now we can check the export files. You can see that for all the objects a ddl file was generated. It contains a commented source and Sap Hana equivalent. The table that we chose earlier was converted into Column store.

For all the objects there was generated a bat file. It contains commands for objects import into Sap Hana using HDBsql tool which is provided in Sap Hana package.

Let me show that all the objects were generated here. Also for the export process there was generated a log file. Here you can find all the information about the exported objects. And actually the same information but in more readable format you can find in sqlways_report.html file. It contains all the information about the exported files. Tables, views, stored procedures, the package. So here you can find the information about the number of objects, their size, data, and time needed for the extraction.

Now all we need is to start import into the target database. Let me show you that the default database schema in our Sap Hana database is here and it’s empty. You can see no object here.

Now I will start the import process and all our objects will be imported into Sap Hana database.

Import is completed.

So let’s check the objects in the Sap Hana database. I will refresh the target schema. You can see that all the tables were generated here. And you can see that all the tables were generated in Column store type as we have specified it earlier.

Indexes were generated. The triggers were generated as well. Stored Procedures.

Actually here we can see a commented source from Oracle database and its Sap Hana equivalent.

Since Sap Hana doesn’t support packages, Oracle package was converted into separate stored procedures in Sap Hana.

Indexes were generated here. Let’s check the views.

As you can see all the objects were generated in the target database.

Now let me show you how to make script conversion using Ispirer Migration Studio. A tool specially designed for this task. Using this tool we can convert one script at a time.

Here we should specify the source and target directions and click run.

On the left pane you can see the source and on the right pane you can see the result of the conversion. This file contains a package. And as I’ve already mentioned earlier, Oracle packages are converted into separate stored procedures in Sap Hana that are placed in this package.

In the bottom of the tool you can see the conversion log that contains the information about the converted file as well as errors if there are any during the conversion.

Let me show you the conversion of PL/SQL block. Sap Hana doesn’t support Pl/SQL blocks. So it was converted into Crate Procedure in Sap Hana. Also you can see procedure conversion in this file with some logics for cursor.

Let’s have a look at the conversion of exceptions. You can see that the exception “When others than” was converted into Declare Exit Handler for SQLException. And “When NO Data Found Then ” into “Declare Exit Handler for not Found”

And the function conversion. You can see that this function was converted into Create Procedure statement, since Sap Hana functions don’t support dml statements in it. And the “return” of this function was converted into “out parameter”.

Now let me show you Ispirer Migration Commander. Using this tool you can migrate several scripts at a time. So let’s choose all these files and click run. Here we should specify the target direction and click ok.

Ispirer Migration Commander tool has also a log information about the conversion process.

Let’s check the conversion result. Here you can see the conversion log file, reports. And just like in Ispirer Migration Studio you can compare both source and target side by side.

As you could see, Ispirer Migration and Modernization Toolkit 2015 can automatically run your migration from Oracle data base to SAP HANA and our tool can minimize your efforts in this type of migration. If you are interested in these services please contact us. You can see our contact information on our web site ispirer.com. Thank you. Bye.