CData Software - Knowledge Base
Recent Articles
-
Import Jumpseller Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Jumpseller. In this article, you will use the OData format to import Jumpseller into Microsoft Power Query.
-
Use the CData SSIS Components to Insert New or Update Existing Google Calendar Records from SQL Server
Easily push SQL Server data to Google Calendar using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Google Calendar or update existing records with data from a SQL Server database.
-
Build a PostgreSQL Interface for HelloSign Data using the CData JDBC Driver
Use the Remoting features of the HelloSign JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Google Translate Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Google Translate in the Denodo Virtual DataPort Administrator.
-
Integrating Antigravity CLI with Amazon S3 via CData CLI
Connect Amazon S3 to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Automate Onfleet Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Onfleet and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
How to Create Power BI Visual Reports with Real-Time ConvertKit Data
Use CData Power BI Connectors to visualize ConvertKit in Power BI.
-
Getting Started with the CData Power BI Connector for Sybase
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Sybase.
-
Create Informatica Mappings From/To a JDBC Data Source for Zuora
Create Zuora data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrate Samanage Data in the Pentaho Report Designer
Publish reports based on Samanage in the Pentaho BI tool.
-
Automate Dynamics CRM Data Replication to Azure Data Lake
Use CData Sync to customize and automate Microsoft Dynamics CRM replication to Azure Data Lake.
-
Build Pipelines with Live Greenplum Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Greenplum from Google Cloud Data Fusion, enabling the integration of live Pivotal GreenPlum into the building and management of effective data pipelines.
-
Integrate SAP ByDesign with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SAP ByDesign with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SAP Business ByDesign.
-
Connect to Twitter Ads Data in RazorSQL
Connect to Twitter Ads from wizards and query Twitter Ads from the GUI in the RazorSQL database management tool.
-
Deploy the ADO.NET Provider for Todoist on an SSRS Report Server
Connect to Todoist 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.
-
Access SharePoint Excel Services Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SharePoint Excel Services from your Oracle system.
-
Access Live ConstantContact Data in AWS Lambda (with IntelliJ IDEA)
Connect to live ConstantContact in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Use a Microsoft Access Database to Update DB2 Data in Real Time
Update DB2 data by creating a linked table in Microsoft Access with the CData DB2 ODBC Driver.
-
How to publish and share Elorus Data dashboards with Tableau Server
The CData ODBC driver for Elorus enables you integrate Elorus into Tableau dashboards.
-
How to import Klipfolio Data into Apache Solr
Use the CData Software JDBC Driver for Klipfolio in Data Import Handler and create an automated import of Klipfolio to Apache Solr Enterprise Search platform.
-
How to create an RPA flow for Paymo Data in UiPath Studio
Use the Paymo ODBC Driver to create workflows that access real-time Paymo without any coding.
-
Prepare, Blend, and Analyze Perplexity Data in Alteryx Designer (ODBC)
Build workflows to access live Perplexity for self-service data analytics.
-
View Reports on Real-Time Phoenix Data in Power BI Report Server
Use the CData ODBC Driver for Phoenix to visualize Apache Phoenix in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrate PayPal Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to PayPal and integrate live PayPal into your Power Automate tasks.
-
Connect to TaxJar Data in Aqua Data Studio
Access TaxJar from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrate with Mailjet Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Mailjet to a JSON file on disk.
-
Feed Demio Data into FineReport
How to set Demio as a JDBC data source in FineReport.
-
How to Work with BambooHR Data in ETL Validator JDBC
Connect to BambooHR from ETL Validator jobs using the CData Software JDBC Driver.
-
Replicate Multiple Sendwithus Accounts
Replicate multiple Sendwithus accounts to one or many databases.
-
Access Live Facebook Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Facebook into the statistical analysis tools available in SAS JMP. This article shows how to use Facebook in the Graph Builder and Query Builder.
-
How to Access Live HBase Data in Power Automate Desktop via ODBC
The CData ODBC Driver for HBase enables you to integrate Apache HBase into workflows built using Microsoft Power Automate Desktop.
-
Connect to PolarTeamPro Data from a Connection Pool in Jetty
The PolarTeamPro JDBC Driver supports connection pooling: This article shows how to connect faster to PolarTeamPro from Web apps in Jetty.
-
Automated Continuous Presto Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Presto replication to Amazon S3.
-
Access Live Couchbase Data in TIBCO Data Virtualization
Use the Couchbase Tibco DV Adapter to create a Couchbase data source in TIBCO Data Virtualization Studio and gain access to live Couchbase from your TDV Server.
-
Natively Connect to Access Data 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.
-
Connect to Mailjet Data in JRuby
Create a simple JRuby app with access to live Mailjet.
-
Access Hubstaff Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Hubstaff.
-
Connect to Auth0 in SpagoBI
Create reports featuring live Auth0 in SpagoBI Studio. Host Auth0 reports on SpagoBI Server.
-
Integrating Cursor CLI with Bitbucket Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Use Microsoft Copilot Studio to talk to your SAS Data Sets Data 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 SAS Data Sets for you.
-
Integrating LangChain with DocuSign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on DocuSign within automated workflows.
-
Use Biml to Build SSIS Tasks to Replicate Beeminder Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Beeminder to SQL Server.
-
Write a Simple Go Application to work with BigCommerce Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to BigCommerce.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for EnterpriseDB
Provide connectivity to EnterpriseDB through an SAP BusinessObjects universe.
-
Connect Zoho CRM Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Zoho CRM using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Xero Data in Google Apps Script via Connect AI
Use CData Connect AI to access Xero Accounting in Google Apps Script.
-
Establish a Live Connection with Miro Data using Tableau Bridge
The CData ODBC Driver for Miro enables you to integrate live Miro into Tableau Cloud dashboards using the Tableau Bridge.
-
Natively Connect to CampaignMonitor Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to CampaignMonitor. Leverage the native support for ODBC in PHP.
-
How to create Oracle Financials Cloud federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Oracle Financials Cloud in MySQL .
-
Migrating data from Mailjet to Databricks using CData SSIS Components.
Easily push Mailjet to Databricks using the CData SSIS Tasks for Mailjet and Databricks.
-
Build a Simple VCL Application for Smartsheet Data
How to build a simple VCL Application to view Smartsheet in RAD Studio using the CData ODBC Driver for Smartsheet.
-
Object-Relational Mapping (ORM) with Beeminder Data 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 Beeminder into a Java-based ORM framework, Hibernate.
-
Connect to ZohoDesk Data from PowerBuilder via JDBC
This article demonstrates how to access ZohoDesk from PowerBuilder using the ZohoDesk JDBC Driver.
-
Build a Singer.io Tap for Office 365 With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Office 365 data using
-
Connect to and Query Smartsheet Data in QlikView over ODBC
Create data visualizations with Smartsheet in QlikView.
-
Connect and Query Live Oracle Sales Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Oracle Sales into Databricks
-
View Reports on Real-Time Klipfolio Data in Power BI Report Server
Use the CData ODBC Driver for Klipfolio to visualize Klipfolio in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Jira Assets Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Jira Assets.
-
Replicate Multiple Oracle HCM Cloud Accounts via the CData Sync CLI
Replicate multiple Oracle HCM Cloud accounts to one or many databases.
-
LINQ to Cohere Data
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 Cohere Data Provider.
-
Connect to Timely Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Timely as an External Source in Dremio.
-
Integrating LangGraph with Twitter Ads Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Twitter Ads within automated workflows.
-
Viewing HubSpot Data in RAD Studio Data Explorer
How to view HubSpot in RAD Studio Data Explorer using the CData ODBC Driver for HubSpot.
-
Work with Salesforce CRM Analytics Data in FoxPro
Load Salesforce CRM Analytics into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Build an ETL App for SAP Business Warehouse Data in Python with CData
Create ETL applications and real-time data pipelines for SAP Business Warehouse in Python with petl.
-
Analyze ZohoExpense Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze ZohoExpense with the CData JDBC Driver for ZohoExpense.
-
DataBind Attio Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Attio to a chart.
-
Moving Data from Microsoft Planner to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Microsoft Planner data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automated Continuous Datadog Replication to MongoDB
Use CData Sync for automated, continuous, customizable Datadog replication to MongoDB.
-
How to Connect to SAP ByDesign Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SAP Business ByDesign. Leverage the pyodbc module for ODBC in Python.
-
How to Import Data from Flowlu into Google Sheets
Import Flowlu into a Google spreadsheet that is automatically refreshed.
-
Visualize LightSpeedRetail Data in Sisense
Create an ElastiCube in Sisense app with access to LightSpeedRetail.
-
How to Query Invoiced Data in MySQL Workbench
Execute MySQL queries against live Invoiced from MySQL Workbench.
-
Getting Started with the CData JDBC Driver for Adobe Analytics
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Adobe Analytics.
-
Working with Egnyte Data in LINQPad
Execute LINQ queries to Egnyte in LINQPad.
-
Use the CData Software JDBC Driver for SAP SuccessFactors LMS in MicroStrategy
Connect to SAP SuccessFactors LMS in MicroStrategy Developer using the CData Software JDBC Driver for SAP SuccessFactors LMS.
-
Publish Wrike-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Wrike.
-
How to Connect to Salesforce Pardot Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Salesforce Pardot. Leverage the pyodbc module for ODBC in Python.
-
Getting Started with the CData ADO.NET Provider for Cassandra
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Apache Cassandra.
-
Integrate Opsgenie with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Opsgenie with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Opsgenie.
-
How to connect to Workday Data from IntelliJ
Integrate connectivity to Workday with wizards in IntelliJ.
-
Connect to and Visualize Live Mouseflow Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Mouseflow.
-
Automated Continuous Microsoft Dataverse Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Microsoft Dataverse replication to Apache Kafka.
-
Connect to Avro Data from a Connection Pool in JBoss
Integrate Apache Avro into Java servlets: Use the Management Console in JBoss to install the Avro JDBC Driver.
-
Automated Continuous Google Forms Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Google Forms replication to IBM DB2.
-
Build a PostgreSQL Interface for Aircall Data using the CData JDBC Driver
Use the Remoting features of the Aircall JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Salesforce Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Salesforce replication to IBM DB2.
-
Integrate Cline with Live ADP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live ADP from within your IDE.
-
Integrating Antigravity CLI with Vimeo via CData CLI
Connect Vimeo to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Getting Started with the CData ODBC Driver for FHIR
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for FHIR.
-
Access Live Vimeo Data in AWS Lambda
Connect to live Vimeo in AWS Lambda using the CData JDBC Driver.
-
Provide OData Services of Tavily Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Tavily by developing a WCF Service Application.
-
Create Reports from Facebook Data in Looker Studio
Use CData Connect AI to gain access to live Facebook and create custom reports in Looker Studio.
-
Connect Humanity Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Humanity using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Salesforce Marketing Data from a Connection Pool in JBoss
Integrate Salesforce Marketing Cloud into Java servlets: Use the Management Console in JBoss to install the Salesforce Marketing JDBC Driver.
-
Build Voice Agents in ElevenLabs with access to Live Salesforce Pardot Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Salesforce Pardot.
-
Connecting Moonlit Workflow with DB2 Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your IBM DB2 in real time.
-
Build a Singer.io Tap for JobNimbus With the CData Python Connector
Learn how to easily build a Singer.io Tap for live JobNimbus data using
-
Rapidly Develop JSON-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by JSON.
-
Integrating Codex CLI with Landbot via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.