IRI Blog Articles

Diving Deeper into Data Management

 

 

Post image for Connecting to 84 More Data Sources

Connecting to 84 More Data Sources

by Claudia Irvine

Data architects and data scientists, as well as DBAs and governance teams, may need to use or migrate data in legacy file formats and databases. Additionally, the ability to mash-up those sources with newer file and database repositories is important in data integration (ETL) and analytic projects, as well as in data profiling for data loss prevention and privacy law compliance.

Users of  IRI CoSort (data transformation and reporting), IRI NextForm (data migration and replication), and IRI FieldShield (data masking) software, have traditionally acquired and manipulated data in structured (flat) files and relational databases. Recent support has been added in the IRI Workbench (Eclipse) GUI for unstructured sources and Micro Focus COBOL index files.

Through a new partnership with CONNX Solutions, IRI Workbench users can use specialized ODBC and JDCB drivers to access and view data in legacy formats like Adabas, Datacom, IDMS, Model 204, and Pick. Connections to these sources not only expand solution reach for IRI users, they eliminate the need to assign more resources to the problem of unlocking esoteric data.

Below is the updated list of supported data sources for those using IRI software. Parentheses denote integration of the IRI Workbench GUI or other dependencies for reaching the data. Italics indicate sources requiring CONNX driver installation.

AccessD3IDMSMyBaseReality/X
Acucobol VisionDatacomIDSMySQLRRDS
AdabasDataflexIDX 3, 4 & 8NetezzaRTF (WB)
Adabas DDb4oImageNonStop SQLSAP Hana
Advanced PickdBaseIMSObjectStoreSequoia
ALLBASEDelimitedInformixOracleSharebase
Altibase (FACT)Derby (WB)IngresOutlook (WB)SQL Anywhere
Alpha FiveDesktop AdapterInterBaseParadoxSQL Server
Amazon RDSDL/1Intersystems CachePathwaySQLite
ASN.1 TAP 3DSMISMPDF (WB)Supra
AzureEnscribeJasminePDSSybase ASA/E & IQ
BIRT DB (WB)Enterprise AdapterjBasePervasiveSQLTerracotta
BIRT Hive (WB)ESDSK-ISAMPickTeradata (WB)
BIRT JDBC (WB)Excel (WB)KnowledgemanPick64+Text
BIRT POJO (WB)ELF web logsKSDSPl-OpenTibero (FACT)
BizTalkFileMakerLDIFPostgreSQLTotal
CacheFirebirdLine SequentialPowerflexUltimate
C-ISAMFixedLotus ApproachPowerhouseUltPlus
CLF web logsFlat FilesLotus NotesPowerPoint (WB)UniData
ClipperFocusManmanProgressUniVerse
CodasylFoxProMax DBQueryObjectUTF-8
CorvisionGA-Power 95, R91Mentor/prorBaseUTF-8
ConceptBaseGemstoneMF-ISAMR83VSAM
CSVGENESISMF Var. LengthRdbVSAM-MVS (Unikix)
DB2 (UDB)GigabaseMOREALITYVSAM-VSE
DB2 for i5/OS (WB)H2Model 204Record SequentialWeb Services (WB)
DB2 for z/OS (WB)Heap / printMongoDB (WB)Red BrickWord (WB)
D-ISAMHSQLDB (WB)MumpsRMSXML

The procedure for connecting to a non-native database in the IRI Workbench involves installing CONNX software and drivers. After a data dictionary file is created in the CONNX software, that file is then used in the Workbench with the CONNX driver as a data source. Following our user guide, setup can take as little as 20 minutes.

Connx1

In the Workbench, the data source name (DSN) is available (as any native DSN would be) and displays in the lower left area of the Data Source Explorer workspace. This enables the use of that data (and its metadata) throughout the IRI Workbench environment.

Consider the following IRI CoSort (SortCL program) example; the script created in the new sort job wizard will use the connection to define the reordering of the ‘Customers’ table in a mainframe C-ISAM repository by zip code:

Connx6In this next example, IRI NextForm remaps data in multiple C-ISAM files (reflected as ODBC-connected DB tables) using a common mapping rule:

Connx4

When the job wizard is complete, a portable job script is produced, and the script can be run from the GUI (or on the command line) to perform the specified migration:

Connx5

In this same environment, data can be migrated, transformed, masked, etc., for whatever the needs may be and the licenses allow.  The ability to successfully access a large variety of structured, semi-structured, and unstructured data sources demonstrates IRI’s congruent commitment to supporting both legacy systems and emerging platforms.

Print Friendly

{ 1 comment… read it below or add one }

Harinath Prabhakaran February 15, 2016 at 10:22 am

I’m interested in the unstructured (dark data) sources. Do you need special drivers for those, or is the data restructuring wizard mentioned in the other articles all I’d need for that?

Reply

Leave a Comment

Previous post:

Next post: