Product information

Wed, 16 Jan 2008, 5:26pm

Pervasive DataTools has the right tool for migrating data from Informix to almost any database without writing code.

The Data Extractor from Informix connects to your source-side Informix database and to your target-side database via direct connection. Easily create each new table in your target database by simply dragging and dropping the "All Fields" icon in the Map Fields interface. Make any needed changes to field names, data types, and/or data field sizes in the same window.

Here are just SOME of the features of the Data Extractor from Informix that make migration from Informix a snap:

• Read Informix data and table schema from single tables or views, or write SQL statements to join data from multiple source tables.
• Automatic detection and resolution of data type differences between Informix and your target database.
• Built-in Expression Builder for writing expressions to clean and transform dirty data on the fly.
• Test Control Panel for testing your field mapping and expressions. View the results in the Data DownLoader from Informix user interface, make needed changes, and get it right before writing any records to your target database.

A FREE trial license for the Data Extractor from Informix is available. Simply register on the Pervasive DataTools web site, download the Data DownLoader from Informix and start migrating your data from Informix today!

- The Pervasive DataTools Team

Tue, 08 Jan 2008, 10:18am

Parse data from virtually any fixed-length Btrieve data file and convert the data to a CSV Text file with the Pervasive Data Parser for Btrieve.

The Data Parser for Btrieve supports dozens of Btrieve data types including 32-bit IEEE floating point, 64-bit IEEE floating point, Autoinc (2- & 4- byte), Bfloat (4- & 8-byte), Bfloat, Bit, Character, Comp, Comp-1, Comp-3, Comp-5, Comp-X, Date, Decimal, Float (4- & 8-byte), Integer (1-, 2-, 4-, & 8-byte), Logical, Logical (2 bytes), LString, LVar, Magic PC (Date, Extended, Number, Real, & Time), Microsoft BASIC Double, Microsoft BASIC Float, Money, Note, Numeric, NumericSA, NumericSTS, Packed Decimal, Sales Ally (Time-2, Date, Time-1, & Time), Unsigned (1-, 2-, 4-, & 8-byte), Zoned Decimal, and ZString. So whether you have a Btrieve DDF or you need to manually define the records and fields of virtually any Btrieve data file, the Pervasive Data Parser for Btrieve can handle the job. The Data Parser from Btrieve supports reading data from semi-structured Btrieve data files and provides a graphical interface in which you can manually define the data records and data fields or apply an external DDF dictionary file.

Export the unpacked data to a CSV Text file that can be imported into virtually any application or database. Or use one of the Pervasive DataTools UpLoaders to further map, manipulate, clean, and convert the CSV data to any one of dozens of formats to which the DataTools offer direct connection or connectivity via ODBC.

The Data Parser for Btrieve is available FREE for a limited time. Simply register on the Pervasive DataTools web site, download the Data Parser for Btrieve and start converting your data today!

- The Pervasive DataTools Team

Thu, 03 Jan 2008, 2:17pm

Convert data from virtually any fixed-length binary data file to any application, database, or other file format with the Pervasive Data Parser for Binary data.

The Data Parser for Binary supports dozens of data types including 16-bit binary, 24-bit binary, 32-bit binary, 64-bit binary, IEEE floating point, VAX floating point, Cray floating point, column binary, Comp, Comp-1, Comp-2, Comp-3, Comp-5, Comp-X, Display, Display Justified, Display Sign Leading, Display Sign Trailing, Packed Decimal, Pascal 48-bit real, Pascal string, Text, Zoned Decimal, Zoned-Leading Sign, and Zoned-Trailing Sign, and many others. So whether you have a COBOL copybook or you need to manually define the records and fields of virtually any binary data file, the Pervasive Data Parser for Binary can handle the job. The Data Parser from Binary supports reading data from un-structured binary data files and provides a graphical interface in which you can manually define the data records and data fields or apply an external dictionary file.

Export the unpacked data to a CSV Text file that can be imported into virtually any application or database. Or use one of the Pervasive DataTools UpLoaders to further map, manipulate, clean, and convert the CSV data to any one of dozens of formats to which the DataTools offer direct connection or connectivity via ODBC.

The Data Parser for Binary is available FREE for a limited time. Simply register on the Pervasive DataTools web site, download the Data Parser for Binary and start converting your data today!

- The Pervasive DataTools Team

Mon, 24 Dec 2007, 11:22am

Pervasive DataTools has the right tool for migrating data from MySQL to PostgreSQL without writing code.

The Data DownLoader from MySQL connects to your source-side MySQL database via ODBC and to your target-side PostgreSQL database via direct connection. Easily create each new table in your PostgreSQL database by simply dragging and dropping the "All Fields" icon in the Map Fields interface. Make any needed changes to field names, data types, and/or data field sizes in the same window.

Here are just SOME of the features of the Data DownLoader from MySQL that make migration from MySQL to PostgreSQL a snap:

• Read MySQL data and table schema from single tables or views, or write SQL statements to join data from multiple source tables.
• Automatic detection and resolution of data type differences between MySQL and PostgreSQL.
• Built-in Expression Builder for writing expressions to clean and transform dirty data on the fly.
• Test Control Panel for testing your field mapping and expressions. View the results in the Data DownLoader from MySQL user interface, make needed changes, and get it right before writing any records to PostgreSQL.

The Data DownLoader from MySQL is available FREE for a limited time. Simply register on the Pervasive DataTools web site, download the Data DownLoader from MySQL and start migrating your data from MySQL to PostgreSQL today!

- The Pervasive DataTools Team

Fri, 21 Dec 2007, 12:47pm

Pervasive DataTools has the right tool for migrating data from Microsoft Access to MySQL - without writing code.

The Data UpLoader to MySQL connects to your source-side MS Access database directly and to your target-side MySQL database via ODBC. Easily create each new table in your MySQL database by simply dragging and dropping the "All Fields" icon in the Map Fields interface. Make any needed changes to field names, data types, and/or data field sizes in the same window.

Here are just SOME of the features of the Data UpLoader to MySQL that make migration from MS Access to MySQL a snap:

• Read MS Access data and table schema from single tables or views, or write SQL statements to join data from multiple source tables.
• Automatic detection and resolution of data type differences between Access and MySQL.
• Built-in Expression Builder for writing expressions to clean and transform dirty data on the fly.
• Test Control Panel for testing your field mapping and expressions. View the results in the Data UpLoader to MySQL user interface, make needed changes, and get it right before writing any records to MySQL.

The Data UpLoader to MySQL is available FREE for a limited time. Simply register on the Pervasive DataTools web site, download the Data UpLoader to MySQL and start migrating your data from MS Access to MySQL today!

- The Pervasive DataTools Team

Thu, 20 Dec 2007, 12:45pm

Pervasive DataTools has the right tool for migrating data from SQL Server to MySQL - without writing code.

The Data UpLoader to MySQL connects to your source-side SQL Server database directly and to your target-side MySQL database via ODBC. Easily create each new table in your MySQL database by simply dragging and dropping the "All Fields" icon in the Map Fields interface. Make any needed changes to field names, data types, and/or data field sizes in the same window.

Here are just SOME of the features of the Data UpLoader to MySQL that make migration from SQL Server to MySQL a snap:

• Read SQL Server data and table schema from single tables or views, or write SQL statements to join data from multiple source tables.
• Automatic detection and resolution of data type differences between SQL Server and MySQL.
• Built-in Expression Builder for writing expressions to clean and transform dirty data on the fly.
• Test Control Panel for testing your field mapping and expressions. View the results in the user interface, make needed changes, and get it right before writing one record to MySQL.

The Data UpLoader to MySQL is available FREE for a limited time. Simply register on the Pervasive DataTools web site, download the Data UpLoader to MySQL and start migrating your data to MySQL today!

- The Pervasive DataTools Team

Wed, 19 Dec 2007, 2:36pm

Pervasive DataTools offers solutions for migrating data from ACT to SugarCRM.

ACT to SugarCRM data migrations can be problematic due to the necessity of linking child records to the parent records. The most common problem is retaining the relationship between the memo fields (child records that contain activities/events and history records) and Contact records.

The DataTools solution...

If you have the ACT application, you can create reports that contain both the parent (Contact) and child (Activities/Events/History) records. Then, print the report to a file on your workstation - rather than to a printer - and download the Data Parser for Unstructured Text to extract the records, with relationships intact, as needed. Export the data records to a CSV file from the Data Extractor.

Then use the Data Builder for SugarCRM to map & transform the "raw" CSV data into the exact CSV structure that is ready to import into SugarCRM using the SugarCRM import utility.

- The Pervasive DataTools Team

Tue, 18 Dec 2007, 2:44pm

Pervasive DataTools offers solutions for migrating data from Goldmine to SugarCRM.

Goldmine to SugarCRM data migrations can be problematic because Goldmine implemented a proprietary method of linking child records in the .DBT files to the parent records in the .DBF files in versions of Goldmine that used a dBASE format for record management. The most common problem is retaining the relationship between the memo fields (child records that contain activities/events and history records) stored in .DBT files and Contact records that are stored in .DBF files.

The DataTools solution...

If you have the Goldmine application, you can create reports that contain both the parent (Contact) and child (Activities/Events/History) records. Then, print the report to a file on your workstation - rather than to a printer. Use the Data Parser for Unstructured Text to extract the records, with relationships intact, as needed. Export the data records to a CSV file from the Data Parser.

Then use the Data Builder for SugarCRM to map & transform the "raw" CSV data into the exact CSV structure that is ready to import into SugarCRM using the SugarCRM import utility.

- The Pervasive DataTools Team

Mon, 17 Dec 2007, 5:20pm

Pervasive DataTools provide solutions for your data conversion and data migration projects between virtually any application, database, file format, and/or web store.

Click on the links below to learn more about data solutions for your projects.

Application Solutions

Database Solutions

Data File Solutions

Web Store Solutions

Fri, 14 Dec 2007, 4:23pm

Parse virtually any fixed text data file and export the parsed data to a CSV text file with the Data Parser for Fixed Text from Pervasive DataTools.

The Data Parser for Fixed Text supports reading data from fixed-length flat files and provides a graphical interface in which you can manually define the data records and data fields or apply an external dictionary file. COBOL copybooks, C structure, and other external dictionary files are supported.

The exported CSV Text file can be imported into virtually any application or database. Or use one of the Pervasive DataTools UpLoaders to further map, manipulate, clean, and convert the CSV data to any one of dozens of formats to which the DataTools offer direct connection or connectivity via ODBC.

The Data Parser for Fixed Text is available FREE for a limited time. Simply register on the Pervasive DataTools web site, download the Data Parser for Fixed Text and start converting your fixed text data today!

- The Pervasive DataTools Team