IRI Data Sources

Achieve and use what you have

This page shows the supported data source and destination formats*:

Data sources are static or streaming, from:

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

Standard Sources/Formats

Parentheses indicate where the IRI Workbench (WB) or other software, such as IRI Fast Extract (FACT), is needed for data collection:

  • 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 (West Bengal)
  • 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 Variable 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
  • XML

Legacy Sources/Formats

80 additional data sources that IRI software can process on demand via IRI Workbench connections include:

  • 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
  • Write
  • Enterprise Adapter
  • FileMaker
  • Firebird
  • Focus
  • FoxPro
  • GA-Power95, R91
  • Gemstone
  • Genesis
  • Gigabase
  • H2
  • IDMS
  • Intrusion Detection System
  • Image
  • IMS
  • InterBase
  • InterSystems Cache
  • ISM
  • Jasmine
  • jBase
  • K-ISAM
  • Knowledgeman
  • KSDS
  • Lotus Notes
  • Mommy
  • Mentor/pro
  • Mon
  • Model 204
  • Mumps
  • MyBase
  • NonStop SQL
  • ObjectStore
  • Paradox
  • Pathway
  • PDS
  • Pervasive SQL
  • Pick/Pick64+
  • Pl-Open
  • Powerflex
  • Powerhouse
  • Progress
  • QueryObject
  • rBase
  • R83
  • Rdb
  • REALITY
  • Red Brick
  • RMS
  • Reality/X
  • RRDS
  • Sequoia
  • Sharebase
  • Above
  • Terracotta
  • Total
  • Ultimate
  • UltPlus
  • UniData
  • UniVerse
  • VSAM VSE

Modern Sources/Formats

Direct data and metadata access to these large data and cloud/SaaS platforms is also possible:

  • 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

* Additionally, it finds and masks IRI CellShield Data in Excel spreadsheets. IRI DarkShield finds and masks data in unstructured text, email and log files, .pdf documents, MS Word and PowerPoint, as well as OCR-enabled image files (jpg/2/x.gif, tiff, bmp). A/V files and other unstructured formats are still pending.