dbSL ETL tools, pont and click data transformation
With our ETL tools you can design any data transformation by using the intuitive and fully graphical designer that includes everything you need to manage your datawarehouse project from start to finish. Just point-and-click, drag-and-drop to build the most complex integration processes without ever writing a single line of code.
Download
Both Visual Importer ETL and Advanced ETL Processor can be downloaded and installed in seconds, it requres only 50 mb of disk space for most complex installation of Advanced ETL Processor Enterprise.
Highly optimised code
Execution Agent is only 5MB, and it can work with Text, XML, Excel, Access, DBF, Foxpro, ODBC, OLE DB, MS Sql Server, Oracle, MySql, PostgreSQL, Firebird, Interbase, SQLite, POP3, SMTP, File System, FTP, SSL, HTTP, Unicode plus it supports more than 300 data transformation and validadtion functions, think of what is it capable of and think how much space do you need to do the same using modern Java or .NET applications.
Visual Transformation
All our ETL tools have no limitations, so you can load the data today and solve all the data quality problems right now.
What is ETL?
ETL stands for for extract, transform, load, three database functions that are combined into one tool to pull data out of one database and place it into another database.
- Extract - the process of reading data from a database.
- Transform - the process of converting the extracted data from its previous form into the form it needs to be in so that it can be placed into another database. Transformation occurs by using rules or lookup tables or by combining the data with other data.
- Load - the process of writing the data into the target database.
Further Reading:
We believe that nowadays most of the customers do not just want to transfer the data from one table into another. Data could come from different sources such as ftp, file or email servers. We provide solutions to Automate entire process of working with data. It is easy to understand and use software.
ETL Products:
Visual Importer |
|
|
|
Loads data into ANY database from Text, Excel, MS Access, DBF files, Oracle, MS Sql, MySql, PostreSQL, Interbase/Firebird or any ODBC compliant database, run sql before and after loading the data |
||
Data Exchange Wizard |
|
|
| This Wizard Loads/Exports data from/into various data sources such as delimited and fixed width files or ODBC data source into/from Oracle, MS SQL Server, MySql, PostreSQL, Interbase/Firebird or any ODBC compliant database Uses native API, Capable of performing calculation during import, may also execute SQL statements before and after Import or Export. Integrated expression builder, comprehensive error log, rejected records file. Source Data Filtering |
||
Visual Importer Professional |
|
|
|
In addition users can design Import, Export and SQL scripts, add them to the Package and schedule it for execution on regular basis. Visual Importer Professional stores all information in the repository. Unlike DTS, SSIS and Oracle Warehouse builder Visual Importer Professional can receive emails and process attachments as well. All FTP operations also supported. By combining simple Package Items together Visual Importer Professional helps small businesses and Fortune 100 companies to automate complicated business processes and everyday tasks. Recommended product for development environment. |
||
Visual Importer Enterprise |
|
|
|
Combines Powerful features of Visual Importer and Visual Importer Professional plus Execution agent - windows service. Recommended product for enterprise environment. |
||
Advanced ETL Processor |
|
|
| Designed for those users who want not just only load or export data but also perform complex validations and transformations, data grouping, de-duplication and sorting. |
||
Advanced ETL Processor Professional |
|
|
| Codeless Automation Tool.
Users can design Data transformations and Sql script add them to the package together with report, file, ftp, email and many more actions and schedule them for execution on regular basis By combining simple Package actions together Advanced ETL Processor Professional helps businesses and Fortune 100 companies to automate complicated business processes and everyday tasks. Advanced ETL Processor Professional supports complex enterprise environments including database, file, smtp, pop3 and ftp servers. Recommended product for development environment. |
||
Advanced ETL Processor Enterprise |
|
|
|
Recommended product for complex enterprise environment. More information about ETL tools: |
||
ActiveX Components:
It is hard to imagine any modern business application not working with the databases. We designed two ActiveX components you can use right now instead of wasting time developing your own import and export routines
VImpX |
|
|
|
ActiveX which imports data into various databases from flat files, Excel, DBF,MS Access Databases, pivot tables or ODBC data sources. |
||
DEWizardX |
|
|
| This ActiveX helps to load and export data from/into various datasources such as delimited and fixed width files or ODBC data source into/from Oracle, MS SQL Server or any ODBC compliant database Uses native API, Capable of performing calculation during import, may also execute SQL statements before and after Import or Export |
||
Reporting:
Active Business Intelligence Portal |
|
|
|
Active BI Portal is a business intelligence software that provides an integrated solution for designing and deploying reports and web forms over the internet and Intranet. |
||
Table data editing:
Let's face the fact sometimes it is not possible to automate everything and very often we have to edit the data manually
Active Table Editor
|
|
|
|
Imagine the following situation you have accounting software package and would like to design some additional reports. You know the database structure pretty well and created some mapping tables for the reports. Now you need to give the end users ability to change the mapping tables, print and export the data. You may use Oracle SQL plus or MS SQL Server Management studio to do that but these tools far too complicated for the users. |
||
Freeware:
Database Browser |
|
|
|
This easy to use tool allows you to connect to any database and browse or modify data ,run sql scripts, export and print data. |
||
