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

CData Software - Knowledge Base

Recent Articles

Automated Continuous Kafka Replication to Microsoft Access

Use CData Sync for automated, continuous, customizable Kafka replication to Microsoft Access.
A PostgreSQL Interface for Salesforce Pardot using the CData ODBC Driver

Use the SQL Gateway and Salesforce Pardot ODBC Driver to create a PostgreSQL entry-point for data access.
Integrate Real-Time Access to Square in SAPUI5 MVC Apps

Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Square in real time.
Feed Epicor Kinetic into FineReport

How to set Epicor Kinetic as a JDBC data source in FineReport.
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Cvent

Provide connectivity to Cvent through an SAP BusinessObjects universe.
Create Reports with Slack in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date Slack.
DataBind Charts to Smartsheet

Use the standard ADO.NET procedures for databinding to provide bidirectional access to Smartsheet 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.
How to Create Power BI Visual Reports with Real-Time Elasticsearch

Use CData Power BI Connectors to visualize Elasticsearch in Power BI.
Automated Continuous Azure Data Catalog Replication to Apache Cassandra

Use CData Sync for automated, continuous, customizable Azure Data Catalog replication to Apache Cassandra.
Connect to HubSpot in NetBeans

Connect to HubSpot in NetBeans with the data source configuration wizard.
Connect to HCL Domino in JRuby

Create a simple JRuby app with access to live HCL Domino.
Build Snowflake-Connected Apps in Mendix

Use CData Connect Cloud to create an OData feed for Snowflake and create custom apps in Mendix.
How to Access Google Analytics Using Entity Framework

This article shows how to access Google Analytics using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
Automated Continuous Tableau CRM Analytics Replication to Databricks

Use CData Sync for automated, continuous, customizable Tableau CRM Analytics replication to Databricks.
Connect to Power BI XMLA in JRuby

Create a simple JRuby app with access to live Power BI XMLA.
Automated Continuous Office 365 Replication to MySQL

Use CData Sync for automated, continuous, customizable Office 365 replication to MySQL.
Connect to Square in DBArtisan

Use wizards in DBArtisan to configure Square as a data source.
Automate Pipedrive Replication to Couchbase

Use CData Sync to Customize and automate Pipedrive replication to Couchbase.
Object-Relational Mapping (ORM) with Zendesk Entities in Java

Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Zendesk into a Java-based ORM framework, Hibernate.
Design BIRT Reports on QuickBooks Online

Provide current QuickBooks Online to your embedded analytics.
Replicate EventBrite for Use in Salesforce Connect

Replicate Eventbrite to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
Analyze Oracle HCM Cloud in Infragistics Reveal

Use the CData API Server to create an OData API on top of Oracle HCM Cloud and visualize live Oracle HCM Cloud in Ingragistics Reveal.
Viewing EventBrite in RAD Studio Data Explorer

How to view Eventbrite in RAD Studio Data Explorer using the CData ODBC Driver for EventBrite.
Build Data Flows from Microsoft Exchange to SQL Server using SSIS

Easily back up Microsoft Exchange to SQL Server using the SSIS components for Microsoft Exchange.
Integrate with live Stripe in Jitterbit

Use CData Connect Cloud to connect to and integrate live Stripe in Jitterbit.
Add Azure Table to Informatica Enterprise Data Catalog

Use the CData Software JDBC Driver for Azure Table with the Informatica Enterprise Data Catalog to classify and organize data.
Use the CData Software ODBC Driver for SAP HANA XS Advanced in MicroStrategy

Connect to SAP HANA XS Advanced in MicroStrategy Developer using the CData Software ODBC Driver for SAP HANA XS Advanced.
How to Create Power BI Visual Reports with Real-Time Avalara AvaTax

Use CData Power BI Connectors to visualize Avalara AvaTax in Power BI.
Visualize Live Databricks in Power BI (via CData Connect Cloud)

Use the CData Power BI Connector and CData Connect Cloud to integrate live Databricks into custom reports in Power BI.
Build Dashboards with Spark in Dundas BI

Create dynamic dashboards and perform analytics based on Apache Spark SQL in Dundas BI.
Visualize CSV in TIBCO Spotfire through OData

Integrate CSV/TSV Files into dashboards in TIBCO Spotfire.
Explore Geographical Relationships in Sage 300 with Power Map

Create data visualizations with Sage 300 in Power Map.
Analyze Dynamics 365 Business Central in Looker

Use CData Connect Cloud to connect to Dynamics 365 Business Central from Looker and build custom apps using live Dynamics 365 Business Central.
Connect to Highrise in NetBeans

Connect to Highrise CRM in NetBeans with the data source configuration wizard.
Integrate with Active Directory using Apache Camel2

Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Active Directory to a JSON file on disk.
Load SAP HANA XS Advanced to a Database Using Embulk

Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SAP HANA XS Advanced to a database.
Access Live ADP in Google Sheets through Connect Spreadsheets

Use Connect Spreadsheets by CData to gain access to live ADP from your Google Sheets.
Connect to HubSpot in the Denodo Platform

Use CData driver technologies to create a virtual data source for HubSpot in the Denodo Virtual DataPort Administrator.
Automate Tasks in Power Automate Using the CData Software API Server and Highrise ADO.NET Provider

Automate actions like sending emails to a contact list, posting to social media, or syncing CRM and ERP.
Create Datasets from IBM Informix in Domo Workbench and Build Visualizations of IBM Informix in Domo

Use the CData Software ODBC Driver for IBM Informix to create datasets from IBM Informix in Domo Workbench and then build visualizations in the Domo service.
Automated Continuous Reckon Accounts Hosted Replication to PostgreSQL

Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to PostgreSQL.
Import MySQL Using Azure Data Factory

Use CData Connect Cloud to connect to MySQL from Azure Data Factory and import live MySQL.
Consume Dynamics GP OData Feeds in SAP Lumira

Use the API Server to create data visualizations on Dynamics GP feeds that reflect any changes in SAP Lumira.
Integrate Live OData Services into Custom Business Apps Built in Power Apps

Use CData Connect Cloud to connect to OData and integrate live OData into apps built in Microsoft Power Apps.
Replicate Sage Intacct for Use in Salesforce Connect

Replicate Sage Intacct to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
Create SSAS Tabular Models from SAP ByDesign

How to build a SQL Server Analysis Service Tabular Model from SAP Business ByDesign using CData drivers.
How to Connect DBeaver to FHIR via a JDBC Driver

Manage FHIR with visual tools in DBeaver like the query browser.
Create Act-On-Connected Business Apps in AppSheet

Connect to Act-On via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to Act-On.
Automated Continuous Blackbaud FE NXT Replication to IBM DB2

Use CData Sync for automated, continuous, customizable Blackbaud FE NXT replication to IBM DB2.
Automate Redshift Tasks in Power Automate Using CData API Server

With CData API Server, easily create OData endpoints for live Amazon Redshift and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
Visualize Live SAP HANA in Tableau

Use CData Tableau Connectors and Tableau Desktop to visualize live SAP HANA.
Explore Geographical Relationships in Sage Cloud Accounting with Power Map

Create data visualizations with Sage Business Cloud Accounting in Power Map.
Connect to Azure DevOps as an External Source in Dremio

Use the CData JDBC Driver to connect to Azure DevOps as an External Source in Dremio.
Visualize Azure Synapse in TIBCO Spotfire through OData

Integrate Azure Synapse into dashboards in TIBCO Spotfire.
Automated Continuous Invoiced Replication to Local Delimited Files

Use CData Sync for automated, continuous, customizable Invoiced replication to delimited files (CSV/TSV).
A PostgreSQL Interface for Exact Online (MySQL Remoting via JDBC)

Use the Remoting features of the Exact Online JDBC Driver to create a PostgreSQL entry-point for data access.
How to create Visio diagrams from NetSuite

Automatically update NetSuite CRM & ERP with the changes you make to Visio master shapes.
Build SAP Concur-Connected Visualizations in datapine

Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live SAP Concur.
Natively Connect to CouchDB in PHP

The CData ODBC driver for CouchDB enables you to create PHP applications with connectivity to Apache CouchDB. Leverage the native support for ODBC in PHP.
Automate Avalara AvaTax Replication to SAP HANA

Use CData Sync to customize and automate Avalara AvaTax replication to SAP HANA.
Rapidly Develop Clio-Driven Apps with Active Query Builder

Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
Query SAP Hybris C4C as a MySQL Database in Node.js

Execute MySQL queries against SAP Hybris C4C from Node.js.
Use the CData ODBC Driver for HCL Domino in Microsoft Power Query

You can use the CData HCL Domino ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import HCL Domino into Microsoft Power Query.
Automated Continuous Box Replication to SQLite

Use CData Sync for automated, continuous, customizable Box replication to SQLite.
Connect to Real-Time Quickbase Data in Power Apps Using Dataflows to Build Custom Applications