CData Software - Knowledge Base
Recent Articles
-
Replicate Odoo Data to Multiple Databases
Replicate Odoo ERP to disparate databases with a point-and-click configuration.
-
How to Connect DBeaver to JSON via a JDBC Driver
Manage JSON with visual tools in DBeaver like the query browser.
-
Visualize Kintone Data in Sisense
Create an ElastiCube in Sisense app with access to Kintone.
-
Integrate Live Amazon Athena Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Amazon Athena from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Amazon Athena.
-
Access Zoom Data from MySQL in Amazon QuickSight
Connect to Zoom and build visualizations of Zoom using a MySQL Connection in Amazon QuickSight.
-
Build Bullhorn CRM-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Bullhorn CRM to explore live Bullhorn CRM Data in GitHub Copilot to assist with building Bullhorn CRM-powered applications.
-
Use Biml to Build SSIS Tasks to Replicate Oracle Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Oracle Database to SQL Server.
-
Connect to Live HubSpot Data in PostGresSQL Interface through CData Connect AI
Create a live connection to HubSpot in CData Connect AI and connect to your HubSpot from PostgreSQL.
-
Integrating GitHub Copilot CLI with Anaplan 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 Amazon QuickSight to Sage Cloud Accounting Data
Create a connection to Sage Business Cloud Accounting in CData Connect AI and insert Sage Business Cloud Accounting into Amazon QuickSight SPICE to build interactive dashboards.
-
How to Seamlessly Import SAP Ariba Source Data into IBM SPSS Modeler
Integrate SAP Ariba Source data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Paddle Data in NetBeans
Connect to Paddle in NetBeans with the data source configuration wizard.
-
Connect to MailerSend Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to MailerSend and work with MailerSend in your FileMaker applications.
-
Integrate WordPress with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate WordPress with External Services.
-
Build Apify-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Apify and build web apps with connectivity to live Apify.
-
Automated Continuous Twitter Ads Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Twitter Ads replication to Apache Cassandra.
-
Replicate Email Data from PowerShell
Write a quick PowerShell script to query Email. Use connectivity to the live data to replicate Email to SQL Server.
-
Query Timely Data in DataGrip
Create a Data Source for Timely in DataGrip and use SQL to query live Timely.
-
Build Visualizations of DocuSign Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of DocuSign in Birst.
-
How to connect to Freshsales Data from IntelliJ
Integrate connectivity to Freshsales with wizards in IntelliJ.
-
DataBind Controls to Tickspot Data in C++Builder
DataBind to Tickspot in C++Builder with standard components and controls.
-
Use the CData Software JDBC Driver for ChartMogul in MicroStrategy Web
Connect to ChartMogul in MicroStrategy Web using the CData Software JDBC Driver for ChartMogul.
-
Natively Connect to Teamgate Data in PHP
The CData ODBC driver for Teamgate enables you to create PHP applications with connectivity to Teamgate. Leverage the native support for ODBC in PHP.
-
Connect and Visualize Live SAP BusinessObjects BI Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live SAP BusinessObjects BI into the Databricks platform and create visualization dashboards with real-time SAP BusinessObjects BI.
-
Deploy the ADO.NET Provider for SAP Business Warehouse on an SSRS Report Server
Connect to SAP Business Warehouse 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.
-
Build MVC Applications with Connectivity to QuickBooks Time Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access QuickBooks Time from an ASP.NET MVC application.
-
Easily Integrate RSS Feeds in Lazarus Pascal IDE
Learn how to easily integrate live RSS Feeds in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Getting Started with the CData ODBC Driver for LeadDesk
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for LeadDesk.
-
Using the CData Software ODBC Driver for Avalara AvaTax in PyCharm
Connect to Avalara AvaTax as an ODBC data source in PyCharm using the CData Software ODBC Driver for Avalara AvaTax.
-
Access Accelo Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Accelo from your Oracle system.
-
Publish Crystal Reports on MessageBird Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date MessageBird.
-
Automated Continuous Microsoft OneLake Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Microsoft OneLake replication to Google Cloud SQL.
-
Manage Sendwithus Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Sendwithus.
-
How to Query Live SAP SuccessFactors LMS Data in Claude Desktop
Connect to and query live SAP SuccessFactors LMS Data in Claude Desktop using CData MCP Server.
-
Building Dynamic Web Pages with PostgreSQL Data Using AngularJS
Create single-page applications with live connectivity to PostgreSQL using the CData API Server.
-
Build AI Agents with Okta Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Okta through CData Connect AI.
-
Integrate Live ActiveCampaign Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to ActiveCampaign from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live ActiveCampaign.
-
How to Connect to Live ActiveCampaign Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your ActiveCampaign for you.
-
Replicate BenchmarkEmail Data to Multiple Databases via the CData Sync CLI
Replicate BenchmarkEmail to disparate databases with a single configuration.
-
Analyze Excel Online Data in Looker
Use CData Connect AI to connect to Excel Online Data from Looker and build custom apps using live Microsoft Excel Online.
-
Connect to Front from Asprova with CData Software ODBC Driver for Front
This article shows how to connect faster to Front data from Asprova.
-
Integrate Clockify with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Clockify with External Services.
-
A PostgreSQL Interface for PostgreSQL Data using the CData ODBC Driver
Use the SQL Gateway and PostgreSQL ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect Discourse Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Discourse using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Design BIRT Reports on ClickUp Data
Provide current ClickUp to your embedded analytics.
-
Prepare, Blend, and Analyze Zoom Data in Alteryx Designer (Connect AI)
Build workflows to access live Zoom for self-service data analytics.
-
Write a Simple Go Application to work with Deel Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Deel.
-
Replicate Multiple ServiceNow Accounts
Replicate multiple ServiceNow accounts to one or many databases.
-
Build Data Flows from Microsoft OneDrive to SQL Server using SSIS
Easily back up Microsoft OneDrive to SQL Server using the SSIS components for Microsoft OneDrive.
-
Getting Started with the CData Power BI Connector for ZeroBounce
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Use Dash to Build to Web Apps on WordPress Data
Create Python applications that use pandas and Dash to build WordPress-connected web apps.
-
Automate Airtable Data Replication to SAP HANA
Use CData Sync to customize and automate Airtable replication to SAP HANA.
-
Access Live Google Ads Data in Coginiti Pro
Connect to and query live Google Ads from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build Salesforce Marketing-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Salesforce Marketing to explore live Salesforce Marketing Data in Gemini Code Assist to assist with building Salesforce Marketing-powered applications.
-
Create a Data Access Object for Slack Data using JDBI
A brief overview of creating a SQL Object API for Slack in JDBI.
-
Use the CData ODBC Driver for Datadog in Microsoft Power Query
You can use the CData Datadog ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Datadog into Microsoft Power Query.
-
Integrating Kiro CLI with Close 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.
-
Shippo Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Shippo facts in real time.
-
Build a PostgreSQL Interface for Quickbase Data using the CData JDBC Driver
Use the Remoting features of the Quickbase JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Marketo Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Marketo.
-
Integrating Dataiku with HCL Domino Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live HCL Domino.
-
Design BIRT Reports on Dynamics CRM Data
Provide current Microsoft Dynamics CRM to your embedded analytics.
-
Build a PostgreSQL Interface for Front Data using the CData JDBC Driver
Use the Remoting features of the Front JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build a Singer.io Tap for Parquet With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Parquet data using
-
How to Connect the Power BI Service to Blackbaud FE NXT: Complete Guide
Connect to the CData Software Power BI Connector for Blackbaud FE NXT from PowerBI.com to provide real-time Blackbaud FE NXT across the organization.
-
How to update Google Drive from Excel
This article explains how to transfer data from Excel to Google Drive using the Excel Add-In for Google Drive.
-
How to Build an ETL App for Adobe Target Data in Python with CData
Create ETL applications and real-time data pipelines for Adobe Target in Python with petl.
-
How to work with Stripe Data in Apache Spark using SQL
Access and process Stripe Data in Apache Spark using the CData Software JDBC Driver.
-
Getting Started with the CData ADO.NET Provider for Tally
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Tally.
-
LINQ to Contentful 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 Contentful Data Provider.
-
Use the CData Software JDBC Driver for Tanda in MicroStrategy
Connect to Tanda in MicroStrategy Developer using the CData Software JDBC Driver for Tanda.
-
Replicate Multiple Monday.com Accounts via the CData Sync CLI
Replicate multiple Monday.com accounts to one or many databases.
-
Build Data Flows from SAP Business Warehouse to SQL Server using SSIS
Easily back up SAP Business Warehouse to SQL Server using the SSIS components for SAP Business Warehouse.
-
Seamlessly Bring Exact Online Data into Retool Using CData Connect AI
Integrate Exact Online data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Analyze HubDB Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze HubDB with the CData JDBC Driver for HubDB.
-
Integrate Goose with Live Zoom Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Zoom from within the local AI agent.
-
Connect to Insightly in SpagoBI
Create reports featuring live Insightly in SpagoBI Studio. Host Insightly reports on SpagoBI Server.
-
Build Cassandra-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Cassandra Data and create custom apps in Mendix.
-
Connect to SendInBlue Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to Optimizely from a Connection Pool in WebLogic
Use the CData JDBC Driver for Optimizely to connect to Optimizely from Web applications running on WebLogic.
-
Connect to Omnisend Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Omnisend as an External Source in Dremio.
-
Connect to Real-Time Intercom Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Intercom in Power Apps.
-
Connect to Amazon Marketplace Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Amazon Marketplace.
-
Access Live Google Ad Manager Data in AWS Lambda
Connect to live Google Ad Manager in AWS Lambda using the CData JDBC Driver.
-
How to Build an ETL App for Vercel Data in Python with CData
Create ETL applications and real-time data pipelines for Vercel in Python with petl.
-
Access Live SAP HANA Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SAP HANA into the statistical analysis tools available in SAS JMP. This article shows how to use SAP HANA in the Graph Builder and Query Builder.
-
Query Splunk Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Splunk and perform CRUD operations on Splunk from Node.js.
-
DataBind Campaigner Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Campaigner to a chart.
-
Connect to Azure Data Lake Storage Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Azure Data Lake Storage Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Access Trello Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Trello from HeidiSQL.
-
Object-Relational Mapping (ORM) with Avaza 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 Avaza into a Java-based ORM framework, Hibernate.
-
Access Live Intercom Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Intercom into the statistical analysis tools available in SAS JMP. This article shows how to use Intercom in the Graph Builder and Query Builder.
-
Query LDAP Objects from Node.js
Use the OData endpoint of the CData API Server to connect to your LDAP and perform CRUD operations on LDAP from Node.js.
-
Integrate Live Databricks Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Databricks from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Databricks.
-
Access Live Miro Data in AWS Lambda
Connect to live Miro in AWS Lambda using the CData JDBC Driver.
-
Publish IBM Cloud Object Storage-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live IBM Cloud Object Storage.
-
Getting Started with the CData Excel Add-In for Zuora
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Zuora.
-
Connect to Wave Financial Data from PowerBuilder via JDBC
This article demonstrates how to access Wave Financial from PowerBuilder using the Wave Financial JDBC Driver.
-
Connect to eBay Data from a Connection Pool in JBoss
Integrate eBay into Java servlets: Use the Management Console in JBoss to install the eBay JDBC Driver.
-
Create Freshservice-Connected Applications in Appsmith
Connect to Freshservice Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Freshservice.