Migrating a DB Connect Source System to a SAP HANA Source System

You can migrate a DB connect source system to a SAP HANA source system for a local database schema or SAP HANA Smart Data Access.

The procedure described below has differences depending on whether the development system or downstream systems are migrated. In both case, the source system type is migrated first. The DataSources are only migrated and edited in the development system however. These changes are collected in a transport request, which is imported into the downstream systems.

Prerequisites

  • SAP BW is running on a SAP HANA database.

  • The DB connect source system has connection type One logical system per DB schema (type 1) or HANA Smart Data Access (type 2), and therefore uses the DEFAULT database connection to its own SAP HANA database.

  • The user performing the migration must be authorized to change the source system and the DataSources.

Procedure

  1. Open the context menu of the DB connect source system in the DataSources tree and choose Migrate. Alternatively, call transaction SA38 and start program RSDS_HANA_MIGRATE_DBCONNECT.

  2. Select the source system that you want to migrate.

  3. To begin with, run the program with the option Check only (no changes). Pay particular attention to warnings about data type assignments that are supported in DB connect source systems but not in SAP HANA source systems. In both cases, you have to edit the migrated DataSource before you can activate it.

  4. Run the program with the option Migrate source system (step. 1). In this step, the source system type is changed to SAP HANA source system, and the connection type is changed to Local SAP HANA Database Schema (type 1) or SAP HANA Smart Data Access (type 2). The DataSources in this source system become inactive, since they cannot be extracted without migration of the adapter-specific settings.

  5. Only in the development system:

    Run the program with the option Migrate DataSources (step. 2). In this step, the DataSources and the adapter-specific settings are migrated. Migrated DataSources (m versions) that cannot be activated automatically are listed. By double-clicking on a DataSource, you call the editor. Check the DataSource (metadata comparison). If a large number of data types have to be changed, you can use the Update function. Activate the DataSource manually. Run the program with the option Migrate DataSources (step. 2) in order to display the DataSources that still require manual post-processing and have to be activated. If all DataSources are active, collect all DataSources from the source system in a transport request.

  6. Only in the downstream systems:

    Instead of performing the second step Migrate DataSources (step 2), import the transport request with the changes from the development system. Note that the first step Migrate Source System (step 1) must be performed first.

Results

The migrated source system now has the type SAP HANA source system. Note that the extracted data might be formatted differently, as a different type of data type conversion (or no data type conversion at all) can be used in DB connect. The character string '123' in the DB connect source system was transferred unchanged to a NUMC(4) (without a leading zero) for example. In the SAP HANA source system, the data is read using a generated database view. The value '123' is converted with TO_ALPHANUM( ) to '0123’ here (with a leading zero).