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
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).
