User:KotetsuKat/Pervasive Data Integrator
For other meanings of Data Integrator, see the Data_Integrator(disambiguation) page
| Developer(s) | Pervasive Software |
|---|---|
| Stable release | 9.2
/ Sept, 2008 |
| Operating system | Design: Windows, Execution:Cross-platform |
| Type | Business Integration Software |
| License | Commercial |
| Website | www.pervasiveintegration.com |
Pervasive Data Integrator is an ETL and Enterprise Application Integration software toolset made by Pervasive Software. Its purpose is to save time over hand-coding data integration projects.[1] Pervasive Data Integrator can automate the integration of data movement tasks on an event-driven, real-time, or regularly scheduled basis.
Pervasive Software also makes data quality profiling[2] and matching tools that work with Pervasive Data Integrator for data analysis, cleansing and remediation tasks.
Uses
[edit]Pervasive Data Integrator is used for data conversion and migrations from old software to new, for point-to-point synchronizations between two or more applications, for Enterprise Application Integration including SOA architectures, for ETL types of data aggregation and Master Data Management projects, and for business to business data exchange.[3] Pervasive Data Integrator is also frequently embedded in other software products, often invisibly, to provide a rapid migration path, or ongoing synchronization option. (Intuit's Quickbooks is an example,[4]) so is Daptiv Connect[5]).Web Service connectors provide SaaS application integration and hosted integration options.
History
[edit](stub) Before Pervasive's acquisition of Data Junction Corporation in Dec. 2003, this application's predecessor was known as Data Junction and was created by the Data Junction Corporation, formerly known as Tools and Techniques.[6]
Components
[edit]The Pervasive Data Integrator consists of a suite of tools, including a visual mapping tool, a workflow process designer, an execution engine, and various schema designers to help with complex data structure reading and writing.
Maps, relationships between source and target columns, are created in a point and click Windows GUI environment. Data transformations and conditional business logic can be defined with a simple functional scripting language, similar to Excel's. There are wizards for the transformation scripting for less technical users.[7]
Processes, workflows that include multiple steps for end-to-end data processing, are also created in a visual flow-chart style designer. This designer can call out to other applications, allowing email, external validation programs, etc. to be part of the automated workflow.[7]
Schemas, data file definitions that supply metadata for file reading and writing, are created in a variety of different visual designers, one for each type of data. EDI is handled in one point and click designer, flat files in another, and unstructured formats like email, HTML, and report or print files are handled by another.[7]
All design specifications from the various designers are saved in XML specification files that the other designers can read, making the components fully internally integrated and making direct hacks that bypass the designers possible, and making them compatible with most version control systems. It also works with ODBC and JDBC compliant BI systems.[8]
Integration execution is typically done on an event-driven, continuous or scheduled basis on a variety of platforms via an engine that has a command line interface, and several APIs. Execution can be done manually via the Process or Map GUI, for projects like one-time migrations.[7]
Connectivity adapters are fairly comprehensive and packaged with the design tools, rather than being sold separately. They cover most types of data normally encountered; protocols like HTTP/HTTPS, FTP, SOAP, and general XML, most prominent databases, EDI formats, including healthcare specific HIPAA, HL7, and NCPDP formats[9], and even many mainframe and legacy binary formats, as well as SaaS and on-premise application APIs. Adapters are also extensible via Java plug-ins.[7]
Environment
[edit]Pervasive Data Integrator is currently a Windows only graphic integration design tool. However, once design is completed, it allows execution on a variety of platforms, both 32 and 64 bit. Supported platforms include: Windows, Sun, HP-UX, AIX, and Linux. Pervasive also has a cloud option, powered by Amazon Web Services.[7]
Installation
[edit]Installation is done via a standard Windows installer for the design tools, and takes about 10 minutes. Unix installation of the execution engine is done via zip file and takes about the same amount of time.
Analysis
[edit]Both analyst criticisms and compliments of Pervasive Data Integrator frequently revolve around its relatively low price for commercial integration software, and use in a variety of different integration architectures. Gartner specifies Pervasive Data Integrator's cheapness, use in a lot of different small strategic projects, instead of being used in a single standard way across large enterprises, as weaknesses,[10] while Bloor lauds its cost effectiveness and versatility for multiple projects as strengths.[11] Gartner also says that Pervasive tends to be underestimated because it is often embedded invisibly in other products.
Competition
[edit]Pervasive Data Integrator labels itself as a narrowly focused best of breed product in the Data Integration software market. While it is a small company, its direct competitors in the ETL space are giants, Datastage (recently acquired by IBM), Ab Initio software, BusinessObjects Data Integrator (now SAP), and Informatica. It also directly competes with ETL tools from database vendors such as Microsoft's SQL Server Integration Services (previously Data Transformation Services); analytics and BI vendors with an ETL component such as WebFOCUS's iWay Software; startups like Syncsort DMExpress, Embarcadero Technologies, Scribe, and Sunopsis; as well as indirect competitors in Enterprise Application Integration, Enterprise Service Bus and Application Server vendors like BEA Systems, TIBCO and WebMethods (now Software AG). There are a few small proprietary vendors such as Software Labs, expressor software, and open source products like Apatar, CloverETL, Pentaho Kettle and Talend as well.
See also
[edit]- Pervasive Software - Company
- Comparison of Business Integration Software
- Extract, Transform, Load
- Enterprise Application Integration
References
[edit]- ^ [1] Data integration software vs. hand coding: Balancing costs and benefits, March 28, 2007, SearchDataManagement.com
- ^ "Pervasive Data Quality Tools". Retrieved 2009-08-21.
- ^ [2]Pervasive Integration Hub Review in Information Management Magazine, Jul/Aug 2009
- ^ [3]Pervasive Intuit Case Study
- ^ [4] Daptiv and Pervasive Software Partner to Help Customers Easily Integrate ...
- ^ [5] Pervasive Completes Acquisition of Data Junction, December 8, 2003
- ^ a b c d e f [6] Pervasive Data Integrator Product Architecture
- ^ "Pervasive Metadata Management". Retrieved 2009-08-21.
- ^ [7] LifeMasters Utilizes Pervasive to Advance Health Management Efforts, Information Management, January, 2008
- ^ [8] Gartner Magic Quadrant for Data Integration Tools, 2009
- ^ [9] Comparative costs and uses of Data Integration Platforms, August, 2008
External links
[edit]Category:Software Category:Cross-platform software Category:ETL tools Category:Middleware Category:Service-oriented architecture related products