![]() Version of Eclipse used in the blog: Eclipse Java EE IDE for Web Developers.Version: Neon.3 Release (4.6.3)Build id: 20170314-1500 SAP HANA Web-based Development Workbench is a very flexible environment which allows to see all the objects created in HANA studio or Eclipse and it has a wide range of tools which make data provisioning process intuitively clear and rapid. Worth to mention is that data types which we use in ORACLE database table should be the same as we have in Hana database All data changes in virtual table will be correspondingly processed in the database itself. Now we have a virtual table which is connected to the real database table created on the ORACLE side. On the HANA Remote Source side we have created corresponding table which we can use for further data transfer. On the Oracle side in package TARGET_* we have the following table which was created as a virtual table: In order to transfer data from HANA database tables to particular ORACLE database table we need a virtual table created in our HANA system based on ORACLE table which we have in our Remote Source. The second step is a virtual table creation. Data Provisioning Adapter acts like a bridge between two remotely connected systems, in our case HANA DB and ORACLE. ![]() In the next step we should create another Remote Source with system based on HANA DB. Here we’ve selected – OracleLogReaderAdapter. ![]() In your HANA Studio or Eclipse select corresponding system and in the folder called Provisioning new remote source should be created for your Oracle system. This case is rather specific and it demands some additional actions. ![]() In this example we will describe a dataflow from HANA DB table to ORACLE DB. First of all we need to define a dataflow and then apply all other settings. Data Provisioning Agent is a part of HANA Agent installation and it should be downloaded separately.ĭepending on the customer requirements and technical settings we may need to customize a few steps. First two elements belong to the Hana instance.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |