DB Software Laboratory ETL software

DB Software Laboratory supplies wide range of ETL and business automation products.
The idea is that ETL is just a part of the solution and loading the data from one database into another just not good enough. The DBSoftLabs' software is designed to help automate entire business processes and they follow the principle of What you see is what you load.
At any stage the user is able to see the result of data transformation/validation without actually loading the data

DB Software Laboratory products

There are 7 ETL products available to download from our web site plus 2 ETL ActiveX components.
Advanced ETL Processor Enterprise works directly with most commercial and open source databases. Plus it offers full for FTP, POP3, SMTP,HTPP and File operations.

Connect all your data sources to any data warehouse

It is a recommend product for complex enterprise environment.

    What makes Advanced ETL Processor different?
  • What you is what you load interface
  • Extract data from emails including googlemail
  • Send emails using any data source
  • File system as a data source fro example it is possible to load pictures from a folder into blob fields
  • Complete business automation
  • Direct connection to most databases
  • Integrated Report Generator
  • Export all data from the database
  • Low resources requirement (Installation is only 23 meg compare this to most .Net applications)

Visual Importer ETL Enterprise is a data transformation and business automation tool.
User can design Import, Export and SQL scripts, add them to the Package and schedule it for execution on regular basis. Visual Importer ETL Enterprise stores all information in the repository. Unlike DTS, SSIS and Oracle Warehouse builder Visual Importer ETL Enterprise can send and receive emails and process attachments as well. All FTP, SMTP, POP3 and file operations also supported. By combining simple Package Items together Visual Importer ETL Enterprise helps businesses and Fortune 100 companies to automate complicated business processes and everyday tasks.
Key benefits of using Visual Importer ETL Enterprise

    Load data from
  • Multiple Delimited or Fixed width Text files
  • Multiple Excel files + Multiple Excel Spreadsheets
  • Multiple MS Access Databases + Multiple Tables
  • Multiple DBF Files
  • Multiple Tables
  • Microsoft SQL Server
  • Oracle Database
  • MySQL
  • PostgreSQL
  • Interbase/Firebird
  • Any Ole DB or ODBC compliant database

    Into:
  • Oracle 7-11g database
  • SQL server 7-2008
  • MySQL
  • PostgreSQL
  • Interbase/Firebird
  • Any ODBC compliant database
  • Ole DB

Available data transformation and business automation tasks:

  • Add Records
  • Update Records
  • Delete Records
  • Add New and Update existing Records
  • Apply Functions to Database Fields
  • Apply user defined Date format
  • Run calculations during import
  • Run Sql script before and after loading data
  • Filter Source Data
  • Use Select Statement as a Data Source
  • Export All Data from any database
  • FTP Downloads and Uploads
  • Create or Delete directories on FTP server
  • Rename or delete files on FTP server
  • Send Emails with attachments
  • Receive Emails with attachments
  • Save attachments
  • Compress files
  • Decompress zip files
  • Copy, move, rename, merge, delete files
  • Compare files using MD5, size or creation date
  • Check if file exist
  • Schedule packages for execution
  • Run bat files or execute any windows application
  • Edit and run SQL Scripts
  • Execute Packages from the command line

Connect all your data sources to any data warehouse