CData Software - Knowledge Base
Recent Articles
-
Integrate Google Ad Manager Data in Pentaho Data Integration
Build ETL pipelines based on Google Ad Manager in the Pentaho Data Integration tool.
-
Deploy the ADO.NET Provider for Brex on an SSRS Report Server
Connect to Brex 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.
-
How to connect to Office 365 Data in DBVisualizer
Integrate Microsoft Office 365 with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrating Codex CLI with Nethunt 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.
-
Build an OLAP Cube in SSAS from Drip Data
Establish a connection to Drip data from SQL Server Analysis Services, and use the Drip Data Provider to build OLAP cubes for use in analytics and reporting.
-
Access Live Shopify Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Shopify from your Excel spreadsheets.
-
Automated Continuous IBM Informix Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable IBM Informix replication to OneLake in Microsoft Fabric.
-
LINQ to Freshservice 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 Freshservice Data Provider.
-
Build a PostgreSQL Interface for Todoist Data using the CData JDBC Driver
Use the Remoting features of the Todoist JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Live Oracle Eloqua Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Oracle Eloqua from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Oracle Eloqua.
-
Analyze TigerGraph Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for TigerGraph from Power Pivot. You will use the Table Import Wizard to load TigerGraph. You can visually build the import query or use any SQL supported by the driver.
-
How to update Outreach.io from Excel
This article explains how to transfer data from Excel to Outreach.io using the Excel Add-In for Outreach.io.
-
Build Dashboards with Teradata Data in DBxtra
Create dynamic dashboards and perform analytics based on Teradata in DBxtra.
-
How to load PingOne data into Elasticsearch via Logstash
Introducing a simple method to load PingOne data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Attio Data from PowerBuilder via JDBC
This article demonstrates how to access Attio from PowerBuilder using the Attio JDBC Driver.
-
How to Visualize FTP Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live FTP Servers in Python.
-
Query Coda Data in DataGrip
Create a Data Source for Coda in DataGrip and use SQL to query live Coda.
-
Visualize Google Sheets 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 Google Sheets into TIBCO Spotfire.
-
Getting Started with the CData ADO.NET Provider for Postmark
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Automated Continuous SAP Concur Replication to SQLite
Use CData Sync for automated, continuous, customizable SAP Concur replication to SQLite.
-
Replicate Multiple Amazon Marketplace Accounts
Replicate multiple Amazon Marketplace accounts to one or many databases.
-
Import Real-Time Salesloft Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Salesloft in ColdFusion.
-
Provide OData Services of Wave Financial Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Wave Financial by developing a WCF Service Application.
-
How to Work with Shippo Data in ETL Validator JDBC
Connect to Shippo from ETL Validator jobs using the CData Software JDBC Driver.
-
Publish SingleStore-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live SingleStore.
-
DataBind Controls to Authorize.Net Data in C++Builder
DataBind to Authorize.Net in C++Builder with standard components and controls.
-
Use the CData Software JDBC Driver for Google Cloud Storage in MicroStrategy Desktop
Connect to Google Cloud Storage in MicroStrategy Desktop using the CData Software JDBC Driver for Google Cloud Storage.
-
Choosing the Best Method to Connect Raisers Edge NXT to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Raisers Edge NXT from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Connect the Power BI Service to AgileCRM: Complete Guide
Connect to the CData Software Power BI Connector for AgileCRM from PowerBI.com to provide real-time AgileCRM across the organization.
-
Replicate Dynamics 365 Data to Multiple Databases via the CData Sync CLI
Replicate Microsoft Dynamics 365 to disparate databases with a single configuration.
-
Access Square Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Square from your Oracle system.
-
Build Charts with CockroachDB Data in Clear Analytics
Create dynamic charts and perform analytics based on CockroachDB in Clear Analytics.
-
Analyze Live Pipedrive Data in SAS Viya
Use CData Connect AI to connect to Pipedrive from SAS Viya and deploy self-service analytics using live Pipedrive.
-
Connect to Dynamics 365 Data in RapidMiner
Integrate Microsoft Dynamics 365 with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrating Claude Code CLI with MYOB AccountRight 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 Informatica Mappings From/To a JDBC Data Source for Twilio
Create Twilio data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automated Continuous Delighted Replication to SQLite
Use CData Sync for automated, continuous, customizable Delighted replication to SQLite.
-
Query SharePoint Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Microsoft SharePoint from Node.js.
-
Create Adobe Analytics Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Adobe Analytics data access from reports, embedded analytics, and more.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Certinia within intelligent workflows.
-
Build Data Flows from Twilio to SQL Server using SSIS
Easily back up Twilio to SQL Server using the SSIS components for Twilio.
-
Object-Relational Mapping (ORM) with Hacker News 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 Hacker News into a Java-based ORM framework, Hibernate.
-
Query Webflow Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Webflow from Node.js.
-
Migrating data from SAP Concur to Google BigQuery using CData SSIS Components.
Easily push SAP Concur to Google BigQuery using the CData SSIS Tasks for SAP Concur and Google BigQuery.
-
Query Stack Exchange Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Stack Exchange from Node.js.
-
Build MVC Applications with Connectivity to Bitbucket Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Bitbucket from an ASP.NET MVC application.
-
Import Square Data Using Azure Data Factory
Use CData Connect AI to connect to Square Data from Azure Data Factory and import live Square.
-
Connect to HDFS Data in DBArtisan
Use wizards in DBArtisan to configure Apache HDFS as a data source.
-
Create Informatica Mappings From/To an ODBC Data Source for Aircall
Create an ODBC connection to Aircall in Informatica and browse and transfer Aircall.
-
Connect to Box Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Box in Airbyte.
-
Create Apps from Act CRM Data in Qlik Sense Cloud
Use CData Connect AI to connect to Act CRM Data and build apps from live Act CRM in Qlik Sense Cloud.
-
How to connect Amazon QuickSight to SAP Hybris C4C Data
Create a connection to SAP Hybris C4C in CData Connect AI and insert SAP Hybris C4C into Amazon QuickSight SPICE to build interactive dashboards.
-
Connecting GenSpark with QuickBooks Online Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to QuickBooks Online without any replication or custom integration required.
-
Connecting GenSpark with Microsoft Teams Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Microsoft Teams without any replication or custom integration required.
-
Analyze MailerLite Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze MailerLite with the CData JDBC Driver for MailerLite.
-
Import and Visualize Chargebee Data in Power View
Create data visualizations based on Chargebee in Excel.
-
Create Klaviyo-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Klaviyo Data from OutSystems and build custom enterprise apps using live Klaviyo.
-
Getting Started with the CData Python Connector for Float
Learn to install and license the CData Python Connector
-
Seamlessly Bring Sugar CRM Data into Retool Using CData Connect AI
Integrate Sugar CRM data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Integrate Cline with Live LinkedIn Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live LinkedIn from within your IDE.
-
Build Automated JSON-Connected Workflows in Zapier
Use CData Connect AI to connect to live JSON and build automated workflows in Zapier.
-
Connect to and Visualize Live Pipedrive Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Pipedrive.
-
How to connect to Delighted Data from Spring Boot
Connect to Delighted in a Spring Boot Application using the CData API Driver for JDBC
-
Connect to Harvest from Asprova with CData Software ODBC Driver for Harvest
This article shows how to connect faster to Harvest data from Asprova.
-
Import Marketo Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Marketo. In this article, you will use the OData format to import Marketo into Microsoft Power Query.
-
Build a Singer.io Tap for Oracle Service Cloud With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Oracle Service Cloud data using
-
Establish a Live Connection with CapsuleCRM Data using Tableau Bridge
The CData ODBC Driver for CapsuleCRM enables you to integrate live CapsuleCRM into Tableau Cloud dashboards using the Tableau Bridge.
-
Build a Singer.io Tap for Webflow With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Webflow data using
-
How to publish and share Sendwithus Data dashboards with Tableau Server
The CData ODBC driver for Sendwithus enables you integrate Sendwithus into Tableau dashboards.
-
Operational Reporting on Oracle SCM Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Oracle SCM.
-
Connect to PayPal Data in RapidMiner
Integrate PayPal with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Visualize SAP Concur Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live SAP Concur in Python.
-
How to Connect to Live Zoho Books 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 Zoho Books for you.
-
Create Informatica Mappings From/To an ODBC Data Source for Elasticsearch
Create an ODBC connection to Elasticsearch in Informatica and browse and transfer Elasticsearch.
-
A PostgreSQL Interface for SuiteCRM Data using the CData ODBC Driver
Use the SQL Gateway and SuiteCRM ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Adobe Experience Manager Data from PowerBuilder via JDBC
This article demonstrates how to access Adobe Experience Manager from PowerBuilder using the Adobe Experience Manager JDBC Driver.
-
Viewing LinkedIn Ads Data in RAD Studio Data Explorer
How to view LinkedIn Ads in RAD Studio Data Explorer using the CData ODBC Driver for LinkedIn Ads.
-
Getting Started with the CData ADO.NET Provider for Shippo
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Visualize Instantly 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 Instantly into TIBCO Spotfire.
-
Getting Started with the CData ODBC Driver for MessageBird
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for MessageBird.
-
Stream ZohoSubscriptions Data into Apache Kafka Topics
Access and stream ZohoSubscriptions in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Email from a Connection Pool in WebLogic
Use the CData JDBC Driver for Email to connect to Email from Web applications running on WebLogic.
-
Integrate Live DocuSign Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to DocuSign from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live DocuSign.
-
Connect to Bitly Data in HULFT Integrate
Connect to Bitly as a JDBC data source in HULFT Integrate
-
Build Dynamics 365-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Dynamics 365 to explore live Dynamics 365 Data in GitHub Copilot to assist with building Dynamics 365-powered applications.
-
Salesforce Reporting in OBIEE with the Salesforce JDBC Driver
Deploy the Salesforce JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build Dashboards with Harvest Data in DBxtra
Create dynamic dashboards and perform analytics based on Harvest in DBxtra.
-
Use Databricks Agent Bricks to Talk to Your SharePoint Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Microsoft SharePoint for you.
-
Analyze Sugar CRM Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Sugar CRM with the CData JDBC Driver for Sugar CRM.
-
Connect to and Visualize Live Front Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Front.
-
Publish Crystal Reports on Campaigner Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Campaigner.
-
Automate Accelo Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Accelo from PowerShell? This article demonstrates how to utilize the Accelo Cmdlets for tasks like connecting to Accelo, automating operations, downloading data, and more.
-
Establish a Live Connection with Office 365 Data using Tableau Bridge
The CData ODBC Driver for Office 365 enables you to integrate live Microsoft Office 365 into Tableau Cloud dashboards using the Tableau Bridge.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed ADP to Power BI dashboards. Simply drag and drop ADP into data visuals on the Power BI canvas.
-
Use the CData Software JDBC Driver for PivotalTracker in MicroStrategy Desktop
Connect to PivotalTracker in MicroStrategy Desktop using the CData Software JDBC Driver for PivotalTracker.
-
Enable the Coinbase JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Coinbase.
-
Integrate Adobe Commerce with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Adobe Commerce with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Adobe Commerce.
-
Create Data Visualizations in Cognos BI with MailerSend Data
Access MailerSend as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Automated Continuous Mailjet Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Mailjet replication to Amazon Redshift.
-
Use the CData Software JDBC Driver for eBay in MicroStrategy
Connect to eBay in MicroStrategy Developer using the CData Software JDBC Driver for eBay.