Connectivity to Data File Formats

Pervasive connectors enable rapid access to heterogeneous data.  Whether your data sits in ASCII or Unicode flat files, Access or dBASE database files, or in Excel spreadsheets, Pervasive connects to that data as smoothly as the original applications.  Just select the file type from the list in Pervasive Map Designer, select your file and visually browse data, including metadata such as column, table and field information.  For fixed-length files, the visual parser makes defining fields point-and-click simple.  Delimited files can be read instantly, displayed in clear rows and columns and written out with any delimiters or other formatting you choose. 

See also Unstructured Data Integration.

Out-of-the-Box Data Connectors

In addition to data file integration, Pervasive has the widest connectivity available, with connectors to databases, technology and Web standards formats, legacy data and applications, message queues, B2B formats, an extensive list of applications and even unstructured data such as print files, reports and HTML. 

Some of the data file variations that Pervasive Data Integrator can connect to out of the box are listed here. If you don’t see the specific connector type you’re looking for, see Universal CONNECT! for more information on how we connect to virtually anything.

  • Access 2000
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:Access 97
    Source/Target Type:Source and Target
    Platform:Window 32, Linux 32

  • Access 97
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:
    Source/Target Type:Source and Target
    Platform:Windows 32, Linux 32

  • Access XP
    DI version:XP
    Connectivity Type:Core Connector
    Connected Via:Access 97
    Source/Target Type:Source and Target
    Platform:Windows 32, Linux 32

  • Alpha Four
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:dBASE II
    Source/Target Type:Source and Target
    Platform:Windows 32, Windows 64, Linux 32, Linux 64, Solaris 64, AIX 64, HP-UX Itanium 64

  • ASCII (Delimited)
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:
    Source/Target Type:Source and Target
    Platform:Windows 32, Windows 64, Linux 32, Linux 64, Solaris 64, AIX 64, HP-UX Itanium 64

  • ASCII (Delimited) Join
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:
    Source/Target Type:Source
    Platform:Windows 32, Windows 64, Linux 32, Linux 64, Solaris 64, AIX 64, HP-UX Itanium 64

  • ASCII (Fixed)
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:
    Source/Target Type:Source and Target
    Platform:Windows 32, Windows 64, Linux 32, Linux 64, Solaris 64, AIX 64, HP-UX Itanium 64

  • Clarion
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:
    Source/Target Type:Source and Target
    Platform:Windows 32, Windows 64, Linux 32

  • Clipper
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:
    Source/Target Type:Source and Target
    Platform:Windows 32, Windows 64, Linux 32, Linux 64, Solaris 64, AIX 64, HP-UX Itanium 64

  • Common Logfile Format Webserver
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:ASCII (Delimited)
    Source/Target Type:Source
    Platform:Windows 32, Windows 64, Linux 32, Linux 64, Solaris 64, AIX 64, HPUX Itanium 64

  • Data Junction Log File
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:
    Source/Target Type:Source
    Platform:Windows 32, Windows 64, Linux 32, Linux 64, Solaris 64, AIX 64, HP-UX Itanium 64

  • DataEase
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:
    Source/Target Type:Source and Target
    Platform:Windows 32, Windows 64, Linux 32, Linux 64, Solaris 64, AIX 64, HP-UX Itanium 64

  • DataFlex (ODBC 3.x)
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:ODBC
    Source/Target Type:Source and Target
    Platform:Windows 32, Windows 64, Linux 32, Linux 64, Solaris 64, AIX 64, HP-UX Itanium 64

  • dBASE II
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:dBASE
    Source/Target Type:Source and Target
    Platform:Windows 32,Windows 64,Linux 32,Linux 64,Solaris 64,AIX 64,HPUX Itanium 64

  • dBASE III+
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:dBASE II
    Source/Target Type:Source and Target
    Platform:Windows 32, Windows 64, Linux 32, Linux 64, Solaris 64, AIX 64, HP-UX Itanium 64

  • dBASE IV
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:dBASE II
    Source/Target Type:Source and Target
    Platform:Windows 32, Windows 64, Linux 32, Linux 64, Solaris 64, AIX 64, HP-UX Itanium 64

  • dBASE V (IDAPI)
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:IDAPI
    Source/Target Type:Source and Target
    Platform:Windows 32, Windows 64, Linux 32, Linux 64, Solaris 64, AIX 64, HP-UX Itanium 64

  • DIF
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:
    Source/Target Type:Source and Target
    Platform:Windows 32, Windows 64, Linux 32, Linux 64, Solaris 64, AIX 64, HPUX Itanium 64

  • Enable
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:dBASE II
    Source/Target Type:Source and Target
    Platform:Window 32, Windows 64, Linux 32, Linux 64, Solaris 64, AIX 64, HPUX Itanium 64

  • Excel 2000
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:Excel v7
    Source/Target Type:Source and Target
    Platform:Windows 32, Windows 64, Linux 32

  • Excel 2007
    DI version:Not Applicable
    Connectivity Type:DMS Connector
    Connected Via:
    Source/Target Type:Source and Target
    Platform:Windows 32

  • Excel 95
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:Excel v5
    Source/Target Type:Source and Target
    Platform:Windows 32, Windows 64, Linux 32

  • Excel 97
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:Excel v7
    Source/Target Type:Source and Target
    Platform:Windows 32, Windows 64, Linux 32

  • Excel v2
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:Excel v4
    Source/Target Type:Source and Target
    Platform:Windows 32, Windows 64, Linux 32, Linux 64, Solaris 64, AIX 64, HP-UX Itanium 64

  • Excel v3
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:Excel v4
    Source/Target Type:Source and Target
    Platform:Windows 32, Windows 64, Linux 32, Linux 64, Solaris 64, AIX 64, HP-UX Itanium 64

  • Excel v4
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:
    Source/Target Type:Source and Target
    Platform:Windows 32, Windows 64, Linux 32, Linux 64, Solaris 64, AIX 64, HP-UX Itanium 64

  • Excel v5
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:
    Source/Target Type:Source and Target
    Platform:Windows 32, Windows 64, Linux 32

  • Excel XP
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:Excel v7
    Source/Target Type:Source and Target
    Platform:Windows 32, Windows 64, Linux 32

  • File to Message Transfer
    DI version:Pre-9.2
    Connectivity Type:MCF Component - Transformer
    Connected Via:
    Source/Target Type:Source and Target
    Platform:Windows 32, Windows 64, Linux 32, Linux 64, Solaris 32, Solaris 64, AIX 32, AIX 64, HPUX Itanium 32, HPUX Itanium 64

  • Folio Flat File
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:
    Source/Target Type:Target
    Platform:Windows 32, Windows 64, Linux 32, Linux 64, Solaris 64, AIX 64, HP-UX Itanium 64

  • FoxBASE +
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:dBASE II
    Source/Target Type:Source and Target
    Platform:Windows 32,Windows 64, Linux 32, Linux 64, Solaris 64, AIX 64, PUX Itanium 64

  • FoxPro
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:dBASE II
    Source/Target Type:Source and Target
    Platform:Windows 32, Windows 64, Linux 32, Linux 64, Solaris 64, AIX 64, HP-UX Itanium 64

  • Join Engine
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:
    Source/Target Type:Source
    Platform:Windows 32, Windows 64, Linux 32, Linux 64, Solaris 64, AIX 64, HP-UX Itanium 64

  • LDIF
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:ASCII (Fixed)
    Source/Target Type:Target
    Platform:Windows 32, Windows 64, Linux 32, Linux 64, Solaris 64, AIX 64, HP-UX Itanium 64

  • Lotus 123 r1A
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:
    Source/Target Type:Source and Target
    Platform:Windows 32, Windows 64, Linux 32, Linux 64, Solaris 64, AIX 64, HP-UX Itanium 64

  • Lotus 123 r2
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:Lotus 123 r1A
    Source/Target Type:Source and Target
    Platform:Windows 32, Windows 64, Linux 32, Linux 64, Solaris 64, AIX 64, HP-UX Itanium 64

  • Lotus 123 r3
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:Lotus 123 r1A
    Source/Target Type:Source and Target
    Platform:Windows 32, Windows 64, Linux 32, Linux 64, Solaris 64, AIX 64, HP-UX Itanium 64

  • Lotus 123 r4
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:Lotus 123 r1A
    Source/Target Type:Source and Target
    Platform:Windows 32, Windows 64, Linux 32, Linux 64, Solaris 64, AIX 64, HP-UX Itanium 64

  • Lotus Notes 5
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:
    Source/Target Type:Source and Target
    Platform:Windows 32, Linux 32

  • Lotus Notes Outbound Solution
    DI version:9.2
    Connectivity Type:Connectivity Solution
    Connected Via:
    Source/Target Type:Source
    Platform:Windows 32

  • Lotus Notes Structured Text
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:
    Source/Target Type:Source and Target
    Platform:Windows 32, Windows 64, Linux 32

  • Magic PC
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:
    Source/Target Type:Source and Target
    Platform:Windows 32, Linux 32

  • MAILER'S+4 (dBASE)
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:dBASE II
    Source/Target Type:Source and Target
    Platform:Windows 32, Windows 64, Linux 32, Linux 64, Solaris 64, AIX 64, HP-UX Itanium 64

  • Microsoft IIS Extended Logfile Format
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:ASCII (Delimited)
    Source/Target Type:Source
    Platform:Windows 32, Windows 64, Linux 32, Linux 64, Solaris 64, AIX 64, HP-UX Itanium 64

  • Paradox v5 (IDAPI)
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:IDAPI
    Source/Target Type:Source and Target
    Platform:Windows 32

  • Quattro Pro Windows v5
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:
    Source/Target Type:Source
    Platform:Windows 32, Windows 64, Linux 32, Linux 64, Solaris 64, AIX 64, HP-UX Itanium 64

  • Rich Text Format
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:
    Source/Target Type:Target
    Platform:Windows 32, Windows 64, Linux 32, Linux 64, Solaris 64, AIX 64, HP-UX Itanium 64

  • Unicode (Delimited)
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:
    Source/Target Type:Source and Target
    Platform:Windows 32, Windows 64, Linux 32, Linux 64, Solaris 64, AIX 64, HP-UX Itanium 64

  • Unicode (Fixed)
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:
    Source/Target Type:Source and Target
    Platform:Windows 32, Windows 64, Linux 32, Linux 64, Solaris 64, AIX 64, HP-UX Itanium 64

  • Visual dBASE 5.5
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:dBASE II
    Source/Target Type:Source and Target
    Platform:Windows 32, Windows 64, Linux 32, Linux 64, Solaris 64, AIX 64, HP-UX Itanium 64

  • Visual FoxPro
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:dBASE II
    Source/Target Type:Source
    Platform:Windows 32, Windows 64, Linux 32, Linux 64, Solaris 64, AIX 64, HP-UX Itanium 64

  • Visual FoxPro (ODBC)
    DI version:Pre-9.2
    Connectivity Type:Core Connector
    Connected Via:ODBC 3.x
    Source/Target Type:Source and Target
    Platform:Windows 32, Windows 64, Linux 32, Linux 64, Solaris 64, AIX 64

Customer Successes in Data File Integration

Read More Case Studies >

Presentations and Demos on Data File Integration

See More Presentations and Demos >

Start Integrating Now!

Thousands of organizations use Pervasive Integration. In just a few minutes, you can be one of them.

download button

Click this button to get your free trial!

You will be asked to sign into the Pervasive site (if you do not have a user ID, it takes less than 30 seconds to create one).

If you have any questions, or experience any problems, please contact Pervasive 

 

Quote Related Links White Papers

 Quote

  • Quote“Pervasive Data Integrator’s breadth of connectivity and mapping capabilities help our customers experience virtually pain-free data extractions. We are also looking to Pervasive to enable additional DENTRIX product enhancements, including even more decreased cycle time and full automation. No one else does as good a job on the migration front.” 


    Dave Johnston
    Director of Channel Management
    Henry Schein Practice Solutions

     

 Related Links

Data Connectors

Database Integration

Application Integration

B2B Data Exchange

Technology and Web Services Integration

 White Papers

Read More White Papers >