‘PeriWin ETL’ is a software tool for your complex data Extraction, Transformation and Loading (ETL) needs. You can extract data from different source application databases and load into one target application database.
For example, a company may have its supply chain data spread across 5 disparate supply chain application for its New York, Houston, Rotterdam, Dubai and Singapore offices. Data fragmented across these 5 application databases can be migrated and consolidated into one standardized database using ‘PeriWin ETL’.
Oracle, Postgres, SQL Server, My Sql, Access, Excel, CSV files, any ODBC / OLE DB compatible database.
Oracle, Postgres, SQL Server, My Sql, any ODBC / OLE DB compatible database.
Amazon AWS, Microsoft Azure, Google Cloud.
Cloud support is provided through PeriWin Cloud Data Integration.
Load data with all integrity constraints set at the destination database. This ensures utmost integrity of your data.
Database design can be different in each of the source databases. Loading can be done onto one standardized database design. In other words, you can load from any data structure to any data structure
Different codes used in different source databases can be transformed onto one standard code in destination database. For example the same customer may be identified by different codes in the source databases. You can standardize these different codes into one standard code providing a consolidated view of your data.
Data in de-normalized form can be loaded onto a normalized form.
All data types can be extracted and loaded. Large text and large binary data fields like CLOB, BLOB can be loaded
You can load your confidential data yourself.
Any support you may require during your project execution phase is available from Milinia. If you require, Milinia can replatform your entire application along with your data.
© 2020 Milinia Soft Solutions Pvt Ltd. All Rights Reserved