CData Software - Knowledge Base
Recent Articles
-
Configure the CData JDBC Driver for Kintone in a Connection Pool in Tomcat
Connect to Kintone from a connection pool in Tomcat.
-
Connect to SAP Business One in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for SAP Business One and connect to SAP Business One in Akorbi Digital RunMyProcess.
-
How to create Visio diagrams from Acumatica
Automatically update Acumatica ERP with the changes you make to Visio master shapes.
-
Automated Continuous Raisers Edge NXT Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to IBM DB2.
-
Import Gmail Using Azure Data Factory
Use CData Connect AI to connect to Gmail from Azure Data Factory and import live Gmail.
-
Replicate Multiple Vertica Accounts via the CData Sync CLI
Replicate multiple Vertica accounts to one or many databases.
-
Connect to YouTube 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 YouTube Analytics.
-
How to load Oracle data into Elasticsearch via Logstash
Introducing a simple method to load Oracle data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use Microsoft Copilot Studio to talk to your OData Services via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your OData for you.
-
Access Live BigQuery in Coginiti Pro
Connect to and query live Google BigQuery from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Access FTP from MySQL in PHP
Connect to FTP through the standard MySQL libraries in PHP.
-
Build a PostgreSQL Interface for GitHub using the CData JDBC Driver
Use the Remoting features of the GitHub JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Visualizations of Blackbaud FE NXT in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Blackbaud FE NXT in Birst.
-
Query Twitter through ODBC in Node.js
Use node-odbc to execute SQL queries against Twitter from Node.js.
-
Provide OData Services of Sage Intacct from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Sage Intacct by developing a WCF Service Application.
-
Build Automated Azure Analysis Services-Connected Workflows in Zapier
Use CData Connect AI to connect to live Azure Analysis Services and build automated workflows in Zapier.
-
Load Quickbase to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Quickbase to a database.
-
DataBind Charts to Dynamics CRM
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Microsoft Dynamics CRM 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 Connect to Live Outreach.io from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Outreach.io for you.
-
Getting Started with the CData SSIS Components for OData
Complete guide to installing, licensing, and connecting with the CData SSIS Components for OData.
-
How to Build an ETL App for Bitbucket in Python with CData
Create ETL applications and real-time data pipelines for Bitbucket in Python with petl.
-
Create Datasets from SAP Business One in Domo Workbench and Build Visualizations of SAP Business One in Domo
Use the CData Software ODBC Driver for SAP Business One to create datasets from SAP Business One in Domo Workbench and then build visualizations in the Domo service.
-
Visualize Live SAP HANA in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SAP HANA.
-
How to connect to MongoDB from Spring Boot
Connect to MongoDB in a Spring Boot Application using CData JDBC MongoDB Driver
-
Extend Google Sheets with LinkedIn Ads
Make calls to the API Server from Google Apps Script.
-
Automated Continuous Marketo Replication to SingleStore
Use CData Sync for automated, continuous, customizable Marketo replication to SingleStore.
-
How to Query EnterpriseDB in MySQL Workbench
Execute MySQL queries against live EnterpriseDB from MySQL Workbench.
-
How to connect SharePoint with Dropbox through external lists
Provide Dropbox to SharePoint users as an external list.
-
Query BambooHR in DataGrip
Create a Data Source for BambooHR in DataGrip and use SQL to query live BambooHR.
-
Integrate Live SAP Hybris C4C into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to SAP Hybris C4C and integrate live SAP Hybris C4C into apps built in Microsoft Power Apps.
-
Create a Data Access Object for Amazon Marketplace using JDBI
A brief overview of creating a SQL Object API for Amazon Marketplace in JDBI.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Greenhouse
Provide connectivity to Greenhouse through an SAP BusinessObjects universe.
-
Getting Started with the CData JDBC Driver for SAP Business One
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SAP Business One.
-
How to Access Live Todoist in Power Automate Desktop via ODBC
The CData ODBC Driver for Todoist enables you to integrate Todoist into workflows built using Microsoft Power Automate Desktop.
-
Automate Zuora Replication to Azure Synapse
Use CData Sync to customize and automate Zuora replication to Azure Synapse.
-
How to Import Data from Microsoft Project into Google Sheets
Import Microsoft Project into a Google spreadsheet that is automatically refreshed.
-
Automate Google Ad Manager Replication to Azure Data Lake
Use CData Sync to customize and automate Google Ad Manager replication to Azure Data Lake.
-
How to Access Live Twitter Ads in Power Automate Desktop via ODBC
The CData ODBC Driver for Twitter Ads enables you to integrate Twitter Ads into workflows built using Microsoft Power Automate Desktop.
-
Connect to Sage Intacct in Aqua Data Studio
Access Sage Intacct from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Visualize Cvent in Sisense
Create an ElastiCube in Sisense app with access to Cvent.
-
Natively Connect to Printify in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Printify. Leverage the native support for ODBC in PHP.
-
Automated Continuous Asana Replication to Snowflake
Use CData Sync for automated, continuous, customizable Asana replication to Snowflake.
-
Creating FHIR-Connected Applications in Unqork
You can use CData Connect AI to feed FHIR to Unqork and build custom business apps.
-
How to integrate Metabase with Tableau CRM Analytics
Use CData Connect AI to connect to live Tableau CRM Analytics and create an interactive dashboard in Metabase from Tableau CRM Analytics.
-
Connect to Avalara AvaTax 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 Avalara AvaTax.
-
Integrate Live Workday into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Workday and integrate live Workday into apps built in Microsoft Power Apps.
-
Access Live MailChimp in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live MailChimp from your Excel spreadsheets.
-
LINQ to Salesforce Pardot
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 Salesforce Pardot Data Provider.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Zoho Books to Power BI dashboards. Simply drag and drop Zoho Books into data visuals on the Power BI canvas.
-
Create Data Visualizations Based On Marketo in Mode
Use CData Connect AI to connect to Marketo from Mode and build visualizations using live
-
Analyze Marketo in Cognos Analytics
Use CData Connect AI to connect to Marketo from Cognos Analytics and analyze live Marketo.
-
How to Access Google Spanner Using Entity Framework
This article shows how to access Google Spanner using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to Seamlessly Import Sage Cloud Accounting Data into IBM SPSS Modeler
Integrate Sage Cloud Accounting data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Getting Started with the CData Excel Add-In for QuickBooks Time
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for QuickBooks Time.
-
Replicate SuiteCRM to Multiple Databases
Replicate SuiteCRM to disparate databases with a point-and-click configuration.
-
Integrate with live SQL Server in Jitterbit
Use CData Connect AI to connect to and integrate live Microsoft SQL Server in Jitterbit.
-
Visualize Cvent in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Cvent into TIBCO Spotfire.
-
Create Dynamic SendGrid Grids Using the Infragistics XamDataGrid
Learn how you can connect SendGrid to Infragistics XamDataGrid to build dynamic grids.
-
Deploy the ADO.NET Provider for SAP Hybris C4C on an SSRS Report Server
Connect to SAP Hybris C4C from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
How to Connect to Live Facebook from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Facebook through natural language.
-
Visualize Calendly in TIBCO Spotfire through ADO.NET
Integrate Calendly into dashboards in TIBCO Spotfire.
-
Query Workday using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Workday entities in PHP by modeling them as objects.
-
Automate Hive Replication to Azure Synapse
Use CData Sync to customize and automate Apache Hive replication to Azure Synapse.
-
Viewing Freshdesk in RAD Studio Data Explorer
How to view Freshdesk in RAD Studio Data Explorer using the CData ODBC Driver for Freshdesk.
-
How to Access Live TaxJar in Visual Studio Code via Cline
Run the CData MCP Server for TaxJar on Windows Subsytem for Linux (WSL) and connect to live TaxJar from the Cline extension in Visual Studio Code.
-
Build Azure DevOps-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Azure DevOps and create custom apps in Bubble.
-
Integrate Bing Ads in Pentaho Data Integration
Build ETL pipelines based on Bing Ads in the Pentaho Data Integration tool.
-
Object-Relational Mapping (ORM) with OData Services 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 OData into a Java-based ORM framework, Hibernate.
-
Access Live IBM Cloud Object Storage Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live IBM Cloud Object Storage data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Automated Continuous Excel Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Excel replication to Amazon S3.
-
Prepare, Blend, and Analyze PostgreSQL in Alteryx Designer (ODBC)
Build workflows to access live PostgreSQL for self-service data analytics.
-
Automate Microsoft Dataverse Replication to SAP HANA
Use CData Sync to customize and automate Microsoft Dataverse (CDS) replication to SAP HANA.
-
Connect to SAP Netweaver Gateway from PowerBuilder via ADO.NET
This article demonstrates how to access SAP Netweaver Gateway from Appeon PowerBuilder using the CData ADO.NET Provider for SAP Netweaver Gateway.
-
Visualize Shippo in Tableau
The CData ODBC driver for Shippo enables you integrate Shippo into Tableau dashboards.
-
Access Live Zoom in AWS Lambda
Connect to live Zoom in AWS Lambda using the CData JDBC Driver.
-
Automated Continuous Salesforce Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Salesforce replication to Google BigQuery.
-
Visualize Live HCL Domino in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live HCL Domino.
-
Extract, Transform, and Load DB2 in Informatica PowerCenter
Create a simple Workflow for IBM DB2 in Informatica PowerCenter.
-
Connect and Visualize Live Instagram Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Instagram into the Databricks platform and create visualization dashboards with real-time Instagram.
-
Visualize Google Directory in TIBCO Spotfire through OData
Integrate Google Directory into dashboards in TIBCO Spotfire.
-
Analyze Live SAP HANA in SAS Viya
Use CData Connect AI to connect to SAP HANA from SAS Viya and deploy self-service analytics using live SAP HANA.
-
Visualize Jira in Tableau
The CData ODBC driver for Jira enables you integrate Atlassian Jira into Tableau dashboards.
-
Visualize Aha in TIBCO Spotfire through OData
Integrate Aha! into dashboards in TIBCO Spotfire.
-
Bridge Twitter Ads Connectivity with Apache NiFi
Access and process Twitter Ads in Apache NiFi using the CData JDBC Driver.
-
How to integrate Paylocity with Apache Airflow
Access and process Paylocity in Apache Airflow using the CData JDBC Driver.
-
Import Xero into the Power BI Service for Visualizations
Use CData Connect AI to connect to Xero and provide access to live Xero Accounting for custom reports in the Power BI Service.
-
Connect and Query Live Slack Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Slack into Databricks
-
Connecting GenSpark with Zoho Creator via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to enterprise data across 300+ systems without any replication or custom integration required.
-
Automated Continuous Dynamics CRM Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Dynamics CRM replication to Google BigQuery.
-
Connect to SAS Data Sets in Claris FileMaker Pro
-