Learn more
 

Ready to get started?

Learn more:

IBM Informix Connectivity Solutions

In this article

Related articles

IBM Informix Integration Guides and Tutorials


A list of guides and tutorials for connecting to and working with live IBM Informix data.

CData Software's connectivity tools enable users to connect directly to live IBM Informix data data from widely-used BI, analytics, ETL, and custom applications, ensuring that our customers can access their data wherever they desire. Below, you'll find a collection of guides and tutorials on integrating with live IBM Informix data.

Integration Use-Cases

Click below to jump to articles related to specific integration use-case.

Business Intelligence & Analytics


ProductTechnologyArticle Title
Alteryx DesignerODBCPrepare, Blend, and Analyze IBM Informix in Alteryx Designer (ODBC)
Alteryx DesignerConnect CloudWork with Live IBM Informix Data in Alteryx Designer (Connect Cloud)
Amazon QuickSightConnect CloudBuild Interactive Dashboards from IBM Informix Data in Amazon QuickSight
Amazon SageMakerConnect CloudIntegrate Live IBM Informix data into Amazon SageMaker Canvas
Aqua Data StudioJDBCConnect to IBM Informix in Aqua Data Studio
AWS DatabricksJDBCProcess & Analyze IBM Informix Data in Databricks (AWS)
Azure Analysis ServicesConnect CloudModel IBM Informix Data Using Azure Analysis Services
BirstJDBCBuild Visualizations of IBM Informix in Birst
BIRTJDBCDesign BIRT Reports on IBM Informix
Clear AnalyticsODBCBuild Charts with IBM Informix in Clear Analytics
Cognos Analytics (On-Prem)Connect CloudAnalyze IBM Informix Data in Cognos Analytics
DBxtraODBCBuild Dashboards with IBM Informix in DBxtra
DomoODBCCreate Datasets from IBM Informix in Domo Workbench
Dundas BIODBCBuild Dashboards with IBM Informix in Dundas BI
Excel (on Mac OS)ODBCWork with IBM Informix Data in MS Excel on Mac OS X
FineReportJDBCFeed IBM Informix into FineReport
Google SheetsConnect CloudAccess Live IBM Informix Data in Google Sheets
IBM Cognos BIODBCCreate Data Visualizations in Cognos BI with IBM Informix
Infragistics RevealConnect CloudAnalyze IBM Informix Data in Infragistics Reval
JasperServerJDBCCreate IBM Informix Reports on JasperReports Server
Jaspersoft BI SuiteJDBCConnect to IBM Informix in Jaspersoft Studio
JReport DesignerJDBCIntegrate with IBM Informix in JReport Designer
KlipfolioConnect CloudCreate IBM Informix-Connected Visualizations in Klipfolio
KNIMEJDBCEnable the IBM Informix JDBC Driver in KNIME
LINQPadADO.NETWorking with IBM Informix in LINQPad
LookerConnect CloudAnalyze IBM Informix Data in Looker
Looker StudioConnect CloudCreate Reports from IBM Informix Data in Looker Studio
MetabaseConnect CloudCreate Interactive IBM Informix-Connected Metabase Dashboards
Microsoft ExcelConnect CloudAccess Live IBM Informix Data in Excel Desktop
Microsoft Excel for the WebConnect CloudAccess Live IBM Informix Data in Excel for the Web
Microsoft SSASADO.NETBuild an OLAP Cube in SSAS from IBM Informix
MicroStrategyConnect CloudConnect to Live IBM Informix Data in MicroStrategy through Connect Cloud
MicroStrategyJDBCUse the CData JDBC Driver for IBM Informix in MicroStrategy
Microstrategy DesktopJDBCUse the CData JDBC Driver for IBM Informix in MicroStrategy Desktop
Microstrategy WebJDBCUse the CData JDBC Driver for IBM Informix in MicroStrategy Web
Mode AnalyticsConnect CloudCreate IBM Informix-Connected Visualizations in Mode
OBIEEJDBCIBM Informix Reporting in OBIEE with the IBM Informix JDBC Driver
pandasPythonUse pandas to Visualize IBM Informix in Python
Pentaho Report DesignerJDBCIntegrate IBM Informix in the Pentaho Report Designer
Power BI DesktopPower BIAuthor Power BI Reports on Real-Time IBM Informix
Power BI ServiceConnect CloudVisualize Live IBM Informix Data in the Power BI Service
Power PivotConnect CloudAccess IBM Informix Data in Microsoft Power Pivot
Power QueryConnect CloudAccess IBM Informix Data in Microsoft Power Query
Qlik CloudConnect CloudCreate Apps from IBM Informix Data in Qlik Sense Cloud
QlikViewODBCConnect to and Query IBM Informix in QlikView over ODBC
RJDBCAnalyze IBM Informix in R (JDBC)
RODBCAnalyze IBM Informix in R (ODBC)
RapidMinerJDBCConnect to IBM Informix in RapidMiner
RedashConnect ServerBuild IBM Informix-Connected Dashboards in Redash
SAP Analytics CloudConnect CloudAnalyze IBM Informix Data in SAP Analytics Cloud
SAP Business ObjectsJDBCCreate an SAP BusinessObjects Universe on the CData JDBC Driver for IBM Informix
SAP Crystal ReportsJDBCPublish Reports with IBM Informix in Crystal Reports
SASODBCUse the CData ODBC Driver for IBM Informix in SAS for Real-Time Reporting and Analytics
SAS JMPODBCUse the CData ODBC Driver for IBM Informix in SAS JMP
SAS ViyaConnect CloudAnalyze Live IBM Informix Data in SAS Viya
SisenseJDBCVisualize Live IBM Informix in Sisense
Spago BIJDBCConnect to IBM Informix in SpagoBI
TableauTableauVisualize IBM Informix in Tableau Desktop
Tableau CloudConnect CloudBuild IBM Informix Visualizations in Tableau Cloud
Tableau ServerTableauPublish IBM Informix-Connected Dashboards in Tableau Server
TIBCO SpotfireADO.NETVisualize IBM Informix in TIBCO Spotfire through ADO.NET
TIBCO SpotfireConnect ServerVisualize IBM Informix Data in TIBCO Spotfire
TIBCO Spotfire ServerJDBCOperational Reporting on IBM Informix from Spotfire Server
VisioODBCLink Visio Shapes to IBM Informix
Zoho AnalyticsConnect CloudCreate IBM Informix-Connected Dashboards in Zoho Analytics

Back to top

ETL & Replication


ProductTechnologyArticle Title
AirbyteConnect CloudConnect to IBM Informix Data in Airbyte ELT Pipelines
Amazon RedshiftCData SyncAutomated Continuous IBM Informix Replication to Amazon Redshift
Amazon S3CData SyncAutomated Continuous IBM Informix Replication to Amazon S3
Apache AirflowJDBCBridge IBM Informix Connectivity with Apache Airflow
Apache CamelJDBCIntegrate with IBM Informix using Apache Camel
Apache CassandraCData SyncAutomated Continuous IBM Informix Replication to Apache Cassandra
Apache KafkaCData SyncAutomated Continuous IBM Informix Replication to Apache Kafka
Apache NiFiJDBCBridge IBM Informix Connectivity with Apache NiFi
Apache NiFi Batch OperationsJDBCPerform Batch Operations with IBM Informix Data in Apache NiFi
AWS GlueConnect CloudBuild ETL Jobs with IBM Informix Data in AWS Glue Jobs
Azure Data FactoryConnect CloudImport IBM Informix Data Using Azure Data Factory
Azure Data LakeCData SyncAutomated Continuous IBM Informix Replication to Azure Data Lake
Azure SynapseCData SyncAutomated Continuous IBM Informix Replication to Azure Synapse
BIMLSSISUse Biml to Build SSIS Tasks to Replicate IBM Informix to SQL Server
CloverDXJDBCConnect to IBM Informix in CloverDX (formerly CloverETL)
CouchbaseCData SyncAutomated Continuous IBM Informix Replication to Couchbase
CSVCData SyncAutomated Continuous IBM Informix Replication to Local Delimited Files
DatabricksCData SyncAutomated Continuous IBM Informix Replication to Databricks
FoxProODBCWork with IBM Informix in FoxPro
Google AlloyDBCData SyncAutomated Continuous IBM Informix Replication to Google AlloyDB
Google BigQueryCData SyncAutomated Continuous IBM Informix Replication to Google BigQuery
Google Cloud SQLCData SyncAutomated Continuous IBM Informix Replication to Google Cloud SQL
Google Data FusionJDBCBuild IBM Informix-Connected ETL Processes in Google Data Fusion
Heroku / Salesforce ConnectCData SyncReplicate IBM Informix for Use in Salesforce Connect
HULFT IntegrateJDBCConnect to IBM Informix in HULFT Integrate
IBM DB2CData SyncAutomated Continuous IBM Informix Replication to IBM DB2
Informatica CloudJDBCIntegrate IBM Informix in Your Informatica Cloud Instance
Informatica PowerCenterJDBCCreate Informatica Mappings From/To a JDBC Data Source for IBM Informix
Jaspersoft ETLJDBCConnect to IBM Informix in Jaspersoft Studio
Microsoft AccessCData SyncAutomated Continuous IBM Informix Replication to Microsoft Access
Microsoft Azure TablesCData SyncAutomated Continuous IBM Informix Replication to Azure SQL
Microsoft ExcelExcelTransfer Data from Excel to IBM Informix
Microsoft Power AutomateConnect CloudBuild IBM Informix-Connected Automated Tasks with Power Automate (Desktop)
MongoDBCData SyncAutomated Continuous IBM Informix Replication to MongoDB
MySQLCData SyncAutomated Continuous IBM Informix Replication to MySQL
Oracle Data IntegratorJDBCETL IBM Informix in Oracle Data Integrator
Oracle DatabaseCData SyncAutomated Continuous IBM Informix Replication to Oracle
petlPythonExtract, Transform, and Load IBM Informix in Python
PostgreSQLCData SyncAutomated Continuous IBM Informix Replication to PostgreSQL
Replicate to MySQLPowerShellReplicate IBM Informix to MySQL with PowerShell
SAP HANACData SyncAutomated Continuous IBM Informix Replication to SAP HANA
SingleStoreCData SyncAutomated Continuous IBM Informix Replication to SingleStore
SnapLogicJDBCIntegrate IBM Informix with External Services using SnapLogic
SnowflakeCData SyncAutomated Continuous IBM Informix Replication to Snowflake
SQL ServerCData SyncAutomated Continuous IBM Informix Replication to SQL Server
SQL Server Linked ServerConnect CloudConnect to IBM Informix Data as a SQL Server Linked Server
SQLiteCData SyncAutomated Continuous IBM Informix Replication to SQLite
TalendJDBCConnect to IBM Informix and Transfer Data in Talend
UiPath StudioODBCCreate an RPA Flow that Connects to IBM Informix in UiPath Studio
VerticaCData SyncAutomated Continuous IBM Informix Replication to a Vertica Database

Back to top

Data Virtualization


ProductTechnologyArticle Title
Access Linked TablesODBCUpdate IBM Informix with a Microsoft Access Linked Table
APOS Live Data GatewayJDBCBuild Semantic Layer Views for IBM Informix (JDBC)
APOS Live Data GatewayConnect CloudBuild Semantic Layer Views for IBM Informix Data (Connect Cloud)
DenodoJDBCCreate A Data Source for IBM Informix in Denodo Platform
DremioJDBCConnect to IBM Informix as an External Source in Dremio
MySQL Federated TablesODBCConnect to IBM Informix as Federated Tables in MySQL
Oracle DatabaseODBCAccess IBM Informix as a Remote Oracle Database
PostgreSQL FDWJDBCA PostgreSQL Interface for IBM Informix
Salesforce ConnectConnect CloudEdit and Search IBM Informix External Objects in Salesforce Connect
SQL Server Linked ServersODBCConnect to IBM Informix as a Linked Server
SQL Server PolyBaseConnect CloudConnect to IBM Informix Data using PolyBase with Connect Cloud
SQL Server PolyBaseODBCConnect to IBM Informix as an External Data Source using PolyBase

Back to top

Software Development


ProductTechnologyArticle Title
.NET ChartsADO.NETDataBind Charts to IBM Informix
.NET QueryBuilderODBCRapidly Develop IBM Informix-Driven Apps with Active Query Builder
Angular JSConnect ServerUsing AngularJS to Build Dynamic Web Pages with IBM Informix
Apache SparkJDBCWork with IBM Informix in Apache Spark Using SQL
AppSheetConnect CloudCreate IBM Informix-Connected Business Apps in AppSheet
Bubble.ioConnect CloudBuild IBM Informix-Connected Apps in Bubble
C++BuilderODBCDataBind Controls to IBM Informix Data in C++Builder
ChoreoConnect CloudBuild Custom Apps on IBM Informix Data in Choreo
ColdFusionJDBCQuery IBM Informix in ColdFusion Using JDBC
ColdFusionODBCQuery IBM Informix in ColdFusion Using ODBC
DashPythonUse Dash & Python to Build Web Apps on IBM Informix
DelphiODBCDataBind Controls to IBM Informix Data in Delphi
DevExpressADO.NETDataBind IBM Informix to the DevExpress Data Grid
EF - Code FirstADO.NETAccess IBM Informix with Entity Framework 6
EF - LINQADO.NETLINQ to IBM Informix
EF - MVCADO.NETBuild MVC Applications with Connectivity to IBM Informix
Filemaker ProODBCBidirectional Access to IBM Informix from FileMaker Pro
Filemaker Pro (on Mac)JDBCBidirectional Access to IBM Informix from FileMaker Pro (on Mac)
GoODBCWrite a Simple Go Application to work with IBM Informix on Linux
Google Apps ScriptConnect CloudConnect to IBM Informix Data in Google Apps Script
HibernateJDBCObject-Relational Mapping (ORM) with IBM Informix Entities in Java
IntelliJJDBCConnect to IBM Informix in IntelliJ
JBossJDBCConnect to IBM Informix from a Connection Pool in JBoss
JDBIJDBCCreate a Data Access Object for IBM Informix using JDBI
JRubyJDBCConnect to IBM Informix in JRuby
MendixConnect CloudBuild IBM Informix-Connected Apps in Mendix
Microsoft Power AppsConnect CloudIntegrate Live IBM Informix Data into Custom Business Apps Built in Power Apps
NodeJSConnect CloudQuery IBM Informix Data in Node.js (via Connect Cloud)
NodeJSODBCQuery IBM Informix through ODBC in Node.js
OutSystemsConnect CloudCreate IBM Informix-Connected Enterprise Applications in OutSystems
PHPConnect ServerAccess IBM Informix in PHP through Connect Server
PHPODBCNatively Connect to IBM Informix in PHP
PowerBuilderADO.NETConnect to IBM Informix from PowerBuilder
PowerShellPowerShellPipe IBM Informix to CSV in PowerShell
PyCharmODBCUsing the CData ODBC Driver for IBM Informix in PyCharm
PythonODBCConnect to IBM Informix in Python on Linux/UNIX
ReactConnect ServerBuild Dynamic React Apps with IBM Informix Data
RubyODBCConnect to IBM Informix in Ruby
RunMyProcessConnect CloudConnect to IBM Informix Data in RunMyProcess
RunMyProcess DSECJDBCConnect to IBM Informix in DigitalSuite Studio through RunMyProcess DSEC
SAP UI5Connect ServerIntegrate Real-Time Access to IBM Informix in SAPUI5 MVC Apps
ServoyJDBCBuild IBM Informix-Connected Apps in Servoy
Spring BootJDBCAccess Live IBM Informix Data in Spring Boot Apps
SQLAlchemyPythonUse SQLAlchemy ORMs to Access IBM Informix in Python
TomcatJDBCConfigure the CData JDBC Driver for IBM Informix in a Connection Pool in Tomcat
UnqorkConnect CloudCreate IBM Informix-Connected Applications in Unqork
VCL App (RAD Studio)ODBCBuild a Simple VCL Application for IBM Informix
WebLogicJDBCConnect to IBM Informix from a Connection Pool in WebLogic

Back to top

Data Management


ProductTechnologyArticle Title
Apache SolrJDBCImport IBM Informix Data into Apache Solr
DB ArtisanJDBCManage IBM Informix in DBArtisan as a JDBC Source
DB ArtisanODBCConnect to IBM Informix in DBArtisan
DBeaverJDBCConnect to IBM Informix in DBeaver
DbVisualizerJDBCConnect to IBM Informix in DBVisualizer
Informatica Enterprise Data CatalogJDBCAdd IBM Informix to Informatica Enterprise Data Catalog
MySQL WorkbenchConnect ServerQuery IBM Informix Data in MySQL Workbench (Connect Server)
MySQL WorkbenchODBCQuery IBM Informix in MySQL Workbench (ODBC)
QuerySurgeJDBCValidate IBM Informix Data with QuerySurge
RazorSQLJDBCConnect to IBM Informix in RazorSQL
SQuirreLJDBCConnect to IBM Informix in Squirrel SQL Client

Back to top

Workflow Automation


ProductTechnologyArticle Title
MuleSoft AnypointJDBCAccess IBM Informix in Anypoint Using SQL
Nintex Workflow CloudConnect CloudBuild IBM Informix-Connected Workflows in Nintex
Power AutomateConnect CloudIntegrate IBM Informix Data into Power Automate Automated Tasks
SSIS ExportSSISExport Data from SQL Server to IBM Informix through SSIS
SSIS ImportSSISImport IBM Informix Data into SQL Server using SSIS
SSIS LookupSSISInsert New or Update Existing IBM Informix Records from SQL Server

Back to top