Migrate the ASE database (On-Prem) to the SAP hana Cloud (Public) using SAP advanced SQL migration

[namitkgupta]

Hi Javier, I need to migrate the ASE database (On-Prem) to SAP HANA Cloud (Public). I was following the blog written by you. However, I got stuck there. I have tried two methods:

1. Accessing the ASE database on local machine via VPN. I am able to access the ASE database with the given details IP is 198.162.2.105 and port is 4901 via interactive SQL. However, I was not able to extract the data via SAP Advanced SQL Migration tool as gateway was not open at the server.

1. Second option is, I have got the direct access to the server where ASE(Sybase) database is present. I have opened the gateway there too. However, gateway host name is 198.162.2.110 /3000. Here, I could successfully open the gateway but not able to reach to the Sybase.

[Javier-Martin]

Hi,

I think the problem may be in the gateway configuration, this tutorial (step #3) explains very well how to configure the gateway:

https://developers.sap.com/tutorials/advanced-sql-migration-tool-ora-hana.html

The tutorial is for source DB Oracle but for ASE is totally similar with the right jdbc driver of course. Please notice this 3 important things:

- The file with the gateway configuration should be named config.properties. net.acceptor.bindaddress is the ip address or hostname where the gateway is installed and started.  This host should be accessible from the host where you run the migration tool.

- For your migration project you should indicate the host and port where the gateway is running, they are defined in parameters #110 and #111 (sapdbmtk config).

- The host and port for the ASE server is something you specify in the sapdbmtk extract command line, the tutorial explains how this should be done.

Try and let me know how it goes, if you don't get it I will be asking for more details to clarify the issue.

Thanks.

Javier.

[namitkgupta]

Hi Javier, This is Sweety Gupta. this was the questipn I have asked you and you replied to us. thank you.

[namitkgupta · Accepted solution]

Yes Javier. I understand migration of data is not possible with SAP ASMT tool. I was just trying to extract the data model. If I will be able to extract the data model then I'll able to move further for my work. 

[Javier-Martin · Accepted solution]

Hi Namit,

I am not understanding well what you try to achieve, not sure why you need to extract the data model, do you need the DDLs for all the objects ?, do you need them for ASE or for Hana ?. Notice that SAP Advanced SQL migration tool is extracting the data model and keeping it in a sort of internal format to convert it to the target database, the tool is not storing the DDLs to create tables for ASE for instance, it keeps all the columns and other info in text files. For procs and functions it gets the real DDL from the ASE server. Once the extraction is done it is able to convert the data model to Hana and in that case you get the DDLs for tables and other objects.

What do you exactly need ?. ÇASE provides an utility to extract objects and generate the DDLs, take a look at ddlgen, not sure if that may be what you need.

Regards.
Javier.

[namitkgupta · Accepted solution]

Hi Javier,

My client wants to move the historical data from ASE on-prem database( with SAP ERP) to Hana DB on cloud. This is purely data migration requirements here and no application related activity is involved.

For this the SAP team in India recommended us to follow the steps as detailed in your blog - https://community.sap.com/t5/technology-blogs-by-sap/sap-ase-database-migration-to-sap-hana-cloud/ba.... We understand that this tool helps in automating the process of extracting the information from source database, convert the data model as per Hana DB format and creating the data model finally in the Hana DB using these scripts. This helps in creating the data model and SQL object in HANA DB on which further data migration can be performed by extracting the data in text files and uploading in HANA DB. So, we wanted to use this tool to replicate the same DATAMODEL on the Hana DB same as that of ASE database so that we can further do the data migration via files. Hope this understanding is correct.

Now we understood that this tool cannot be used for databases linked to SAP ERP system when we used the EXTRACT command.

Hence I was asking if we can use the EXTRACT_OFFLINE method using the DDL scripts from the source ASE database. As you mentioned , may be we can use the DDLGEN to generate the DDL scripts. but will the SAP advanced migration tool support the next steps like extract_offline and subsequent steps? If not,  what shall be the best way to do this?

So for the this ASE on-prem database migration to HANA cloud DB, we need some automation using a tool. I hope I am able to clarify my requirements here. Thanks for all the help.

Regards

Namit

[Javier-Martin · Accepted solution]

Hi Namit,

My understanding is that the data model in Hana for the ERP may not be identical to the one you have in ASE and thus you want to get the one from ASE and convert it to Hana to load the data from ASE in it, that would be a kind of intermediate data store. Wnen the tool connects to a database server via the gateway it checks that is is not an SAP solution and it complains returning an error message, you can try to use extract offline using DDL files you obtain with any other tool (DDL get may be on possibility) but please keep in mind this is something we have never tried before. As far as I know the data model for an ERP system is huge with thousands of tables (many of them not used) so my suggestion for you is get the DDL only for the tables you want to move data from and the use extract_offline option, they should be converted to Hana with the tool if the extract works well.

Regards.

Javier.

[namitkgupta · Accepted solution]

Hi Javier, Thanks for all the inputs. We are able to use the Extract_offline method to process the DDL files generated from the ASE database and proceed further on subsequent steps.

[Javier-Martin · Accepted solution]

Hi Namit,

I am really happy to hear you managed to do it and to know that the the tool has been useful for you.

Thanks & good luck.

Javier.