CData Software - Knowledge Base
Recent Articles
-
How to Query Retently Data in MySQL Workbench
Execute MySQL queries against live Retently from MySQL Workbench.
-
Connect to SharePoint Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Microsoft SharePoint.
-
Viewing Tanda Data in RAD Studio Data Explorer
How to view Tanda in RAD Studio Data Explorer using the CData ODBC Driver for Tanda.
-
Connect to Odoo Data in DBeaver
Use the CData ODBC Driver to connect to Odoo ERP in DBeaver.
-
A PostgreSQL Interface for Avro Data (MySQL Remoting via JDBC)
Use the Remoting features of the Avro JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Salesforce CRM Analytics Data in Ruby
Connect to Salesforce CRM Analytics in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Export Data from SQL Server to Salesforce Through SSIS
Easily push SQL Server data to Salesforce using the CData SSIS Tasks for Salesforce. This example uses an SSIS workflow to populate Salesforce with data from a SQL Server database using the CData SSIS Tasks for Salesforce.
-
Build Semantic Layer Views for Bullhorn CRM Data in APOS Live Data Gateway
Use the CData Connector for Bullhorn CRM in APOS Live Data Gateway to build Semantic Layer Views for Bullhorn CRM.
-
Connect to Humanity in SpagoBI
Create reports featuring live Humanity in SpagoBI Studio. Host Humanity reports on SpagoBI Server.
-
Object-Relational Mapping (ORM) with Twitter Ads 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 Twitter Ads into a Java-based ORM framework, Hibernate.
-
Integrate Live DB2 Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to DB2 from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live IBM DB2.
-
Automated Continuous Klipfolio Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Klipfolio replication to PostgreSQL.
-
How to connect Amazon QuickSight to Adobe Analytics Data
Create a connection to Adobe Analytics in CData Connect AI and insert Adobe Analytics into Amazon QuickSight SPICE to build interactive dashboards.
-
Create Dynamic Basecamp Grids Using the Infragistics XamDataGrid
Learn how you can connect Basecamp to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Gong Data in Aqua Data Studio
Access Gong from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrate with Active Directory Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Active Directory in SnapLogic.
-
Create Data Visualizations Based On Quickbase Data in Mode
Use CData Connect AI to connect to Quickbase Data from Mode and build visualizations using live
-
How to create Recurly federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Recurly in MySQL .
-
Replicate Datadog Data to Multiple Databases via the CData Sync CLI
Replicate Datadog to disparate databases with a single configuration.
-
Build an OLAP Cube in SSAS from GitLab Data
Establish a connection to GitLab data from SQL Server Analysis Services, and use the GitLab Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to load Couchbase data into Elasticsearch via Logstash
Introducing a simple method to load Couchbase data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrating Antigravity CLI with Moosend via CData CLI
Connect Moosend to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Bridge Oracle Sales Connectivity with Apache NiFi
Access and process Oracle Sales in Apache NiFi using the CData JDBC Driver.
-
Connect to SuiteCRM Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for SuiteCRM.
-
Integrate Live Spark Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Apache Spark SQL to Blue Prism using the CData ODBC Driver for Spark to create automated workflows for repetitive business tasks.
-
Automate Oracle Sales Data Replication to Azure Synapse
Use CData Sync to customize and automate Oracle Sales replication to Azure Synapse.
-
Consume LinkedIn OData Feeds in PowerBuilder
This article demonstrates how to consume LinkedIn as OData feeds from PowerBuilder using the API Server.
-
Build a Singer.io Tap for BenchmarkEmail With the CData Python Connector
Learn how to easily build a Singer.io Tap for live BenchmarkEmail data using
-
Bridge Adobe Commerce Connectivity with Apache NiFi
Access and process Adobe Commerce in Apache NiFi using the CData JDBC Driver.
-
Use Grok to Talk to Your Avro Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Apache Avro for you.
-
Connect to Adobe Analytics Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Adobe Analytics.
-
Access MongoDB 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 MongoDB.
-
Integrate Live SAP SuccessFactors Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to SAP SuccessFactors and integrate live SAP SuccessFactors into apps built in Microsoft Power Apps.
-
Connecting Moonlit Workflow with eBay Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your eBay in real time.
-
Explore Geographical Relationships in Wave Financial Data with Power Map
Create data visualizations with Wave Financial in Power Map.
-
Connect to ZendeskSell Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for ZendeskSell to connect to ZendeskSell and execute queries in PowerBuilder.
-
Use Manus AI to Talk to Your Redshift Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Amazon Redshift.
-
Use JayDeBeApi to access Short.io Data in Python
Use standard Python scripting and the development environment of your choice to access live Short.io.
-
Visualize SAP Ariba Procurement Data in Tableau
The CData ODBC driver for SAP Ariba Procurement enables you integrate SAP Ariba Procurement into Tableau dashboards.
-
Build a PostgreSQL Interface for Bannerbear Data using the CData JDBC Driver
Use the Remoting features of the Bannerbear JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData API Server to Access Teradata Data in Microsoft PowerPivot
Use the CData API Server to connect to live Teradata in the Power Pivot business intelligence tool.
-
Import Real-Time Nuclia Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Nuclia in ColdFusion.
-
Automated Continuous Facebook Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Facebook replication to Amazon S3.
-
Use the CData ODBC Driver for Office 365 in Microsoft Power Query
You can use the CData Office 365 ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Microsoft Office 365 into Microsoft Power Query.
-
Visualize Datadog Data in Tableau
The CData ODBC driver for Datadog enables you integrate Datadog into Tableau dashboards.
-
Build Supabase-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Supabase.
-
Excel Spreadsheet Automation on Clio Data with the QUERY Formula
Pull data from Clio, automate spreadsheets, and more with the QUERY formula.
-
Connect to Live GraphQL Data in MicroStrategy through CData Connect AI
Create a live connection to GraphQL Data in CData Connect AI and connect to your GraphQL from MicroStrategy.
-
Getting Started with the CData Python Connector for Brex
Learn to install and license the CData Python Connector
-
Choosing the Best Method to Connect Harvest to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Harvest from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use the CData Software JDBC Driver for HubDB in MicroStrategy Web
Connect to HubDB in MicroStrategy Web using the CData Software JDBC Driver for HubDB.
-
Query QuickBooks Data as a MySQL Database in Node.js
Execute MySQL queries against QuickBooks Desktop from Node.js.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Salesforce
Provide connectivity to Salesforce & Force.com through an SAP BusinessObjects universe.
-
Query Drip Data in DataGrip
Create a Data Source for Drip in DataGrip and use SQL to query live Drip.
-
Automated Continuous TaxJar Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable TaxJar replication to Azure SQL Database.
-
Access Dynamics NAV Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Microsoft Dynamics NAV from HeidiSQL.
-
Consume Suadeo OData Feeds in PowerBuilder
This article demonstrates how to consume Suadeo as OData feeds from PowerBuilder using the API Server.
-
Import Real-Time Bitly Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Bitly in ColdFusion.
-
Access Live SAP Ariba Procurement Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAP Ariba Procurement from your Google Sheets.
-
Automated Continuous BigCommerce Replication to SingleStore
Use CData Sync for automated, continuous, customizable BigCommerce replication to SingleStore.
-
Moving Data from Sybase IQ to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Sybase IQ data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrate with Live ShipStation Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to ShipStation from the MuleSoft Anypoint Platform to integrate live ShipStation into custom reports and dashboards.
-
Import and Visualize Typeform Data in Power View
Create data visualizations based on Typeform in Excel.
-
How to Query Live Splunk Data in Perplexity MacOS Desktop
Connect to and query live Splunk Data in Perplexity Desktop using CData MCP Server.
-
Getting Started with the CData Connect AI Python SDK for Trello
Install the CData Connect AI Python SDK to read and write live Trello with standard DB-API 2.0 Python code.
-
Automated Continuous Retently Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Retently replication to Azure SQL Database.
-
How to Query Live IBM Cloud Object Storage Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live IBM Cloud Object Storage data in natural language using Python.
-
How to connect to Planio Data in DBVisualizer
Integrate Planio with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Odoo Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Odoo Data and connect to Odoo ERP in Akorbi Digital RunMyProcess.
-
Publish Reports with Teradata Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Teradata.
-
Use Dash to Build Web Apps on Sage Intacct Data via CData Connect AI
Build interactive Dash web apps on live Sage Intacct using pandas and the CData Connect AI Python SDK.
-
Use the CData Software JDBC Driver for Outlook in MicroStrategy
Connect to Outlook in MicroStrategy Developer using the CData Software JDBC Driver for Outlook.
-
Create a Data Access Object for Customer.io Data using JDBI
A brief overview of creating a SQL Object API for Customer.io in JDBI.
-
Import and Visualize Bitbucket Data in Power View
Create data visualizations based on Bitbucket in Excel.
-
Connect to SAP Business Warehouse from Asprova with CData Software ODBC Driver for SAP Business Warehouse
This article shows how to connect faster to SAP Business Warehouse data from Asprova.
-
Visualize Samanage Data in TIBCO Spotfire through ADO.NET
Integrate Samanage into dashboards in TIBCO Spotfire.
-
Superchat Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Superchat facts in real time.
-
Access Insightly Data from MySQL in Amazon QuickSight
Connect to Insightly and build visualizations of Insightly using a MySQL Connection in Amazon QuickSight.
-
Configure the CData JDBC Driver for Webex in a Connection Pool in Tomcat
Connect to Webex from a connection pool in Tomcat.
-
DataBind Controls to ZohoSubscriptions Data in Delphi
DataBind to ZohoSubscriptions in Delphi with standard data access components and controls.
-
Connect to Jira Assets Data in Aqua Data Studio
Access Jira Assets from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Connect to Live Zoho Inventory Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Zoho Inventory for you.
-
Connect NetSuite Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your NetSuite CRM & ERP using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Build an ETL App for Microsoft Ads Data in Python with CData Connect AI
Build ETL pipelines that read and write live Microsoft Ads in Python with petl and the CData Connect AI Python SDK.
-
Connect to Freshsales from a Connection Pool in WebLogic
Use the CData JDBC Driver for Freshsales to connect to Freshsales from Web applications running on WebLogic.
-
Connect to Sage Cloud Accounting Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Sage Business Cloud Accounting in Airbyte.
-
Feed LDAP Objects into FineReport
How to set LDAP as a JDBC data source in FineReport.
-
How to Access Browserless Data Using Entity Framework
This article shows how to access Browserless using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to Create Power BI Visual Reports with Real-Time iContact Data
Use CData Power BI Connectors to visualize iContact in Power BI.
-
Analyze Live FHIR Data in SAS Viya
Use CData Connect AI to connect to FHIR from SAS Viya and deploy self-service analytics using live FHIR.
-
Build Microsoft Planner-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Microsoft Planner to explore live Microsoft Planner Data in Cursor to assist with building Microsoft Planner-powered applications.
-
Connect to Printify Data in DBeaver
Use the CData ODBC Driver to connect to Printify in DBeaver.
-
Connect to GitHub in SpagoBI
Create reports featuring live GitHub in SpagoBI Studio. Host GitHub reports on SpagoBI Server.
-
Extract, Transform, and Load Google Sheets Data in Informatica PowerCenter
Create a simple Workflow for Google Sheets in Informatica PowerCenter.
-
Access Live AfterShip Data in AWS Lambda
Connect to live AfterShip in AWS Lambda using the CData JDBC Driver.
-
Operational Reporting on SendGrid Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SendGrid.
-
Build Agents in Relevance AI with Access to Live YouTube Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on YouTube Analytics within intelligent agent workflows.
-
Automated Continuous REST Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable REST replication to PostgreSQL.
-
How to Work with Aweber Data in AWS Glue Jobs Using JDBC
Connect to Aweber from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Enable the Jira Assets JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Jira Assets.