DataPipe

DataPipe connects to any industry standard OLE DB/ODBC database using database drivers provided by the database vendors.

Choose the database and table or query that contains the data you need to modify (Click to enlarge).

 

DataPipe offers the fastest and most powerful search and replaces:

• Exact search (including multi-line and binary character search)
• Pattern or wildcard search
• 'Sounds-like' search
• Fuzzy search (great for finding typing errors)
• Click here for more details

The replacement text can include all or part of the original text or a re-arrangement of it, and the case of the replacement text can be automatically altered to preserve the case of the original text. The replacement text can also be modified by any combination of filters such as by converting it to Upper Case, performing further search and replaces inside the replacement text or even a database or dictionary lookup.

Replace text interactively in preview mode and in live database mode (Click to enlarge).

DataPipe can manipulate specific portions of the text rather than the entire text, such as Line Ranges, Column Ranges, Lines Matching a Pattern and Lines Not Matching a Pattern. You can combine sections together, for example, to alter a specific line and column range. You can also apply further text manipulations to the Replaced Text in a Search and Replace operation, such as by making the Replacement Text UPPERCASE.

DataPipe's enterprise features include:

• No limit on manipulations in a single pass - so if you have 8 million records, you only need to change them once
• No limit on the number of records processed
• Detailed audit logs to track job start and end times and unsuccessful updates
• Restart control logic to resume aborted jobs
• Precise control over cursor and locking options to optimize speed with your database.

DataPipe makes it easy to connect to Customer Relationship Management (CRM) tools like GoldMine, Onyx, Siebel, Great Elk, ACT!, Eipiphany and more.

Check out the powerful functions listed below:

• Fast!
• Interactive search and replace - check records before you change them
• Process multiple tables in multiple databases
• Correct capitalization in names and surnames (even with names like Mac and Mc, de and van de etc)
• Swap data fields around, such as date fields MM/DD/YYYY -> DD/MM/YYYY, swap surnames and first names etc
• Standardize formatting of addresses (e.g. PO Box, P.O. Box, POBOX)
• Standardize phone number formatting (e.g. 800 612 0382, (800) 612-0382)
• Convert currency amounts to words for check printing e.g. $7 -> "Seven Dollars and no cents"
• Extract email addresses for your next marketing campaign
• Trim blanks and multiple white space
• Remove binary "garbage" characters
• Remove HTML and XML
• Insert or remove text within a field
• No need for custom programming in 99% of cases. If you need to, you can write custom code using industry-standard VBScript or JScript
• Easy to use with integrated online help and tips
• Automate DataPipe to run at predetermined times using an external scheduling tool
• Translations are available for other languages
• Click here to see more

DataPipe is used by Aspect Computing, IMS, UC Davis Medical Center, City of Winnipeg, Trucking2Go, Harrington Industrial Plastics, Trane, United Nations, Intelli-Source, Suramericana de Seguros SA, Johnson & Johnson, East Tennessee Computers, Saskatchewan Learning and many other large organisations.

DataPipe comes in both Single User and Site licenses:

• Microsoft® Windows® 7 and x64, Vista®, Vista 64, 2008/2003 Server, XP, 2000
• Hard Disk with 15 MB free disk space
• 64 MB RAM
• SQL Server, Access, Informix, Sybase, DB2, Oracle, MySQL, DBF, FoxPro, FileMaker Pro, Excel Spreadsheets or any OLE DB/ODBC compliant database.

Multi-user, Site and Enterprise licenses are also available to enhance the efficiency of your entire team.