CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Google Translate Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Google Translate data replication to OneLake in Microsoft Fabric.
-
Integrate Coda with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Coda with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Coda data.
-
Connect to Deel Data in Aqua Data Studio
Access Deel data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Connect to Live NetSuite SuiteAnalytics Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live NetSuite SuiteAnalytics data securely in real time.
-
Use Dash to Build to Web Apps on Instagram Data
Create Python applications that use pandas and Dash to build Instagram-connected web apps.
-
Access Live Sage 200 Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Sage 200 data from your Google Sheets.
-
Write a Simple Go Application to work with SparkPost Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SparkPost data.
-
DataBind JSON Services to the DevExpress Data Grid
Use the CData ADO.NET Provider for JSON with the DevExpress Windows Forms and Web controls to provide JSON services to a chart.
-
Use Claude to Talk to Your Authorize.Net 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 Authorize.Net data for you.
-
Automated CampaignMonitor Data Replication to Teradata
Use CData Sync to Customize and automate CampaignMonitor data replication to Teradata.
-
Automate Mixpanel Data Replication to Azure Synapse
Use CData Sync to customize and automate Mixpanel data replication to Azure Synapse.
-
Access Live SendGrid Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SendGrid data into the statistical analysis tools available in SAS JMP. This article shows how to use SendGrid data in the Graph Builder and Query Builder.
-
Connect to Everhour Data from a Connection Pool in JBoss
Integrate Everhour data into Java servlets: Use the Management Console in JBoss to install the Everhour JDBC Driver.
-
How to connect PolyBase to Pinterest
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Pinterest data.
-
Replicate Office 365 Data to Multiple Databases via the CData Sync CLI
Replicate Office 365 data to disparate databases with a single configuration.
-
Integrating Gumloop with Bannerbear Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Bannerbear data within automated workflows.
-
Build Miro-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Miro data.
-
Feed Slack Data into FineReport
How to set Slack data as a JDBC data source in FineReport.
-
Analyze Live GraphQL Data in SAS Viya
Use CData Connect AI to connect to GraphQL data from SAS Viya and deploy self-service analytics using live GraphQL data.
-
Create Data Visualizations in Cognos BI with ZohoMarketingHub Data
Access ZohoMarketingHub data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Analyze Google Drive Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Google Drive data with the CData JDBC Driver for Google Drive.
-
Automated Continuous PhantomBuster Replication to AlloyDB
Use CData Sync for automated, continuous, customizable PhantomBuster replication to AlloyDB.
-
Integrate BigQuery Data in the Pentaho Report Designer
Publish reports based on BigQuery data in the Pentaho BI tool.
-
Build Semantic Layer Views for Perplexity Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Perplexity data.
-
Moving Data from Retently to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Retently data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to SAP Business One Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for SAP Business One data in the Denodo Virtual DataPort Administrator.
-
Access Live BenchmarkEmail Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate BenchmarkEmail data into the statistical analysis tools available in SAS JMP. This article shows how to use BenchmarkEmail data in the Graph Builder and Query Builder.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for LinkedIn
Provide connectivity to LinkedIn data through an SAP BusinessObjects universe.
-
How to Visualize Todoist Data in Python with pandas
Use pandas and other modules to analyze and visualize live Todoist data in Python.
-
Access GraphQL Data from MySQL in PHP
Connect to GraphQL through the standard MySQL libraries in PHP.
-
Connect to WordPress Data in Aqua Data Studio
Access WordPress data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Access Freshteam Data 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 Freshteam data.
-
Automated Harvest Data Replication to Teradata
Use CData Sync to Customize and automate Harvest data replication to Teradata.
-
Use Microsoft Copilot Studio to talk to your SAP Ariba Source 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 SAP Ariba Source data for you.
-
Easily Integrate SendInBlue Data in Lazarus Pascal IDE
Learn how to easily integrate live SendInBlue data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Consume AlloyDB OData Feeds in PowerBuilder
This article demonstrates how to consume AlloyDB data as OData feeds from PowerBuilder using the API Server.
-
Moving Data from Stack Exchange to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Stack Exchange data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrate Theia IDE with Live Asana 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 Asana data from within the development environment.
-
Use JayDeBeApi to access Parquet Data in Python
Use standard Python scripting and the development environment of your choice to access live Parquet data.
-
Operational Reporting on PhantomBuster Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote PhantomBuster data.
-
A PostgreSQL Interface for Pipeline CRM Data (MySQL Remoting via JDBC)
Use the Remoting features of the Pipeline CRM JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect and Visualize Live Moosend Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Moosend data into the Databricks platform and create visualization dashboards with real-time Moosend data.
-
Access Live Amazon Marketplace Data in AWS Lambda
Connect to live Amazon Marketplace data in AWS Lambda using the CData JDBC Driver.
-
Enable the AlloyDB JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with AlloyDB data.
-
How to import Adobe Analytics Data into Apache Solr
Use the CData Software JDBC Driver for Adobe Analytics in Data Import Handler and create an automated import of Adobe Analytics data to Apache Solr Enterprise Search platform.
-
Access Live ConvertKit Data in AWS Lambda (with IntelliJ IDEA)
Connect to live ConvertKit data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Access Vercel Data 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 Vercel data.
-
Build MVC Applications with Connectivity to Zoho Inventory Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Zoho Inventory from an ASP.NET MVC application.
-
Bridge Smartsheet Connectivity with Apache NiFi
Access and process Smartsheet data in Apache NiFi using the CData JDBC Driver.
-
Use the CData Software JDBC Driver for Klaviyo in MicroStrategy Desktop
Connect to Klaviyo data in MicroStrategy Desktop using the CData Software JDBC Driver for Klaviyo.
-
Build an OLAP Cube in SSAS from Kafka Data
Establish a connection to Kafka data data from SQL Server Analysis Services, and use the Kafka Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate Devin with Live GitHub Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live GitHub data.
-
Link SurveyMonkey with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SurveyMonkey data in Filemaker Pro for Mac or Windows.
-
Access Twitter Ads Data from MySQL in PHP
Connect to Twitter Ads through the standard MySQL libraries in PHP.
-
Build Semantic Layer Views for Moosend Data in APOS Live Data Gateway
Use the CData Connector for Moosend in APOS Live Data Gateway to build Semantic Layer Views for Moosend data.
-
Access ZohoPeople Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access ZohoPeople data from your Oracle system.
-
Build Voice Agents in ElevenLabs with access to Live ZohoSubscriptions Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live ZohoSubscriptions data.
-
Integrate with Sybase IQ Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Sybase IQ data in SnapLogic.
-
Establish a Live Connection with Salesloft Data using Tableau Bridge
The CData ODBC Driver for Salesloft enables you to integrate live Salesloft data into Tableau Cloud dashboards using the Tableau Bridge.
-
Automated Continuous Eventbrite Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Eventbrite replication to Azure SQL Database.
-
Use the CData ODBC Driver for AfterShip from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for AfterShip to connect to AfterShip data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring AfterShip data in Excel.
-
Visualize Confluence Data in TIBCO Spotfire through OData
Integrate Confluence data into dashboards in TIBCO Spotfire.
-
Connect to Cassandra Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Cassandra data using standard SQL.
-
Getting Started with the CData Tableau Connector for Reckon Accounts Hosted
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Reckon Accounts Hosted.
-
Load LinkedIn Ads Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load LinkedIn Ads data to a database.
-
LINQ to Egnyte 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 Egnyte Data Provider.
-
Build Google Forms-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Google Forms data and build Google Forms-connected web apps with Axios.
-
Build Data Flows from SQL Server to SendGrid through SSIS
Easily push SQL Server data to SendGrid using the CData SSIS Tasks for SendGrid.
-
Visualize SAP 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 SAP data into TIBCO Spotfire.
-
Process & Analyze Gong Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Gong Data.
-
Connect Oracle HCM Cloud to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Oracle HCM Cloud with IBM WebSphere for seamless data integration and connectivity.
-
How to Build an ETL App for Act-On Data in Python with CData
Create ETL applications and real-time data pipelines for Act-On data in Python with petl.
-
Create Kafka-Connected Applications in Appsmith
Connect to Kafka Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Kafka data.
-
Connect to Microsoft Ads Data in JRuby
Create a simple JRuby app with access to live Microsoft Ads data.
-
Query Live OneNote Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live OneNote data through a conversational interface.
-
Use the CData Software JDBC Driver for Vault CRM in MicroStrategy Desktop
Connect to Vault CRM data in MicroStrategy Desktop using the CData Software JDBC Driver for Vault CRM.
-
Use the CData Software JDBC Driver for Sentry in MicroStrategy Web
Connect to Sentry data in MicroStrategy Web using the CData Software JDBC Driver for Sentry.
-
Query MailChimp Data as a SQL Server Database in Node.js
Execute SQL Server queries against MailChimp data from Node.js.
-
How to work with Sage 300 Data in Apache Spark using SQL
Access and process Sage 300 Data in Apache Spark using the CData Software JDBC Driver.
-
Build Visualizations of SuiteCRM Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SuiteCRM data in Birst.
-
Use Grok to Talk to Your Zuora Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Zuora data for you.
-
How to Connect the Power BI Service to Unbounce: Complete Guide
Connect to the CData Software Power BI Connector for Unbounce from PowerBI.com to provide real-time Unbounce data across the organization.
-
Use the CData Software JDBC Driver for Mistral AI in MicroStrategy Desktop
Connect to Mistral AI data in MicroStrategy Desktop using the CData Software JDBC Driver for Mistral AI.
-
Use the CData SSIS Components to Insert New or Update Existing Email Records from SQL Server
Easily push SQL Server data to Email using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Email or update existing records with data from a SQL Server database.
-
Zoho CRM Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Zoho CRM facts in real time.
-
Build SAP ByDesign-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live SAP ByDesign data and build SAP ByDesign-connected web apps with Axios.
-
Connect to SAS Data Sets Data in CloverDX (formerly CloverETL)
Transfer SAS Data Sets data using the visual workflow in the CloverDX data integration tool.
-
Connect Google Tasks to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Google Tasks data using the CData Python MCP Server.
-
Connect to SAP Concur in SpagoBI
Create reports featuring live SAP Concur data in SpagoBI Studio. Host SAP Concur reports on SpagoBI Server.
-
Deploy the ADO.NET Provider for Toggl on an SSRS Report Server
Connect to Toggl data 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.
-
Explore Geographical Relationships in SAP Business One Data with Power Map
Create data visualizations with SAP Business One data in Power Map.
-
Connect to Zoho Creator Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Zoho Creator and the Script function in FileMaker Pro to connect to Zoho Creator and work with Zoho Creator data in your FileMaker application.
-
Build Charts with AlloyDB Data in Clear Analytics
Create dynamic charts and perform analytics based on AlloyDB data in Clear Analytics.
-
Automated Continuous Strava Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Strava data replication to OneLake in Microsoft Fabric.
-
Operational Reporting on Invoiced Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Invoiced data.
-
DataBind Controls to Sage 300 Data in Delphi
DataBind to Sage 300 data in Delphi with standard data access components and controls.
-
Automated Continuous Freshservice Replication to SQL Server
Use CData Sync for automated, continuous, customizable Freshservice replication to SQL Server.
-
Use the CData Software JDBC Driver for OnePageCrm in MicroStrategy Web
Connect to OnePageCrm data in MicroStrategy Web using the CData Software JDBC Driver for OnePageCrm.
-
Create Data Visualizations in Cognos BI with HDFS Data
Access HDFS data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
DataBind Controls to Sybase Data in Delphi
DataBind to Sybase data in Delphi with standard data access components and controls.