CData Software - Knowledge Base
Recent Articles
-
Visualize Intercom 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 Intercom data into TIBCO Spotfire.
-
Visualize Keap 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 Keap data into TIBCO Spotfire.
-
Analyze BambooHR Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for BambooHR from Power Pivot. You will use the Table Import Wizard to load BambooHR data. You can visually build the import query or use any SQL supported by the driver.
-
Integrate Facebook Ads with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Facebook Ads with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Facebook Ads data.
-
Use JayDeBeApi to access JDBC-ODBC Bridge Data in Python
Use standard Python scripting and the development environment of your choice to access live JDBC-ODBC Bridge data.
-
How to integrate Kintone with Apache Airflow
Access and process Kintone data in Apache Airflow using the CData JDBC Driver.
-
Getting Started with the CData Excel Add-In for Redis
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Redis.
-
Replicate Email Data to Multiple Databases via the CData Sync CLI
Replicate Email data to disparate databases with a single configuration.
-
Build a Simple VCL Application for Redis Data
How to build a simple VCL Application to view Redis data in RAD Studio using the CData ODBC Driver for Redis.
-
Import and Visualize Cosmos DB Data in Power View
Create data visualizations based on Cosmos DB data in Excel.
-
Automated Continuous Dynamics NAV Replication to Oracle
Use CData Sync for automated, continuous, customizable Dynamics NAV replication to Oracle.
-
How to Connect to Live Google Contacts 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 Google Contacts data for you.
-
ETL Bitly in Oracle Data Integrator
This article shows how to transfer Bitly data into a data warehouse using Oracle Data Integrator.
-
Moving Data from SQL Server to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live SQL Server data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrate Real-Time Access to Google Spanner in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Google Spanner data in real time.
-
Build a PostgreSQL Interface for Avro Data using the CData JDBC Driver
Use the Remoting features of the Avro JDBC Driver to create a PostgreSQL entry-point for data access.
-
Replicate Hive Data in Heroku for Use in Salesforce Connect
Replicate Hive data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Acumatica Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Acumatica facts in real time.
-
Connect to Gong in SpagoBI
Create reports featuring live Gong data in SpagoBI Studio. Host Gong reports on SpagoBI Server.
-
Automated Continuous Hugging Face Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Hugging Face replication to Apache Kafka.
-
Build PolarTeamPro-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live PolarTeamPro data.
-
Connect to SurveyMonkey in SpagoBI
Create reports featuring live SurveyMonkey data in SpagoBI Studio. Host SurveyMonkey reports on SpagoBI Server.
-
Connect to Dropbox Data in Ruby
Connect to Dropbox data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Use the CData Software ODBC Driver for AlloyDB in MicroStrategy
Connect to AlloyDB data in MicroStrategy Developer using the CData Software ODBC Driver for AlloyDB.
-
How to Access Pipeline CRM Data Using Entity Framework
This article shows how to access Pipeline CRM data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Access Live SAP Ariba Source 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 SAP Ariba Source data through MCP integration.
-
Integrating LangChain with BenchmarkEmail Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on BenchmarkEmail data within automated workflows.
-
Connect to Parquet Data in RazorSQL
Connect to Parquet from wizards and query Parquet data from the GUI in the RazorSQL database management tool.
-
Integrate Cline with Live Vault CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Vault CRM data from within your IDE.
-
Design BIRT Reports on Trello Data
Provide current Trello data to your embedded analytics.
-
DataBind Google Drive Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Google Drive with the DevExpress Windows Forms and Web controls to provide Google Drive data to a chart.
-
Use Agno to Talk to Your Power BI XMLA Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Power BI XMLA data for you.
-
How to connect to NetSuite Data with Squirrel SQL client
Connect to NetSuite data and execute queries in the Squirrel SQL Client.
-
Integrating LangGraph with Power BI XMLA Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Power BI XMLA data within automated workflows.
-
Build Google Analytics-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Google Analytics Data and create custom apps in Mendix.
-
Connect to Procore Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Procore data from Filemaker Pro on Mac.
-
Integrate SAP SuccessFactors with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SAP SuccessFactors with External Services.
-
Connect to Live SAP SuccessFactors Data in MicroStrategy through CData Connect AI
Create a live connection to SAP SuccessFactors Data in CData Connect AI and connect to your SAP SuccessFactors data from MicroStrategy.
-
Import Workday Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Workday Data and provide access to live Workday data for custom reports in the Power BI Service.
-
Use the CData Software ODBC Driver for ClickTime in MicroStrategy Web
Connect to ClickTime data in MicroStrategy Web using the CData Software ODBC Driver for ClickTime.
-
Viewing SAS xpt Data in RAD Studio Data Explorer
How to view SAS xpt data in RAD Studio Data Explorer using the CData ODBC Driver for SAS xpt.
-
Natively Connect to Salesforce Data 360 Data in PHP
The CData ODBC driver for Salesforce Data 360 enables you to create PHP applications with connectivity to Salesforce Data 360 data. Leverage the native support for ODBC in PHP.
-
Paddle Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Paddle facts in real time.
-
Build Reckon Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Reckon data and build visualizations in Tableau Cloud.
-
Integrate with Live Azure Data Catalog Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Azure Data Catalog from the MuleSoft Anypoint Platform to integrate live Azure Data Catalog data into custom reports and dashboards.
-
Viewing Beeminder Data in RAD Studio Data Explorer
How to view Beeminder data in RAD Studio Data Explorer using the CData ODBC Driver for Beeminder.
-
Getting Started with the CData Tableau Connector for Gumroad
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Choosing the Best Method to Connect Unbounce to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Unbounce data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Stream Paymo Data into Apache Kafka Topics
Access and stream Paymo data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Getting Started with the CData Excel Add-In for Mistral AI
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Mistral AI.
-
Natively Connect to Basecamp Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Basecamp data. Leverage the native support for ODBC in PHP.
-
Publish Zoho Books-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Zoho Books data.
-
Integrate Theia IDE with Live Google Forms Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Google Forms data from within the development environment.
-
Build Apps with Live ADP data in Adalo using CData Connect AI
Use CData Connect AI to integrate live ADP data into the Adalo platform and build custom mobile and web applications with real-time ADP data.
-
Import Real-Time Bullhorn CRM Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Bullhorn CRM data in ColdFusion.
-
Integrate Cursor with Live Klipfolio Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Klipfolio data from within the editor.
-
Import Real-Time Workable Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Workable data in ColdFusion.
-
Add HubDB Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for HubDB with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect Tickspot to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Tickspot with IBM WebSphere for seamless data integration and connectivity.
-
Use Azure AI Foundry to Talk to Your Zuora Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Zuora data for you.
-
Analyze Apify Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Apify from Power Pivot. You will use the Table Import Wizard to load Apify data. You can visually build the import query or use any SQL supported by the driver.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Stack Exchange
Provide connectivity to Stack Exchange data through an SAP BusinessObjects universe.
-
Create Informatica Mappings From/To an ODBC Data Source for Mailgun
Create an ODBC connection to Mailgun in Informatica and browse and transfer Mailgun data.
-
Create Dynamic SendGrid Grids Using the Infragistics XamDataGrid
Learn how you can connect SendGrid to Infragistics XamDataGrid to build dynamic grids.
-
Integrating Dataiku with Trello Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Trello data.
-
Work with Live Zoho Books Data in Power Query
Use CData Connect AI to connect to Zoho Books data and work with live Zoho Books data in Microsoft Power Query.
-
How to Connect the Power BI Service to SingleStore: Complete Guide
Connect to the CData Software Power BI Connector for SingleStore from PowerBI.com to provide real-time SingleStore data across the organization.
-
Create Data Visualizations in Cognos BI with Contentful Data
Access Contentful data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create Reports with Zoho Creator Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Zoho Creator data.
-
How to Access Basecamp Data Using Entity Framework
This article shows how to access Basecamp data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Configure the CData JDBC Driver for Avro in a Connection Pool in Tomcat
Connect to Avro data from a connection pool in Tomcat.
-
How to connect to Ontraport Data from IntelliJ
Integrate connectivity to Ontraport data with wizards in IntelliJ.
-
Query Databricks Data as a SQL Server Database in Node.js
Execute SQL Server queries against Databricks data from Node.js.
-
How to publish and share ChartMogul Data dashboards with Tableau Server
The CData ODBC driver for ChartMogul enables you integrate ChartMogul data into Tableau dashboards.
-
Integrating Gumloop with Anaplan Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Anaplan data within automated workflows.
-
Connect to Freshteam Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Freshteam and the SQL Gateway to access Freshteam data from Google Apps Script.
-
Access Live ADP Data in Coginiti Pro
Connect to and query live ADP data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Create Reports with Nethunt Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Nethunt data.
-
DataBind Charts to Adobe Commerce Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Adobe Commerce data 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.
-
Work with Live SurveyMonkey Data in Power Query
Use CData Connect AI to connect to SurveyMonkey data and work with live SurveyMonkey data in Microsoft Power Query.
-
Connect to FormSite Data as an External Source in Dremio
Use the CData JDBC Driver to connect to FormSite as an External Source in Dremio.
-
Excel Spreadsheet Automation on SFTP Data with the QUERY Formula
Pull data from SFTP, automate spreadsheets, and more with the QUERY formula.
-
Create Teradata-Connected Applications in Appsmith
Connect to Teradata Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Teradata data.
-
Integrating Kiro with Front 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.
-
Build Pipeliner CRM-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Pipeliner CRM data.
-
Connect to Trello Data in RazorSQL
Connect to Trello from wizards and query Trello data from the GUI in the RazorSQL database management tool.
-
How to Query AgileCRM Data in MySQL Workbench
Execute MySQL queries against live AgileCRM data from MySQL Workbench.
-
Create Data Visualizations in Cognos BI with IBM Cloud Object Storage Data
Access IBM Cloud Object Storage data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Use the CData ODBC Driver for QuickBooks Online from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for QuickBooks Online to connect to QuickBooks Online data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring QuickBooks Online data in Excel.
-
Use CData Connect AI to Access Supabase Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Supabase data in the Power Pivot business intelligence tool.
-
Connect to Bright Data Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Bright Data.
-
Configure the CData JDBC Driver for SharePoint Excel Services in a Connection Pool in Tomcat
Connect to SharePoint Excel Services data from a connection pool in Tomcat.
-
Replicate Multiple QuickBooks Time Accounts via the CData Sync CLI
Replicate multiple QuickBooks Time accounts to one or many databases.
-
Automated Continuous HubDB Replication to MongoDB
Use CData Sync for automated, continuous, customizable HubDB replication to MongoDB.
-
Connect to BigCommerce from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from BigCommerce data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Getting Started with the CData SSIS Components for Trello
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Trello.
-
Integrate Smartsheet Data in Pentaho Data Integration
Build ETL pipelines based on Smartsheet data in the Pentaho Data Integration tool.
-
Access eBay Data from MySQL in PHP
Connect to eBay through the standard MySQL libraries in PHP.
-
Automated Continuous Workday Replication to Snowflake
Use CData Sync for automated, continuous, customizable Workday replication to Snowflake.
-
Build an OLAP Cube in SSAS from Calendly Data
Establish a connection to Calendly data data from SQL Server Analysis Services, and use the Calendly Data Provider to build OLAP cubes for use in analytics and reporting.