CData Software - Knowledge Base
Recent Articles
-
Working with Close Data in LINQPad
Execute LINQ queries to Close in LINQPad.
-
Migrating data from Microsoft Dataverse to Databricks using CData SSIS Components.
Easily push Microsoft Dataverse (CDS) to Databricks using the CData SSIS Tasks for Microsoft Dataverse and Databricks.
-
How to connect to Salesforce Pardot Data from IntelliJ
Integrate connectivity to Salesforce Pardot with wizards in IntelliJ.
-
Integrating Cursor CLI with LaunchDarkly 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.
-
Consume Azure Data Lake Storage OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Azure Data Lake Storage feeds that reflect any changes in SAP Lumira.
-
Explore Geographical Relationships in Sendwithus Data with Power Map
Create data visualizations with Sendwithus in Power Map.
-
Edit and Search External Smartsheet Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Smartsheet to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Smartsheet Data objects that you can access from apps and the dashboard.
-
Migrating data from CapsuleCRM to Snowflake using CData SSIS Components.
Easily push CapsuleCRM to Snowflake using the CData SSIS Tasks for CapsuleCRM and Snowflake.
-
Integrate Live Klaviyo Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Klaviyo from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Klaviyo.
-
Build Data Flows from Tavily to SQL Server using SSIS
Easily back up Tavily to SQL Server using the SSIS components for Tavily.
-
Use Biml to Build SSIS Tasks to Replicate Oracle SCM Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Oracle SCM to SQL Server.
-
Use the CData Software JDBC Driver for PabblySubscriptions in MicroStrategy
Connect to PabblySubscriptions in MicroStrategy Developer using the CData Software JDBC Driver for PabblySubscriptions.
-
Configure the CData JDBC Driver for Cosmos DB in a Connection Pool in Tomcat
Connect to Azure Cosmos DB from a connection pool in Tomcat.
-
Query Live Google Analytics Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Google Analytics directly from the development environment.
-
Publish Reports with Parallel Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Parallel.
-
Visualize Live Exa Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Exa using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Getting Started with the CData SSIS Components for Teamwork
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Teamwork.
-
Integrating SAS xpt Data in Talend Cloud Data Management Platform
Connect SAS xpt Data with Talend Cloud Data Management Platform using the CData JDBC Driver for SAS xpt.
-
Connect to Printify Data from a Connection Pool in Jetty
The Printify JDBC Driver supports connection pooling: This article shows how to connect faster to Printify from Web apps in Jetty.
-
Build Visualizations of Monday.com Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Monday.com in Birst.
-
Import Real-Time Microsoft Dataverse Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Microsoft Dataverse (CDS) in ColdFusion.
-
Integrate Facebook Ads Data in Pentaho Data Integration
Build ETL pipelines based on Facebook Ads in the Pentaho Data Integration tool.
-
How to Connect to Live Oracle Sales Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Oracle Sales for you.
-
Integrating Claude Code with SAS Data Sets Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on SAS Data Sets within assisted coding and automated development workflows.
-
How to Import Data from Act-On into Google Sheets
Import Act-On into a Google spreadsheet that is automatically refreshed.
-
Establish a Live Connection with Shippo Data using Tableau Bridge
The CData ODBC Driver for Shippo enables you to integrate live Shippo into Tableau Cloud dashboards using the Tableau Bridge.
-
Visualize Blackbaud FE NXT Data in TIBCO Spotfire through OData
Integrate Blackbaud FE NXT into dashboards in TIBCO Spotfire.
-
Integrating Codex CLI with Microsoft Office 365 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 Lakebase Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Lakebase data access from reports, embedded analytics, and more.
-
Build Apps with Live CapsuleCRM Data Using the Low-Code Development Platform of Mendix
Connect CapsuleCRM with Mendix to build apps using the CData API Driver for JDBC.
-
Automated Continuous Stripe Replication to Oracle
Use CData Sync for automated, continuous, customizable Stripe replication to Oracle.
-
Use the CData Software ODBC Driver for Google Cloud Storage in MicroStrategy
Connect to Google Cloud Storage in MicroStrategy Developer using the CData Software ODBC Driver for Google Cloud Storage.
-
Perform Batch Operations with Dynamics NAV Data in Apache NiFi
Connect to Microsoft Dynamics NAV and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
How to connect SharePoint with SAP Fieldglass Data through external lists
Provide SAP Fieldglass to SharePoint users as an external list.
-
A PostgreSQL Interface for Facebook Data (MySQL Remoting via JDBC)
Use the Remoting features of the Facebook JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Work with Amplitude Data in AWS Glue Jobs Using JDBC
Connect to Amplitude from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Google Campaign Manager 360 Data from AWS Glue
Use CData Connect AI to gain access to live Google Campaign Manager 360 from your AWS Glue jobs.
-
Integrate with ScrapingBee Data in JReport Designer
Create charts and reports based on ScrapingBee in JReport Designer.
-
Query, Visualize, and Share live Epicor Kinetic Data in Redash
Use CData Connect AI to connect to live Epicor Kinetic in Redash for querying, visualizing, and sharing.
-
Visualize Cloudflare Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Cloudflare.
-
How to connect and process Dynamics 365 Business Central from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Dynamics 365 Business Central.
-
Query Oracle Service Cloud Data as a SQL Server Database in Node.js
Execute SQL Server queries against Oracle Service Cloud from Node.js.
-
Operational Reporting on Mocean Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Mocean.
-
Create a Data Access Object for ChartMogul Data using JDBI
A brief overview of creating a SQL Object API for ChartMogul in JDBI.
-
Connect to Oracle HCM Cloud Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Oracle HCM Cloud from Filemaker Pro on Mac.
-
Access Tally Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Tally ERP from your Oracle system.
-
How to connect to Everhour Data with Squirrel SQL client
Connect to Everhour and execute queries in the Squirrel SQL Client.
-
Analyze eBay Data in Cognos Analytics
Use CData Connect AI to connect to eBay Data from Cognos Analytics and analyze live eBay.
-
Visualize Teamgate 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 Teamgate into TIBCO Spotfire.
-
Use the CData Software JDBC Driver for Facebook in MicroStrategy
Connect to Facebook in MicroStrategy Developer using the CData Software JDBC Driver for Facebook.
-
Use the CData API Server to Access Blackbaud FE NXT Data in Microsoft PowerPivot
Use the CData API Server to connect to live Blackbaud FE NXT in the Power Pivot business intelligence tool.
-
Use JayDeBeApi to access CouchDB Data in Python
Use standard Python scripting and the development environment of your choice to access live Apache CouchDB.
-
Connecting Agentforce with Zendesk Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Zendesk for you.
-
A PostgreSQL Interface for Quaderno Data using the CData ODBC Driver
Use the SQL Gateway and Quaderno ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Google Campaign Manager 360 Data in Ruby
Connect to Google Campaign Manager 360 in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrate Live Mouseflow Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Mouseflow to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Build a PostgreSQL Interface for SparkPost Data using the CData JDBC Driver
Use the Remoting features of the SparkPost JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating LangGraph with Salesforce Pardot Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Salesforce Pardot within automated workflows.
-
How to connect to Paylocity Data in DBVisualizer
Integrate Paylocity with visual data analysis tools and data connection wizards in DBVisualizer
-
Analyze Cohere Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Cohere in Microsoft R Open.
-
Connect to Procore Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Procore in Airbyte.
-
Build Salesforce CRM Analytics-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Salesforce CRM Analytics Data from Zoho Analytics and import live Salesforce CRM Analytics.
-
Choosing the Best Method to Connect GitHub to SQL Server: 5 Options Explained
Discover multiple ways to connect and use GitHub from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Real-Time Yelp Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Yelp in Power Apps.
-
Integrate with live Airtable Data in Jitterbit
Use CData Connect AI to connect to and integrate live Airtable in Jitterbit.
-
Connect to QuickBooks Online Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for QuickBooks Online.
-
Moving Data from SAP Netweaver Gateway to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live SAP Netweaver Gateway data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Using the CData Software ODBC Driver for TaxJar in PyCharm
Connect to TaxJar as an ODBC data source in PyCharm using the CData Software ODBC Driver for TaxJar.
-
Manage Microsoft Entra ID Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Microsoft Entra ID.
-
Consume SAP Concur OData Feeds in PowerBuilder
This article demonstrates how to consume SAP Concur as OData feeds from PowerBuilder using the API Server.
-
Integrating LlamaIndex with Raisers Edge NXT Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Raisers Edge NXT in real time.
-
How to Connect PayPal Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live PayPal data in real time using natural language.
-
Automated Continuous Everhour Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Everhour replication to Amazon Redshift.
-
How to Access ZohoDesk Data Using Entity Framework
This article shows how to access ZohoDesk using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Use the CData ODBC Driver for Cassandra in Microsoft Power Query
You can use the CData Cassandra ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Apache Cassandra into Microsoft Power Query.
-
Integrate IBM Cloud Object Storage Data in the Pentaho Report Designer
Publish reports based on IBM Cloud Object Storage in the Pentaho BI tool.
-
Configure the CData JDBC Driver for Postmark in a Connection Pool in Tomcat
Connect to Postmark from a connection pool in Tomcat.
-
Moving Data from Salesforce to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Salesforce data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build Google Ads-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Google Ads to explore live Google Ads Data in Cursor to assist with building Google Ads-powered applications.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Close
Provide connectivity to Close through an SAP BusinessObjects universe.
-
Connecting Agentforce with Vault CRM Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Veeva Vault & Vault CRM for you.
-
Validate Cloudant Data with QuerySurge
Access and validate IBM Cloudant in QuerySurge using the CData JDBC Driver.
-
Automated Continuous LaunchDarkly Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable LaunchDarkly replication to Apache Cassandra.
-
Feed Microsoft Ads Data into FineReport
How to set Microsoft Ads as a JDBC data source in FineReport.
-
Connect and Visualize Live Google Analytics Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Google Analytics into the Databricks platform and create visualization dashboards with real-time Google Analytics.
-
Analyze Cloudflare Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Cloudflare from Power Pivot. You will use the Table Import Wizard to load Cloudflare. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Live Tally Data in MicroStrategy through CData Connect AI
Create a live connection to Tally Data in CData Connect AI and connect to your Tally ERP from MicroStrategy.
-
Migrating data from Reckon Accounts Hosted to Google BigQuery using CData SSIS Components.
Easily push Reckon Accounts Hosted to Google BigQuery using the CData SSIS Tasks for Reckon Accounts Hosted and Google BigQuery.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Microsoft Ads to Power BI dashboards. Simply drag and drop Microsoft Ads into data visuals on the Power BI canvas.
-
DataBind Controls to SingleStore Data in C++Builder
DataBind to SingleStore in C++Builder with standard components and controls.
-
Connect to SAP Hybris C4C Data in Jaspersoft Studio
Execute SQL to remote SAP Hybris C4C in Jaspersoft Studio.
-
Using the CData Software ODBC Driver for Recurly in PyCharm
Connect to Recurly as an ODBC data source in PyCharm using the CData Software ODBC Driver for Recurly.
-
Replicate Printful Data in Heroku for Use in Salesforce Connect
Replicate Printful to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Redshift Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Amazon Redshift.
-
Trigger YouTube Analytics IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for YouTube Analytics with standard wizards in Logic Apps.
-
Automated Continuous Avaza Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Avaza replication to delimited files (CSV/TSV).
-
Use the CData API Server to Access SAP Concur Data in Microsoft PowerPivot
Use the CData API Server to connect to live SAP Concur in the Power Pivot business intelligence tool.
-
Stream Microsoft Exchange Data into Apache Kafka Topics
Access and stream Microsoft Exchange in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Connect DBeaver to Vault CRM via a JDBC Driver
Manage Veeva Vault & Vault CRM with visual tools in DBeaver like the query browser.
-
Integrate Live Parquet Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Apache Parquet to Blue Prism using the CData ODBC Driver for Parquet to create automated workflows for repetitive business tasks.