CData Software - Knowledge Base
Recent Articles
-
Query Oracle Service Cloud Data as a SQL Server Database in Node.js
Execute SQL Server queries against Oracle Service Cloud data from Node.js.
-
Operational Reporting on Mocean Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Mocean data.
-
Create a Data Access Object for ChartMogul Data using JDBI
A brief overview of creating a SQL Object API for ChartMogul data 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 data 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 data from your Oracle system.
-
How to connect to Everhour Data with Squirrel SQL client
Connect to Everhour data 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 data.
-
How to Connect BenchmarkEmail 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 BenchmarkEmail data in real time using natural language.
-
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 data into TIBCO Spotfire.
-
Use the CData Software JDBC Driver for Facebook in MicroStrategy
Connect to Facebook data in MicroStrategy Developer using the CData Software JDBC Driver for Facebook.
-
Use JayDeBeApi to access CouchDB Data in Python
Use standard Python scripting and the development environment of your choice to access live CouchDB data.
-
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 data 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 data 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 data 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 data within automated workflows.
-
How to connect to Paylocity Data in DBVisualizer
Integrate Paylocity data 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 data in Microsoft R Open.
-
Connect to Procore Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Procore data 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 data.
-
Choosing the Best Method to Connect GitHub to SQL Server: 5 Options Explained
Discover multiple ways to connect and use GitHub data 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 data in Power Apps.
-
Integrate with live Airtable Data in Jitterbit
Use CData Connect AI to connect to and integrate live Airtable data 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 data.
-
Create Typeform-Connected Business Apps in AppSheet
Connect to Typeform Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Typeform data.
-
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 data as OData feeds from PowerBuilder using the API Server.
-
Integrating Boomi Agentstudio with Mailjet Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Mailjet data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
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 data 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 data 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 Cassandra data into Microsoft Power Query.
-
Integrate IBM Cloud Object Storage Data in the Pentaho Report Designer
Publish reports based on IBM Cloud Object Storage data in the Pentaho BI tool.
-
Configure the CData JDBC Driver for Postmark in a Connection Pool in Tomcat
Connect to Postmark data 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.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Close
Provide connectivity to Close data 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 Vault CRM data for you.
-
Validate Cloudant Data with QuerySurge
Access and validate Cloudant data 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 data 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 data into the Databricks platform and create visualization dashboards with real-time Google Analytics data.
-
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 data. 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 data from MicroStrategy.
-
Migrating data from Reckon Accounts Hosted to Google BigQuery using CData SSIS Components.
Easily push Reckon Accounts Hosted data to Google BigQuery using the CData SSIS Tasks for Reckon Accounts Hosted and Google BigQuery.
-
DataBind Controls to SingleStore Data in C++Builder
DataBind to SingleStore data in C++Builder with standard components and controls.
-
Connect to SAP Hybris C4C Data in Jaspersoft Studio
Execute SQL to remote SAP Hybris C4C data 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 data 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 Redshift data.
-
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).
-
Stream Microsoft Exchange Data into Apache Kafka Topics
Access and stream Microsoft Exchange data 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 Vault CRM data with visual tools in DBeaver like the query browser.
-
Integrate Live Parquet Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Parquet data to Blue Prism using the CData ODBC Driver for Parquet to create automated workflows for repetitive business tasks.
-
Build Charts with Mode Data in Clear Analytics
Create dynamic charts and perform analytics based on Mode data in Clear Analytics.
-
Connect to FormSite Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for FormSite and the SQL Gateway to access FormSite data from Google Apps Script.
-
Integrating LangGraph with SFTP Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on SFTP data within automated workflows.
-
DataBind Controls to Customer.io Data in C++Builder
DataBind to Customer.io data in C++Builder with standard components and controls.
-
Connect to GetResponse Data in Ruby
Connect to GetResponse data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Voice Agents in ElevenLabs with access to Live Quickbase Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Quickbase data.
-
Connect to Adobe Analytics Data from AWS Glue
Use CData Connect AI to gain access to live Adobe Analytics data from your AWS Glue jobs.
-
Replicate Multiple ZohoMarketingHub Accounts via the CData Sync CLI
Replicate multiple ZohoMarketingHub accounts to one or many databases.
-
Build Bright Data-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Bright Data data and build web apps with connectivity to live Bright Data data.
-
Integrate with Tally Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Tally data to a JSON file on disk.
-
Build Charts with Salesforce Pardot Data in Clear Analytics
Create dynamic charts and perform analytics based on Salesforce Pardot data in Clear Analytics.
-
Connect to Oracle Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Oracle Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Integrate Campaigner Data in the Pentaho Report Designer
Publish reports based on Campaigner data in the Pentaho BI tool.
-
Automated Continuous ZohoInvoice Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable ZohoInvoice data replication to OneLake in Microsoft Fabric.
-
Use JayDeBeApi to access TaxJar Data in Python
Use standard Python scripting and the development environment of your choice to access live TaxJar data.
-
Use the CData ODBC Driver for AgileCRM in Microsoft Power Query
You can use the CData AgileCRM ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import AgileCRM data into Microsoft Power Query.
-
Integrate Klipfolio Data into Power Automate Desktop using CData Connect
CData Connect for Klipfolio Data enables you to integrate Klipfolio data into workflows built using Microsoft Power Automate Desktop.
-
Connect to Dynamics 365 Business Central Data in DBArtisan
Use wizards in DBArtisan to configure Dynamics 365 Business Central data as a data source.
-
ETL FreshBooks in Oracle Data Integrator
This article shows how to transfer FreshBooks data into a data warehouse using Oracle Data Integrator.
-
Consume MariaDB OData Feeds in SAP Lumira
Use the API Server to create data visualizations on MariaDB feeds that reflect any changes in SAP Lumira.
-
Manage OData Services in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for OData.
-
Query Zoho Creator Data as a MySQL Database in Node.js
Execute MySQL queries against Zoho Creator data from Node.js.
-
Automated Continuous Kintone Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Kintone replication to PostgreSQL.
-
Integrate NASA Data in the Pentaho Report Designer
Publish reports based on NASA data in the Pentaho BI tool.
-
Build Pipelines with Live PayPal Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to PayPal from Google Cloud Data Fusion, enabling the integration of live PayPal data into the building and management of effective data pipelines.
-
Create Perplexity-Connected Dashboards in Grafana
Connect to Perplexity Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Perplexity data.
-
Visualize Close Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Close data.
-
Analyze SAP Business Warehouse Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SAP Business Warehouse from Power Pivot. You will use the Table Import Wizard to load SAP Business Warehouse data. You can visually build the import query or use any SQL supported by the driver.
-
Automated Continuous LightSpeedRetail Replication to Oracle
Use CData Sync for automated, continuous, customizable LightSpeedRetail replication to Oracle.
-
Interact with Live Elasticsearch Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Elasticsearch data.
-
How to connect Amazon QuickSight to Greenhouse Data
Create a connection to Greenhouse data in CData Connect AI and insert Greenhouse data into Amazon QuickSight SPICE to build interactive dashboards.
-
How to Work with Avaza Data in AWS Glue Jobs Using JDBC
Connect to Avaza from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Access Live ClickUp Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate ClickUp data into the statistical analysis tools available in SAS JMP. This article shows how to use ClickUp data in the Graph Builder and Query Builder.
-
A PostgreSQL Interface for ConvertKit Data (MySQL Remoting via JDBC)
Use the Remoting features of the ConvertKit JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Oracle SCM
Provide connectivity to Oracle SCM data through an SAP BusinessObjects universe.
-
Create Dynamic Vercel Grids Using the Infragistics XamDataGrid
Learn how you can connect Vercel to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Mouseflow Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Mouseflow to connect to Mouseflow data and execute queries in PowerBuilder.
-
Visualize Vault CRM Data in TIBCO Spotfire through ADO.NET
Integrate Vault CRM data into dashboards in TIBCO Spotfire.
-
How to Build an ETL App for Clockify Data in Python with CData
Create ETL applications and real-time data pipelines for Clockify data in Python with petl.
-
Build ConvertAPI-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to ConvertAPI data and build web apps with connectivity to live ConvertAPI data.
-
How to Connect SharePoint 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 SharePoint data in real time using natural language.
-
Analyze Live Workday Data in SAS Viya
Use CData Connect AI to connect to Workday data from SAS Viya and deploy self-service analytics using live Workday data.