CData Software - Knowledge Base
Recent Articles
-
DataBind Controls to Teradata Data in C++Builder
DataBind to Teradata in C++Builder with standard components and controls.
-
Analyze Power BI XMLA Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Power BI XMLA with the CData JDBC Driver for Power BI XMLA.
-
Getting Started with the CData Python Connector for Browserless
Learn to install and license the CData Python Connector
-
How to create MailChimp federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for MailChimp in MySQL .
-
Analyze Exact Online Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Exact Online and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Build a Simple VCL Application for Typeform Data
How to build a simple VCL Application to view Typeform in RAD Studio using the CData ODBC Driver for Typeform.
-
Connect Marketo Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Marketo using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
A PostgreSQL Interface for Oracle Eloqua Data using the CData ODBC Driver
Use the SQL Gateway and Oracle Eloqua ODBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Live OneNote Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Microsoft OneNote using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating LangChain with Snapchat Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Snapchat Ads within automated workflows.
-
Import SurveyMonkey Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to SurveyMonkey Data and provide access to live SurveyMonkey for custom reports in the Power BI Service.
-
Deploy the ADO.NET Provider for Trello on an SSRS Report Server
Connect to Trello 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.
-
Getting Started with the CData SSIS Components for MailerLite
Complete guide to installing, licensing, and connecting with the CData SSIS Components for MailerLite.
-
Automated Continuous Accelo Replication to SQLite
Use CData Sync for automated, continuous, customizable Accelo replication to SQLite.
-
How to connect and process Harvest from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Harvest.
-
Build AI/ML Models with Live Zoom Data using Dataiku
Connect Zoom Data with Dataiku using the CData API Driver for JDBC.
-
How to Query ConvertKit Data in MySQL Workbench
Execute MySQL queries against live ConvertKit from MySQL Workbench.
-
Visualize OneNote Data in TIBCO Spotfire through ADO.NET
Integrate Microsoft OneNote into dashboards in TIBCO Spotfire.
-
Integrate with live IBM Informix Data in Jitterbit
Use CData Connect AI to connect to and integrate live IBM Informix in Jitterbit.
-
Integrate with Live Oracle Eloqua Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Oracle Eloqua from the MuleSoft Anypoint Platform to integrate live Oracle Eloqua into custom reports and dashboards.
-
Using the CData Software ODBC Driver for Harvest in PyCharm
Connect to Harvest as an ODBC data source in PyCharm using the CData Software ODBC Driver for Harvest.
-
How to connect Amazon QuickSight to Smartsheet Data
Create a connection to Smartsheet in CData Connect AI and insert Smartsheet into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect to Slack Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Slack.
-
How to connect to SageHR Data in DBVisualizer
Integrate SageHR with visual data analysis tools and data connection wizards in DBVisualizer
-
Getting Started with the CData Excel Add-In for LaunchDarkly
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for LaunchDarkly.
-
Connect to Optimizely Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Optimizely and the SQL Gateway to access Optimizely from Google Apps Script.
-
Consume SAP Hybris C4C OData Feeds in PowerBuilder
This article demonstrates how to consume SAP Hybris C4C as OData feeds from PowerBuilder using the API Server.
-
Connect to Microsoft OneDrive Data in Claris FileMaker Pro
Use the CData ODBC Driver for Microsoft OneDrive in FileMaker Pro to connect to Microsoft OneDrive and work with Microsoft OneDrive in your FileMaker applications.
-
Visualize Zoho Creator Data in Tableau
The CData ODBC driver for Zoho Creator enables you integrate Zoho Creator into Tableau dashboards.
-
DataBind FormSite Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide FormSite to a chart.
-
Integrate Theia IDE with Live Spark Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Connect to Delighted Data in DBeaver
Use the CData ODBC Driver to connect to Delighted in DBeaver.
-
Use the CData Software ODBC Driver for Sage Intacct in MicroStrategy Desktop
Connect to Sage Intacct in MicroStrategy Desktop using the CData Software ODBC Driver for Sage Intacct.
-
Connect to Azure Table Data in NetBeans
Connect to Azure Table Storage in NetBeans with the data source configuration wizard.
-
View Reports on Real-Time SAP Business One Data in Power BI Report Server
Use the CData ODBC Driver for SAP Business One to visualize SAP Business One in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Access PDFMonkey Data Using Entity Framework
This article shows how to access PDFMonkey using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Prepare, Blend, and Analyze JSON Services in Alteryx Designer (Connect AI)
Build workflows to access live JSON for self-service data analytics.
-
Integrate Live TigerGraph Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live TigerGraph to Blue Prism using the CData ODBC Driver for TigerGraph to create automated workflows for repetitive business tasks.
-
Publish Reports with Freshteam Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Freshteam.
-
Create Reports with Asana Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Asana.
-
Visualize Invoiced Data in Sisense
Create an ElastiCube in Sisense app with access to Invoiced.
-
Connect to Real-Time Mouseflow Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Mouseflow in Power Apps.
-
Edit and Search Amazon Athena External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Amazon Athena to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Amazon Athena objects that you can access from apps and the dashboard.
-
How to Connect to Live Oracle SCM Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Oracle SCM for you.
-
Automated Continuous Recurly Replication to Snowflake
Use CData Sync for automated, continuous, customizable Recurly replication to Snowflake.
-
Access Toggl Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Toggl from your Oracle system.
-
Connect to Ontraport Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Ontraport.
-
How to import Freshservice Data into Apache Solr
Use the CData Software JDBC Driver for Freshservice in Data Import Handler and create an automated import of Freshservice to Apache Solr Enterprise Search platform.
-
Analyze Omnisend Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Omnisend from Power Pivot. You will use the Table Import Wizard to load Omnisend. You can visually build the import query or use any SQL supported by the driver.
-
Access Live Float Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Float into the statistical analysis tools available in SAS JMP. This article shows how to use Float in the Graph Builder and Query Builder.
-
Integrate Kintone Data in Pentaho Data Integration
Build ETL pipelines based on Kintone in the Pentaho Data Integration tool.
-
How to load PagerDuty data into Elasticsearch via Logstash
Introducing a simple method to load PagerDuty data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build Pipelines with Live SendGrid Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to SendGrid from Google Cloud Data Fusion, enabling the integration of live SendGrid into the building and management of effective data pipelines.
-
Build Zoho Creator-Connected Apps in Choreo
Use CData Connect AI to connect to Zoho Creator Data from Choreo and build custom apps using live Zoho Creator.
-
Access Live Airtable Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Airtable data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
How to Create Power BI Visual Reports with Real-Time Sybase Data
Use CData Power BI Connectors to visualize Sybase in Power BI.
-
Connect to Confluence Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Atlassian Confluence in Airbyte.
-
How to connect to Keap Data with Squirrel SQL client
Connect to Keap and execute queries in the Squirrel SQL Client.
-
Analyze HBase Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Apache HBase and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Build Apps with Live ZohoSubscriptions Data Using the Low-Code Development Platform of Mendix
Connect ZohoSubscriptions with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to LinkedIn Data from a Connection Pool in Jetty
The LinkedIn JDBC Driver supports connection pooling: This article shows how to connect faster to LinkedIn from Web apps in Jetty.
-
Integrate Gmail Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Gmail from Informatica Cloud.
-
Visualize Live Printful Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Printful using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Xero-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Xero Accounting.
-
Connect to Reckon Data in DBArtisan
Use wizards in DBArtisan to configure Reckon as a data source.
-
Use JayDeBeApi to access Vault CRM Data in Python
Use standard Python scripting and the development environment of your choice to access live Veeva Vault & Vault CRM.
-
Connect to Microsoft Teams Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Microsoft Teams and the Script function in FileMaker Pro to connect to Microsoft Teams and work with Microsoft Teams in your FileMaker application.
-
Build AI Agents with GitLab 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 GitLab through CData Connect AI.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for GitLab
Provide connectivity to GitLab through an SAP BusinessObjects universe.
-
How to work with Planio Data in Apache Spark using SQL
Access and process Planio Data in Apache Spark using the CData Software JDBC Driver.
-
Publish Intercom-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Intercom.
-
ETL Aircall in Oracle Data Integrator
This article shows how to transfer Aircall into a data warehouse using Oracle Data Integrator.
-
Publish ZohoInvoice-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live ZohoInvoice.
-
Integrating OpenCode Terminal with Access 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.
-
A PostgreSQL Interface for SAP Business Warehouse Data using the CData ODBC Driver
Use the SQL Gateway and SAP Business Warehouse ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to JSON Services in Claris FileMaker Pro
Use the CData ODBC Driver for JSON in FileMaker Pro to connect to JSON and work with JSON in your FileMaker applications.
-
How to Design Microsoft Entra ID Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Microsoft Entra ID from mobile and tablet Power Apps.
-
Build Apps with Live ZohoMarketingHub Data Using the Low-Code Development Platform of Mendix
Connect ZohoMarketingHub with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to Spark Data from a Connection Pool in Jetty
The Spark JDBC Driver supports connection pooling: This article shows how to connect faster to Apache Spark SQL from Web apps in Jetty.
-
Automated Continuous OData Replication to IBM DB2
Use CData Sync for automated, continuous, customizable OData replication to IBM DB2.
-
Integrate Zoho Recruit Data in the Pentaho Report Designer
Publish reports based on Zoho Recruit in the Pentaho BI tool.
-
Build Certinia-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Certinia and build Certinia-connected web apps with Axios.
-
Integrating GitHub Copilot CLI with Act CRM 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.
-
How to Connect to Live Google Spanner Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Google Spanner for you.
-
Connect to Moosend Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Moosend.
-
How to Query Live Samanage Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Samanage data in natural language using Python.
-
How to load JDBC-ODBC Bridge data into Elasticsearch via Logstash
Introducing a simple method to load JDBC-ODBC Bridge data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to QuickBooks Time Data in RazorSQL
Connect to QuickBooks Time from wizards and query QuickBooks Time from the GUI in the RazorSQL database management tool.
-
Create Greenhouse-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Greenhouse Data from Klipfolio and build custom visualizations using live Greenhouse.
-
Back Up Recurly to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Recurly data.
-
Explore Geographical Relationships in Short.io Data with Power Map
Create data visualizations with Short.io in Power Map.
-
Import and Visualize Square Data in Power View
Create data visualizations based on Square in Excel.
-
Load SAP SuccessFactors LMS Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SAP SuccessFactors LMS to a database.
-
Use Manus AI to Talk to Your OData Services via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on OData.
-
Connect to SAP Business One Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with SAP Business One Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to Helpscout Data in Ruby
Connect to Helpscout in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Replicate Opsgenie Data to Multiple Databases
Replicate Opsgenie to disparate databases with a point-and-click configuration.
-
Integrating GitHub Copilot CLI with Wistia 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.
-
Use Claude to Talk to Your Sybase 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 Sybase for you.
-
How to Access OpenWeatherMap Data Using Entity Framework
This article shows how to access OpenWeatherMap using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.