January 2008 - Posts

• DataTools to Migrate Data from Informix

  Pervasive DataTools has the right tool for migrating data from Informix to almost any database without writing code. The Data DownLoader 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 DownLoader 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. The Data DownLoader from Informix is available FREE for a limited time. 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 Posted Jan 16 2008, 05:26 PM by Pervasive DataTools Weblog

• DataTools to Parse Btrieve Data

  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 Posted Jan 08 2008, 10:18 AM by Pervasive DataTools Weblog

• DataTools to Convert Text to Date

  One of the most common issues encountered when performing data conversion is the problem of converting text to dates. When dates are entered/stored as text strings, there are almost as many variations in the date formats as there are data entry users! Locale also plays a huge role in the wide variety of date formats. The task of converting text to a "true" date field in any application or database can be difficult and often requires "writing code" to translate the text strings to dates. Pervasive DataTools Data UpLoaders are the solution for text to date conversion! Each Data UpLoader includes two built-in features for handling text to date conversions, as follows: For text and spreadsheet data sources, each Data UpLoader can auto-detect data fields that contain consistently-formatted date strings. The transformation engine will auto-convert these date strings to the correct date format for your target application or database. In cases where the source date strings are not consistent, use the graphical expression builder that includes over 20 built-in date, time, and date/time functions to convert date strings to the correct date format for your target application or database. The Data UpLoaders are available FREE for a limited time. Simply register on the Pervasive DataTools web site, download the Data UpLoader for your application or database and start converting your data today! - The Pervasive DataTools Team Posted Jan 07 2008, 12:12 PM by Pervasive DataTools Weblog

• DataTools to Parse a Binary Data File

  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 Posted Jan 03 2008, 02:17 PM by Pervasive DataTools Weblog