CData Software - Knowledge Base
Recent Articles
-
Connect to JobNimbus Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for JobNimbus.
-
How to create Visio diagrams from Google Spanner Data
Automatically update Google Spanner with the changes you make to Visio master shapes.
-
Load Bitbucket Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Bitbucket to a database.
-
Getting Started with the CData JDBC Driver for Google Sheets
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Google Sheets.
-
Analyze Live Zoom Data in SAS Viya
Use CData Connect AI to connect to Zoom from SAS Viya and deploy self-service analytics using live Zoom.
-
Connect to Supabase Data from PowerBuilder via JDBC
This article demonstrates how to access Supabase from PowerBuilder using the Supabase JDBC Driver.
-
Configure the CData JDBC Driver for Google Campaign Manager 360 in a Connection Pool in Tomcat
Connect to Google Campaign Manager 360 from a connection pool in Tomcat.
-
Connect to Google Directory Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Google Directory from Filemaker Pro on Mac.
-
Automated Continuous Salesforce Pardot Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Salesforce Pardot replication to PostgreSQL.
-
Use the CData Software JDBC Driver for IBM Cloud Object Storage in MicroStrategy Desktop
Connect to IBM Cloud Object Storage in MicroStrategy Desktop using the CData Software JDBC Driver for IBM Cloud Object Storage.
-
Connect to Greenhouse Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Greenhouse.
-
Query Stripe Data in ColdFusion
Write standard ColdFusion data access code to connect to Stripe.
-
Bridge Pipeliner CRM Connectivity with Apache NiFi
Access and process Pipeliner CRM in Apache NiFi using the CData JDBC Driver.
-
Access Live AgileCRM Data in AWS Lambda (with IntelliJ IDEA)
Connect to live AgileCRM in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Access Live Neo4J Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Neo4J from your Google Sheets.
-
Publish Reports with Google Tasks Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Tasks.
-
Analyze CouchDB Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Apache CouchDB and visualize live Apache CouchDB in Infragistics Reveal.
-
Build Data Flows from SAP Ariba Procurement to SQL Server using SSIS
Easily back up SAP Ariba Procurement to SQL Server using the SSIS components for SAP Ariba Procurement.
-
How to Connect DBeaver to Qualaroo via a JDBC Driver
Manage Qualaroo with visual tools in DBeaver like the query browser.
-
Moving Data from Avro to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Avro data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Analyze Elorus Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Elorus from Power Pivot. You will use the Table Import Wizard to load Elorus. You can visually build the import query or use any SQL supported by the driver.
-
Build Semantic Layer Views for OnePageCrm Data in APOS Live Data Gateway
Use the CData Connector for OnePageCrm in APOS Live Data Gateway to build Semantic Layer Views for OnePageCrm.
-
Edit and Search External Bullhorn CRM Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Bullhorn CRM to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Bullhorn CRM Data objects that you can access from apps and the dashboard.
-
Integrate Open WebUI with Live Zoho Projects Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Zoho Projects from within the chat interface.
-
Integrating Antigravity CLI with Oracle Sales via CData CLI
Connect Oracle Sales to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Natively Connect to Okta Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Okta. Leverage the native support for ODBC in PHP.
-
Connect to JobNimbus Data in Ruby
Connect to JobNimbus in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connecting Agentforce with Workday 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 Workday for you.
-
Bidirectional Access to Google Translate Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Google Translate in Filemaker Pro for Mac or Windows.
-
Feed Shippo Data into FineReport
How to set Shippo as a JDBC data source in FineReport.
-
Access Live IBM Informix Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to IBM Informix from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Import Oracle Sales Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Oracle Sales Data and provide access to live Oracle Sales for custom reports in the Power BI Service.
-
How to connect Amazon QuickSight to Greenplum Data
Create a connection to Pivotal GreenPlum in CData Connect AI and insert Pivotal GreenPlum into Amazon QuickSight SPICE to build interactive dashboards.
-
Edit and Search Oracle Sales External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Oracle Sales to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Oracle Sales objects that you can access from apps and the dashboard.
-
Connect to Tavily Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Automated Continuous eBay Analytics Replication to AlloyDB
Use CData Sync for automated, continuous, customizable eBay Analytics replication to AlloyDB.
-
Analyze Facebook Data in Looker
Use CData Connect AI to connect to Facebook Data from Looker and build custom apps using live Facebook.
-
Consume Epicor Kinetic OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Epicor Kinetic feeds that reflect any changes in SAP Lumira.
-
Automated Continuous Insightly Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Insightly replication to Amazon Redshift.
-
How to integrate Metabase with Excel Online Data
Use CData Connect AI to connect to live Microsoft Excel Online and create an interactive dashboard in Metabase from Microsoft Excel Online.
-
Getting Started with the CData ODBC Driver for CouchDB
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for CouchDB.
-
Choosing the Best Method to Connect Cloudflare to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Cloudflare from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Replicate Harvest Data in Heroku for Use in Salesforce Connect
Replicate Harvest to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SuiteCRM
Provide connectivity to SuiteCRM through an SAP BusinessObjects universe.
-
Consume Odoo OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Odoo feeds that reflect any changes in SAP Lumira.
-
Integrate with Ontraport Data in JReport Designer
Create charts and reports based on Ontraport in JReport Designer.
-
How to Connect DBeaver to Billsby via a JDBC Driver
Manage Billsby with visual tools in DBeaver like the query browser.
-
Access Live Snapchat Ads Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Snapchat Ads from your Excel spreadsheets.
-
Getting Started with the CData Power BI Connector for Anaplan
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Anaplan.
-
Stream QuickBooks Time Data into Apache Kafka Topics
Access and stream QuickBooks Time in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrating Kiro CLI with AlloyDB 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.
-
Analyze QuickBooks Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze QuickBooks Desktop in Microsoft R Open.
-
Access Live HubSpot Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate HubSpot into the statistical analysis tools available in SAS JMP. This article shows how to use HubSpot in the Graph Builder and Query Builder.
-
Connect to Yelp Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Yelp and work with Yelp in your FileMaker applications.
-
How to Query Live Dropbox Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Dropbox data in natural language using Python.
-
Build Agents in Relevance AI with Access to Live HubSpot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on HubSpot within intelligent agent workflows.
-
Build Charts with Google Drive Data in Clear Analytics
Create dynamic charts and perform analytics based on Google Drive in Clear Analytics.
-
Analyze SageHR Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SageHR in Microsoft R Open.
-
Connecting Pipedream with SAP SuccessFactors LMS 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 SAP SuccessFactors LMS data in real time.
-
Automated Continuous Adobe Target Replication to Vertica
Use CData Sync for automated, continuous, customizable Adobe Target replication to Vertica.
-
Automated Continuous Invoiced Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Invoiced replication to PostgreSQL.
-
How to create Visio diagrams from SendGrid Data
Automatically update SendGrid with the changes you make to Visio master shapes.
-
How to Connect to Live Azure Synapse Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Azure Synapse for you.
-
Build Oracle Eloqua-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Oracle Eloqua to explore live Oracle Eloqua Data in Gemini Code Assist to assist with building Oracle Eloqua-powered applications.
-
How to Build an ETL App for OneNote Data in Python with CData
Create ETL applications and real-time data pipelines for Microsoft OneNote in Python with petl.
-
Getting Started with the CData Power BI Connector for Shortcut
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Trigger Slack IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Slack with standard wizards in Logic Apps.
-
Process & Analyze Dynamics NAV Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Dynamics NAV Data.
-
Replicate ActiveCampaign Data in Heroku for Use in Salesforce Connect
Replicate ActiveCampaign to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
DataBind Mailgun Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Mailgun to a chart.
-
Connect to TigerGraph Data as an External Source in Dremio
Use the CData JDBC Driver to connect to TigerGraph as an External Source in Dremio.
-
Visualize Tavily Data in Tableau
The CData ODBC driver for Tavily enables you integrate Tavily into Tableau dashboards.
-
How to Query SAP Netweaver Gateway Data in MySQL Workbench
Execute MySQL queries against live SAP Netweaver Gateway from MySQL Workbench.
-
Access Live Yelp Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Yelp in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
View Reports on Real-Time SAP SuccessFactors Data in Power BI Report Server
Use the CData ODBC Driver for SAP SuccessFactors to visualize SAP SuccessFactors in Power BI Desktop and then publish them to Power BI Report Server.
-
Build Microsoft Ads-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Microsoft Ads to explore live Microsoft Ads Data in GitHub Copilot to assist with building Microsoft Ads-powered applications.
-
Automate Float Data Replication to SAP HANA
Use CData Sync to customize and automate Float replication to SAP HANA.
-
Bidirectional Access to AgileCRM Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate AgileCRM in Filemaker Pro for Mac or Windows.
-
Create Dashboards and Visualize Live Instagram Data in Geckoboard
Use CData Connect AI to connect to live Instagram and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to Connect to Live Cloudant 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 IBM Cloudant for you.
-
Build Semantic Layer Views for Freshdesk Data in APOS Live Data Gateway
Use the CData Connector for Freshdesk in APOS Live Data Gateway to build Semantic Layer Views for Freshdesk.
-
Create Informatica Mappings From/To a JDBC Data Source for Parallel
Create Parallel data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build iContact-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live iContact.
-
Connect to Coinbase Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Coinbase in the Denodo Virtual DataPort Administrator.
-
Build Cassandra-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Apache Cassandra and build web apps with connectivity to live Apache Cassandra.
-
Extract, Transform, and Load Nuclia Data in Informatica PowerCenter
Create a simple Workflow for Nuclia in Informatica PowerCenter.
-
Getting Started with the CData ADO.NET Provider for Wrike
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
How to Connect DBeaver to Egnyte via a JDBC Driver
Manage Egnyte with visual tools in DBeaver like the query browser.
-
Use the CData Software JDBC Driver for Klipfolio in MicroStrategy Desktop
Connect to Klipfolio in MicroStrategy Desktop using the CData Software JDBC Driver for Klipfolio.
-
Integrate Theia IDE with Live Google Contacts Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Integrating LangChain with Redis Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Redis within automated workflows.
-
Use the CData Software JDBC Driver for Greenplum in MicroStrategy Web
Connect to Pivotal GreenPlum in MicroStrategy Web using the CData Software JDBC Driver for Greenplum.
-
How to import ZohoInvoice Data into Apache Solr
Use the CData Software JDBC Driver for ZohoInvoice in Data Import Handler and create an automated import of ZohoInvoice to Apache Solr Enterprise Search platform.
-
Build Authorize.Net Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Authorize.Net and build visualizations in Tableau.
-
Easily Integrate Parallel Data in Lazarus Pascal IDE
Learn how to easily integrate live Parallel in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Analyze Marketo Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Marketo with the CData JDBC Driver for Marketo.
-
Moving Data from Pipeline CRM to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Pipeline CRM data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to Workable Data in RazorSQL
Connect to Workable from wizards and query Workable from the GUI in the RazorSQL database management tool.
-
Build Data Flows from Sybase to SQL Server using SSIS
Easily back up Sybase to SQL Server using the SSIS components for Sybase.
-
How to Easily Query Invoiced Data in OpenOffice Base
Connect to Invoiced data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.