Show articles by: Integration Technology | Driver Technology | Recent Articles

CData Software - Knowledge Base

Recent Articles

Automated Continuous Couchbase Replication to Amazon Redshift

Use CData Sync for automated, continuous, customizable Couchbase replication to Amazon Redshift.
Create Data Visualizations in Cognos BI with SAP Netweaver Gateway

Access SAP Netweaver Gateway as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
Automated Continuous Excel Replication to AlloyDB

Use CData Sync for automated, continuous, customizable Excel replication to AlloyDB.
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Salesloft

Provide connectivity to Salesloft through an SAP BusinessObjects universe.
Prepare, Blend, and Analyze IBM Informix in Alteryx Designer (Connect Cloud)

Build workflows to access live IBM Informix for self-service data analytics.
How to Work with IBM Cloud Object Storage in AWS Glue Jobs Using JDBC

Connect to IBM Cloud Object Storage from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
Query Klaviyo in ColdFusion

Write standard ColdFusion data access code to connect to Klaviyo.
Integrate with GMO MakeShop in SnapLogic

Use CData Connect Cloud to connect to and integrate with live GMO MakeShop in SnapLogic.
How to Work with Printify in ETL Validator JDBC

Connect to Printify from ETL Validator jobs using the CData Software JDBC Driver.
DataBind Charts to HCL Domino

Use the standard ADO.NET procedures for databinding to provide bidirectional access to HCL Domino from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
Automated Continuous Avro Replication to MongoDB

Use CData Sync for automated, continuous, customizable Avro replication to MongoDB.
Bridge Microsoft OneDrive Connectivity with Apache NiFi

Access and process Microsoft OneDrive in Apache NiFi using the CData JDBC Driver.
Visualize Twitter in TIBCO Spotfire through OData

Integrate Twitter into dashboards in TIBCO Spotfire.
Create Reports with Elasticsearch in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date Elasticsearch.
How to Access ConstantContact Using Entity Framework

This article shows how to access ConstantContact using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
Automated Continuous SharePoint Replication to IBM DB2

Use CData Sync for automated, continuous, customizable SharePoint replication to IBM DB2.
Connect to Harvest in SpagoBI

Create reports featuring live Harvest in SpagoBI Studio. Host Harvest reports on SpagoBI Server.
Integrate with Reckon Accounts Hosted using Apache Camel2

Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Reckon Accounts Hosted to a JSON file on disk.
Connect to Microsoft Exchange in RunMyProcess through Connect Cloud

Use CData Connect Cloud to create on OData API for Microsoft Exchange and connect to Microsoft Exchange in Akorbi Digital RunMyProcess.
Access Live Excel Online in Excel (Desktop) through Connect Spreadsheets

Use Connect Spreadsheets by CData to gain access to live Microsoft Excel Online from your Excel spreadsheets.
Validate Azure Active Directory with QuerySurge

Access and validate Azure Active Directory in QuerySurge using the CData JDBC Driver.
Create xBase Dashboards in Bold BI

Use CData Software Connect Server to create a virtual SQL Server Database for xBase to build custom dashboards in Bold BI.
How to Access HBase Using Entity Framework

This article shows how to access Apache HBase using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
How to work with Spark in Apache Spark using SQL

Access and process Spark in Apache Spark using the CData Software JDBC Driver.
Automated Continuous ActiveCampaign Replication to AlloyDB

Use CData Sync for automated, continuous, customizable ActiveCampaign replication to AlloyDB.
How to connect to SAP Concur from Spring Boot

Connect to SAP Concur in a Spring Boot Application using CData JDBC SAP Concur Driver
Natively Connect to ConstantContact in PHP via ODBC (Linux)

Create PHP applications on Linux/UNIX machines with connectivity to ConstantContact. Leverage the native support for ODBC in PHP.
Connect to Salesloft from a Connection Pool in Jetty

The Salesloft JDBC Driver supports connection pooling: This article shows how to connect faster to Salesloft from Web apps in Jetty.
Creating Elasticsearch-Connected Applications in Unqork

You can use CData Connect Cloud to feed Elasticsearch to Unqork and build custom business apps.
Automated Continuous YouTube Analytics Replication to MongoDB

Use CData Sync for automated, continuous, customizable YouTube Analytics replication to MongoDB.
Natively Connect to Access in PHP via ODBC (Linux)

Create PHP applications on Linux/UNIX machines with connectivity to Microsoft Access. Leverage the native support for ODBC in PHP.
Explore Geographical Relationships in EventBrite with Power Map

Create data visualizations with Eventbrite in Power Map.
Access Live Snapchat Ads in Coginiti Pro

Connect to and query live Snapchat Ads from the GUI in the Coginiti Pro: SQL Analytics Tool.
Create Dashboards and Visualize Live ShipStation in Geckoboard

Use CData Connect Cloud to connect to live ShipStation and create dashboards for real-time monitoring and visualization in Geckoboard.
Configure the CData JDBC Driver for ActiveCampaign in a Connection Pool in Tomcat

Connect to ActiveCampaign from a connection pool in Tomcat.
How to load ConstantContact data into Elasticsearch via Logstash

Introducing a simple method to load ConstantContact data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
Create Data Visualizations Based On Exact Online in Mode

Use CData Connect Cloud to connect to Exact Online from Mode and build visualizations using live
Back Up Microsoft Dynamics GP to SQL Server through SSIS

Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Dynamics GP. In this article, we will employ an SSIS workflow to populate a database with Microsoft Dynamics GP data.
Connect to WooCommerce from a Connection Pool in WebLogic

Use the CData JDBC Driver for WooCommerce to connect to WooCommerce from Web applications running on WebLogic.
Analyze Azure Active Directory in R via JDBC

Use standard R functions and the development environment of your choice to analyze Azure Active Directory with the CData JDBC Driver for Azure Active Directory.
How to Query Oracle Service Cloud in MySQL Workbench

Execute MySQL queries against live Oracle Service Cloud from MySQL Workbench.
Bidirectional Access to Sugar CRM from FileMaker Pro

Use the MySQL Remoting feature of the JDBC driver to integrate Sugar CRM in Filemaker Pro for Mac or Windows.
Analyze Smartsheet with Power Pivot

This article walks you through the process of using the CData ODBC Driver for Smartsheet from Power Pivot. You will use the Table Import Wizard to load Smartsheet. You can visually build the import query or use any SQL supported by the driver.
Create GitHub Dataflows on PowerBI.com

Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.
Automated Oracle Sales Replication to Teradata

Use CData Sync to Customize and automate Oracle Sales replication to Teradata.
Analyze Microsoft Planner in Infragistics Reveal

Use CData Connect Cloud to create on OData API on top of Microsoft Planner and visualize live Microsoft Planner in Infragistics Reveal.
Build Visualizations of Live CData Connect Cloud in Power BI (through CData Connect)

Use CData Connect to create a virtual database for CData Connect Cloud and build custom reports in Power BI.
Automated Continuous MailChimp Replication to SQLite

Use CData Sync for automated, continuous, customizable MailChimp replication to SQLite.
Connect to Impala from a Connection Pool in JBoss

Integrate Apache Impala into Java servlets: Use the Management Console in JBoss to install the Impala JDBC Driver.
Publish Crystal Reports on Jira Service Management

Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Atlassian Jira Service Management.
A PostgreSQL Interface for MYOB AccountRight using the CData ODBC Driver

Use the SQL Gateway and MYOB AccountRight ODBC Driver to create a PostgreSQL entry-point for data access.
Visualize Live Avro in the Power BI Service

Use CData Software Connect Server to create a virtual SQL Server database for Apache Avro and create custom reports in the Power BI Service.
Enable the SingleStore JDBC Driver in KNIME

Use standard data access components in KNIME to create charts and reports with SingleStore.
Connect to and Visualize Live OneNote in Tableau Prep

Use CData Tableau Connectors and Tableau Prep Builder to visualize live Microsoft OneNote.
Integrate Live HubSpot into Custom Business Apps Built in Power Apps

Use CData Connect Cloud to connect to HubSpot and integrate live HubSpot into apps built in Microsoft Power Apps.
Use Dash to Build to Web Apps on Oracle Financials Cloud

Create Python applications that use pandas and Dash to build Oracle Financials Cloud-connected web apps.
Connect to Act CRM in Ruby

Connect to Act CRM in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
Visualize Jira Service Management in TIBCO Spotfire through ADO.NET

Integrate Atlassian Jira Service Management into dashboards in TIBCO Spotfire.
Build an OLAP Cube in SSAS from Reckon

Establish a connection to Reckon data from SQL Server Analysis Services, and use the Reckon Data Provider to build OLAP cubes for use in analytics and reporting.
Integrate Live Drift into Blue Prism for Intelligent Robotic Process Automation (RPA)