CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData Python Connector for Cloudflare
Learn to install and license the CData Python Connector
-
DataBind Controls to Google Ad Manager Data in C++Builder
DataBind to Google Ad Manager in C++Builder with standard components and controls.
-
Connect to Azure Table Data in Claris FileMaker Pro
Use the CData ODBC Driver for Azure Table in FileMaker Pro to connect to Azure Table and work with Azure Table Storage in your FileMaker applications.
-
Connect to SAS Data Sets Data in JRuby
Create a simple JRuby app with access to live SAS Data Sets.
-
Connect to xBase Data in NetBeans
Connect to xBase in NetBeans with the data source configuration wizard.
-
Connect to SFTP Data in Jaspersoft Studio
Execute SQL to remote SFTP in Jaspersoft Studio.
-
Connect to ZohoInvoice in SpagoBI
Create reports featuring live ZohoInvoice in SpagoBI Studio. Host ZohoInvoice reports on SpagoBI Server.
-
Automated Continuous ZohoSubscriptions Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable ZohoSubscriptions replication to Apache Kafka.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Foursquare
Provide connectivity to Foursquare through an SAP BusinessObjects universe.
-
Consume Pinterest OData Feeds in PowerBuilder
This article demonstrates how to consume Pinterest as OData feeds from PowerBuilder using the API Server.
-
Integrating OpenCode Terminal with Zuora 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.
-
Create SSAS Tabular Models from BigQuery Data
How to build a SQL Server Analysis Service Tabular Model from Google BigQuery using CData drivers.
-
Create Reports with Quickbase Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Quickbase.
-
Visualize Dotmailer Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Dotmailer.
-
Connect to ChartMogul Data in Ruby
Connect to ChartMogul in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Google Calendar Data Replication to Teradata
Use CData Sync to Customize and automate Google Calendar replication to Teradata.
-
Connect to Google Ads from a Connection Pool in WebLogic
Use the CData JDBC Driver for Google Ads to connect to Google Ads from Web applications running on WebLogic.
-
Getting Started with the CData ODBC Driver for Planio
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Planio.
-
Automated Continuous FormSite Replication to Snowflake
Use CData Sync for automated, continuous, customizable FormSite replication to Snowflake.
-
Access Vimeo Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Vimeo from your Oracle system.
-
Create Power BI Reports on Real-Time Pipeliner CRM Data
Use the CData ODBC Driver for Pipeliner CRM to visualize Pipeliner CRM in Power BI Desktop.
-
How to Connect the Power BI Service to Templated: Complete Guide
Connect to the CData Software Power BI Connector for Templated from PowerBI.com to provide real-time Templated across the organization.
-
Connect to Figshare Data in DBArtisan
Use wizards in DBArtisan to configure Figshare as a data source.
-
Build Data Flows from Guru to SQL Server using SSIS
Easily back up Guru to SQL Server using the SSIS components for Guru.
-
Create Informatica Mappings From/To an ODBC Data Source for Drip
Create an ODBC connection to Drip in Informatica and browse and transfer Drip.
-
How to Connect DBeaver to Wrike via a JDBC Driver
Manage Wrike with visual tools in DBeaver like the query browser.
-
Connect to Guru Data from a Connection Pool in Jetty
The Guru JDBC Driver supports connection pooling: This article shows how to connect faster to Guru from Web apps in Jetty.
-
Integrate Cline with Live Microsoft Entra ID Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Microsoft Entra ID from within your IDE.
-
A PostgreSQL Interface for Dynamics CRM Data using the CData ODBC Driver
Use the SQL Gateway and Dynamics CRM ODBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize ZendeskSell Data in Sisense
Create an ElastiCube in Sisense app with access to ZendeskSell.
-
Access Live Act-On Data in Coginiti Pro
Connect to and query live Act-On from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use the CData ODBC Driver for Clari in Microsoft Power Query
You can use the CData Clari ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Clari into Microsoft Power Query.
-
Visualize Excel Online 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 Microsoft Excel Online into TIBCO Spotfire.
-
Integrating Kiro CLI with Toggl 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.
-
Connect Reckon Accounts Hosted to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Reckon Accounts Hosted with IBM WebSphere for seamless data integration and connectivity.
-
Connect to Real-Time GitHub Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for GitHub and Dataflow to import and use GitHub in Power Apps.
-
Build Dashboards with Redis Data in Dundas BI
Create dynamic dashboards and perform analytics based on Redis in Dundas BI.
-
DataBind Controls to Dynamics NAV Data in Delphi
DataBind to Microsoft Dynamics NAV in Delphi with standard data access components and controls.
-
Manage Calendly Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Calendly.
-
Replicate Multiple DB2 Accounts via the CData Sync CLI
Replicate multiple DB2 accounts to one or many databases.
-
Connect to Live Vault CRM Data in MicroStrategy through CData Connect AI
Create a live connection to Vault CRM Data in CData Connect AI and connect to your Veeva Vault & Vault CRM from MicroStrategy.
-
Connect to EmailOctopus Data in DBArtisan
Use wizards in DBArtisan to configure EmailOctopus as a data source.
-
Connect to Real-Time Bright Data Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Bright Data in Power Apps.
-
Connect to ShipEngine Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for ShipEngine in the Denodo Virtual DataPort Administrator.
-
Analyze PhantomBuster Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze PhantomBuster with the CData JDBC Driver for PhantomBuster.
-
Create GitLab Dataflows on PowerBI.com
Connect to the CData Power BI Connector for GitLab from PowerBI.com to create Power BI Dataflows with real-time data.
-
Migrating data from Opsgenie to Snowflake using CData SSIS Components.
Easily push Opsgenie to Snowflake using the CData SSIS Tasks for Opsgenie and Snowflake.
-
Connect to Epicor Kinetic Data in Jaspersoft Studio
Execute SQL to remote Epicor Kinetic in Jaspersoft Studio.
-
Build MVC Applications with Connectivity to Postmark Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Postmark from an ASP.NET MVC application.
-
Connect to and Query HBase Data in QlikView over ODBC
Create data visualizations with Apache HBase in QlikView.
-
Publish Crystal Reports on Sybase Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Sybase.
-
Visualize Intercom Data in TIBCO Spotfire through ADO.NET
Integrate Intercom into dashboards in TIBCO Spotfire.
-
Create Data Visualizations in Cognos BI with SAP Data
Access SAP ERP/NetWeaver as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create Data Visualizations in Cognos BI with Perigon Data
Access Perigon as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrating Dataiku with Oracle SCM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Oracle SCM.
-
Access Greenhouse Data from MySQL in Amazon QuickSight
Connect to Greenhouse and build visualizations of Greenhouse using a MySQL Connection in Amazon QuickSight.
-
Create Dynamic QuickBooks Online Grids Using the Infragistics XamDataGrid
Learn how you can connect QuickBooks Online to Infragistics XamDataGrid to build dynamic grids.
-
Create Reports from Gong Data in Looker Studio
Use CData Connect AI to gain access to live Gong and create custom reports in Looker Studio.
-
Create YouTube Analytics-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to YouTube Analytics Data from OutSystems and build custom enterprise apps using live YouTube Analytics.
-
Automated Continuous MySQL Replication to Oracle
Use CData Sync for automated, continuous, customizable MySQL replication to Oracle.
-
Validate Shopify Data with QuerySurge
Access and validate Shopify in QuerySurge using the CData JDBC Driver.
-
How to Connect to Live Presto Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Presto through natural language.
-
How to Connect to Live CouchDB 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 Apache CouchDB for you.
-
Integrating Claude Code with NetSuite SuiteAnalytics Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on NetSuite SuiteAnalytics within assisted coding and automated development workflows.
-
Create SSAS Tabular Models from Databricks Data
How to build a SQL Server Analysis Service Tabular Model from Databricks using CData drivers.
-
Integrating LangGraph with Snapchat Ads Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Snapchat Ads within automated workflows.
-
A PostgreSQL Interface for Freshservice Data using the CData ODBC Driver
Use the SQL Gateway and Freshservice ODBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software ODBC Driver for Intercom in SAS for Real-Time Reporting and Analytics
Connect to real-time Intercom in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Intercom.
-
Operational Reporting on Freshteam Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Freshteam.
-
How to Query Live ShipStation Data in Claude Desktop
Connect to and query live ShipStation Data in Claude Desktop using CData MCP Server.
-
Automated Continuous SQL Server Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable SQL Server replication to Google BigQuery.
-
Integrate Certinia Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Certinia from Informatica Cloud.
-
Use the CData Software ODBC Driver for Apollo in MicroStrategy Web
Connect to Apollo in MicroStrategy Web using the CData Software ODBC Driver for Apollo.
-
Connect to Typeform Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Typeform and the SQL Gateway to access Typeform from Google Apps Script.
-
Query PostgreSQL Data through ODBC in Node.js
Use node-odbc to execute SQL queries against PostgreSQL from Node.js.
-
Create Datasets from ActiveCampaign in Domo Workbench and Build Visualizations of ActiveCampaign Data in Domo
Use the CData Software ODBC Driver for ActiveCampaign to create datasets from ActiveCampaign in Domo Workbench and then build visualizations in the Domo service.
-
Getting Started with the CData ODBC Driver for Raisers Edge NXT
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Raisers Edge NXT.
-
Build Dashboards with Ontraport Data in DBxtra
Create dynamic dashboards and perform analytics based on Ontraport in DBxtra.
-
Access SAP Ariba Source Data from MySQL in Amazon QuickSight
Connect to SAP Ariba Source and build visualizations of SAP Ariba Source using a MySQL Connection in Amazon QuickSight.
-
How to load Amazon Athena data into Elasticsearch via Logstash
Introducing a simple method to load Amazon Athena data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to publish and share Amazon Athena Data dashboards with Tableau Server
The CData ODBC driver for Amazon Athena enables you integrate Amazon Athena into Tableau dashboards.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Pinterest
Provide connectivity to Pinterest through an SAP BusinessObjects universe.
-
Analyze SAP Concur Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of SAP Concur and visualize SAP Concur in SAP Analytics Cloud.
-
Excel Spreadsheet Automation on ShipEngine Data with the QUERY Formula
Pull data from ShipEngine, automate spreadsheets, and more with the QUERY formula.
-
Build Amplitude-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Amplitude and build web apps with connectivity to live Amplitude.
-
Connect to Zoho Books from a Connection Pool in WebLogic
Use the CData JDBC Driver for Zoho Books to connect to Zoho Books from Web applications running on WebLogic.
-
Zuora Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Zuora through CData Connect AI using different applications and tools.
-
How to Access Live Auth0 Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Auth0 enables you to integrate Auth0 into workflows built using Microsoft Power Automate Desktop.
-
How to Connect the Power BI Service to xBase: Complete Guide
Connect to the CData Software Power BI Connector for xBase from PowerBI.com to provide real-time xBase across the organization.
-
Codat Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Codat facts in real time.
-
Connect to Cassandra Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Cassandra and the Script function in FileMaker Pro to connect to Cassandra and work with Apache Cassandra in your FileMaker application.
-
Integrate Azure DevOps Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Azure DevOps and integrate live Azure DevOps into your Power Automate tasks.
-
Getting Started with the CData Connect AI Python SDK for PayPal
Install the CData Connect AI Python SDK to read and write live PayPal with standard DB-API 2.0 Python code.
-
Use the CData ODBC Driver for Freshsales from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Freshsales to connect to Freshsales from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Freshsales in Excel.
-
Create Reports with Parquet Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Apache Parquet.
-
Integrating Antigravity CLI with Sage Intacct via CData CLI
Connect Sage Intacct to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to load Sage Cloud Accounting data into Elasticsearch via Logstash
Introducing a simple method to load Sage Cloud Accounting data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create a Data Access Object for OneNote Data using JDBI
A brief overview of creating a SQL Object API for Microsoft OneNote in JDBI.
-
Query SAP HANA Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume SAP HANA entities in PHP by modeling them as objects.
-
Replicate Cvent Data from PowerShell
Write a quick PowerShell script to query Cvent. Use connectivity to the live data to replicate Cvent to SQL Server.