CData Software - Knowledge Base
Recent Articles
-
Build Semantic Layer Views for eBay Data in APOS Live Data Gateway
Use the CData Connector for eBay in APOS Live Data Gateway to build Semantic Layer Views for eBay.
-
Operational Reporting on Shortcut Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Shortcut.
-
How to connect to Airtable Data with Squirrel SQL client
Connect to Airtable and execute queries in the Squirrel SQL Client.
-
Automated Continuous Dynamics 365 Business Central Replication to MongoDB
Use CData Sync for automated, continuous, customizable Dynamics 365 Business Central replication to MongoDB.
-
Connect to and Query Salesforce Data in QlikView over ODBC
Create data visualizations with Salesforce & Force.com in QlikView.
-
Build Wrike-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Wrike.
-
ConvertKit Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on ConvertKit facts in real time.
-
Extract, Transform, and Load Pinterest Data in Informatica PowerCenter
Create a simple Workflow for Pinterest in Informatica PowerCenter.
-
Build a Simple VCL Application for Figshare Data
How to build a simple VCL Application to view Figshare in RAD Studio using the CData ODBC Driver for Figshare.
-
Build Dashboards with Salesforce Marketing Data in DBxtra
Create dynamic dashboards and perform analytics based on Salesforce Marketing Cloud in DBxtra.
-
Build Voice Agents in ElevenLabs with access to Live SAP Business One Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live SAP Business One.
-
Connect to Dynamics 365 Data from PowerBuilder via JDBC
This article demonstrates how to access Microsoft Dynamics 365 from PowerBuilder using the Dynamics 365 JDBC Driver.
-
Create Data Visualizations in Cognos BI with Google Ad Manager Data
Access Google Ad Manager as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrate NASA Data in Pentaho Data Integration
Build ETL pipelines based on NASA in the Pentaho Data Integration tool.
-
LINQ to Scrapfly 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 Scrapfly Data Provider.
-
How to Work with GitLab Data in AWS Glue Jobs Using JDBC
Connect to GitLab from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Use Databricks Agent Bricks to Talk to Your SAP Concur Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your SAP Concur for you.
-
Query Live Microsoft Dataverse 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 Microsoft Dataverse (CDS) directly from the development environment.
-
Natively Connect to SAS xpt Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to SAS XPORT. Leverage the native support for ODBC in PHP.
-
Access Live OneNote Data in Coginiti Pro
Connect to and query live Microsoft OneNote from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automated Continuous Adobe Target Replication to MongoDB
Use CData Sync for automated, continuous, customizable Adobe Target replication to MongoDB.
-
Import Real-Time Avaza Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Avaza in ColdFusion.
-
Create Mailjet Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Mailjet from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrate with Adobe Analytics Data in JReport Designer
Create charts and reports based on Adobe Analytics in JReport Designer.
-
How to Connect to Live NetSuite SuiteAnalytics 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 NetSuite SuiteAnalytics through natural language.
-
Query REST Data in ColdFusion
Write standard ColdFusion data access code to connect to REST.
-
Connect to Attio Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Attio and the SQL Gateway to access Attio from Google Apps Script.
-
Use Claude to Talk to Your Snapchat Ads 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 Snapchat Ads for you.
-
Create Informatica Mappings From/To an ODBC Data Source for FreshBooks
Create an ODBC connection to FreshBooks in Informatica and browse and transfer FreshBooks.
-
Automated Continuous Microsoft Ads Replication to SingleStore
Use CData Sync for automated, continuous, customizable Microsoft Ads replication to SingleStore.
-
Use Biml to Build SSIS Tasks to Replicate LinkedIn Ads Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate LinkedIn Ads to SQL Server.
-
Visualize Pipeline CRM Data in Sisense
Create an ElastiCube in Sisense app with access to Pipeline CRM.
-
Create a Data Access Object for DB2 Data using JDBI
A brief overview of creating a SQL Object API for IBM DB2 in JDBI.
-
Query Salesloft Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Salesloft entities in PHP by modeling them as objects.
-
How to Connect to Live Oracle HCM Cloud 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 Oracle HCM Cloud for you.
-
Publish Crystal Reports on Oracle Service Cloud Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Oracle Service Cloud.
-
Build Visualizations of LaunchDarkly Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of LaunchDarkly in Birst.
-
Connect to Cloudant Data in HULFT Integrate
Connect to Cloudant as a JDBC data source in HULFT Integrate
-
Analyze Xero Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Xero Accounting in Microsoft R Open.
-
Connect to Facebook Data in DBArtisan
Use wizards in DBArtisan to configure Facebook as a data source.
-
Connect to Strava Data from PowerBuilder via JDBC
This article demonstrates how to access Strava from PowerBuilder using the Strava JDBC Driver.
-
Connecting Agentforce with Dynamics CRM Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Microsoft Dynamics CRM for you.
-
Connect to Adobe Analytics Data in Ruby
Connect to Adobe Analytics in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Work with MYOB AccountRight Data in ETL Validator JDBC
Connect to MYOB AccountRight from ETL Validator jobs using the CData Software JDBC Driver.
-
Use the CData Software ODBC Driver for CockroachDB in MicroStrategy Desktop
Connect to CockroachDB in MicroStrategy Desktop using the CData Software ODBC Driver for CockroachDB.
-
How to Build an ETL App for SAP Netweaver Gateway Data in Python with CData
Create ETL applications and real-time data pipelines for SAP Netweaver Gateway in Python with petl.
-
Getting Started with the CData ADO.NET Provider for Supabase
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Integrating Klipfolio Data in Talend Cloud Data Management Platform
Connect Klipfolio Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Create a Data Access Object for Google Ads Data using JDBI
A brief overview of creating a SQL Object API for Google Ads in JDBI.
-
A PostgreSQL Interface for Onfleet Data (MySQL Remoting via JDBC)
Use the Remoting features of the Onfleet JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Live Sybase Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Connect to Google Spanner Data from a Connection Pool in Jetty
The Google Spanner JDBC Driver supports connection pooling: This article shows how to connect faster to Google Spanner from Web apps in Jetty.
-
Getting Started with the CData SSIS Components for NetSuite
Complete guide to installing, licensing, and connecting with the CData SSIS Components for NetSuite.
-
Connect to Live Xero Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Xero in CData Connect AI and connect to your Xero Accounting from PostgreSQL.
-
Viewing Salesloft Data in RAD Studio Data Explorer
How to view Salesloft in RAD Studio Data Explorer using the CData ODBC Driver for Salesloft.
-
Analyze SAS Data Sets Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of SAS Data Sets and visualize live SAS Data Sets in Infragistics Reveal.
-
How to Work with Dynamics 365 Business Central Data in ETL Validator JDBC
Connect to Dynamics 365 Business Central from ETL Validator jobs using the CData Software JDBC Driver.
-
View Reports on Real-Time Postmark Data in Power BI Report Server
Use the CData ODBC Driver for Postmark to visualize Postmark in Power BI Desktop and then publish them to Power BI Report Server.
-
Create Reports from ServiceNow Data in Looker Studio
Use CData Connect AI to gain access to live ServiceNow and create custom reports in Looker Studio.
-
Build an OLAP Cube in SSAS from SAP Concur Data
Establish a connection to SAP Concur data from SQL Server Analysis Services, and use the SAP Concur Data Provider to build OLAP cubes for use in analytics and reporting.
-
Migrating data from ShipEngine to Databricks using CData SSIS Components.
Easily push ShipEngine to Databricks using the CData SSIS Tasks for ShipEngine and Databricks.
-
Build Google Search-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Google Search and build web apps with connectivity to live Google Search.
-
Build Visualizations of Confluence Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Atlassian Confluence in Birst.
-
Visualize Live Teradata Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Teradata using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Visualize Factorial Data in Python with pandas
Use pandas and other modules to analyze and visualize live Factorial in Python.
-
Use Manus AI to Talk to Your Zoho Books 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 Zoho Books.
-
Operational Reporting on Anaplan Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Anaplan.
-
Build MVC Applications with Connectivity to Mode Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Mode from an ASP.NET MVC application.
-
Automated Continuous Twitter Ads Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Twitter Ads replication to Google Cloud SQL.
-
Integrate Goose with Live Monday.com Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Monday.com from within the local AI agent.
-
How to Build an ETL App for Brex Data in Python with CData
Create ETL applications and real-time data pipelines for Brex in Python with petl.
-
Visualize Live Mistral AI Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Mistral AI.
-
Analyze Apify Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Apify with the CData JDBC Driver for Apify.
-
Import Real-Time Google Forms Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Google Forms in ColdFusion.
-
Visualize Live Epicor Kinetic Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Epicor Kinetic using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Create Power BI Visual Reports with Real-Time Guru Data
Use CData Power BI Connectors to visualize Guru in Power BI.
-
Natively Connect to Shippo Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Shippo. Leverage the native support for ODBC in PHP.
-
Visualize CampaignMonitor Data in TIBCO Spotfire through ADO.NET
Integrate CampaignMonitor into dashboards in TIBCO Spotfire.
-
Build Azure Table-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Azure Table Storage.
-
Write a Simple Go Application to work with Yelp Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Yelp.
-
Connect to Teamwork Data in DBArtisan
Use wizards in DBArtisan to configure Teamwork as a data source.
-
Access Live Mocean Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Mocean into the statistical analysis tools available in SAS JMP. This article shows how to use Mocean in the Graph Builder and Query Builder.
-
Build Data Flows from ADP to SQL Server using SSIS
Easily back up ADP to SQL Server using the SSIS components for ADP.
-
Automated Continuous Salesforce Marketing Replication to SQLite
Use CData Sync for automated, continuous, customizable Salesforce Marketing replication to SQLite.
-
Automated Continuous Clio Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Clio replication to Google BigQuery.
-
View Reports on Real-Time Hacker News Data in Power BI Report Server
Use the CData ODBC Driver for Hacker News to visualize Hacker News in Power BI Desktop and then publish them to Power BI Report Server.
-
Build Voice Agents in ElevenLabs with access to Live Oracle Sales Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Oracle Sales.
-
Connect to Google Calendar Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Google Calendar Data and connect to Google Calendar in Akorbi Digital RunMyProcess.
-
Establish a Live Connection with OnePageCrm Data using Tableau Bridge
The CData ODBC Driver for OnePageCrm enables you to integrate live OnePageCrm into Tableau Cloud dashboards using the Tableau Bridge.
-
Excel Spreadsheet Automation on Reckon Data with the QUERY Formula
Pull data from Reckon, automate spreadsheets, and more with the QUERY formula.
-
How to work with Insightly Data in Apache Spark using SQL
Access and process Insightly Data in Apache Spark using the CData Software JDBC Driver.
-
Publish Google Search-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Google Search.
-
Connect to Live Act-On Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Act-On in CData Connect AI and connect to your Act-On from PostgreSQL.
-
Integrating Boomi Agentstudio with Gmail Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Gmail, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Build Agents in Relevance AI with Access to Live Databricks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Databricks within intelligent agent workflows.
-
Edit and Search Adobe Target External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Adobe Target to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Adobe Target objects that you can access from apps and the dashboard.
-
Build Visualizations of Aircall Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Aircall in Birst.
-
Build Azure Table-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Azure Table to explore live Azure Table Data in Claude Code to assist with building Azure Table-powered applications.
-
Build a PostgreSQL Interface for Google Calendar Data using the CData JDBC Driver
Use the Remoting features of the Google Calendar JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Spotify Data from a Connection Pool in Jetty
The Spotify JDBC Driver supports connection pooling: This article shows how to connect faster to Spotify from Web apps in Jetty.