Super db transformer for many type database.
(Oracle,SYBASE,DB2,Access,DBASE,Foxpro,Paradox,etc)
It supports database Oracle, SYBASE, DB2, Access, DBASE, Foxpro, Paradox, and text database and transforming among them. Through DBPut, database administrator needs only design an transform rule and run it at any time. The DBPut makes it unnecessary to program and save your time and money.
Here are some key features of "DBPut data transfer":
· Conversion of data to the following file:
· Text file
· HTML file
· Excel spreadsheet
· SYLK (Symbolic Link)
· DIF (Data Interchange Format)
· Lotus 1-2-3 file
· QuattroPro file
· XML file
· Rich Text format
· SPSS format
· Adobe Acrobat Document
· LDAP/Lightweight Data Interchange Format
·
· Convert data between many database.
· Support access MySQL through IP protocol directly.
· Support access Oracle through IP protocol directly without Oracle client library installed.
· Convert other database to MS SQL Server.
· Convert other database to DB2.
· Convert text data to MySQL, Oracle, MSSQL, DB2 or other database.
· Convert data between many database through ODBC.
· Directly read data from Paradox, dbase or FoxPro.
· Flexible transfer function
· Run job as custom execution flow.
· Transfer a table; Merge more tables into one.
· Split one table into more.
· Automatically mapping between source and target tables.
· Split source fields
· Calculate between multi-fields
· Multiple transfer modes: append, update, append-update, delete, copy.
· Filter source data with flexible condition.
· convert data of datetime type.
· wipe off the repeated record of source dataset.
· Split record.
· Switch between row and col.
· Generate temporary primary key.
· Support debug dblink.
· Preview result of convert process.
· Re-process error data.
· Run job as specified schedule automatically.
· Run job automatically as day, week, month, year by seting datetime trigger.
Limitations:
· convert limited to maximum 500 records
What's New in This Release:
· Add Job creating wizard module, you can create a job and many DBLinks quickly.
· Allow converting long string or binary data from source to target database,such as long, blob, graph, memo type.
· Modify function:ExecOraQuery,Exp_ExecOraProcedure,ExecMSSQLQuery,ExecMSSQLProc,ExecODBCQuery, you can get more result information of executing SQL or procedure.
· Add function null(), you can use it to get null value to realize more flexible function.
· Fixed a bug can't convert BLOB or LONG data in some database.
· Fixed a bug that paradox or dBase table will be locked If you browse data or import a table definition from a paradox for dBase table.
· Allow modifying schedule property for many jobs at the same time.
|