Data UpLoaders Overview

The Pervasive Data UpLoaders are the tools to use for reading data from virtually any source and loading data directly into a specific target database, application, or file format. Each Data UpLoader reads data from dozens of data sources - including databases, text files, spreadsheets, application exports, etc. - all via native connectivity and writes data to the selected target. The graphical tool gives you the power to view all the source data in its native format (before uploading!), so you can see the data you are working with.

And that is only the beginning. A world class Source-to-Target drag-n-drop data field mapping UI is available (with online video training) to perform any needed data re-structuring before it is written into the Target. A full-blown data transformation capability is in the same mapping UI, with easy wizards for record filtering and data editing, reformatting, cleansing and manipulation on-the-fly so that only clean data is loaded into your target!

SQL Databases | Applications | File Formats | ODBC

SQL Databases

For RDBMS (Relational Database Management System) targets, the Data UpLoader obeys the database rules and constraints, and even reports errors if the Map tries to violate integrity rules. Many more features are available (in fact, too many to mention here, give it a try!); e.g., single-step visual debugging of transformations, detailed logging, before and after views of the data (including after the UpLoad has run!).

On the Target side, you have an abundant choice of data adapters to choose from for uploading data directly into the most recent versions of the most popular SQL databases. You might find the standard client-based adapters suitable. However, there are also adapters for high-speed data UpLoads over the network, as well as mass-insert adapters that exploit RDBMS database APIs for extremely high-speed insertion of data into your target database or application. You can even choose the very sophisticated Multimode Adapter, that takes full advantage of the target database's SQL interface (though hiding the complexity from the User) to produce highly-optimized SQL streams for the most complicated data loads – e.g., loading or inserting into multiple tables in the same pass, or performing multiple SQL operations (Insert, Delete, Update) in the same pass - with the added ability to pass these SQL streams native to the database API in real-time during the UpLoad, or if preferred, via an offline SQL Script file that the UpLoader will produce for you automatically. Or finally, you can select the "offline" Adapter that produces database SQL Loader data files that are perfectly pre-formatted for instant/easy load into your database using the database's loader utility.

You can use these adapters to do both initial data loads into database tables (including the creation of the tables themselves from scratch if needed!), and updates to existing tables.

A Pervasive Data UpLoader is available for each of the following target SQL databases:

• IBM DB2
• Informix
• Microsoft Access
• Microsoft SQL Server
• MySQL
• Oracle Database
• Pervasive.SQL
• PostgreSQL
• Sybase

Applications

For application targets, the Data UpLoader obeys the rules and constraints of the application API. Many features are available including single-step visual debugging of transformations, detailed logging, before and after views of the data (including after the UpLoad has run!).

Use the UpLoaders to do initial data loads, updates, and deletes directly to the application entities with no need for intermediate import files. The powerful RIFL (Rapid Integration Flow Language) Expression Builder is available for cleansing and manipulating the data at the field level and on-the-fly before it is loaded into your target. You can parse or concatenate name and address fields, re-format dates, strip leading and trailing blanks, and much more. There is also an Expression Tester to help ensure your data is going to be written to your target as needed.

On the Target side, you have an abundant choice of Adapters to choose from for uploading data into current versions of the most popular applications, including hosted applications!

A Pervasive Data UpLoader is available for each of the following target applications:

• Lotus Notes
• Microsoft CRM
• Salesforce.com
• SalesLogix
• Siebel CRM on Demand
• SAS
• SPSS

File Formats

For file format targets, each of the Data UpLoaders provides knowledge of data types, field naming rules, and other built-in intelligence about the target format. Many additional features are available including single-step visual debugging of transformations, detailed logging, before and after views of the data (including after the UpLoad has run!).

There are UpLoaders available for loading data directly into the most popular file formats. You can use each of these to do initial data loads or to add new data records to an existing file. The RIFL Expression builder is available to help you build rules to filter data records and/or to clean and manipulate the data to fit your target file format exactly as required. You can save your work and re-use your data mapping specifications over and over again...each time you need to load data from the same source to the same target!

A Pervasive Data UpLoader is available for each of the following target file formats:

• Binary / COBOL
• Btrieve
• C-ISAM
• C-TREE
• CSV & Unicode Text
• DataEase
• Delimited ASCII (including Unicode)
• Delimited Text (including Unicode)
• Fixed Text
• HTML
• Micro Focus COBOL
• Microsoft Excel
• RTF (Rich Text Format)
• xBASE (dBASE, Clipper, FoxPro, etc.)
• XML

ODBC Connectivity

Pervasive DataTools supports ODBC connectivity to databases, applications, and data files. We offer two DataTools, each of which supports a different "level" or "tier" of ODBC connectivity:

• Tier 1 - Connects to data files and desktop applications
• Tier 2 - Connects to data files, desktop applications, and SQL databases

Tier 1 ODBC UpLoader

The Data UpLoader to ODBC Tier 1 supports ODBC connectivity to virtually any data file or desktop application for which you have an ODBC driver installed and configured properly. Some examples are:

• Microsoft Access
• Microsoft Excel
• dBASE
• FoxPro
• Visual FoxPro
• Paradox
• CSV Text Files

Tier 2 ODBC UpLoader

The Data UpLoader to ODBC Tier 2 supports ODBC connectivity to everything in the Tier 1 UpLoader PLUS any SQL database for which you have an ODBC driver installed and configured properly. Some examples are:

• Microsoft SQL Server
• Oracle Database
• Sybase
• IBM DB2
• Red Brick
• Teradata

The ODBC Tier 2 UpLoader is perfect for connecting to those SQL databases for which the DataTools do not provide native connectivity.