DBPut is a very creative and useful solution to many data transfer problems.
You do not need to understand SQL grammas. Through its graphic interface, you can
transfer your data into any database format you want. The DBPut contains many functions
that perform most database transform routine. So with a few minutes, you can transfer a
database that would takes a few hours to be finished by an database expert.
What can DBPut do for you
Read/write data from/to the databases Oracle, SQLServer, SYBASE, DB2, Informix, Interbase,MySQL,paradox, dbf, Microsoft access, Text, HTML, Excel, SYLK, DIF, Lotus 1-2-3, QuattroPro, XML, RTF, SPSS, PDF, LDAP.
Transfer a table; Merge more tables into one.
Split one table into more.
Run more transform jobs at the same time.
Design data transform flow in a few minutes through graphical interface.
Automatically mapping between source and target tables.
Filtering source data during transformation process.
You can define variables in transform job and Dblink. These variables could be used in any condition to finish a complicate transformation process.
Debug transform job and observe transform result one by one.
Preview result transformed. This function provides evidence for adjusting your conversion mode.
Automatically schedule tasks by system time.
Calculate field values of source table and realize such as splitting and grouping data, automatically creating data, and implementing complicated calculating.
Capture and deal with null values.
Provide abundant function library£¬which contains character string function, date time function, numerical calculation function, Bool calculation function, and database function, to satisfy most user's demands.
Monitor quality of conversion process and view current conversion schedule and capability curve.
Re-process wrong data.
Features
Support diverse databases such as file type database (dbf and paradox), Oracle, SQLServer, SYBASE, DB2, Informix, Interbase, Accesse, MySQL, and other DBMS databases.
Support direct connection between Oracle and DB2, enhanced conversion efficiecy.
Support graphical interface of conversion jobs.
Support graphic cache of conversion designing history. If you delete one DBlink, system will automatically resume parameter data of last when you create the Dblink again.
Provide fast field mapping between source and target tables.
Embed powerful function of expression calculator.
Provide over 200 transform functions such as character string, date, numerical value calculation, Bool, database processing.
Filter source data.
Calculation of data from different rows.
Support complicated field calculation function.
Debug to conversion job for examining result of conversion job.
Validate logic to conversion job.
Supported databases:
Oracle 10G, 9i, 8i, 8.0.x and 7.x
MySQL 5.0, 4.1, 4.0., 3.23 and earlier
Microsoft SQL Server 2000, 7.0 and 6.5
IBM DB2 8.1, 7.2, 6.1 and earlier
Informix 9.3, 7.3 and earlier
Microsoft Access 2000, 97, 95 and 2.0
dBase, FoxPro, Excel, Paradox,
Sybase Adaptive Server Anywhere
Sybase SQL Anywhere
Sybase Adaptive Server Enterprise
Interbase, Pervasive.SQL and any other ODBC-compliant database
