4/19/2023 0 Comments Extract transform load![]() The data exported from IT Advisor cannot be changed by transformations inside the ITA server. The data is exported using the ETL Export Database. Exporting data from IT Advisor is used when ever data is used outside ITA.Once transformation(s) are in place t he integration is configured using the server configuration interface and can be found here When data needs to be changed/modified before it is used inside ITA this can be done using a transformation or a set of transformations called a job. The integration is configured using the server configuration interface and can be found here When data is ready the only thing that must be done is setting up the integration between the external system providing data and ITA. One where "Data is Ready" and one where "Data needs change" before being used in ITA. The data is being imported via the ETL Import Database. Importing data into IT Advisor is used whenever data must be provided to ITA.Together this gives the ability to extract and enter data on the ITA server.īased on the ETL system, it is possible to develop custom solutions, integrating ITA with a broad range of data sources.ĮTL can be used in 2 ways: Importing Data in to and Exporting Data from IT Advisor. ![]() It also allows scheduled execution of transformation scripts on the IT Advisor server. The ETL system creates databases that can be accessed directly by 3rd party tools and solutions. One of the ways to integrate with external systems is using the Extract, Transform, Load (ETL) system.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |