CData Software - Knowledge Base
Recent Articles
-
DataBind AfterShip Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide AfterShip to a chart.
-
Connect to WordPress Data in JRuby
Create a simple JRuby app with access to live WordPress.
-
Connect to Live Odoo Data in MicroStrategy through CData Connect AI
Create a live connection to Odoo Data in CData Connect AI and connect to your Odoo ERP from MicroStrategy.
-
Integrate with Live Reckon Accounts Hosted Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Reckon Accounts Hosted from the MuleSoft Anypoint Platform to integrate live Reckon Accounts Hosted into custom reports and dashboards.
-
Connect Qualaroo Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Qualaroo using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Manage Aha! Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Aha!.
-
Analyze SQL Server Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Microsoft SQL Server with the CData JDBC Driver for SQL Server.
-
Use the CData Software JDBC Driver for Sugar CRM in MicroStrategy
Connect to Sugar CRM in MicroStrategy Developer using the CData Software JDBC Driver for Sugar CRM.
-
Model SAP SuccessFactors LMS Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SAP SuccessFactors LMS, enabling the direct import of real-time SAP SuccessFactors LMS.
-
Connect to API Data in ACL Analytics
Connect to API via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to API.
-
Automate Parquet Data Replication to Couchbase
Use CData Sync to Customize and automate Apache Parquet replication to Couchbase.
-
Connect to MarkLogic Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live MarkLogic.
-
DataBind Controls to Todoist Data in Delphi
DataBind to Todoist in Delphi with standard data access components and controls.
-
Use Databricks Agent Bricks to Talk to Your Cvent Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Cvent for you.
-
Build a PostgreSQL Interface for Outreach.io Data using the CData JDBC Driver
Use the Remoting features of the Outreach.io JDBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Aweber 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 Aweber into TIBCO Spotfire.
-
Access Bannerbear Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Bannerbear from your Oracle system.
-
Automated Continuous Lakebase Replication to SingleStore
Use CData Sync for automated, continuous, customizable Lakebase replication to SingleStore.
-
Integrate Live Phoenix Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Phoenix from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Apache Phoenix.
-
Integrating Claude Code CLI with Figshare 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.
-
Bidirectional Access to Insightly Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Insightly in Filemaker Pro for Mac or Windows.
-
Visualize Live Twilio Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Twilio.
-
Create Facebook Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Facebook data access from reports, embedded analytics, and more.
-
Use Manus AI to Talk to Your Office 365 Data 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 Microsoft Office 365.
-
Query QuickBooks Time Data in DataGrip
Create a Data Source for QuickBooks Time in DataGrip and use SQL to query live QuickBooks Time.
-
DataBind Twilio Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Twilio with the DevExpress Windows Forms and Web controls to provide Twilio to a chart.
-
Build Facebook-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Facebook and build web apps with connectivity to live Facebook.
-
How to Connect to Live SAS xpt Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your SAS XPORT for you.
-
Back Up ConvertKit 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 ConvertKit data.
-
Use Claude to Talk to Your Phoenix 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 Apache Phoenix for you.
-
Add LionDesk Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for LionDesk with the Informatica Enterprise Data Catalog to classify and organize data.
-
Object-Relational Mapping (ORM) with PayPal 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 PayPal into a Java-based ORM framework, Hibernate.
-
Build SingleStore-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for SingleStore to explore live SingleStore Data in GitHub Copilot to assist with building SingleStore-powered applications.
-
Getting Started with the CData Power BI Connector for Zendesk
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Zendesk.
-
Connect to HelloSign Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for HelloSign.
-
Integrate Power BI XMLA Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Power BI XMLA from Informatica Cloud.
-
Connect to Facebook Ads from Asprova with CData Software ODBC Driver for Facebook Ads
This article shows how to connect faster to Facebook Ads data from Asprova.
-
Connect to Jira Data in Claris FileMaker Pro
Use the CData ODBC Driver for Jira in FileMaker Pro to connect to Jira and work with Atlassian Jira in your FileMaker applications.
-
Publish Reports with Microsoft OneDrive Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Microsoft OneDrive.
-
Automated Continuous Vertica Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Vertica replication to AlloyDB.
-
ETL Tickspot in Oracle Data Integrator
This article shows how to transfer Tickspot into a data warehouse using Oracle Data Integrator.
-
Migrating data from Microsoft Entra ID to Snowflake using CData SSIS Components.
Easily push Microsoft Entra ID to Snowflake using the CData SSIS Tasks for Microsoft Entra ID and Snowflake.
-
Connect Google Campaign Manager 360 Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Google Campaign Manager 360 using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Consume FTP OData Feeds in PowerBuilder
This article demonstrates how to consume FTP Servers as OData feeds from PowerBuilder using the API Server.
-
Getting Started with the CData Tableau Connector for Amazon S3
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Amazon S3.
-
Integrating Kiro CLI with Mouseflow 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.
-
Visualize SAP HANA XS Advanced Data in Tableau
The CData ODBC driver for SAP HANA XS Advanced enables you integrate SAP HANA XS Advanced into Tableau dashboards.
-
Connect to Beeminder Data in JRuby
Create a simple JRuby app with access to live Beeminder.
-
Automated Continuous Hive Replication to MongoDB
Use CData Sync for automated, continuous, customizable Hive replication to MongoDB.
-
Connect to Salesforce Pardot Data in JRuby
Create a simple JRuby app with access to live Salesforce Pardot.
-
Build Workday-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Workday to explore live Workday Data in Cursor to assist with building Workday-powered applications.
-
Connect to Epicor Kinetic Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Epicor Kinetic.
-
Connecting Mastra with NetSuite SuiteAnalytics 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 NetSuite SuiteAnalytics, no replication required.
-
How to Connect to Live Salesforce CRM Analytics 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 Salesforce CRM Analytics for you.
-
Access SharePoint Data from MySQL in PHP
Connect to SharePoint through the standard MySQL libraries in PHP.
-
How to Visualize Zoho Projects Data in Python with pandas
Use pandas and other modules to analyze and visualize live Zoho Projects in Python.
-
How to Work with SAP Data in AWS Glue Jobs Using JDBC
Connect to SAP from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to connect and process iContact from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live iContact.
-
How to Connect to Live Zoho Books Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Zoho Books for you.
-
Create a Data Access Object for Hugging Face Data using JDBI
A brief overview of creating a SQL Object API for Hugging Face in JDBI.
-
Integrating LangGraph with SQL Analysis Services Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on SQL Analysis Services within automated workflows.
-
Build AI/ML Models with Live Stack Exchange Data using Dataiku
Connect Stack Exchange Data with Dataiku using the CData API Driver for JDBC.
-
Connect to iContact Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for iContact in the Denodo Virtual DataPort Administrator.
-
Work with Tally Data in FoxPro
Load Tally ERP into a FoxPro database. This article includes full code and a walk-through of the process.
-
Mistral AI Reporting in OBIEE with the Mistral AI JDBC Driver
Deploy the Mistral AI JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrate PabblySubscriptions Data in Pentaho Data Integration
Build ETL pipelines based on PabblySubscriptions in the Pentaho Data Integration tool.
-
Integrating GitHub Copilot CLI with Simplesat 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.
-
Configure the CData JDBC Driver for OpenWeatherMap in a Connection Pool in Tomcat
Connect to OpenWeatherMap from a connection pool in Tomcat.
-
Working with MailerLite Data in LINQPad
Execute LINQ queries to MailerLite in LINQPad.
-
Automated Continuous SAP HANA Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable SAP HANA replication to Apache Kafka.
-
Manage YouTube Analytics Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for YouTube Analytics.
-
Connect to Tanda Data from a Connection Pool in JBoss
Integrate Tanda into Java servlets: Use the Management Console in JBoss to install the Tanda JDBC Driver.
-
Migrating data from Procore to Google BigQuery using CData SSIS Components.
Easily push Procore to Google BigQuery using the CData SSIS Tasks for Procore and Google BigQuery.
-
Work with Live Presto Data in Power Query
Use CData Connect AI to connect to Presto and work with live Presto in Microsoft Power Query.
-
Connect to Vertica Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Vertica.
-
Visualize your Salesforce Data in Tibco Spotfire
Connect to Salesforce as an ADO.NET data source and create a simple dashboard in TIBCO Spotfire.
-
Connect to Adobe Analytics Data in RapidMiner
Integrate Adobe Analytics with standard components and data source configuration wizards in RapidMiner Studio.
-
Prepare, Blend, and Analyze MailerSend Data in Alteryx Designer (ODBC)
Build workflows to access live MailerSend for self-service data analytics.
-
Connect and Query Live EnterpriseDB Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live EnterpriseDB into Databricks
-
Build Apps with Live Gmail in Adalo using CData Connect AI
Use CData Connect AI to integrate live Gmail into the Adalo platform and build custom mobile and web applications with real-time Gmail.
-
Load Float Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Float to a database.
-
Connecting Moonlit Workflow with Google Contacts Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Google Contacts in real time.
-
Use ChatGPT to Talk to Your NetSuite SuiteAnalytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your NetSuite SuiteAnalytics for you.
-
Getting Started with the CData JDBC Driver for FreshBooks
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for FreshBooks.
-
Connect to Zoho Projects Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Automated Continuous Figshare Replication to Oracle
Use CData Sync for automated, continuous, customizable Figshare replication to Oracle.
-
Access Live Zuora Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Zuora from your Excel spreadsheets.
-
Import and Visualize Office 365 Data in Power View
Create data visualizations based on Microsoft Office 365 in Excel.
-
Connect to Autopilot from a Connection Pool in WebLogic
Use the CData JDBC Driver for Autopilot to connect to Autopilot from Web applications running on WebLogic.
-
Operational Reporting on Teamwork Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Teamwork.
-
Provide OData Services of GitHub Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for GitHub by developing a WCF Service Application.
-
Connect to Raisers Edge NXT Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Prepare, Blend, and Analyze Bannerbear Data in Alteryx Designer (ODBC)
Build workflows to access live Bannerbear for self-service data analytics.
-
How to Seamlessly Import Bitly Data into IBM SPSS Modeler
Integrate Bitly data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Chargebee-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Chargebee.
-
Create Power BI Reports on Real-Time Google Ads Data
Use the CData ODBC Driver for Google Ads to visualize Google Ads in Power BI Desktop.
-
Visualize Live Excel Online Data in the Power BI Service
Use CData Connect AI to connect to live Microsoft Excel Online and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Design SQL Server Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to SQL Server from mobile and tablet Power Apps.
-
How to Easily Query Brex Data in OpenOffice Base
Connect to Brex data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to Connect DBeaver to CircleCI via a JDBC Driver
Manage CircleCI with visual tools in DBeaver like the query browser.