IRI Data Sources

 

Next Steps
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 finding and masking PII/PHI/PAN/PI/CSI in structured RDB columns and flat files
  • IRI DarkShield, for the same, plus semi-structured and unstructured DB, document, file and image sources
  • IRI RowGen, for synthesizing realistic test data into flat-file, formatted report, and RDB table/schema targets

Data sources are static or streaming, from:

  • Amazon S3
  • ASN.1 CDR files
  • Azure BLOB storage
  • DBs via ODBC
  • Flat files
  • FTP & SFTP
  • GCP storage
  • .gzip files
  • HDFS
  • HTTP & HTTPS
  • Kafka & MQTT
  • Parquet files
  • 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 et al
  • C-ISAM
  • CLF web logs
  • CSV
  • DB2 (UDB)
  • DB2 for i5/OS
  • DB2 for z/OS
  • Delimited
  • Derby (WB)
  • ELF web logs
  • ESDS
  • Excel
  • HL7
  • HSQLDB (WB)
  • IDX 3, 4 & 8
  • Informix
  • Ingres
  • LDIF
  • JSON
  • Line Sequential
  • MariaDB
  • MaxDB
  • MF- & RM-ISAM
  • MF Var. Length
  • MySQL
  • Oracle
  • PDF (WB)
  • PostgreSQL
  • Record Sequential
  • RTF (WB)
  • SQL Anywhere
  • SQL Server
  • SQLite
  • Sybase ASA/E & IQ
  • Tibero (FACT)
  • Teradata
  • Text
  • TSV
  • UTF-8 & 16
  • Variable Block
  • Variable Sequential
  • VSAM MVS (UniKix)
  • Web Services (WB)
  • Word (WB)
  • X12
  • 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 DynamoDB
  • Amazon EMR HIVE
  • Amazon Redshift
  • Amazon RDS
  • Apache Cassandra
  • Apache Hadoop Hive
  • Azure CosmosDB
  • Cloudera CDH HIVE
  • Cloudera Impala
  • Couchbase
  • Database.com
  • Elasticsearch
  • Google BigQuery
  • Google BigTable
  • Hortonworks HIVE
  • Hubspot
  • Kafka Connect
  • MapR HIVE
  • Marketo
  • MarkLogic (XML)
  • MongoDB
  • MS Dynamics CRM
  • MS SQL Azure
  • Oracle Eloqua
  • Oracle Cloud DB
  • Netezza
  • Parquet files
  • Pivotal Greenplum
  • Pivotal HD HIVE
  • Redis
  • SAP HANA
  • Salesforce.com
  • Snowflake DB
  • Solr
  • Spark SQL
  • Vertica DB

* In addition, IRI CellShield finds and masks data in Excel spreadsheets. IRI DarkShield finds and masks data in unstructured text, email and log files, .pdf documents, MS Word and Excel, along with DICOM and OCR-ready image files (bmp, gif, jpg/2, png, tif/f).



Request More Information

Live Chat

* indicates a required field.
IRI does NOT share your information.