CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Bitbucket Replication to Databricks
Use CData Sync for automated, continuous, customizable Bitbucket replication to Databricks.
-
Migrating data from Azure Table to Google BigQuery using CData SSIS Components.
Easily push Azure Table Storage to Google BigQuery using the CData SSIS Tasks for Azure Table and Google BigQuery.
-
Connect to Bright Data Data in RapidMiner
Integrate Bright Data with standard components and data source configuration wizards in RapidMiner Studio.
-
Create Dynamic Marketo Grids Using the Infragistics XamDataGrid
Learn how you can connect Marketo to Infragistics XamDataGrid to build dynamic grids.
-
How to Query Live Suadeo Data in Claude Desktop
Connect to and query live Suadeo Data in Claude Desktop using CData MCP Server.
-
Use Grok to Talk to Your DB2 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your IBM DB2 for you.
-
Integrate Live Oracle Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Oracle Database and integrate live Oracle Database into apps built in Microsoft Power Apps.
-
Build a PostgreSQL Interface for Insightly Data using the CData JDBC Driver
Use the Remoting features of the Insightly JDBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData Power BI Connector for ChargeOver
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Connect to Databricks Data from PowerBuilder via ADO.NET
This article demonstrates how to access Databricks from Appeon PowerBuilder using the CData ADO.NET Provider for Databricks.
-
Use the CData Software ODBC Driver for Wave Financial in MicroStrategy
Connect to Wave Financial in MicroStrategy Developer using the CData Software ODBC Driver for Wave Financial.
-
Integrating Cursor CLI with Hubstaff 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.
-
Create Informatica Mappings From/To a JDBC Data Source for JSON
Create JSON data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Use Azure AI Foundry to Talk to Your Vault CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Veeva Vault & Vault CRM for you.
-
Load ZohoInvoice Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load ZohoInvoice to a database.
-
How to Query Tickspot Data in MySQL Workbench
Execute MySQL queries against live Tickspot from MySQL Workbench.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Google Ad Manager to Power BI dashboards. Simply drag and drop Google Ad Manager into data visuals on the Power BI canvas.
-
Connect to IBM Informix Data in DBArtisan
Use wizards in DBArtisan to configure IBM Informix as a data source.
-
Visualize Live Apify Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Apify using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Easily Query Hubstaff Data in OpenOffice Base
Connect to Hubstaff data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Google Calendar Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Google Calendar facts in real time.
-
Build Apps with Live Zoho Projects in Adalo using CData Connect AI
Use CData Connect AI to integrate live Zoho Projects into the Adalo platform and build custom mobile and web applications with real-time Zoho Projects.
-
Extract, Transform, and Load Wistia Data in Informatica PowerCenter
Create a simple Workflow for Wistia in Informatica PowerCenter.
-
Automated Continuous Oracle Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Oracle replication to delimited files (CSV/TSV).
-
Integrate Xero Data in the Pentaho Report Designer
Publish reports based on Xero Accounting in the Pentaho BI tool.
-
Integrate with live Xero Data in Jitterbit
Use CData Connect AI to connect to and integrate live Xero Accounting in Jitterbit.
-
Provide OData Services of ShipStation Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for ShipStation by developing a WCF Service Application.
-
Connect to Oracle Data in ACL Analytics
Connect to Oracle Database via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Oracle Database.
-
Analyze FTP Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze FTP Servers in Microsoft R Open.
-
Create PayPal-Connected Nintex Workflows
Use CData Connect AI to connect to PayPal Data from Nintex Workflow Cloud and build custom workflows using live PayPal.
-
Connect to CapsuleCRM Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to Query Live Instagram Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Instagram data in natural language using Python.
-
Connect to Paymo Data in HULFT Integrate
Connect to Paymo as a JDBC data source in HULFT Integrate
-
Using the CData Software ODBC Driver for Google Forms in PyCharm
Connect to Google Forms as an ODBC data source in PyCharm using the CData Software ODBC Driver for Google Forms.
-
Use Claude to Talk to Your SingleStore Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your SingleStore for you.
-
Analyze Jodoo Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Jodoo from Power Pivot. You will use the Table Import Wizard to load Jodoo. You can visually build the import query or use any SQL supported by the driver.
-
Integrating Boomi Agentstudio with Vertica Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Vertica, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Use the CData Software ODBC Driver for SurveyMonkey in MicroStrategy
Connect to SurveyMonkey in MicroStrategy Developer using the CData Software ODBC Driver for SurveyMonkey.
-
Add Freshteam Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Freshteam with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to publish and share SendInBlue Data dashboards with Tableau Server
The CData ODBC driver for SendInBlue enables you integrate SendInBlue into Tableau dashboards.
-
Analyze HBase Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Apache HBase with the CData JDBC Driver for HBase.
-
Integrating Kiro CLI with Odoo 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.
-
Build Dashboards with Kintone Data in DBxtra
Create dynamic dashboards and perform analytics based on Kintone in DBxtra.
-
How to connect Amazon QuickSight to Excel Online Data
Create a connection to Microsoft Excel Online in CData Connect AI and insert Microsoft Excel Online into Amazon QuickSight SPICE to build interactive dashboards.
-
Visualize Azure Data Catalog Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Azure Data Catalog into TIBCO Spotfire.
-
Publish SparkPost-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live SparkPost.
-
Connect to Yelp from Asprova with CData Software ODBC Driver for Yelp
This article shows how to connect faster to Yelp data from Asprova.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Wave Financial
Provide connectivity to Wave Financial through an SAP BusinessObjects universe.
-
Build Dashboards with WooCommerce Data in DBxtra
Create dynamic dashboards and perform analytics based on WooCommerce in DBxtra.
-
Integrate Live Monday.com Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Monday.com and integrate live Monday.com into apps built in Microsoft Power Apps.
-
How to Build an ETL App for Jira Data in Python with CData Connect AI
Build ETL pipelines that read and write live Atlassian Jira in Python with petl and the CData Connect AI Python SDK.
-
Google Ads Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Google Ads through CData Connect AI using different applications and tools.
-
Integrating Jodoo Data in Talend Cloud Data Management Platform
Connect Jodoo Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Visualize Live Timely Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Timely.
-
Extend Google Sheets with Act CRM Data
Make calls to Act CRM from Google Apps Script via the API Server.
-
Model FHIR Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and FHIR, enabling the direct import of real-time FHIR.
-
Build Agents in Relevance AI with Access to Live Okta Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Okta within intelligent agent workflows.
-
Build a Singer.io Tap for Discourse With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Discourse data using
-
Extend Google Sheets with Azure DevOps Data
Make calls to Azure DevOps from Google Apps Script via the API Server.
-
Integrate with live Dynamics CRM Data in Jitterbit
Use CData Connect AI to connect to and integrate live Microsoft Dynamics CRM in Jitterbit.
-
Automated Continuous DocuSign Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable DocuSign replication to Azure SQL Database.
-
Automated Continuous Zoho Projects Replication to Databricks
Use CData Sync for automated, continuous, customizable Zoho Projects replication to Databricks.
-
A PostgreSQL Interface for SAP Netweaver Gateway Data (MySQL Remoting via JDBC)
Use the Remoting features of the SAP Netweaver Gateway JDBC Driver to create a PostgreSQL entry-point for data access.
-
Consume WordPress OData Feeds in SAP Lumira
Use the API Server to create data visualizations on WordPress feeds that reflect any changes in SAP Lumira.
-
Build Apps with Live Avaza Data Using the Low-Code Development Platform of Mendix
Connect Avaza with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to SAP Concur Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SAP Concur to connect to SAP Concur and execute queries in PowerBuilder.
-
How to connect and process GitLab from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live GitLab.
-
Automated Continuous QuickBooks Online Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable QuickBooks Online replication to Apache Kafka.
-
Access Dynamics 365 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 Microsoft Dynamics 365.
-
Connect to Shopify Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Excel Spreadsheet Automation on xBase Data with the QUERY Formula
Pull data from xBase, automate spreadsheets, and more with the QUERY formula.
-
DataBind Controls to xBase Data in Delphi
DataBind to xBase in Delphi with standard data access components and controls.
-
Connect to Lakebase Data from PowerBuilder via ADO.NET
This article demonstrates how to access Lakebase from Appeon PowerBuilder using the CData ADO.NET Provider for Lakebase.
-
Integrating OpenCode Terminal with Salesforce Pardot 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.
-
Create Informatica Mappings From/To a JDBC Data Source for ChartMogul
Create ChartMogul data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build SAP SuccessFactors-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SAP SuccessFactors.
-
Connect to ChartMogul Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Build Automated Workflows with Live Redshift Data in Workato
Use CData Connect AI to connect to live Amazon Redshift and build automated workflows in Workato.
-
Natively Connect to Hacker News Data in PHP
The CData ODBC driver for Hacker News enables you to create PHP applications with connectivity to Hacker News. Leverage the native support for ODBC in PHP.
-
Create SAP ByDesign-Connected Dashboards in Grafana
Connect to SAP ByDesign Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to SAP Business ByDesign.
-
ServiceNow Reporting in OBIEE with the ServiceNow JDBC Driver
Deploy the ServiceNow JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
A PostgreSQL Interface for Apollo Data using the CData ODBC Driver
Use the SQL Gateway and Apollo ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to integrate Metabase with Salesforce Data
Use CData Connect AI to connect to live Salesforce & Force.com and create an interactive dashboard in Metabase from Salesforce & Force.com.
-
Query RSS Feeds from Node.js
Use the OData endpoint of the CData API Server to connect to your RSS Feeds and perform CRUD operations on RSS from Node.js.
-
Automated Continuous SendInBlue Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SendInBlue replication to OneLake in Microsoft Fabric.
-
Import Spark Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Apache Spark SQL. In this article, you will use the OData format to import Apache Spark SQL into Microsoft Power Query.
-
Trigger Facebook Ads IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Facebook Ads with standard wizards in Logic Apps.
-
Build Voice Agents in ElevenLabs with access to Live Pipedrive Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Pipedrive.
-
How to Work with Demio Data in AWS Glue Jobs Using JDBC
Connect to Demio from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Salesforce Data 360 Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Salesforce Data 360 and the Script function in FileMaker Pro to connect to Salesforce Data 360 and work with Salesforce Data 360 in your FileMaker application.
-
Publish Crystal Reports on Facebook Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Facebook.
-
Create a Data Access Object for Exa Data using JDBI
A brief overview of creating a SQL Object API for Exa in JDBI.
-
How to Access Google Forms Data Using Entity Framework
This article shows how to access Google Forms using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Reckon Accounts Hosted Data in Google Apps Script via Connect AI
Use CData Connect AI to access Reckon Accounts Hosted in Google Apps Script.
-
How to Query Live Sage 300 Data in Claude Desktop
Connect to and query live Sage 300 Data in Claude Desktop using CData MCP Server.
-
Use the CData ODBC Driver for Shippo from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Shippo to connect to Shippo from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Shippo in Excel.
-
Integrate with Sybase IQ Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Sybase IQ to a JSON file on disk.
-
Object-Relational Mapping (ORM) with Cloudant 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 IBM Cloudant into a Java-based ORM framework, Hibernate.
-
Replicate Google Analytics Data in Heroku for Use in Salesforce Connect
Replicate Google Analytics to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Automate MarkLogic Data Replication to Azure Synapse
Use CData Sync to customize and automate MarkLogic replication to Azure Synapse.