CData Software - Knowledge Base
Recent Articles
-
Connect to ChargeOver Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for ChargeOver.
-
Use Dash to Build Web Apps on Microsoft Ads Data via CData Connect AI
Build interactive Dash web apps on live Microsoft Ads using pandas and the CData Connect AI Python SDK.
-
Query Oracle HCM Cloud Data as a MySQL Database in Node.js
Execute MySQL queries against Oracle HCM Cloud from Node.js.
-
Create Billsby Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Billsby from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Spark Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Viewing Tickspot Data in RAD Studio Data Explorer
How to view Tickspot in RAD Studio Data Explorer using the CData ODBC Driver for Tickspot.
-
Connect to ClickTime Data in NetBeans
Connect to ClickTime in NetBeans with the data source configuration wizard.
-
Create Reports with ZendeskSell Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ZendeskSell.
-
Access Live Sage 200 Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Sage 200 through MCP integration.
-
Publish Salesforce Pardot-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Salesforce Pardot.
-
Connect to Pushbullet Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Pushbullet to connect to Pushbullet and execute queries in PowerBuilder.
-
A PostgreSQL Interface for CapsuleCRM Data using the CData ODBC Driver
Use the SQL Gateway and CapsuleCRM ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to ZohoInvoice Data in DBeaver
Use the CData ODBC Driver to connect to ZohoInvoice in DBeaver.
-
Migrating data from Avaza to Databricks using CData SSIS Components.
Easily push Avaza to Databricks using the CData SSIS Tasks for Avaza and Databricks.
-
Connect to Microsoft Ads Data in Ruby
Connect to Microsoft Ads in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Access Live Pingdom Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Pingdom in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to import PolarTeamPro Data into Apache Solr
Use the CData Software JDBC Driver for PolarTeamPro in Data Import Handler and create an automated import of PolarTeamPro to Apache Solr Enterprise Search platform.
-
Configure the CData JDBC Driver for Egnyte in a Connection Pool in Tomcat
Connect to Egnyte from a connection pool in Tomcat.
-
Build an OLAP Cube in SSAS from Deel Data
Establish a connection to Deel data from SQL Server Analysis Services, and use the Deel Data Provider to build OLAP cubes for use in analytics and reporting.
-
Build SingleStore-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for SingleStore to explore live SingleStore Data in Gemini Code Assist to assist with building SingleStore-powered applications.
-
Automated Continuous Vault CRM Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Vault CRM replication to Google Cloud SQL.
-
Import Real-Time Clio Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Clio in ColdFusion.
-
Use Microsoft Copilot Studio to talk to your Salesforce Marketing Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Salesforce Marketing Cloud for you.
-
Integrate LibreChat with Live Redshift Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Amazon Redshift from within the chat interface.
-
Establish a Live Connection with Mailjet Data using Tableau Bridge
The CData ODBC Driver for Mailjet enables you to integrate live Mailjet into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrating HelloSign Data in Talend Cloud Data Management Platform
Connect HelloSign Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Import Real-Time Marketo Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Marketo in ColdFusion.
-
DataBind Controls to Delighted Data in Delphi
DataBind to Delighted in Delphi with standard data access components and controls.
-
Provide OData Services of Couchbase Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Couchbase by developing a WCF Service Application.
-
Connect to Jumpseller Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Jumpseller in the Denodo Virtual DataPort Administrator.
-
Excel Spreadsheet Automation on Missive Data with the QUERY Formula
Pull data from Missive, automate spreadsheets, and more with the QUERY formula.
-
Use the CData Software ODBC Driver for Google Analytics in SAS for Real-Time Reporting and Analytics
Connect to real-time Google Analytics in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Google Analytics.
-
Natively Connect to ActiveCampaign Data in PHP
The CData ODBC driver for ActiveCampaign enables you to create PHP applications with connectivity to ActiveCampaign. Leverage the native support for ODBC in PHP.
-
Replicate Cosmos DB Data in Heroku for Use in Salesforce Connect
Replicate Azure Cosmos DB to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Moving Data from Short.io to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Short.io data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
A PostgreSQL Interface for Raisers Edge NXT Data using the CData ODBC Driver
Use the SQL Gateway and Raisers Edge NXT ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to QuickBooks Time Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for QuickBooks Time.
-
Access Live JSON Services in Excel 365 Online (Excel for the web)
Connect to JSON from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Build Agents in Relevance AI with Access to Live Twitter Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Twitter Ads within intelligent agent workflows.
-
Connect to Scrapfly Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Scrapfly and work with Scrapfly in your FileMaker application.
-
Sentry Reporting in OBIEE with the Sentry JDBC Driver
Deploy the Sentry JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrate with Odoo Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Odoo ERP in SnapLogic.
-
Configure the CData JDBC Driver for Hive in a Connection Pool in Tomcat
Connect to Apache Hive from a connection pool in Tomcat.
-
Connect to Teradata from Asprova with CData Software ODBC Driver for Teradata
This article shows how to connect faster to Teradata data from Asprova.
-
Analyze API Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of API and visualize API in SAP Analytics Cloud.
-
Connect to Phoenix Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Apache Phoenix.
-
Import and Visualize ScrapingBee Data in Power View
Create data visualizations based on ScrapingBee in Excel.
-
Analyze Freshsales Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Freshsales with the CData JDBC Driver for Freshsales.
-
Provide OData Services of ZendeskSell Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for ZendeskSell by developing a WCF Service Application.
-
Build Dashboards with OpenWeatherMap Data in DBxtra
Create dynamic dashboards and perform analytics based on OpenWeatherMap in DBxtra.
-
Using the CData Software ODBC Driver for Freshservice in PyCharm
Connect to Freshservice as an ODBC data source in PyCharm using the CData Software ODBC Driver for Freshservice.
-
Access Azure Data Catalog Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Azure Data Catalog.
-
Integrate PivotalTracker with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate PivotalTracker with External Services.
-
How to Use a Microsoft Access Database to Update Salesforce Marketing Data in Real Time
Update Salesforce Marketing data by creating a linked table in Microsoft Access with the CData Salesforce Marketing ODBC Driver.
-
Connect to WooCommerce Data in ACL Analytics
Connect to WooCommerce via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to WooCommerce.
-
Automated Continuous HCL Domino Replication to Amazon S3
Use CData Sync for automated, continuous, customizable HCL Domino replication to Amazon S3.
-
Automate Bitbucket Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Bitbucket and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Integrating Codex CLI with SharePoint Excel Services 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.
-
Integrate JotForm Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live JotForm from Informatica Cloud.
-
Build MVC Applications with Connectivity to Paymo Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Paymo from an ASP.NET MVC application.
-
Integrate Live REST Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live REST to Blue Prism using the CData ODBC Driver for REST to create automated workflows for repetitive business tasks.
-
Enable the Tanda JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Tanda.
-
Analyze Redis Data in Cognos Analytics
Use CData Connect AI to connect to Redis Data from Cognos Analytics and analyze live Redis.
-
How to use SQLAlchemy ORM to access Confluence Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Atlassian Confluence.
-
Connect to Power BI XMLA Data in NetBeans
Connect to Power BI XMLA in NetBeans with the data source configuration wizard.
-
Connect to HBase Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for HBase to connect to Apache HBase and execute queries in PowerBuilder.
-
How to Seamlessly Import Google Directory Data into IBM SPSS Modeler
Integrate Google Directory data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Voice Agents in ElevenLabs with access to Live HBase Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Apache HBase.
-
Use the CData Software JDBC Driver for REST in MicroStrategy Desktop
Connect to REST in MicroStrategy Desktop using the CData Software JDBC Driver for REST.
-
How to connect to LeadDesk Data with Squirrel SQL client
Connect to LeadDesk and execute queries in the Squirrel SQL Client.
-
Load ShipEngine Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load ShipEngine to a database.
-
Integrating Insightly Data in Talend Cloud Data Management Platform
Connect Insightly Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Build an OLAP Cube in SSAS from Google Tasks Data
Establish a connection to Google Tasks data from SQL Server Analysis Services, and use the Google Tasks Data Provider to build OLAP cubes for use in analytics and reporting.
-
Use the CData Software ODBC Driver for Dynamics 365 in MicroStrategy Web
Connect to Microsoft Dynamics 365 in MicroStrategy Web using the CData Software ODBC Driver for Dynamics 365.
-
Automate Gorgias Data Replication to SAP HANA
Use CData Sync to customize and automate Gorgias replication to SAP HANA.
-
DataBind Gong Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Gong to a chart.
-
Bidirectional Access to Microsoft Entra ID Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Microsoft Entra ID in Filemaker Pro for Mac or Windows.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for FreshBooks
Provide connectivity to FreshBooks through an SAP BusinessObjects universe.
-
Using the CData Software ODBC Driver for ZohoInvoice in PyCharm
Connect to ZohoInvoice as an ODBC data source in PyCharm using the CData Software ODBC Driver for ZohoInvoice.
-
Integrate Goose with Live Snowflake Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Snowflake from within the local AI agent.
-
Load Mailgun Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Mailgun to a database.
-
Access Live Gorgias Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Gorgias into the statistical analysis tools available in SAS JMP. This article shows how to use Gorgias in the Graph Builder and Query Builder.
-
Automated Continuous Slack Replication to Vertica
Use CData Sync for automated, continuous, customizable Slack replication to Vertica.
-
How to Visualize Greenhouse Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Greenhouse in Python.
-
Visualize Live Clockify Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Clockify.
-
Access Live Calendly Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Calendly into the statistical analysis tools available in SAS JMP. This article shows how to use Calendly in the Graph Builder and Query Builder.
-
Automated Continuous CData Connect AI Replication to MongoDB
Use CData Sync for automated, continuous, customizable CData Connect AI replication to MongoDB.
-
Salesforce CRM Analytics Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Salesforce CRM Analytics facts in real time.
-
LINQ to Zendesk Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Zendesk Data Provider.
-
Build Couchbase-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Couchbase to explore live Couchbase Data in Cursor to assist with building Couchbase-powered applications.
-
How to Query Live Zendesk Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Zendesk data in natural language using Python.
-
Getting Started with the CData SSIS Components for Klipfolio
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Klipfolio.
-
Create Data Visualizations in Cognos BI with PostgreSQL Data
Access PostgreSQL as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Getting Started with the CData ODBC Driver for Stack Exchange
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Stack Exchange.
-
Connect to and Query Attio Data in QlikView over ODBC
Create data visualizations with Attio in QlikView.
-
Use Dash to Build Web Apps on Zoho Projects Data via CData Connect AI
Build interactive Dash web apps on live Zoho Projects using pandas and the CData Connect AI Python SDK.
-
How to integrate Dynamics NAV with Apache Airflow
Access and process Microsoft Dynamics NAV in Apache Airflow using the CData JDBC Driver.
-
Billsby Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Billsby facts in real time.
-
Use the CData ODBC Driver for FormSite from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for FormSite to connect to FormSite from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring FormSite in Excel.
-
Integrate with Box Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Box in SnapLogic.