Hello SAP Bloggers/Techies,
So, There might be hundreds of blogs explaining about the Data Provisioning techniques for SAP HANA as this technology is in the market since many years. However, I would like to contribute little more by simplifying the Data Provisioning concept in layman’s point of view so that even a beginner can understand the basic logic.
Data Provisioning in simple terms means the act of bringing data or being able to access the data from source system to the target system without the interference of the data warehouse.
So the technique which we are using to fetch the desired data from the source to our target system is called Data Provisioning.
There are four types of Data Provisioning Techniques in terms of HANA point of view which are as below:
- Real time Provisioning
- Near Real Time provisioning
- Data Federation
- Local Data Import
So, lets see each provisioning Techniques in details:
- Real Time provisioning: This includes two tool basically. SLT (System Landscape Transformation and Replication Server) and Sybase Replication Server. These two tool are used for fetching real time data/latest data from source and paste in target system with a latency of less than 5 seconds. Sources supported are SAP ECC and SAP Standard supported Vendors (like Oracle. IBM etc.)
- Near Real Time Data Provisioning: Tools like BODS (Business Objects Data Services) and Informatica. BODS is an ETL tool which allows you to work on the meta data or data itself before pushing it to the HANA Target. It supports Structured and unstructured Data (Like HADOOP) and you can fine-tune the data as per your requirement before sending it to the target system.
- Data Federation: It’s like Smart Data Access. In this case, we actually do not bring the data into the target system, we keep the data where it is, we just bring the meta data and create the virtual data tables in the target systems. Then you can go on and build model on top of them and send them to the application layer and so on. This is achieved by installing drivers into the HANA box and being able to communicate with source systems like Oracle, Hadoop, MS-SQL Server, SAP HANA system, Teradata etc.
- Local Data Import: Since many of the business users use CSV and Flat files as a source, internally HANA has a local import which allows you to bring in CSV and Flat file data into the system.
We also have SAP DXC which is designed specifically to interact with SAP ERP system. SAP DXC uses SAP ERP Extractor to bring data directly to SAP HANA system.
So, this is pretty much a simple overview to the Data Provisioning Techniques in SAP HANA. Please feel free to like and share your feedback on the comment section.