CData Software - Knowledge Base
Recent Articles
-
Back Up Missive to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Missive data.
-
DataBind Controls to Datadog Data in Delphi
DataBind to Datadog in Delphi with standard data access components and controls.
-
Migrating data from Dropbox to Google BigQuery using CData SSIS Components.
Easily push Dropbox to Google BigQuery using the CData SSIS Tasks for Dropbox and Google BigQuery.
-
Build a Simple VCL Application for ShipEngine Data
How to build a simple VCL Application to view ShipEngine in RAD Studio using the CData ODBC Driver for ShipEngine.
-
Build Agents in Relevance AI with Access to Live Salesforce Marketing Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Salesforce Marketing Cloud within intelligent agent workflows.
-
Connect to Gong Data from a Connection Pool in Jetty
The Gong JDBC Driver supports connection pooling: This article shows how to connect faster to Gong from Web apps in Jetty.
-
Connect Google Drive Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Google Drive using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automated Continuous PayPal Replication to SingleStore
Use CData Sync for automated, continuous, customizable PayPal replication to SingleStore.
-
Use the CData ODBC Driver for Keap from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Keap to connect to Keap from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Keap in Excel.
-
Automated Continuous SAP HANA Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable SAP HANA replication to Amazon Redshift.
-
Automate Okta Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Okta and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Create Okta Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Okta from PowerBI.com to create Power BI Dataflows with real-time data.
-
A PostgreSQL Interface for Wistia Data (MySQL Remoting via JDBC)
Use the Remoting features of the Wistia JDBC Driver to create a PostgreSQL entry-point for data access.
-
Rapidly Develop Blackbaud FE NXT-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 Blackbaud FE NXT.
-
Integrate Opsgenie Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Opsgenie from Informatica Cloud.
-
Choosing the Best Method to Connect Datadog to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Datadog from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Access Live PayPal Data in Coginiti Pro
Connect to and query live PayPal from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Sage 300 Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Sage 300 in the Denodo Virtual DataPort Administrator.
-
Visualize Live DB2 Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live IBM DB2.
-
Integrate Cline with Live Bullhorn CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Bullhorn CRM from within your IDE.
-
Replicate Multiple SAP BusinessObjects BI Accounts
Replicate multiple SAP BusinessObjects BI accounts to one or many databases.
-
Feed Rebilly Data into FineReport
How to set Rebilly as a JDBC data source in FineReport.
-
Integrate Real-Time Access to Active Directory in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Active Directory in real time.
-
Build a Singer.io Tap for Microsoft Planner With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Microsoft Planner data using
-
A PostgreSQL Interface for BambooHR Data (MySQL Remoting via JDBC)
Use the Remoting features of the BambooHR JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Sage Intacct Replication to Oracle
Use CData Sync for automated, continuous, customizable Sage Intacct replication to Oracle.
-
Extend Google Sheets with Zoho Books Data
Make calls to Zoho Books from Google Apps Script via the API Server.
-
Build Apps with Live Webflow Data Using the Low-Code Development Platform of Mendix
Connect Webflow with Mendix to build apps using the CData API Driver for JDBC.
-
Use Azure AI Foundry to Talk to Your Oracle Financials Cloud 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 Oracle Financials Cloud for you.
-
Build an OLAP Cube in SSAS from OData Services
Establish a connection to OData data from SQL Server Analysis Services, and use the OData Data Provider to build OLAP cubes for use in analytics and reporting.
-
Visualize Procore Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Procore into TIBCO Spotfire.
-
Query Aircall Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Aircall from Node.js.
-
Create a Data Access Object for Front Data using JDBI
A brief overview of creating a SQL Object API for Front in JDBI.
-
Automate RSS Feeds Replication to SAP HANA
Use CData Sync to customize and automate RSS Feeds replication to SAP HANA.
-
How to connect to SAP ByDesign Data in DBVisualizer
Integrate SAP Business ByDesign with visual data analysis tools and data connection wizards in DBVisualizer
-
Use the CData Software ODBC Driver for Float in MicroStrategy
Connect to Float in MicroStrategy Developer using the CData Software ODBC Driver for Float.
-
Analyze SAP SuccessFactors LMS Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of SAP SuccessFactors LMS and visualize live SAP SuccessFactors LMS in Infragistics Reveal.
-
Create Reports with Printify Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Printify.
-
Getting Started with the CData JDBC Driver for MessageBird
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for MessageBird.
-
Use the CData Software ODBC Driver for Beeminder in MicroStrategy Web
Connect to Beeminder in MicroStrategy Web using the CData Software ODBC Driver for Beeminder.
-
Tavily Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Tavily facts in real time.
-
Replicate Multiple Zoho CRM Accounts
Replicate multiple Zoho CRM accounts to one or many databases.
-
Replicate Nethunt Data in Heroku for Use in Salesforce Connect
Replicate Nethunt to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrating Cursor CLI with Simplesat 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.
-
Process & Analyze Highrise Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Highrise Data.
-
DataBind Charts to Sage Cloud Accounting Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Sage Business Cloud Accounting 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.
-
Automate Helpscout Data Replication to Azure Data Lake
Use CData Sync to customize and automate Helpscout replication to Azure Data Lake.
-
Connect to Box Data in RapidMiner
Integrate Box with standard components and data source configuration wizards in RapidMiner Studio.
-
Getting Started with the CData Python Connector for PabblySubscriptions
Learn to install and license the CData Python Connector
-
Integrating Boomi Agentstudio with Bullhorn CRM Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Bullhorn CRM, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Integrating GitHub Copilot CLI with Oracle Service Cloud 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.
-
Enable the Google Forms JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Google Forms.
-
Replicate Toggl Data from PowerShell
Write a quick PowerShell script to query Toggl. Use connectivity to the live data to replicate Toggl to SQL Server.
-
Access Live Outreach.io Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Outreach.io from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to Autopilot Data in Aqua Data Studio
Access Autopilot from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Explore Geographical Relationships in Campaigner Data with Power Map
Create data visualizations with Campaigner in Power Map.
-
Automated Continuous Microsoft Teams Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Microsoft Teams replication to Google BigQuery.
-
Enable the QuickBooks Online JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with QuickBooks Online.
-
Connect to Typeform Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Typeform in the Denodo Virtual DataPort Administrator.
-
Build Semantic Layer Views for Shippo Data in APOS Live Data Gateway
Use the CData Connector for Shippo in APOS Live Data Gateway to build Semantic Layer Views for Shippo.
-
Connect to IBM Informix Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for IBM Informix.
-
How to Work with JotForm Data in AWS Glue Jobs Using JDBC
Connect to JotForm from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate Sage Intacct Data in the Pentaho Report Designer
Publish reports based on Sage Intacct in the Pentaho BI tool.
-
Visualize Live Microsoft OneDrive Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Microsoft OneDrive using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Import Data from Zoho Books into Google Sheets
Import Zoho Books into a Google spreadsheet that is automatically refreshed.
-
How to create an RPA flow for RabbitMQ Data in UiPath Studio
Use the RabbitMQ ODBC Driver to create workflows that access real-time RabbitMQ without any coding.
-
Consume Sage 200 OData Feeds in PowerBuilder
This article demonstrates how to consume Sage 200 as OData feeds from PowerBuilder using the API Server.
-
Getting Started with the CData ODBC Driver for MarkLogic
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for MarkLogic.
-
Create SSAS Tabular Models from Mailgun Data
How to build a SQL Server Analysis Service Tabular Model from Mailgun using CData drivers.
-
How to Work with Notion Data in ETL Validator JDBC
Connect to Notion from ETL Validator jobs using the CData Software JDBC Driver.
-
Automate SAP Data Replication to Azure Data Lake
Use CData Sync to customize and automate SAP ERP/NetWeaver replication to Azure Data Lake.
-
Connect to Workable Data from PowerBuilder via ADO.NET
This article demonstrates how to access Workable from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Import Real-Time Deel Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Deel in ColdFusion.
-
Access Live Zoho CRM 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 Zoho CRM through MCP integration.
-
How to Connect DBeaver to SAP Fieldglass via a JDBC Driver
Manage SAP Fieldglass with visual tools in DBeaver like the query browser.
-
Visualize QuickBooks Time Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to QuickBooks Time.
-
Visualize Avalara AvaTax Data in Tableau
The CData ODBC driver for Avalara AvaTax enables you integrate Avalara AvaTax into Tableau dashboards.
-
Connecting Pipedream with WooCommerce Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on WooCommerce data in real time.
-
Connect to AlloyDB Data in HULFT Integrate
Connect to AlloyDB as a JDBC data source in HULFT Integrate
-
Use Databricks Agent Bricks to Talk to Your FTP Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your FTP Servers for you.
-
Migrating data from Zoho Creator to Google BigQuery using CData SSIS Components.
Easily push Zoho Creator to Google BigQuery using the CData SSIS Tasks for Zoho Creator and Google BigQuery.
-
How to Seamlessly Import Freshdesk Data into IBM SPSS Modeler
Integrate Freshdesk data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Use the CData Software ODBC Driver for YouTube Analytics in MicroStrategy Web
Connect to YouTube Analytics in MicroStrategy Web using the CData Software ODBC Driver for YouTube Analytics.
-
Integrate Ontraport Data in the Pentaho Report Designer
Publish reports based on Ontraport in the Pentaho BI tool.
-
A PostgreSQL Interface for Phoenix Data using the CData ODBC Driver
Use the SQL Gateway and Phoenix ODBC Driver to create a PostgreSQL entry-point for data access.
-
Stream Highrise Data into Apache Kafka Topics
Access and stream Highrise CRM in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to load Simplesat data into Elasticsearch via Logstash
Introducing a simple method to load Simplesat data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Query Google Search Results as a MySQL Database in Node.js
Execute MySQL queries against Google Search from Node.js.
-
How to use SQLAlchemy ORM to access Marketo Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Marketo.
-
Connect to Dotmailer Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Dotmailer using standard SQL.
-
Import Real-Time PingOne Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use PingOne in ColdFusion.
-
Connect to Asana Data in DBArtisan
Use wizards in DBArtisan to configure Asana as a data source.
-
Connect to Flowlu Data in DBArtisan
Use wizards in DBArtisan to configure Flowlu as a data source.
-
Automated MarkLogic Data Replication to Teradata
Use CData Sync to Customize and automate MarkLogic replication to Teradata.
-
Operational Reporting on HCL Domino Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote HCL Domino.
-
Build HubSpot-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for HubSpot Data and create custom apps in Bubble.
-
Object-Relational Mapping (ORM) with Nuclia 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 Nuclia into a Java-based ORM framework, Hibernate.
-
Publish Asana-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Asana.
-
Use the CData Software ODBC Driver for TigerGraph in MicroStrategy
Connect to TigerGraph in MicroStrategy Developer using the CData Software ODBC Driver for TigerGraph.
-
Create Power BI Reports on Real-Time Vault CRM Data
Use the CData ODBC Driver for Vault CRM to visualize Veeva Vault & Vault CRM in Power BI Desktop.