CData Software - Knowledge Base
Recent Articles
-
Access Live SAP Concur Data in AWS Lambda
Connect to live SAP Concur in AWS Lambda using the CData JDBC Driver.
-
Connect to GraphQL Data from AWS Glue
Use CData Connect AI to gain access to live GraphQL from your AWS Glue jobs.
-
Connect to DocuSign Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Visualize MailerLite Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to MailerLite.
-
Build SQL Server-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Microsoft SQL Server and build web apps with connectivity to live Microsoft SQL Server.
-
Connect to LinkedIn Ads Data from PowerBuilder via ADO.NET
This article demonstrates how to access LinkedIn Ads from Appeon PowerBuilder using the CData ADO.NET Provider for LinkedIn Ads.
-
How to update Snapchat Ads from Excel
This article explains how to transfer data from Excel to Snapchat Ads using the Excel Add-In for Snapchat Ads.
-
Create Informatica Mappings From/To an ODBC Data Source for ActiveCampaign
Create an ODBC connection to ActiveCampaign in Informatica and browse and transfer ActiveCampaign.
-
Connect to GitLab Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time GitLab using standard SQL.
-
How to Connect to Live Pipedrive 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 Pipedrive for you.
-
Analyze WooCommerce Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of WooCommerce and visualize WooCommerce in SAP Analytics Cloud.
-
Automated Continuous FormSite Replication to MongoDB
Use CData Sync for automated, continuous, customizable FormSite replication to MongoDB.
-
Build Automated DocuSign-Connected Workflows in Zapier
Use CData Connect AI to connect to live DocuSign and build automated workflows in Zapier.
-
Bidirectional Access to OpenWeatherMap Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate OpenWeatherMap in Filemaker Pro for Mac or Windows.
-
Automated Continuous Retently Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Retently replication to Apache Cassandra.
-
Analyze Elasticsearch Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Elasticsearch and visualize live Elasticsearch in Infragistics Reveal.
-
Automated Jira Assets Data Replication to Teradata
Use CData Sync to Customize and automate Jira Assets replication to Teradata.
-
Analyze SendGrid Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of SendGrid and visualize live SendGrid in Infragistics Reveal.
-
Create Reports from Jira Assets Data in Looker Studio
Use CData Connect AI to gain access to live Jira Assets and create custom reports in Looker Studio.
-
Use the CData Software ODBC Driver for Everhour in MicroStrategy
Connect to Everhour in MicroStrategy Developer using the CData Software ODBC Driver for Everhour.
-
Query Float Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Float and perform CRUD operations on Float from Node.js.
-
How to Use a Microsoft Access Database to Update Sage Intacct Data in Real Time
Update Sage Intacct data by creating a linked table in Microsoft Access with the CData Sage Intacct ODBC Driver.
-
Integrate with AlloyDB Data in JReport Designer
Create charts and reports based on Google AlloyDB in JReport Designer.
-
Connect to Outreach.io Data in Ruby
Connect to Outreach.io in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to connect to Google Search Results in DBVisualizer
Integrate Google Search with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrating LangChain with Jira Assets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Jira Assets within automated workflows.
-
Integrate YouTube Analytics with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate YouTube Analytics with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to YouTube Analytics.
-
Build a Simple VCL Application for CircleCI Data
How to build a simple VCL Application to view CircleCI in RAD Studio using the CData ODBC Driver for CircleCI.
-
Integrate Teradata with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Teradata with External Services.
-
Build MVC Applications with Connectivity to QuickBooks Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access QuickBooks from an ASP.NET MVC application.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SparkPost
Provide connectivity to SparkPost through an SAP BusinessObjects universe.
-
Integrate with Amazon Marketplace Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Amazon Marketplace to a JSON file on disk.
-
Access Live Coinbase Data in TIBCO Data Virtualization
Use the CData API Driver for Tibco DV to create a Coinbase data source in TIBCO Data Virtualization Studio and gain access to live Coinbase from your TDV Server.
-
Connect to Templated Data in Jaspersoft Studio
Execute SQL to remote Templated in Jaspersoft Studio.
-
Build MVC Applications with Connectivity to Amazon Marketplace Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Amazon Marketplace from an ASP.NET MVC application.
-
Automated Pipeliner CRM Data Replication to Teradata
Use CData Sync to Customize and automate Pipeliner CRM replication to Teradata.
-
Bidirectional Access to Billsby Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Billsby in Filemaker Pro for Mac or Windows.
-
Create a Data Access Object for SAS xpt Data using JDBI
A brief overview of creating a SQL Object API for SAS XPORT in JDBI.
-
Operational Reporting on Pipeline CRM Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Pipeline CRM.
-
Enable the Nuclia JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Nuclia.
-
Query Jira Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Atlassian Jira and perform CRUD operations on Jira from Node.js.
-
Integrate Live SAP Ariba Source Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to SAP Ariba Source and integrate live SAP Ariba Source into apps built in Microsoft Power Apps.
-
Create Datasets from Grafana in Domo Workbench and Build Visualizations of Grafana Data in Domo
Use the CData Software ODBC Driver for Grafana to create datasets from Grafana in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Cloudflare Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Cloudflare to connect to Cloudflare and execute queries in PowerBuilder.
-
Amazon S3 Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Amazon S3 through CData Connect AI using different applications and tools.
-
Connect to Sage Cloud Accounting Data in ACL Analytics
Connect to Sage Business Cloud Accounting via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Sage Business Cloud Accounting.
-
Natively Connect to Quaderno Data in PHP
The CData ODBC driver for Quaderno enables you to create PHP applications with connectivity to Quaderno. Leverage the native support for ODBC in PHP.
-
Using the CData Software ODBC Driver for FHIR in PyCharm
Connect to FHIR as an ODBC data source in PyCharm using the CData Software ODBC Driver for FHIR.
-
Connect Placid to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Placid using the CData Python MCP Server.
-
Create Google Spanner-Connected Dashboards in Grafana
Connect to Google Spanner Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Google Spanner.
-
Connect to Microsoft Dataverse Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to HCL Domino Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for HCL Domino.
-
Access MarkLogic Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live MarkLogic from HeidiSQL.
-
Integrating Antigravity CLI with BigCommerce via CData CLI
Connect BigCommerce to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to ShipStation Data in JRuby
Create a simple JRuby app with access to live ShipStation.
-
Build Agents in Relevance AI with Access to Live Facebook Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Facebook Ads within intelligent agent workflows.
-
Rapidly Develop Campaigner-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Campaigner.
-
How to import Jumpseller Data into Apache Solr
Use the CData Software JDBC Driver for Jumpseller in Data Import Handler and create an automated import of Jumpseller to Apache Solr Enterprise Search platform.
-
Extend Google Sheets with Amazon Marketplace Data
Make calls to Amazon Marketplace from Google Apps Script via the API Server.
-
Import Real-Time ElevenLabs Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use ElevenLabs in ColdFusion.
-
Integrating GitHub Copilot CLI with Discord 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 Datasets from Contentful in Domo Workbench and Build Visualizations of Contentful Data in Domo
Use the CData Software ODBC Driver for Contentful to create datasets from Contentful in Domo Workbench and then build visualizations in the Domo service.
-
Connect to SAP Concur Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for SAP Concur in Airbyte.
-
Seamlessly Bring SAP Ariba Procurement Data into Retool Using CData Connect AI
Integrate SAP Ariba Procurement data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Enable the YouTube Analytics JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with YouTube Analytics.
-
Visualize JotForm Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to JotForm.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Planio to Power BI dashboards. Simply drag and drop Planio into data visuals on the Power BI canvas.
-
Rootly Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Rootly facts in real time.
-
Create Dynamic Placid Grids Using the Infragistics XamDataGrid
Learn how you can connect Placid to Infragistics XamDataGrid to build dynamic grids.
-
Automated Continuous Salesforce Pardot Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Salesforce Pardot replication to Amazon S3.
-
How to use SQLAlchemy ORM to access Sage 200 Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Sage 200.
-
Automated Continuous NetSuite SuiteAnalytics Replication to SQLite
Use CData Sync for automated, continuous, customizable NetSuite SuiteAnalytics replication to SQLite.
-
Build Visualizations of CloudConvert Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of CloudConvert in Birst.
-
Access Live SAS Data Sets Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAS Data Sets from your Excel spreadsheets.
-
DataBind Azure DevOps Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Azure DevOps with the DevExpress Windows Forms and Web controls to provide Azure DevOps to a chart.
-
Publish Crystal Reports on ConvertAPI Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ConvertAPI.
-
Use the CData Software ODBC Driver for ADP in MicroStrategy Web
Connect to ADP in MicroStrategy Web using the CData Software ODBC Driver for ADP.
-
How to Query Live AlloyDB Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Google AlloyDB data in natural language using Python.
-
Connect to Qualaroo Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Work with Live Vault CRM Data in Power Query
Use CData Connect AI to connect to Veeva Vault & Vault CRM and work with live Veeva Vault & Vault CRM in Microsoft Power Query.
-
Moving Data from Bright Data to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Bright Data data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Replicate OneNote Data to Multiple Databases
Replicate Microsoft OneNote to disparate databases with a point-and-click configuration.
-
Automated Continuous API Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable API replication to Apache Kafka.
-
Integrating Cursor CLI with HubSpot 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.
-
Import Real-Time Landbot Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Landbot in ColdFusion.
-
Create Informatica Mappings From/To a JDBC Data Source for Google Directory
Create Google Directory data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Getting Started with the CData ODBC Driver for ShipEngine
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for ShipEngine.
-
Getting Started with the CData Python Connector for Attio
Learn to install and license the CData Python Connector
-
Query SQL Server Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Microsoft SQL Server from Node.js.
-
Build Apps with Live ZohoDesk Data Using the Low-Code Development Platform of Mendix
Connect ZohoDesk with Mendix to build apps using the CData API Driver for JDBC.
-
How to Connect to Live BigQuery 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 Google BigQuery for you.
-
Connect to SAP ByDesign Data in Aqua Data Studio
Access SAP Business ByDesign from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Google Campaign Manager 360 from Asprova with CData Software ODBC Driver for Google Campaign Manager 360
This article shows how to connect faster to Google Campaign Manager 360 data from Asprova.
-
How to connect to Okta Data in DBVisualizer
Integrate Okta with visual data analysis tools and data connection wizards in DBVisualizer
-
Import HCL Domino Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access HCL Domino. In this article, you will use the OData format to import HCL Domino into Microsoft Power Query.
-
Connect to ServiceNow Data from a Connection Pool in JBoss
Integrate ServiceNow into Java servlets: Use the Management Console in JBoss to install the ServiceNow JDBC Driver.
-
Integrate Productboard Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Productboard from Informatica Cloud.
-
Access Live PostgreSQL Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live PostgreSQL data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Build a Simple VCL Application for Databricks Data
How to build a simple VCL Application to view Databricks in RAD Studio using the CData ODBC Driver for Databricks.
-
Connect to OnePageCrm Data in Aqua Data Studio
Access OnePageCrm from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.