CData Software - Knowledge Base
Recent Articles
-
Bidirectional Access to Spotify Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Spotify in Filemaker Pro for Mac or Windows.
-
How to create an RPA flow for PDFMonkey Data in UiPath Studio
Use the PDFMonkey ODBC Driver to create workflows that access real-time PDFMonkey without any coding.
-
DataBind Charts to WooCommerce Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to WooCommerce 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.
-
A PostgreSQL Interface for Productboard Data using the CData ODBC Driver
Use the SQL Gateway and Productboard ODBC Driver to create a PostgreSQL entry-point for data access.
-
Bind Live Sybase IQ Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Sybase IQ data
-
How to work with Freshsales Data in Apache Spark using SQL
Access and process Freshsales Data in Apache Spark using the CData Software JDBC Driver.
-
Automated Continuous OnePageCrm Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable OnePageCrm replication to Google BigQuery.
-
Integrating OpenCode Terminal with Clockify 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.
-
Work with Live SharePoint Data in Power Query
Use CData Connect AI to connect to Microsoft SharePoint and work with live Microsoft SharePoint in Microsoft Power Query.
-
Migrating data from Avro to Snowflake using CData SSIS Components.
Easily push Apache Avro to Snowflake using the CData SSIS Tasks for Avro and Snowflake.
-
Automate Hive Data Replication to Azure Synapse
Use CData Sync to customize and automate Apache Hive replication to Azure Synapse.
-
Working with Attio Data in LINQPad
Execute LINQ queries to Attio in LINQPad.
-
Process & Analyze Planio Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Planio Data.
-
Getting Started with the CData JDBC Driver for Scrapfly
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Scrapfly.
-
Create Oracle Sales-Connected Dashboards in Grafana
Connect to Oracle Sales Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Oracle Sales.
-
ETL Coda in Oracle Data Integrator
This article shows how to transfer Coda into a data warehouse using Oracle Data Integrator.
-
Use Grok to Talk to Your Sage Intacct 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 Sage Intacct for you.
-
Connect to eBay Analytics Data in Aqua Data Studio
Access eBay Analytics from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Create Data Visualizations Based On YouTube Analytics Data in Mode
Use CData Connect AI to connect to YouTube Analytics Data from Mode and build visualizations using live
-
Automated Continuous NetSuite SuiteAnalytics Replication to Amazon S3
Use CData Sync for automated, continuous, customizable NetSuite SuiteAnalytics replication to Amazon S3.
-
DataBind Zoho Projects Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Zoho Projects with the DevExpress Windows Forms and Web controls to provide Zoho Projects to a chart.
-
Visualize Access 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 Microsoft Access into TIBCO Spotfire.
-
Build Voice Agents in ElevenLabs with access to Live Facebook Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Facebook.
-
Use the CData ODBC Driver for Databricks from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Databricks to connect to Databricks from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Databricks in Excel.
-
How to Build an ETL App for CapsuleCRM Data in Python with CData
Create ETL applications and real-time data pipelines for CapsuleCRM in Python with petl.
-
Create Square-Connected Dashboards in Grafana
Connect to Square Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Square.
-
Connect to Oracle Service Cloud Data from a Connection Pool in Jetty
The Oracle Service Cloud JDBC Driver supports connection pooling: This article shows how to connect faster to Oracle Service Cloud from Web apps in Jetty.
-
How to integrate Metabase with SQL Server Data
Use CData Connect AI to connect to live Microsoft SQL Server and create an interactive dashboard in Metabase from Microsoft SQL Server.
-
Connect to BambooHR Data in Jaspersoft Studio
Execute SQL to remote BambooHR in Jaspersoft Studio.
-
Publish Crystal Reports on Aha! Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Aha!.
-
How to Connect to Live SAP Fieldglass Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your SAP Fieldglass for you.
-
Automated Continuous SurveyMonkey Replication to SQL Server
Use CData Sync for automated, continuous, customizable SurveyMonkey replication to SQL Server.
-
Connect Freshservice Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Freshservice using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Create Power BI Visual Reports with Real-Time HBase Data
Use CData Power BI Connectors to visualize Apache HBase in Power BI.
-
Automated Continuous MariaDB Replication to Amazon S3
Use CData Sync for automated, continuous, customizable MariaDB replication to Amazon S3.
-
Publish Zoom-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Zoom.
-
Connect to Salesforce Marketing Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Salesforce Marketing to connect to Salesforce Marketing Cloud and execute queries in PowerBuilder.
-
How to Access Live BigCommerce Data in Visual Studio Code via Cline
Run CData MCP Server for BigCommerce on Windows Subsytem for Linux (WSL) and connect to live BigCommerce from the Cline extension in Visual Studio Code.
-
Build AI Agents with Google Campaign Manager 360 Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Google Campaign Manager 360 through CData Connect AI.
-
Connect to LeadDesk Data from PowerBuilder via JDBC
This article demonstrates how to access LeadDesk from PowerBuilder using the LeadDesk JDBC Driver.
-
How to Build an ETL App for SpaceX Data in Python with CData
Create ETL applications and real-time data pipelines for SpaceX in Python with petl.
-
Build a PostgreSQL Interface for Twitter Ads Data using the CData JDBC Driver
Use the Remoting features of the Twitter Ads JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to Testmonitor Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Testmonitor. Leverage the pyodbc module for ODBC in Python.
-
Feed JotForm Data into FineReport
How to set JotForm as a JDBC data source in FineReport.
-
Automate Dotmailer Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Dotmailer from PowerShell? This article demonstrates how to utilize the Dotmailer Cmdlets for tasks like connecting to Dotmailer, automating operations, downloading data, and more.
-
Analyze PostgreSQL Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of PostgreSQL and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Build Visualizations of Shippo Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Shippo in Birst.
-
How to Easily Query Confluence Data in OpenOffice Base
Connect to Confluence data in OpenOffice Base using the CData ODBC Driver for Confluence and generate reports with live data insights.
-
Build a PostgreSQL Interface for Oracle Eloqua Data using the CData JDBC Driver
Use the Remoting features of the Oracle Eloqua JDBC Driver to create a PostgreSQL entry-point for data access.
-
Natively Connect to Databricks Data in PHP
The CData ODBC driver for Databricks enables you to create PHP applications with connectivity to Databricks. Leverage the native support for ODBC in PHP.
-
Getting Started with the CData Power BI Connector for Spotify
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Easily Integrate Azure Data Lake Storage Data in Lazarus Pascal IDE
Learn how to easily integrate live Azure Data Lake Storage in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Work with QuickBooks Data in ETL Validator JDBC
Connect to QuickBooks from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Box Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Box and the SQL Gateway to access Box from Google Apps Script.
-
Easily Integrate DocuSign Data in Lazarus Pascal IDE
Learn how to easily integrate live DocuSign in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Hive Data in RazorSQL
Connect to Hive from wizards and query Apache Hive from the GUI in the RazorSQL database management tool.
-
Build Dashboards with Oracle Eloqua Reporting Data in DBxtra
Create dynamic dashboards and perform analytics based on Oracle Eloqua Reporting in DBxtra.
-
Integrate with Google Campaign Manager 360 Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Google Campaign Manager 360 to a JSON file on disk.
-
Create Informatica Mappings From/To an ODBC Data Source for Microsoft Ads
Create an ODBC connection to Microsoft Ads in Informatica and browse and transfer Microsoft Ads.
-
Write a Simple Go Application to work with LDAP Objects on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to LDAP.
-
Query Facebook Ads Data as a SQL Server Database in Node.js
Execute SQL Server queries against Facebook Ads from Node.js.
-
Automated Continuous Greenhouse Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Greenhouse replication to Azure SQL Database.
-
Connect to ZohoSubscriptions Data from a Connection Pool in Jetty
The ZohoSubscriptions JDBC Driver supports connection pooling: This article shows how to connect faster to ZohoSubscriptions from Web apps in Jetty.
-
Integrate JobNimbus with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate JobNimbus with External Services.
-
Access Live Salesforce CRM Analytics Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Salesforce CRM Analytics into the statistical analysis tools available in SAS JMP. This article shows how to use Salesforce CRM Analytics in the Graph Builder and Query Builder.
-
How to Easily Query Microsoft Ads Data in OpenOffice Base
Connect to Microsoft Ads data in OpenOffice Base using the CData ODBC Driver for Microsoft Ads and generate reports with live data insights.
-
How to Use a Microsoft Access Database to Update Google Directory Data in Real Time
Update Google Directory data by creating a linked table in Microsoft Access with the CData Google Directory ODBC Driver.
-
Manage Eventbrite Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Eventbrite.
-
How to integrate Metabase with Splunk Data
Use CData Connect AI to connect to live Splunk and create an interactive dashboard in Metabase from Splunk.
-
Connecting Pipedream with MailChimp Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on MailChimp data in real time.
-
Analyze FreshBooks Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze FreshBooks in Microsoft R Open.
-
Deploy the ADO.NET Provider for ChargeOver on an SSRS Report Server
Connect to ChargeOver 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.
-
Establish a Live Connection with Cassandra Data using Tableau Bridge
The CData ODBC Driver for Cassandra enables you to integrate live Apache Cassandra into Tableau Cloud dashboards using the Tableau Bridge.
-
Create a Data Access Object for Adobe Experience Manager Data using JDBI
A brief overview of creating a SQL Object API for Adobe Experience Manager in JDBI.
-
Create a Data Access Object for SendPulse Data using JDBI
A brief overview of creating a SQL Object API for SendPulse in JDBI.
-
Establish a Live Connection with ActiveCampaign Data using Tableau Bridge
The CData ODBC Driver for ActiveCampaign enables you to integrate live ActiveCampaign into Tableau Cloud dashboards using the Tableau Bridge.
-
Explore Geographical Relationships in Freshteam Data with Power Map
Create data visualizations with Freshteam in Power Map.
-
Build Vertica-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Vertica Data from Zoho Analytics and import live Vertica.
-
Connect to Microsoft Ads Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Microsoft Ads Data and connect to Microsoft Ads in Akorbi Digital RunMyProcess.
-
Automated Continuous Avaza Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Avaza replication to Google BigQuery.
-
Automated Continuous HubSpot Replication to Snowflake
Use CData Sync for automated, continuous, customizable HubSpot replication to Snowflake.
-
How to connect to Dynamics NAV Data from Spring Boot
Connect to Dynamics NAV in a Spring Boot Application using the CData JDBC Driver for Dynamics NAV
-
Publish Reports with SpaceX Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SpaceX.
-
Replicate Multiple Facebook Ads Accounts
Replicate multiple Facebook Ads accounts to one or many databases.
-
Use JayDeBeApi to access Google Drive Data in Python
Use standard Python scripting and the development environment of your choice to access live Google Drive.
-
Replicate Avalara AvaTax Data to Multiple Databases via the CData Sync CLI
Replicate Avalara AvaTax to disparate databases with a single configuration.
-
Provide OData Services of Placid Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Placid by developing a WCF Service Application.
-
Connect MariaDB to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect MariaDB with IBM WebSphere for seamless data integration and connectivity.
-
Automate Zoho Books Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Zoho Books from PowerShell? This article demonstrates how to utilize the Zoho Books Cmdlets for tasks like connecting to Zoho Books, automating operations, downloading data, and more.
-
Query Flowlu Data as a MySQL Database in Node.js
Execute MySQL queries against Flowlu from Node.js.
-
Integrate Parallel with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Parallel with External Services.
-
Deploy the ADO.NET Provider for Cohere on an SSRS Report Server
Connect to Cohere 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.
-
Automated Continuous GitLab Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable GitLab replication to delimited files (CSV/TSV).
-
Perform Batch Operations with Google Drive Data in Apache NiFi
Connect to Google Drive and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Automated Continuous Zoho Inventory Replication to MongoDB
Use CData Sync for automated, continuous, customizable Zoho Inventory replication to MongoDB.
-
Build Data Flows from CapsuleCRM to SQL Server using SSIS
Easily back up CapsuleCRM to SQL Server using the SSIS components for CapsuleCRM.
-
Build Semantic Layer Views for ZarMoney Data in APOS Live Data Gateway
Use the CData Connector for ZarMoney in APOS Live Data Gateway to build Semantic Layer Views for ZarMoney.
-
A PostgreSQL Interface for CSV Data (MySQL Remoting via JDBC)
Use the Remoting features of the CSV JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect SAP Business Warehouse to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live SAP Business Warehouse using the CData Python MCP Server.
-
Getting Started with the CData Python Connector for Google Forms
Learn to install and license the CData Python Connector