CData Software - Knowledge Base
Recent Articles
-
How to connect Amazon QuickSight to Sybase IQ Data
Create a connection to Sybase IQ in CData Connect AI and insert Sybase IQ into Amazon QuickSight SPICE to build interactive dashboards.
-
Use the CData Software ODBC Driver for Hacker News in MicroStrategy Desktop
Connect to Hacker News in MicroStrategy Desktop using the CData Software ODBC Driver for Hacker News.
-
Connect to GetResponse Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Create a Data Access Object for Yelp Data using JDBI
A brief overview of creating a SQL Object API for Yelp in JDBI.
-
How to connect PolyBase to SuiteCRM
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SuiteCRM.
-
Build MariaDB-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for MariaDB Data and create custom apps in Bubble.
-
How to integrate Postmark with Apache Airflow
Access and process Postmark in Apache Airflow using the CData JDBC Driver.
-
Object-Relational Mapping (ORM) with Oracle Sales Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Oracle Sales into a Java-based ORM framework, Hibernate.
-
Automated Continuous Zoho CRM Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Zoho CRM replication to Apache Kafka.
-
Query Live ShipStation Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live ShipStation directly from the development environment.
-
Connect to Sage Intacct Data in DBArtisan
Use wizards in DBArtisan to configure Sage Intacct as a data source.
-
Automated Continuous Clockify Replication to SingleStore
Use CData Sync for automated, continuous, customizable Clockify replication to SingleStore.
-
Use Databricks Agent Bricks to Talk to Your Amazon Athena Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Amazon Athena for you.
-
Automate Shippo Data Replication to SAP HANA
Use CData Sync to customize and automate Shippo replication to SAP HANA.
-
Working with PolarTeamPro Data in LINQPad
Execute LINQ queries to PolarTeamPro in LINQPad.
-
Connect to TaxJar Data from PowerBuilder via JDBC
This article demonstrates how to access TaxJar from PowerBuilder using the TaxJar JDBC Driver.
-
Connect to ZohoDesk 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 ZohoDesk and work with ZohoDesk in your FileMaker application.
-
Build Zendesk Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Zendesk and build visualizations in Tableau.
-
Provide OData Services of SAP Hybris C4C Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SAP Hybris C4C by developing a WCF Service Application.
-
Create Reports from SharePoint Data in Looker Studio
Use CData Connect AI to gain access to live Microsoft SharePoint and create custom reports in Looker Studio.
-
Create ConvertAPI Dataflows on PowerBI.com
Connect to the CData Power BI Connector for ConvertAPI from PowerBI.com to create Power BI Dataflows with real-time data.
-
Analyze MailerLite Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze MailerLite in Microsoft R Open.
-
Build a Simple VCL Application for FormSite Data
How to build a simple VCL Application to view FormSite in RAD Studio using the CData ODBC Driver for FormSite.
-
Access Live Zoho Creator Data in Excel 365 Online (Excel for the web)
Connect to Zoho Creator from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Analyze Airtable Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Airtable from Power Pivot. You will use the Table Import Wizard to load Airtable. You can visually build the import query or use any SQL supported by the driver.
-
Build Visualizations of AlloyDB Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Google AlloyDB in Birst.
-
How to publish and share Missive Data dashboards with Tableau Server
The CData ODBC driver for Missive enables you integrate Missive into Tableau dashboards.
-
Load Teamwork Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Teamwork to a database.
-
How to Build an ETL App for MariaDB Data in Python with CData Connect AI
Build ETL pipelines that read and write live MariaDB in Python with petl and the CData Connect AI Python SDK.
-
Build Apps with Live Databricks in Adalo using CData Connect AI
Use CData Connect AI to integrate live Databricks into the Adalo platform and build custom mobile and web applications with real-time Databricks.
-
Add Snowflake Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Snowflake with the Informatica Enterprise Data Catalog to classify and organize data.
-
Import OData Services into the Power BI Service for Visualizations
Use CData Connect AI to connect to OData Services and provide access to live OData for custom reports in the Power BI Service.
-
Automated Continuous Presto Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Presto replication to Google Cloud SQL.
-
Build Data Flows from Freshdesk to SQL Server using SSIS
Easily back up Freshdesk to SQL Server using the SSIS components for Freshdesk.
-
Integrate with Sage Intacct Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Sage Intacct in SnapLogic.
-
Getting Started with the CData SSIS Components for ElevenLabs
Complete guide to installing, licensing, and connecting with the CData SSIS Components for ElevenLabs.
-
How to create an RPA flow for Aircall Data in UiPath Studio
Use the Aircall ODBC Driver to create workflows that access real-time Aircall without any coding.
-
Connect to Microsoft Dataverse Data from Crystal Reports
Use CData Connect AI to connect to and report on live Microsoft Dataverse (CDS) from Crystal Reports.
-
How to Connect to & Open SAP Data in Microsoft Excel
This article uses the CData ODBC driver for SAP to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automate Twilio Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Twilio from PowerShell? This article demonstrates how to utilize the Twilio Cmdlets for tasks like connecting to Twilio, automating operations, downloading data, and more.
-
Create Reports with Oracle Financials Cloud Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Oracle Financials Cloud.
-
Integrating Codex CLI with Factorial 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.
-
Access Live Gmail Data in Excel 365 Online (Excel for the web)
Connect to Gmail from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Configure the CData JDBC Driver for CouchDB in a Connection Pool in Tomcat
Connect to Apache CouchDB from a connection pool in Tomcat.
-
How to connect SharePoint with LDAP Objects through external lists
Provide LDAP to SharePoint users as an external list.
-
Access RSS Feeds 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 RSS Feeds.
-
Integrate Live WooCommerce Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Build Attio-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Attio and build web apps with connectivity to live Attio.
-
Import Reckon Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Reckon. In this article, you will use the OData format to import Reckon into Microsoft Power Query.
-
Automated Continuous HubDB Replication to Databricks
Use CData Sync for automated, continuous, customizable HubDB replication to Databricks.
-
Create Dashboards and Visualize Live JSON Services in Geckoboard
Use CData Connect AI to connect to live JSON and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Build GraphQL-Connected Apps in Choreo
Use CData Connect AI to connect to GraphQL Data from Choreo and build custom apps using live GraphQL.
-
Connect to and Query Basecamp Data in QlikView over ODBC
Create data visualizations with Basecamp in QlikView.
-
Access Live Azure Data Lake Storage 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 Azure Data Lake Storage through MCP integration.
-
Migrating data from DB2 to Databricks using CData SSIS Components.
Easily push IBM DB2 to Databricks using the CData SSIS Tasks for DB2 and Databricks.
-
Replicate Mailjet Data to Multiple Databases via the CData Sync CLI
Replicate Mailjet to disparate databases with a single configuration.
-
Integrating Claude Code CLI with YouTube Analytics 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.
-
Automated Continuous Todoist Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Todoist replication to Azure SQL Database.
-
How to Connect DBeaver to Klipfolio via a JDBC Driver
Manage Klipfolio with visual tools in DBeaver like the query browser.
-
Stream GetResponse Data into Apache Kafka Topics
Access and stream GetResponse in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Explore Geographical Relationships in IBM Informix Data with Power Map
Create data visualizations with IBM Informix in Power Map.
-
Connect to Sybase Data in Jaspersoft Studio
Execute SQL to remote Sybase in Jaspersoft Studio.
-
Connect to Microsoft Dataverse Data in Jaspersoft Studio
Execute SQL to remote Microsoft Dataverse (CDS) in Jaspersoft Studio.
-
Integrating Gumloop with SAS Data Sets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on SAS Data Sets within automated workflows.
-
Connect to PingOne Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for PingOne to connect to PingOne and execute queries in PowerBuilder.
-
Bidirectional Access to VWO Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate VWO in Filemaker Pro for Mac or Windows.
-
Integrate Theia IDE with Live SAP BusinessObjects BI Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Connect Shippo to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Shippo using the CData Python MCP Server.
-
Integrate Dynamics CRM with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Dynamics CRM with External Services.
-
Replicate Oracle HCM Cloud Data in Heroku for Use in Salesforce Connect
Replicate Oracle HCM Cloud to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrate Shopify Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Shopify and integrate live Shopify into your Power Automate tasks.
-
Integrate AlloyDB with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate AlloyDB with External Services.
-
Connect to Delighted Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Delighted and the SQL Gateway to access Delighted from Google Apps Script.
-
LINQ to Salesforce Marketing 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 Salesforce Marketing Data Provider.
-
Configure the CData Connect AI Connector for Looker Studio
Use the CData Connect AI Connector to connect to your CData Connect AI instance from Looker Studio.
-
Integrating Codex CLI with ConstantContact 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 Live Active Directory Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
How to connect to Oracle Financials Cloud Data with Squirrel SQL client
Connect to Oracle Financials Cloud and execute queries in the Squirrel SQL Client.
-
Create Reports from PostgreSQL Data in Looker Studio
Use CData Connect AI to gain access to live PostgreSQL and create custom reports in Looker Studio.
-
Build Dashboards with SAP Concur Data in DBxtra
Create dynamic dashboards and perform analytics based on SAP Concur in DBxtra.
-
Create SSAS Tabular Models from DB2 Data
How to build a SQL Server Analysis Service Tabular Model from IBM DB2 using CData drivers.
-
Use Microsoft Copilot Studio to talk to your Highrise 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 Highrise CRM for you.
-
Getting Started with the CData Power BI Connector for Clio
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Create Informatica Mappings From/To a JDBC Data Source for PingOne
Create PingOne data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Access Mailgun Data from MySQL in Amazon QuickSight
Connect to Mailgun and build visualizations of Mailgun using a MySQL Connection in Amazon QuickSight.
-
QuickBooks Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on QuickBooks facts in real time.
-
Connect to FTP Data from AWS Glue
Use CData Connect AI to gain access to live FTP Servers from your AWS Glue jobs.
-
Perform Batch Operations with Sage Intacct Data in Apache NiFi
Connect to Sage Intacct and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Migrating data from Unbounce to Databricks using CData SSIS Components.
Easily push Unbounce to Databricks using the CData SSIS Tasks for Unbounce and Databricks.
-
View Reports on Real-Time PolarTeamPro Data in Power BI Report Server
Use the CData ODBC Driver for PolarTeamPro to visualize PolarTeamPro in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrating Cursor CLI with Salesforce 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.
-
Use the CData Software ODBC Driver for Apollo in SAS for Real-Time Reporting and Analytics
Connect to real-time Apollo in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Apollo.
-
Query LinkedIn Ads Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume LinkedIn Ads entities in PHP by modeling them as objects.
-
Visualize Pipeliner CRM Data in Tableau
The CData ODBC driver for Pipeliner CRM enables you integrate Pipeliner CRM into Tableau dashboards.
-
How to Easily Query Sugar CRM Data in OpenOffice Base
Connect to Sugar CRM data in OpenOffice Base using the CData ODBC Driver for Sugar CRM and generate reports with live data insights.
-
Analyze Bugsnag Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Bugsnag in Microsoft R Open.
-
Replicate Elorus Data from PowerShell
Write a quick PowerShell script to query Elorus. Use connectivity to the live data to replicate Elorus to SQL Server.
-
DataBind Charts to Codat Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Codat 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.
-
How to Query Mistral AI Data in MySQL Workbench
Execute MySQL queries against live Mistral AI from MySQL Workbench.
-
Build Charts with Sage Intacct Data in Clear Analytics
Create dynamic charts and perform analytics based on Sage Intacct in Clear Analytics.