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

CData Software - Knowledge Base

Recent Articles

Create Apps from Salesforce Pardot in Qlik Sense Cloud

Use CData Connect AI to connect to Salesforce Pardot and build apps from live Salesforce Pardot in Qlik Sense Cloud.
Automated Continuous XML Replication to Local Delimited Files

Use CData Sync for automated, continuous, customizable XML replication to delimited files (CSV/TSV).
How to connect to Sybase IQ from IntelliJ

Integrate connectivity to Sybase IQ with wizards in IntelliJ.
Connect to Quickbase through External Services in Salesforce

Use CData Connect AI to securely connect Salesforce External Services with Quickbase using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
Publish Crystal Reports on TaxJar

Use the Report Wizard and standard ADO.NET to design a report based on up-to-date TaxJar.
Load Oracle Service Cloud to a Database Using Embulk

Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Oracle Service Cloud to a database.
Connect to SAP SuccessFactors in Ruby

Connect to SAP SuccessFactors in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
How to Query HarperDB in MySQL Workbench

Execute MySQL queries against live HarperDB from MySQL Workbench.
Connect to Odoo through External Services in Salesforce

Use CData Connect AI to securely connect Salesforce External Services with Odoo using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
Analyze Facebook Ads in Slingshot with CData API Server

Use the CData API Server to build an OData API on top of Facebook Ads and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.
Import Real-Time Sage 200 via JDBC in ColdFusion to Build Applications

Use CData JDBC drivers to import and use Sage 200 in ColdFusion.
Connect to PostgreSQL through External Services in Salesforce

Use CData Connect AI to securely connect Salesforce External Services with PostgreSQL using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
How to connect to Microsoft Exchange from IntelliJ

Integrate connectivity to Microsoft Exchange with wizards in IntelliJ.
Natively Connect to Elasticsearch in PHP

The CData ODBC driver for Elasticsearch enables you to create PHP applications with connectivity to Elasticsearch. Leverage the native support for ODBC in PHP.
Process & Analyze SFTP in Databricks (AWS)

Use CData, AWS, and Databricks to perform data engineering and data science on live SFTP .
Connect to and Query Printful in QlikView over ODBC

Create data visualizations with Printful in QlikView.
Automated Continuous SAP Ariba Procurement Replication to Apache Cassandra

Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to Apache Cassandra.
Import API into the Power BI Service for Visualizations

Use CData Connect AI to connect to API and provide access to live API for custom reports in the Power BI Service.
Create Confluence Reports on JasperReports Server

Deploy the CData JDBC Driver on JasperReports Server to provide real-time Confluence data access from reports, embedded analytics, and more.
Query Asana using the OData SDK for PHP

Use the API Server and the OData PHP SDK to easily consume Asana entities in PHP by modeling them as objects.
Create Informatica Mappings From/To a JDBC Data Source for Exact Online

Create Exact Online data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
Create Reports with Facebook in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date Facebook.
Work with NetSuite in FoxPro

Load NetSuite CRM & ERP into a FoxPro database. This article includes full code and a walk-through of the process.
Use Dash to Build to Web Apps on MariaDB

Create Python applications that use pandas and Dash to build MariaDB-connected web apps.
Integrate with live Microsoft Project in Jitterbit

Use CData Connect AI to connect to and integrate live Microsoft Project in Jitterbit.
LINQ to Microsoft Dataverse

LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Microsoft Dataverse Data Provider.
Connect to Microsoft Teams from Crystal Reports

Use CData Connect AI to connect to and report on live Microsoft Teams from Crystal Reports.
Connect to Adobe Analytics as an External Data Source using PolyBase

Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Adobe Analytics.
Access Live MariaDB in AWS Lambda (with IntelliJ IDEA)

Connect to live MariaDB in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
DataBind Typeform to the DevExpress Data Grid

Use the CData Software ADO.NET Provider for Typeform with the DevExpress Windows Forms and Web controls to provide Typeform to a chart.
PowerShell Scripting to Replicate Typeform to MySQL

Write a simple PowerShell script to replicate Typeform to a MySQL database.
Analyze Azure Active Directory in Looker

Use CData Connect AI to connect to Azure Active Directory from Looker and build custom apps using live Azure Active Directory.
Connect to Amazon S3 in Google Apps Script via SQL Gateway

Use the ODBC Driver for Amazon S3 and the SQL Gateway to access Amazon S3 from Google Apps Script.
DataBind Controls to JSON Services in Delphi

DataBind to JSON in Delphi with standard data access components and controls.
Connect to and Visualize Live GitHub in Tableau Prep

Use CData Tableau Connectors and Tableau Prep Builder to visualize live GitHub.
Build Charts with Salesforce in Clear Analytics

Create dynamic charts and perform analytics based on Salesforce & Force.com in Clear Analytics.
How to Connect to & Open Kintone in Microsoft Excel

This article uses the CData ODBC driver for Kintone to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
Connect to Redshift from a Connection Pool in Jetty

The Redshift JDBC Driver supports connection pooling: This article shows how to connect faster to Amazon Redshift from Web apps in Jetty.
Automated Continuous Zoho Creator Replication to MySQL

Use CData Sync for automated, continuous, customizable Zoho Creator replication to MySQL.
Integrate Zoho Inventory into Power Automate Desktop using CData Connect

CData Connect for Zoho Inventory enables you to integrate Zoho Inventory into workflows built using Microsoft Power Automate Desktop.
Access Live IBM Cloud Object Storage in Coginiti Pro

Connect to and query live IBM Cloud Object Storage from the GUI in the Coginiti Pro: SQL Analytics Tool.
Use the CData Software JDBC Driver for xBase in MicroStrategy

Connect to xBase in MicroStrategy Developer using the CData Software JDBC Driver for xBase.
Trigger Kafka IFTTT Flows in Azure App Service

This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.
Automated Continuous Act CRM Replication to OneLake in Microsoft Fabric

Use CData Sync for automated, continuous, customizable Act CRM replication to OneLake in Microsoft Fabric.
Use the CData Software JDBC Driver for QuickBooks in MicroStrategy

Connect to QuickBooks Desktop in MicroStrategy Developer using the CData Software JDBC Driver for QuickBooks.
Databind Charts to Salesforce Data

Use the standard ADO.NET procedures for databinding to provide bidirectional access to Salesforce data 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.
Getting Started with the CData PowerShell Cmdlets for Kintone