Overview

prevero. ETL is an ETL tool that extracts data from one or more data sources, transforms it and finally loads it into a target database. For example, data can be filtered or merged, date formats can be converted or replaced. prevero. ETL provides data from SAP, Microsoft SQL Server, Oracle databases and many other data sources. This data can be stored either in prevero. ARJUNA databases or other relational databases. This can also be done via scripts that are built into the import routines. The operation of prevero. ETL is so user-friendly that even the business department can extract and transform data independently without the support of IT. Predefined transformation steps support the setup of the most common tasks. In addition, the experienced user has unlimited possibilities for data transformation through his own Visual Basic scripting.

Features

• Direct connection to SAP ERP and BW
• Connection via ODBC to relational databases
• Native connection to Oracle databases
• Native connection to Microsoft SQL Server
• OLE-DB connections possible
• Text imports and imports from Excel
• Prefabricated transformers available
• Own VB scripting possible via VB.NET
• Output directly in prevero. ARJUNA Databases