CData Software - Knowledge Base
Recent Articles
-
How to Access Stack Exchange Data Using Entity Framework
This article shows how to access Stack Exchange using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Visualize Live Marketo Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Marketo.
-
Replicate Google Campaign Manager 360 Data in Heroku for Use in Salesforce Connect
Replicate Google Campaign Manager 360 to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Use the CData ODBC Driver for FTP from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for FTP to connect to FTP Servers from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring FTP Servers in Excel.
-
Integrating Kiro CLI with Aha! 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.
-
Integrating LlamaIndex with Paylocity Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Paylocity in real time.
-
Build CouchDB-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for CouchDB Data and create custom apps in Mendix.
-
Connect to Nuclia Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Nuclia and the SQL Gateway to access Nuclia from Google Apps Script.
-
How to connect to GitHub Data from Spring Boot
Connect to GitHub in a Spring Boot Application using the CData JDBC Driver for GitHub
-
Access Live SingleStore Data in AWS Lambda
Connect to live SingleStore in AWS Lambda using the CData JDBC Driver.
-
Build AI/ML Models with Live ServiceDesk Plus Data using Dataiku
Connect ServiceDesk Plus Data with Dataiku using the CData API Driver for JDBC.
-
Getting Started with the CData Connect AI Python SDK for Oracle Sales
Install the CData Connect AI Python SDK to read and write live Oracle Sales with standard DB-API 2.0 Python code.
-
Automated Continuous GetResponse Replication to Oracle
Use CData Sync for automated, continuous, customizable GetResponse replication to Oracle.
-
How to Build an ETL App for Azure Synapse Data in Python with CData Connect AI
Build ETL pipelines that read and write live Azure Synapse in Python with petl and the CData Connect AI Python SDK.
-
Using the CData Software ODBC Driver for SAP Business One in PyCharm
Connect to SAP Business One as an ODBC data source in PyCharm using the CData Software ODBC Driver for SAP Business One.
-
Viewing CampaignMonitor Data in RAD Studio Data Explorer
How to view CampaignMonitor in RAD Studio Data Explorer using the CData ODBC Driver for CampaignMonitor.
-
Integrating Claude Code CLI with MailChimp 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.
-
Create Hacker News Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Hacker News data access from reports, embedded analytics, and more.
-
How to connect to Sage 300 Data in DBVisualizer
Integrate Sage 300 with visual data analysis tools and data connection wizards in DBVisualizer
-
Automate IBM Cloud Object Storage Data Replication to Azure Data Lake
Use CData Sync to customize and automate IBM Cloud Object Storage replication to Azure Data Lake.
-
Using the CData Software ODBC Driver for Google Cloud Storage in PyCharm
Connect to Google Cloud Storage as an ODBC data source in PyCharm using the CData Software ODBC Driver for Google Cloud Storage.
-
Automated Continuous Teradata Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Teradata replication to Azure SQL Database.
-
Analyze Amazon Marketplace Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Amazon Marketplace with the CData JDBC Driver for Amazon Marketplace.
-
Connecting GenSpark with Amazon DynamoDB Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Amazon DynamoDB without any replication or custom integration required.
-
DataBind Controls to Slack Data in Delphi
DataBind to Slack in Delphi with standard data access components and controls.
-
Automated Continuous Xero Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Xero replication to Google BigQuery.
-
Replicate Sage 300 Data in Heroku for Use in Salesforce Connect
Replicate Sage 300 to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connecting Agentforce with Databricks 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 Databricks for you.
-
Build ConvertKit-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live ConvertKit.
-
DataBind Charts to Oracle Financials Cloud Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Oracle Financials Cloud 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.
-
Connecting Moonlit Workflow with Exact Online 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 Exact Online in real time.
-
Integrating Codex CLI with Salesforce CRM Analytics 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 Live Miro Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Miro using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Connect DBeaver to Ontraport via a JDBC Driver
Manage Ontraport with visual tools in DBeaver like the query browser.
-
Visualize Live ZohoMarketingHub Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live ZohoMarketingHub.
-
Use the CData Software ODBC Driver for Copper in SAS for Real-Time Reporting and Analytics
Connect to real-time Copper in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Copper.
-
Access ZohoSubscriptions Data from MySQL in Amazon QuickSight
Connect to ZohoSubscriptions and build visualizations of ZohoSubscriptions using a MySQL Connection in Amazon QuickSight.
-
Connect to JotForm in SpagoBI
Create reports featuring live JotForm in SpagoBI Studio. Host JotForm reports on SpagoBI Server.
-
Viewing Google Contacts Data in RAD Studio Data Explorer
How to view Google Contacts in RAD Studio Data Explorer using the CData ODBC Driver for Google Contacts.
-
Connect to SparkPost Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for SparkPost.
-
Use the CData Software JDBC Driver for Xero in MicroStrategy Web
Connect to Xero Accounting in MicroStrategy Web using the CData Software JDBC Driver for Xero.
-
Integrating Antigravity CLI with Microsoft SQL Server via CData CLI
Connect Microsoft SQL Server to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Getting Started with the CData SSIS Components for CloudConvert
Complete guide to installing, licensing, and connecting with the CData SSIS Components for CloudConvert.
-
Connect to Amazon Marketplace Data in NetBeans
Connect to Amazon Marketplace in NetBeans with the data source configuration wizard.
-
Connect Avalara AvaTax Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Avalara AvaTax using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build Visualizations of Hugging Face Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Hugging Face in Birst.
-
How to work with Pushbullet Data in Apache Spark using SQL
Access and process Pushbullet Data in Apache Spark using the CData Software JDBC Driver.
-
Build Office 365-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Microsoft Office 365 and build Office 365-connected web apps with Axios.
-
Query xBase Data in DataGrip
Create a Data Source for xBase in DataGrip and use SQL to query live xBase.
-
Build GraphQL-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live GraphQL and build GraphQL-connected web apps with Axios.
-
Access Live Demio Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Demio in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Import Real-Time SAP HANA Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SAP HANA in ColdFusion.
-
Build an OLAP Cube in SSAS from Google Directory Data
Establish a connection to Google Directory data from SQL Server Analysis Services, and use the Google Directory Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to import GetResponse Data into Apache Solr
Use the CData Software JDBC Driver for GetResponse in Data Import Handler and create an automated import of GetResponse to Apache Solr Enterprise Search platform.
-
Build Charts with Google Tasks Data in Clear Analytics
Create dynamic charts and perform analytics based on Google Tasks in Clear Analytics.
-
Access Live WordPress Data in AWS Lambda
Connect to live WordPress in AWS Lambda using the CData JDBC Driver.
-
Analyze Salesforce Data 360 Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Salesforce Data 360 and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Create RSS Dataflows on PowerBI.com
Connect to the CData Power BI Connector for RSS from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build Automated Workflows with Live Box Data in Workato
Use CData Connect AI to connect to live Box and build automated workflows in Workato.
-
Connect and Query Live DB2 Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live IBM DB2 into Databricks
-
Model, Search, and Visualize Live Phoenix Data in ThoughtSpot
Use CData Connect AI to connect to live Apache Phoenix for modeling, searching, and visualizing.
-
Create Informatica Mappings From/To a JDBC Data Source for Short.io
Create Short.io data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Outreach.io Data in DBArtisan
Use wizards in DBArtisan to configure Outreach.io as a data source.
-
Integrate Hacker News with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Hacker News with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Hacker News.
-
Easily Integrate Moosend Data in Lazarus Pascal IDE
Learn how to easily integrate live Moosend in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Access ElevenLabs Data from MySQL in Amazon QuickSight
Connect to ElevenLabs and build visualizations of ElevenLabs using a MySQL Connection in Amazon QuickSight.
-
How to Connect to Jumpseller Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Jumpseller. Leverage the pyodbc module for ODBC in Python.
-
Connect to Power BI XMLA Data from PowerBuilder via JDBC
This article demonstrates how to access Power BI XMLA from PowerBuilder using the Power BI XMLA JDBC Driver.
-
Publish Miro-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Miro.
-
Create Informatica Mappings From/To an ODBC Data Source for Avalara AvaTax
Create an ODBC connection to Avalara AvaTax in Informatica and browse and transfer Avalara AvaTax.
-
Access Certinia Data from MySQL in Amazon QuickSight
Connect to Certinia and build visualizations of Certinia using a MySQL Connection in Amazon QuickSight.
-
Connect Postmark Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Postmark using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrating LangGraph with AlloyDB Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Google AlloyDB within automated workflows.
-
Replicate Ontraport Data from PowerShell
Write a quick PowerShell script to query Ontraport. Use connectivity to the live data to replicate Ontraport to SQL Server.
-
How to Build an ETL App for Paylocity Data in Python with CData
Create ETL applications and real-time data pipelines for Paylocity in Python with petl.
-
Getting Started with the CData Python Connector for HDFS
Learn to install and license the CData Python Connector
-
Integrate Live Dynamics CRM Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Connect to Bullhorn CRM Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Bullhorn CRM Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Integrating OpenCode Terminal with Instantly 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.
-
How to connect and process ZohoDesk from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live ZohoDesk.
-
Getting Started with the CData ODBC Driver for GraphQL
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for GraphQL.
-
Bridge Bitbucket Connectivity with Apache NiFi
Access and process Bitbucket in Apache NiFi using the CData JDBC Driver.
-
Automate LinkedIn Ads Integration Tasks from PowerShell
Are you in search of a quick and easy way to access LinkedIn Ads from PowerShell? This article demonstrates how to utilize the LinkedIn Ads Cmdlets for tasks like connecting to LinkedIn Ads, automating operations, downloading data, and more.
-
Query Clari Data in DataGrip
Create a Data Source for Clari in DataGrip and use SQL to query live Clari.
-
Create Sage 200-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Sage 200 Data from OutSystems and build custom enterprise apps using live Sage 200.
-
Connect to Zuora in SpagoBI
Create reports featuring live Zuora in SpagoBI Studio. Host Zuora reports on SpagoBI Server.
-
Automated Continuous VWO Replication to MySQL
Use CData Sync for automated, continuous, customizable VWO replication to MySQL.
-
Integrate API Data into Power Automate Desktop using CData Connect
CData Connect for API Data enables you to integrate API into workflows built using Microsoft Power Automate Desktop.
-
How to Seamlessly Import PostgreSQL Data into IBM SPSS Modeler
Integrate PostgreSQL data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Grafana Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Grafana using standard SQL.
-
Add Spotify Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Spotify with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated ADP Data Replication to Teradata
Use CData Sync to Customize and automate ADP replication to Teradata.
-
How to connect and process Moosend from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Moosend.
-
Create Data Visualizations Based On Redshift Data in Mode
Use CData Connect AI to connect to Redshift Data from Mode and build visualizations using live
-
Create Informatica Mappings From/To a JDBC Data Source for Dynamics 365 Business Central
Create Dynamics 365 Business Central data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to connect to Anaplan Data from Spring Boot
Connect to Anaplan in a Spring Boot Application using the CData JDBC Driver for Anaplan
-
How to work with Intercom Data in Apache Spark using SQL
Access and process Intercom Data in Apache Spark using the CData Software JDBC Driver.
-
Deploy the ADO.NET Provider for Perplexity on an SSRS Report Server
Connect to Perplexity 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 Coinbase Data with Power Map
Create data visualizations with Coinbase in Power Map.
-
Getting Started with the CData Python Connector for Google Directory
Learn to install and license the CData Python Connector