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.
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
DB Software repository also provides other tool supporting business intelligence processes in a data warehouse environment. Those are: Data Exchange Wizard, ABI Portal, Active Table Editor, VImp X, DEWizardX, Database Browser
More information in DB Software Laboratory tools: www.dbsoftlab.com