DaaS and Ennov InSight Interaction

Use the information about the high-level architecture of the DaaS solution to access and interact with data.

Ennov InSight uses an Oracle database for data storage. DaaS allows you to query the data, process datasets, or generate reports.

Data Factory is the platform in which the self-hosted integration runtime (SHIR) server copies/transfers data from the source to the destination point. In the diagram above, Oracle database with the Ennov InSight data is the source point and Azure SQL database is the destination point.

The self-hosted integration runtime server is required to establish a connection between the source and destination points. By default, Data factory is not connected to the source or destination points. Data Factory pipelines are run on self-hosted integration servers which provide the data transfer from the Oracle database to Azure SQL database.

SQL server and SQL database are deployed to the environment and the required information is given to the client to access the database. SQL database is installed on the database server and the credentials are shared with users for access to the database.