About the SAP HANA database connector¶
The SAP HANA Connector enables seamless integration with SAP HANA database (latest version, SAP HANA 2.0).
Sidra’s Connector for SAP HANA allows configuring a Data Intake Process from a SAP HANA database in a fast and easy way. The resulting configured Data Intake Process extracts data from any table/view in the source database and loads it into the specified Data Storage Unit at regular intervals. It relies on the Sidra Metadata model for mapping source data structures to Sidra as the destination, and uses Azure Data Factory as the underlying data integration mechanism within Sidra.
When configuring and executing this plugin, several underlying steps are involved to achieve the following:
- The necessary metadata and data governance structures are created and populated in Sidra, Data Intake Process, Provider, Entities, Attributes, and needed relations among these.
- The actual data integration infrastructure (ADF Pipeline) is created, configured, and deployed.
- The resulting Data Intake Process is configured in less than five minutes. Once the settings are configured and the deployment process is started, the actual duration of the data ingestion from the created pipelines may vary from a few minutes to a few hours, depending on the data volumes.
After starting the Data Intake Process creation, users will receive a message mentioning that the process has started and will continue in the background. Users will be able to navigate through Sidra Web as usual while this process happens.
Once the whole deployment process is finished, users will receive a notification in Sidra Web Notifications widget. Once the process has finished, the new data structures (new Entities) will appear in the Data Catalog automatically, and the Data Intake Process will appear in the Data Intake section including this new data source.
Deployment requirements¶
ADF needs connectivity to the SAP HANA CLOUD instance in order to be able to intake all data from the source database. For letting ADF access SAP HANA database, a self-hosted integration runtime must be created.
Integration Runtime creation¶
For setting up the integration runtime, an Azure Virtual Machine must be deployed and configured as an ADF integration runtime with access to the SAP HANA database instance. When the VM is ready, its IP must be added into the DSU Staging storage account networking firewall.