CData Software - Knowledge Base
Recent Articles
-
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.
-
Automated Continuous Microsoft Ads Replication to SQLite
Use CData Sync for automated, continuous, customizable Microsoft Ads replication to SQLite.
-
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
-
Connect to Paymo Data in HULFT Integrate
Connect to Paymo as a JDBC data source in HULFT Integrate
-
Connect to ElevenLabs Data in Ruby
Connect to ElevenLabs in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
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.
-
Visualize Live Beeminder Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Beeminder.
-
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.
-
Connect to SuiteCRM Data in CloverDX (formerly CloverETL)
Transfer SuiteCRM using the visual workflow in the CloverDX data integration tool.
-
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.
-
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.
-
How to connect to Gumroad Data from IntelliJ
Integrate connectivity to Gumroad with wizards in IntelliJ.
-
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.
-
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.
-
Visualize Hacker News Data in Tableau
The CData ODBC driver for Hacker News enables you integrate Hacker News into Tableau dashboards.
-
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.
-
Working with Aircall Data in LINQPad
Execute LINQ queries to Aircall in LINQPad.
-
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.
-
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.
-
Access SurveyMonkey Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SurveyMonkey from your Oracle system.
-
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.
-
Automated Continuous TaxJar Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable TaxJar replication to delimited files (CSV/TSV).
-
Access Lakebase Data from MySQL in Amazon QuickSight
Connect to Lakebase and build visualizations of Lakebase using a MySQL Connection in Amazon QuickSight.
-
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.
-
Access Live Clari Data in AWS Lambda
Connect to live Clari in AWS Lambda using the CData JDBC Driver.
-
Rapidly Develop Avalara AvaTax-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Avalara AvaTax.
-
Access Live Zoho Inventory Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Zoho Inventory data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Create Google Spanner-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Google Spanner Data from OutSystems and build custom enterprise apps using live Google Spanner.
-
Connecting Agentforce with Oracle Service Cloud 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 Oracle Service Cloud for you.
-
Validate Webflow Data with QuerySurge
Access and validate Webflow in QuerySurge using the CData JDBC Driver.
-
Build Dashboards with Delighted Data in Dundas BI
Create dynamic dashboards and perform analytics based on Delighted in Dundas BI.
-
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.
-
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.
-
Create Google Contacts Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Google Contacts from PowerBI.com to create Power BI Dataflows with real-time data.
-
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.
-
Automate ConstantContact Data Replication to Azure Data Lake
Use CData Sync to customize and automate ConstantContact replication to Azure Data Lake.
-
ServiceNow Reporting in OBIEE with the ServiceNow JDBC Driver
Deploy the ServiceNow JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Feed Pipedrive Data into FineReport
How to set Pipedrive as a JDBC data source in FineReport.
-
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.
-
Connect to Dynamics CRM Data in Jaspersoft Studio
Execute SQL to remote Microsoft Dynamics CRM in Jaspersoft Studio.
-
Integrate Pipeline CRM with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Pipeline CRM with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Pipeline CRM.
-
Connect to SAP Concur Data in NetBeans
Connect to SAP Concur in NetBeans with the data source configuration wizard.
-
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.
-
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.
-
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 Cloud and the Script function in FileMaker Pro to connect to Salesforce Data 360 and work with Salesforce Data 360 in your FileMaker application.
-
Create a Data Access Object for Exa Data using JDBI
A brief overview of creating a SQL Object API for Exa in JDBI.
-
Migrating data from Act-On to Snowflake using CData SSIS Components.
Easily push Act-On to Snowflake using the CData SSIS Tasks for Act-On and Snowflake.
-
Build Odoo-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Odoo to explore live Odoo Data in GitHub Copilot to assist with building Odoo-powered applications.
-
How to Connect DBeaver to FreshBooks via a JDBC Driver
Manage FreshBooks with visual tools in DBeaver like the query browser.
-
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.
-
Automated Continuous Blackbaud FE NXT Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Blackbaud FE NXT replication to Google Cloud SQL.
-
Integrate with Hubstaff Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Hubstaff to a JSON file on disk.
-
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.
-
How to Connect to Live Sybase 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 Sybase for you.
-
Build Dashboards with Bannerbear Data in DBxtra
Create dynamic dashboards and perform analytics based on Bannerbear in DBxtra.
-
Connecting Mastra with SAP SuccessFactors Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time SAP SuccessFactors, no replication required.
-
Build Figshare-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData API Driver for MCP Server to explore live Figshare Data in Gemini Code Assist to assist with building Figshare-powered applications.
-
Automate MarkLogic Data Replication to Azure Synapse
Use CData Sync to customize and automate MarkLogic replication to Azure Synapse.
-
Analyze Zuora Data in Looker
Use CData Connect AI to connect to Zuora Data from Looker and build custom apps using live Zuora.
-
Getting Started with the CData SSIS Components for Everhour
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Everhour.
-
Build an OLAP Cube in SSAS from Power BI XMLA Data
Establish a connection to Power BI XMLA data from SQL Server Analysis Services, and use the Power BI XMLA Data Provider to build OLAP cubes for use in analytics and reporting.
-
Extract, Transform, and Load Greenplum Data in Informatica PowerCenter
Create a simple Workflow for Pivotal GreenPlum in Informatica PowerCenter.
-
Build Visualizations of Avro Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Apache Avro in Birst.
-
Access Onfleet Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Onfleet from your Oracle system.
-
Migrating data from OData to Google BigQuery using CData SSIS Components.
Easily push OData to Google BigQuery using the CData SSIS Tasks for OData and Google BigQuery.
-
Getting Started with the CData Tableau Connector for AfterShip
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Integrating Kiro CLI with TigerGraph 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.
-
Edit and Search Vimeo External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Vimeo to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Vimeo objects that you can access from apps and the dashboard.
-
Automated Continuous Delighted Replication to Oracle
Use CData Sync for automated, continuous, customizable Delighted replication to Oracle.
-
Process & Analyze eBay Analytics Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live eBay Analytics Data.
-
Create Elasticsearch-Connected Nintex Workflows
Use CData Connect AI to connect to Elasticsearch Data from Nintex Workflow Cloud and build custom workflows using live Elasticsearch.
-
Replicate Multiple CapsuleCRM Accounts via the CData Sync CLI
Replicate multiple CapsuleCRM accounts to one or many databases.
-
Automated Continuous Zendesk Replication to Snowflake
Use CData Sync for automated, continuous, customizable Zendesk replication to Snowflake.
-
Create Dynamic Google Sheets Grids Using the Infragistics XamDataGrid
Learn how you can connect Google Sheets to Infragistics XamDataGrid to build dynamic grids.
-
Create Informatica Mappings From/To an ODBC Data Source for Superchat
Create an ODBC connection to Superchat in Informatica and browse and transfer Superchat.
-
Use Databricks Agent Bricks to Talk to Your Google Spanner Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Google Spanner for you.
-
Connect to Live Impala Data in MicroStrategy through CData Connect AI
Create a live connection to Impala Data in CData Connect AI and connect to your Apache Impala from MicroStrategy.
-
Integrating Dataiku with SAP Fieldglass Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live SAP Fieldglass.
-
How to Visualize LaunchDarkly Data in Python with pandas
Use pandas and other modules to analyze and visualize live LaunchDarkly in Python.
-
Build Data Flows from Access to SQL Server using SSIS
Easily back up Microsoft Access to SQL Server using the SSIS components for Access.
-
Connect to Salesforce Marketing Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Salesforce Marketing Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Create Oracle Service Cloud-Connected Dashboards in Grafana
Connect to Oracle Service Cloud Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Oracle Service Cloud.
-
Explore Geographical Relationships in Zoho CRM Data with Power Map
Create data visualizations with Zoho CRM in Power Map.
-
Automated Continuous Freshteam Replication to Vertica
Use CData Sync for automated, continuous, customizable Freshteam replication to Vertica.
-
How to use SQLAlchemy ORM to access Amazon Marketplace Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Amazon Marketplace.
-
Access Live GitHub Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live GitHub from your Excel spreadsheets.