CData Software - Knowledge Base
Recent Articles
-
Build MVC Applications with Connectivity to Autopilot Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Autopilot from an ASP.NET MVC application.
-
Connect to SharePoint Excel Services Data in HULFT Integrate
Connect to SharePoint Excel Services as a JDBC data source in HULFT Integrate
-
Write a Simple Go Application to work with Codat Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Codat.
-
Explore Geographical Relationships in Salesforce Data with Power Map
Create data visualizations with Salesforce & Force.com in Power Map.
-
Visualize Jira Data in TIBCO Spotfire through OData
Integrate Atlassian Jira into dashboards in TIBCO Spotfire.
-
Query SAP Ariba Procurement Data in DataGrip
Create a Data Source for SAP Ariba Procurement in DataGrip and use SQL to query live SAP Ariba Procurement.
-
Connect Azure Analysis Services Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Azure Analysis Services using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Natively Connect to Pinterest Data in PHP
The CData ODBC driver for Pinterest enables you to create PHP applications with connectivity to Pinterest. Leverage the native support for ODBC in PHP.
-
Create Power BI Reports on Real-Time Workday Data
Use the CData ODBC Driver for Workday to visualize Workday in Power BI Desktop.
-
Import Real-Time ZohoMarketingHub Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use ZohoMarketingHub in ColdFusion.
-
Moving Data from Testmonitor to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Testmonitor data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Use Grok to Talk to Your Office 365 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 Microsoft Office 365 for you.
-
Publish Reports with AdRoll Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date AdRoll.
-
Consume ServiceNow OData Feeds in SAP Lumira
Use the API Server to create data visualizations on ServiceNow feeds that reflect any changes in SAP Lumira.
-
Automated Continuous Teamgate Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Teamgate replication to Google Cloud SQL.
-
Build Agents in Relevance AI with Access to Live SAP Concur Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on SAP Concur within intelligent agent workflows.
-
Visualize Live Greenplum Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Pivotal GreenPlum using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating GitHub Copilot CLI with Unbounce 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.
-
Build Agents in Relevance AI with Access to Live Exact Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Exact Online within intelligent agent workflows.
-
Integrate Live Google Ad Manager Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Google Ad Manager from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Google Ad Manager.
-
Build a Simple VCL Application for SAP Concur Data
How to build a simple VCL Application to view SAP Concur in RAD Studio using the CData ODBC Driver for SAP Concur.
-
Connect to SAP Business One Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for SAP Business One.
-
Use the CData Software ODBC Driver for AfterShip in MicroStrategy Web
Connect to AfterShip in MicroStrategy Web using the CData Software ODBC Driver for AfterShip.
-
Analyze SharePoint Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Microsoft SharePoint and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Salesforce Marketing Reporting in OBIEE with the Salesforce Marketing JDBC Driver
Deploy the Salesforce Marketing JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous Google Sheets Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Google Sheets replication to Amazon Redshift.
-
Configure the CData JDBC Driver for SAP Business Warehouse in a Connection Pool in Tomcat
Connect to SAP Business Warehouse from a connection pool in Tomcat.
-
Choosing the Best Method to Connect Close to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Close from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Getting Started with the CData Tableau Connector for CloudConvert
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
How to Connect to Live Certinia Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Certinia securely in real time.
-
Integrate Figshare Data in the Pentaho Report Designer
Publish reports based on Figshare in the Pentaho BI tool.
-
Connect Google Spanner to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Google Spanner using the CData Python MCP Server.
-
Automated Continuous SAP Fieldglass Replication to AlloyDB
Use CData Sync for automated, continuous, customizable SAP Fieldglass replication to AlloyDB.
-
Automated Continuous ZohoDesk Replication to AlloyDB
Use CData Sync for automated, continuous, customizable ZohoDesk replication to AlloyDB.
-
Add Vault CRM Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Vault CRM with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Azure DevOps Data from a Connection Pool in Jetty
The Azure DevOps JDBC Driver supports connection pooling: This article shows how to connect faster to Azure DevOps from Web apps in Jetty.
-
Import Real-Time Dotmailer Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Dotmailer in ColdFusion.
-
How to Connect DBeaver to Azure Data Catalog via a JDBC Driver
Manage Azure Data Catalog with visual tools in DBeaver like the query browser.
-
Connect to Real-Time Grafana Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Grafana in Power Apps.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Tanda
Provide connectivity to Tanda through an SAP BusinessObjects universe.
-
Build Dashboards with Aircall Data in DBxtra
Create dynamic dashboards and perform analytics based on Aircall in DBxtra.
-
How to create Teamwork federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Teamwork in MySQL .
-
Visualize Pipedrive 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 Pipedrive into TIBCO Spotfire.
-
Connect to Databricks Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Databricks.
-
Access HubDB Data from MySQL in Amazon QuickSight
Connect to HubDB and build visualizations of HubDB using a MySQL Connection in Amazon QuickSight.
-
Stream Bitbucket Data into Apache Kafka Topics
Access and stream Bitbucket in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create Reports from Odoo Data in Looker Studio
Use CData Connect AI to gain access to live Odoo ERP and create custom reports in Looker Studio.
-
Freshdesk Reporting in OBIEE with the Freshdesk JDBC Driver
Deploy the Freshdesk JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build AI Agents with JSON 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 JSON through CData Connect AI.
-
Build Marketo-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Marketo to explore live Marketo Data in Gemini Code Assist to assist with building Marketo-powered applications.
-
How to Visualize Greenplum Data in Python with pandas
Use pandas and other modules to analyze and visualize live Pivotal GreenPlum in Python.
-
Access Live Google Ads Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Ads from your Google Sheets.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Adobe Commerce
Provide connectivity to Adobe Commerce through an SAP BusinessObjects universe.
-
Connect to and Visualize Live FHIR Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live FHIR.
-
Query Optimizely Data as a MySQL Database in Node.js
Execute MySQL queries against Optimizely from Node.js.
-
Replicate Multiple Teamwork Accounts via the CData Sync CLI
Replicate multiple Teamwork accounts to one or many databases.
-
Use Dash to Build to Web Apps on Google Spanner Data
Create Python applications that use pandas and Dash to build Google Spanner-connected web apps.
-
Publish Parallel-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Parallel.
-
A PostgreSQL Interface for ConstantContact Data using the CData ODBC Driver
Use the SQL Gateway and ConstantContact ODBC Driver to create a PostgreSQL entry-point for data access.
-
DataBind Controls to Contentful Data in Delphi
DataBind to Contentful in Delphi with standard data access components and controls.
-
Connect Instantly to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Instantly with IBM WebSphere for seamless data integration and connectivity.
-
DataBind Controls to VWO Data in Delphi
DataBind to VWO in Delphi with standard data access components and controls.
-
Connect to PayPal Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time PayPal using standard SQL.
-
Using the CData Software ODBC Driver for Elasticsearch in PyCharm
Connect to Elasticsearch as an ODBC data source in PyCharm using the CData Software ODBC Driver for Elasticsearch.
-
Automate QuickBooks Time Data Replication to SAP HANA
Use CData Sync to customize and automate QuickBooks Time replication to SAP HANA.
-
Automate Neo4J Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Neo4J from PowerShell? This article demonstrates how to utilize the Neo4J Cmdlets for tasks like connecting to Neo4J, automating operations, downloading data, and more.
-
Connect to and Visualize Live Neo4J Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Neo4J.
-
How to import Anaplan Data into Apache Solr
Use the CData Software JDBC Driver for Anaplan in Data Import Handler and create an automated import of Anaplan to Apache Solr Enterprise Search platform.
-
Extend Google Sheets with Microsoft Entra ID Data
Make calls to Microsoft Entra ID from Google Apps Script via the API Server.
-
Connecting Mastra with Azure Table 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 Azure Table Storage, no replication required.
-
Rapidly Develop Twilio-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 Twilio.
-
Establish a Live Connection with Microsoft Planner Data using Tableau Bridge
The CData ODBC Driver for Microsoft Planner enables you to integrate live Microsoft Planner into Tableau Cloud dashboards using the Tableau Bridge.
-
View Reports on Real-Time TaxJar Data in Power BI Report Server
Use the CData ODBC Driver for TaxJar to visualize TaxJar in Power BI Desktop and then publish them to Power BI Report Server.
-
Access Google Analytics Data from MySQL in PHP
Connect to Google Analytics through the standard MySQL libraries in PHP.
-
Visualize eBay Analytics Data in Tableau
The CData ODBC driver for eBay Analytics enables you integrate eBay Analytics into Tableau dashboards.
-
Import Real-Time Cvent Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Cvent in ColdFusion.
-
Visualize SAP SuccessFactors LMS Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to SAP SuccessFactors LMS.
-
Visualize Email Data in Tableau
The CData ODBC driver for Email enables you integrate Email into Tableau dashboards.
-
Connect to HubSpot Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for HubSpot.
-
Build Pipelines with Live SAP BusinessObjects BI Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to SAP BusinessObjects BI from Google Cloud Data Fusion, enabling the integration of live SAP BusinessObjects BI into the building and management of effective data pipelines.
-
Connect to Google Search Results in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Build a Singer.io Tap for ZohoInvoice With the CData Python Connector
Learn how to easily build a Singer.io Tap for live ZohoInvoice data using
-
Manage Freshteam Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Freshteam.
-
Connect to Sage Intacct Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Sage Intacct Data and connect to Sage Intacct in Akorbi Digital RunMyProcess.
-
Load Mailjet Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Mailjet to a database.
-
Integrating LangGraph with Sugar CRM Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Sugar CRM within automated workflows.
-
Automated Continuous HubSpot Replication to Databricks
Use CData Sync for automated, continuous, customizable HubSpot replication to Databricks.
-
Build Twitter Ads-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Twitter Ads and build web apps with connectivity to live Twitter Ads.
-
Create Reports with Keap Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Keap.
-
Connect Printify to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Printify using the CData Python MCP Server.
-
Integrating Claude Code CLI with Hive 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.
-
Using the CData Software ODBC Driver for Snowflake in PyCharm
Connect to Snowflake as an ODBC data source in PyCharm using the CData Software ODBC Driver for Snowflake.
-
Connect to IBM Informix Data in Claris FileMaker Pro
Use the CData ODBC Driver for IBM Informix in FileMaker Pro to connect to IBM Informix and work with IBM Informix in your FileMaker applications.
-
Connect to Kintone Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Kintone.
-
Deploy the ADO.NET Provider for Recurly on an SSRS Report Server
Connect to Recurly 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 Adobe Commerce Replication to SingleStore
Use CData Sync for automated, continuous, customizable Adobe Commerce replication to SingleStore.
-
Integrate Discourse Data in Pentaho Data Integration
Build ETL pipelines based on Discourse in the Pentaho Data Integration tool.
-
Build Adobe Commerce-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Adobe Commerce Data and create custom apps in Bubble.
-
Connect Tally to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Tally ERP using the CData Python MCP Server.
-
Connect to Salesforce Marketing in SpagoBI
Create reports featuring live Salesforce Marketing Cloud in SpagoBI Studio. Host Salesforce Marketing reports on SpagoBI Server.