File size: 77.4 MB Design Import, Export and SQL scripts, add them to the Package and schedule it for execution on regular basis. Unlike SSIS and Oracle Warehouse builder Visual Importer ETL Professional can receive emails and process attachments as well. All FTP operations also supported. By combining simple Package Items together Visual Importer ETL Professional helps small businesses and Fortune 100 companies to automate complicated business processes and everyday tasks.
Features : LOAD DATA FROM: Multiple Delimited or Fixed width Text files
Multiple Excel files + Multiple Excel Spreadsheets
Multiple MS Access Databases
Multiple Foxpro/DBF Files
Clarion
Oracle
MS SQL Server 6.5, 7.0, 2000, 2005, 2008, CE, Express
Firebird/Interbase
MySQL
PostgreSQL
SQLite
Any ODBC source
OLE DB
JDBC
BDE
Windows Event Log
XML Files
QVX Files
QVD Files
SalesForce
Brightpearl
Google Spreadsheets
Slemma
RSS Feed Into: Oracle
MS SQL Server
MySQL
PostgreSQL
SQLite
Interbase/Firebird
Any ODBC Compliant Database
OLE DB
JDBC
BDE
SalesForce
Slemma Supported Repository Types: MS Access (Default Repository).
Oracle
MS Sql Server
Interbase
MySQL
PostgreSQL DATA LOADING AND AUTOMATION TASK: 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
HTTP downloads
HTTP forms submissions
Post Twitter messages
Generate reports
Send SMS messages
Encrypt and decrypt files
Check database connections
Ping servers
Schedule packages for execution
Run bat files or execute any windows application
Edit and run SQL Scripts
Execute Packages from the command line Whats New:
Updates: official site does not provide any info about changes in this version
Download 百度网盘
|