CData Software - Knowledge Base
Recent Articles
-
Build a PostgreSQL Interface for MYOB AccountRight Data using the CData JDBC Driver
Use the Remoting features of the MYOB AccountRight JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Informatica Mappings From/To a JDBC Data Source for ActiveCampaign
Create ActiveCampaign data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Query CircleCI Data in ColdFusion
Write standard ColdFusion data access code to connect to CircleCI.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for ZohoSubscriptions
Provide connectivity to ZohoSubscriptions through an SAP BusinessObjects universe.
-
Object-Relational Mapping (ORM) with Deel 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 Deel into a Java-based ORM framework, Hibernate.
-
Analyze Live Oracle Financials Cloud Data in SAS Viya
Use CData Connect AI to connect to Oracle Financials Cloud from SAS Viya and deploy self-service analytics using live Oracle Financials Cloud.
-
Load Act-On Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Act-On to a database.
-
How to load Outlook data into Elasticsearch via Logstash
Introducing a simple method to load Outlook data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Automated Continuous Microsoft Planner Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Microsoft Planner replication to AlloyDB.
-
Use the CData Software JDBC Driver for Cloudflare in MicroStrategy
Connect to Cloudflare in MicroStrategy Developer using the CData Software JDBC Driver for Cloudflare.
-
Configure the CData JDBC Driver for Freshdesk in a Connection Pool in Tomcat
Connect to Freshdesk from a connection pool in Tomcat.
-
Connect to Google Drive Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Google Drive from Filemaker Pro on Mac.
-
Build an OLAP Cube in SSAS from Sybase Data
Establish a connection to Sybase data from SQL Server Analysis Services, and use the Sybase Data Provider to build OLAP cubes for use in analytics and reporting.
-
Query Missive Data in ColdFusion
Write standard ColdFusion data access code to connect to Missive.
-
Analyze Marketo Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Marketo in Microsoft R Open.
-
Access Live Parquet Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Apache Parquet in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Query WordPress Data in ColdFusion
Write standard ColdFusion data access code to connect to WordPress.
-
Query Google Spanner Data as a SQL Server Database in Node.js
Execute SQL Server queries against Google Spanner from Node.js.
-
How to Query Live Microsoft Ads Data in Perplexity MacOS Desktop
Connect to and query live Microsoft Ads Data in Perplexity Desktop using CData MCP Server.
-
Import and Visualize MailerLite Data in Power View
Create data visualizations based on MailerLite in Excel.
-
Connect to ActiveCampaign Data in DBeaver
Use the CData ODBC Driver to connect to ActiveCampaign in DBeaver.
-
Integrate Reckon with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Reckon with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Reckon.
-
Build SAS xpt-Connected Apps in Choreo
Use CData Connect AI to connect to SAS xpt Data from Choreo and build custom apps using live SAS XPORT.
-
Build Adobe Analytics-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Adobe Analytics.
-
Integrate Cline with Live SAP Ariba Procurement Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live SAP Ariba Procurement from within your IDE.
-
Use the CData Software ODBC Driver for Phoenix in MicroStrategy Desktop
Connect to Apache Phoenix in MicroStrategy Desktop using the CData Software ODBC Driver for Phoenix.
-
Excel Spreadsheet Automation on Pinecone Data with the QUERY Formula
Pull data from Pinecone, automate spreadsheets, and more with the QUERY formula.
-
Integrating Antigravity CLI with MySQL via CData CLI
Connect MySQL to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Automated Continuous Workday Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Workday replication to AlloyDB.
-
Use Azure AI Foundry to Talk to Your Cassandra Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Apache Cassandra for you.
-
Edit and Search Oracle HCM Cloud External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Oracle HCM Cloud to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Oracle HCM Cloud objects that you can access from apps and the dashboard.
-
Access Live NetSuite Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live NetSuite CRM & ERP from your Excel spreadsheets.
-
Access Live Certinia Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Certinia from your Excel spreadsheets.
-
How to connect to Raisers Edge NXT Data from IntelliJ
Integrate connectivity to Raisers Edge NXT with wizards in IntelliJ.
-
Create Datasets from YouTube Analytics in Domo Workbench and Build Visualizations of YouTube Analytics Data in Domo
Use the CData Software ODBC Driver for YouTube Analytics to create datasets from YouTube Analytics in Domo Workbench and then build visualizations in the Domo service.
-
Replicate Adobe Commerce Data to Multiple Databases via the CData Sync CLI
Replicate Adobe Commerce to disparate databases with a single configuration.
-
How to Easily Query AdRoll Data in OpenOffice Base
Connect to AdRoll data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to Access Live Close Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Close enables you to integrate Close into workflows built using Microsoft Power Automate Desktop.
-
Build Xero-Connected Apps in Choreo
Use CData Connect AI to connect to Xero Data from Choreo and build custom apps using live Xero Accounting.
-
DataBind Controls to Azure Table Data in Delphi
DataBind to Azure Table Storage in Delphi with standard data access components and controls.
-
Getting Started with the CData Tableau Connector for Zoho Books
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Zoho Books.
-
Getting Started with the CData Excel Add-In for Azure Analysis Services
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Azure Analysis Services.
-
How to Seamlessly Import Foursquare Data into IBM SPSS Modeler
Integrate Foursquare data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Access Live YouTube Analytics 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 YouTube Analytics through MCP integration.
-
Integrate Sage Intacct Data into Power Automate Desktop using CData Connect
CData Connect for Sage Intacct Data enables you to integrate Sage Intacct into workflows built using Microsoft Power Automate Desktop.
-
Connect to SAP Hybris C4C Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for SAP Hybris C4C in the Denodo Virtual DataPort Administrator.
-
Integrate Teamwork Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Teamwork from Informatica Cloud.
-
Build Google Calendar-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Google Calendar to explore live Google Calendar Data in Cursor to assist with building Google Calendar-powered applications.
-
Edit and Search External NetSuite SuiteAnalytics Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of NetSuite SuiteAnalytics to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create NetSuite SuiteAnalytics Data objects that you can access from apps and the dashboard.
-
Building Dynamic Web Pages with Adobe Analytics Data Using AngularJS
Create single-page applications with live connectivity to Adobe Analytics using the CData API Server.
-
Connect to iContact Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for iContact to connect to iContact and execute queries in PowerBuilder.
-
Connect to SendInBlue 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 SendInBlue and work with SendInBlue in your FileMaker application.
-
Build MVC Applications with Connectivity to SharePoint Excel Services Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SharePoint Excel Services from an ASP.NET MVC application.
-
Automated Continuous Kintone Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Kintone replication to IBM DB2.
-
How to Build an ETL App for SAP Fieldglass Data in Python with CData
Create ETL applications and real-time data pipelines for SAP Fieldglass in Python with petl.
-
How to connect and process Presto from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Presto.
-
Connect to Samanage Data in Ruby
Connect to Samanage in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build SAP ByDesign-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SAP Business ByDesign and build web apps with connectivity to live SAP Business ByDesign.
-
How to Easily Query Amazon S3 Data in OpenOffice Base
Connect to Amazon S3 data in OpenOffice Base using the CData ODBC Driver for Amazon S3 and generate reports with live data insights.
-
Analyze Sugar CRM Data in Cognos Analytics
Use CData Connect AI to connect to Sugar CRM Data from Cognos Analytics and analyze live Sugar CRM.
-
View Reports on Real-Time Vault CRM Data in Power BI Report Server
Use the CData ODBC Driver for Vault CRM to visualize Veeva Vault & Vault CRM in Power BI Desktop and then publish them to Power BI Report Server.
-
Build Codat-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Codat.
-
How to Query Live Freshdesk Data in Claude Desktop
Connect to and query live Freshdesk Data in Claude Desktop using CData MCP Server.
-
Access Live Twilio Data in AWS Lambda
Connect to live Twilio in AWS Lambda using the CData JDBC Driver.
-
Build Dashboards with QuickBooks Time Data in Dundas BI
Create dynamic dashboards and perform analytics based on QuickBooks Time in Dundas BI.
-
Connect to Teradata Data in DBArtisan
Use wizards in DBArtisan to configure Teradata as a data source.
-
DataBind Controls to Workable Data in Delphi
DataBind to Workable in Delphi with standard data access components and controls.
-
Access Toggl 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 Toggl.
-
Create Power BI Reports on Real-Time ZohoSubscriptions Data
Use the CData ODBC Driver for ZohoSubscriptions to visualize ZohoSubscriptions in Power BI Desktop.
-
Integrating Cursor CLI with Kintone 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 Live BenchmarkEmail Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live BenchmarkEmail using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Connect to Live Apollo 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 Apollo for you.
-
Access Live Workable Data in Coginiti Pro
Connect to and query live Workable from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Strava Data in DBeaver
Use the CData ODBC Driver to connect to Strava in DBeaver.
-
Analyze SAP Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of SAP ERP/NetWeaver and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Access Live Sybase IQ Data in AWS Lambda
Connect to live Sybase IQ in AWS Lambda using the CData JDBC Driver.
-
Process & Analyze Google Sheets Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Google Sheets Data.
-
Design BIRT Reports on Suadeo Data
Provide current Suadeo to your embedded analytics.
-
Connect to Real-Time WordPress Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for WordPress and Dataflow to import and use WordPress in Power Apps.
-
Connect to SuiteCRM in SpagoBI
Create reports featuring live SuiteCRM in SpagoBI Studio. Host SuiteCRM reports on SpagoBI Server.
-
How to Connect Google Campaign Manager 360 Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Google Campaign Manager 360 data in real time using natural language.
-
Integrate Brex with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Brex with External Services.
-
Validate Authorize.Net Data with QuerySurge
Access and validate Authorize.Net in QuerySurge using the CData JDBC Driver.
-
Using the CData Software ODBC Driver for SingleStore in PyCharm
Connect to SingleStore as an ODBC data source in PyCharm using the CData Software ODBC Driver for SingleStore.
-
Visualize Trello Data in Tableau
The CData ODBC driver for Trello enables you integrate Trello into Tableau dashboards.
-
DataBind Charts to Zendesk Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Zendesk 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 connect PolyBase to RSS
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live RSS Feeds.
-
How to connect to Trello Data in DBVisualizer
Integrate Trello with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous Pipeliner CRM Replication to MongoDB
Use CData Sync for automated, continuous, customizable Pipeliner CRM replication to MongoDB.
-
Build Automated MYOB AccountRight-Connected Workflows in Zapier
Use CData Connect AI to connect to live MYOB AccountRight and build automated workflows in Zapier.
-
How to connect to Copper Data with Squirrel SQL client
Connect to Copper and execute queries in the Squirrel SQL Client.
-
Integrate with Snowflake Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Snowflake in SnapLogic.
-
Publish Crystal Reports on Twilio Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Twilio.
-
Use the CData Software ODBC Driver for Aha! in MicroStrategy Web
Connect to Aha! in MicroStrategy Web using the CData Software ODBC Driver for Aha!.
-
Working with Facebook Data in LINQPad
Execute LINQ queries to Facebook in LINQPad.
-
Connect to Postmark Data from a Connection Pool in JBoss
Integrate Postmark into Java servlets: Use the Management Console in JBoss to install the Postmark JDBC Driver.
-
Load LinkedIn Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load LinkedIn to a database.
-
Integrating Codex CLI with Sybase IQ 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.
-
Building Dynamic Web Pages with Authorize.Net Data Using AngularJS
Create single-page applications with live connectivity to Authorize.Net using the CData API Server.
-
DataBind Charts to Greenhouse Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Greenhouse 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.