IRI Data Sources


Reaching and Using What You Have

Overview
Data Sources
Discover Data
Design & Run Jobs
Edit & Share Projects
Eclipse Facilities

This page lists the data source and target formats supported by*:

 

  • IRI Voracity, for enterprise data discovery, integration, migration, governance, and analytics
  • IRI CoSort, for high-performance data transformation, reporting, and pre-load sorting
  • IRI NextForm, for data and database migration
  • IRI FieldShield, for PAN, PHI, and PII data masking
  • IRI RowGen, for synthetic, but realistic test data generation

Data sources are static or streaming, from:

  • Amazon S3
  • DBs via ODBC
  • Flat files
  • FTP & SFTP
  • .gzip files
  • HDFS
  • HTTP & HTTPS
  • Kafka & MQTT
  • Pipes
  • Programs

Default Sources/Formats

 

Parentheses denote where the IRI Workbench (WB) or other software, like IRI Fast Extract (FACT), is needed for data acquisition:

  • Acucobol Vision
  • Altibase (FACT)
  • ASN.1 TAP3
  • C-ISAM
  • CLF web logs
  • CSV
  • DB2 (UDB)
  • DB2 for i5/OS
  • DB2 for z/OS
  • Delimited
  • Derby (WB)
  • ESDS
  • Excel
  • ELF web logs
  • Fixed
  • Heap / print
  • HSQLDB (WB)
  • IDX 3, 4 & 8
  • Informix
  • Ingres
  • LDIF
  • JSON
  • Line Sequential
  • MaxDB
  • MF- & RM-ISAM
  • MF Var. Length
  • MySQL
  • Oracle
  • Outlook (WB)
  • PDF (WB)
  • PostgreSQL
  • Powerpoint (WB)
  • Record Sequential
  • RTF (WB)
  • SQL Anywhere
  • SQL Server
  • SQLite
  • Sybase ASA/E & IQ
  • Tibero (FACT)
  • Teradata
  • Text
  • UTF-8 & 16
  • Variable Block
  • Variable Sequential
  • VSAM MVS (UniKix)
  • Web Services (WB)
  • Word (WB)
  • XML

Legacy Sources/Formats

80 additional data sources that IRI software can process via IRI Workbench connections on request, are:

  • Access
  • Adabas
  • Advanced Pick
  • ALLBASE
  • Alpha Five
  • BizTalk
  • Cache
  • Clipper
  • Codasyl
  • CorVision
  • ConceptBase
  • D-ISAM
  • D3
  • Datacom
  • Dataflex
  • Db4o
  • dBase
  • Desktop Adapter
  • DL/1
  • DSM
  • Enscribe
  • Enterprise Adapter
  • FileMaker
  • Firebird
  • Focus
  • FoxPro
  • GA-Power95, R91
  • Gemstone
  • GENESIS
  • Gigabase
  • H2
  • IDMS
  • IDS
  • Image
  • IMS
  • InterBase
  • Intersystems Cache
  • ISM
  • Jasmine
  • jBase
  • K-ISAM
  • Knowledgeman
  • KSDS
  • Lotus Notes
  • Manman
  • Mentor /pro
  • MO
  • Model 204
  • Mumps
  • MyBase
  • NonStop SQL
  • ObjectStore
  • Paradox
  • Pathway
  • PDS
  • PervasiveSQL
  • Pick/Pick64+
  • Pl-Open
  • Powerflex
  • Powerhouse
  • Progress
  • QueryObject
  • rBase
  • R83
  • Rdb
  • REALITY
  • Red Brick
  • RMS
  • Reality/X
  • RRDS
  • Sequoia
  • Sharebase
  • Supra
  • Terracotta
  • Total
  • Ultimate
  • UltPlus
  • UniData
  • UniVerse
  • VSAM VSE

Modern Sources/Formats

 

Direct data and metadata access to these big data and cloud/SaaS platforms are also available:

  • Amazon EMR Hive
  • Amazon RDS
  • Apache Cassandra
  • Apache Hadoop Hive
  • Azure
  • Cloudera CDH Hive
  • Cloudera Impala
  • Database.com
  • ElasticSearch (JSON)
  • FinancialForce
  • Force.com apps
  • Hortonworks Hive
  • Hubspot
  • Lightning Connect
  • MapR Hive
  • Marketo
  • MarkLogic (XML)
  • MongoDB
  • MS Dynamics CRM
  • MS SQL Azure
  • Oracle Eloqua
  • Oracle Service Cloud
  • Netezza
  • Pivotal Greenplum
  • Pivotal HD Hive
  • SAP HANA
  • Salesforce.com
  • ServiceMAX
  • Spark SQL
  • Veeva CRM

* In addition, IRI CellShield finds and masks data in Excel spreadheets. IRI DarkShield finds and masks data in unstructured text, email and log files, .pdf documents, MS Word and PowerPoint, along with OCR-ready image files (jpg/2/x. gif, tiff, bmp). A/V files and other unstructured formats pending.