CData Software - Knowledge Base
Recent Articles
-
Build a PostgreSQL Interface for JDBC-ODBC Bridge Data using the CData JDBC Driver
Use the Remoting features of the JDBC-ODBC Bridge JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Basecamp Data from MySQL in PHP
Connect to Basecamp through the standard MySQL libraries in PHP.
-
Integrate with live Amazon DynamoDB Data in Jitterbit
Use CData Connect AI to connect to and integrate live Amazon DynamoDB in Jitterbit.
-
Publish Microsoft Teams-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Microsoft Teams.
-
Use the CData API Server to Access SAP Hybris C4C Data in Microsoft PowerPivot
Use the CData API Server to connect to live SAP Hybris C4C in the Power Pivot business intelligence tool.
-
Access Live Google Ad Manager Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Ad Manager from your Excel spreadsheets.
-
Create Reports with ScrapingBee Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ScrapingBee.
-
Getting Started with the CData Power BI Connector for Act CRM
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Act CRM.
-
Build an OLAP Cube in SSAS from Gorgias Data
Establish a connection to Gorgias data from SQL Server Analysis Services, and use the Gorgias Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Klipfolio Data from PowerBuilder via JDBC
This article demonstrates how to access Klipfolio from PowerBuilder using the Klipfolio JDBC Driver.
-
How to Connect the Power BI Service to PolarTeamPro: Complete Guide
Connect to the CData Software Power BI Connector for PolarTeamPro from PowerBI.com to provide real-time PolarTeamPro across the organization.
-
Automated Continuous Pipedrive Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Pipedrive replication to Apache Cassandra.
-
How to work with Oracle Data in Apache Spark using SQL
Access and process Oracle Data in Apache Spark using the CData Software JDBC Driver.
-
Migrating data from Amplitude to Snowflake using CData SSIS Components.
Easily push Amplitude to Snowflake using the CData SSIS Tasks for Amplitude and Snowflake.
-
Analyze Stack Exchange Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Stack Exchange from Power Pivot. You will use the Table Import Wizard to load Stack Exchange. You can visually build the import query or use any SQL supported by the driver.
-
Automated Continuous Trello Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Trello replication to Amazon Redshift.
-
Explore Geographical Relationships in Quaderno Data with Power Map
Create data visualizations with Quaderno in Power Map.
-
Connect to SurveyMonkey Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for SurveyMonkey.
-
Analyze Google Translate Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Google Translate with the CData JDBC Driver for Google Translate.
-
How to Query Live Adobe Target Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Adobe Target data in natural language using Python.
-
Build Data Flows from Aweber to SQL Server using SSIS
Easily back up Aweber to SQL Server using the SSIS components for Aweber.
-
Working with PagerDuty Data in LINQPad
Execute LINQ queries to PagerDuty in LINQPad.
-
Connect to Shortcut from a Connection Pool in WebLogic
Use the CData JDBC Driver for Shortcut to connect to Shortcut from Web applications running on WebLogic.
-
Automated Continuous Google Campaign Manager 360 Replication to SQL Server
Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to SQL Server.
-
Query Zoho Inventory Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Zoho Inventory from Node.js.
-
Connect to Salesforce Pardot Data from PowerBuilder via ADO.NET
This article demonstrates how to access Salesforce Pardot from Appeon PowerBuilder using the CData ADO.NET Provider for Salesforce Pardot.
-
Connect to Google Ad Manager Data from a Connection Pool in JBoss
Integrate Google Ad Manager into Java servlets: Use the Management Console in JBoss to install the Google Ad Manager JDBC Driver.
-
DataBind Rootly Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Rootly to a chart.
-
Import Real-Time Act-On Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Act-On in ColdFusion.
-
Bridge Customer.io Connectivity with Apache NiFi
Access and process Customer.io in Apache NiFi using the CData JDBC Driver.
-
Build Exact Online-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Exact Online to explore live Exact Online Data in GitHub Copilot to assist with building Exact Online-powered applications.
-
Automated Continuous AlloyDB Replication to Amazon S3
Use CData Sync for automated, continuous, customizable AlloyDB replication to Amazon S3.
-
Import RSS Feeds into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access RSS Feeds. In this article, you will use the OData format to import RSS Feeds into Microsoft Power Query.
-
Integrating Trello Data in Talend Cloud Data Management Platform
Connect Trello Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Trello.
-
Integrate Live Google Contacts Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Google Contacts from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Google Contacts.
-
Use ChatGPT to Talk to Your Splunk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Splunk for you.
-
Build Dashboards with Auth0 Data in DBxtra
Create dynamic dashboards and perform analytics based on Auth0 in DBxtra.
-
Consume ActiveCampaign OData Feeds in SAP Lumira
Use the API Server to create data visualizations on ActiveCampaign feeds that reflect any changes in SAP Lumira.
-
Visualize BambooHR Data in Tableau
The CData ODBC driver for BambooHR enables you integrate BambooHR into Tableau dashboards.
-
Use the CData Software ODBC Driver for Quickbase in MicroStrategy Desktop
Connect to Quickbase in MicroStrategy Desktop using the CData Software ODBC Driver for Quickbase.
-
Analyze Paylocity Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Paylocity in Microsoft R Open.
-
Automate Clari Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Clari from PowerShell? This article demonstrates how to utilize the Clari Cmdlets for tasks like connecting to Clari, automating operations, downloading data, and more.
-
Create a Data Access Object for ZohoPeople Data using JDBI
A brief overview of creating a SQL Object API for ZohoPeople in JDBI.
-
How to Visualize SuiteCRM Data in Python with pandas
Use pandas and other modules to analyze and visualize live SuiteCRM in Python.
-
Use the CData Software ODBC Driver for Anaplan in SAS for Real-Time Reporting and Analytics
Connect to real-time Anaplan in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Anaplan.
-
How to Design HubDB Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to HubDB from mobile and tablet Power Apps.
-
Connect to MariaDB Data from HeidiSQL
Use CData Connect AI to connect to and query live MariaDB from HeidiSQL.
-
Build SAP Ariba Source-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for SAP Ariba Source to explore live SAP Ariba Source Data in GitHub Copilot to assist with building SAP Ariba Source-powered applications.
-
Use Microsoft Copilot Studio to talk to your CockroachDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your CockroachDB for you.
-
Create Reports from OneNote Data in Looker Studio
Use CData Connect AI to gain access to live Microsoft OneNote and create custom reports in Looker Studio.
-
Build Okta Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Okta and build visualizations in Tableau Cloud.
-
Connect to Coda Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Coda in the Denodo Virtual DataPort Administrator.
-
Build a PostgreSQL Interface for Salesloft Data using the CData JDBC Driver
Use the Remoting features of the Salesloft JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Data Flows from SQL Server to Reckon through SSIS
Easily push SQL Server data to Reckon using the CData SSIS Tasks for Reckon.
-
Integrating Claude Code CLI with Wrike 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.
-
How to Connect to Live Tally Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Tally ERP for you.
-
How to connect to Zoho Recruit Data in DBVisualizer
Integrate Zoho Recruit with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate Open WebUI with Live Jira Assets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Jira Assets from within the chat interface.
-
Build AI Agents with Neo4J 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 Neo4J through CData Connect AI.
-
Replicate Multiple Google Analytics Accounts via the CData Sync CLI
Replicate multiple Google Analytics accounts to one or many databases.
-
How to Connect Flowise AI Agents to Live Salesforce CRM Analytics Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Salesforce CRM Analytics without replication.
-
Build a PostgreSQL Interface for Workday Data using the CData JDBC Driver
Use the Remoting features of the Workday JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automate Intercom Data Replication to SAP HANA
Use CData Sync to customize and automate Intercom replication to SAP HANA.
-
Use Dash to Build Web Apps on Cassandra Data via CData Connect AI
Build interactive Dash web apps on live Apache Cassandra using pandas and the CData Connect AI Python SDK.
-
Import Real-Time Google Ads Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Google Ads in ColdFusion.
-
How to load Oracle Service Cloud data into Elasticsearch via Logstash
Introducing a simple method to load Oracle Service Cloud data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Viewing BenchmarkEmail Data in RAD Studio Data Explorer
How to view BenchmarkEmail in RAD Studio Data Explorer using the CData ODBC Driver for BenchmarkEmail.
-
How to Connect to & Open Drip Data in Microsoft Excel
This article uses the CData ODBC driver for Drip to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Migrating data from Salesforce Marketing to Snowflake using CData SSIS Components.
Easily push Salesforce Marketing Cloud to Snowflake using the CData SSIS Tasks for Salesforce Marketing and Snowflake.
-
Access Live SAP HANA Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live SAP HANA from your Excel spreadsheets.
-
A PostgreSQL Interface for Rootly Data (MySQL Remoting via JDBC)
Use the Remoting features of the Rootly JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to connect PolyBase to Elorus
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Elorus.
-
Integrate Live Redshift Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Redshift from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Amazon Redshift.
-
Migrating data from Google Tasks to Snowflake using CData SSIS Components.
Easily push Google Tasks to Snowflake using the CData SSIS Tasks for Google Tasks and Snowflake.
-
Analyze CockroachDB Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of CockroachDB and visualize CockroachDB in SAP Analytics Cloud.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for CampaignMonitor
Provide connectivity to CampaignMonitor through an SAP BusinessObjects universe.
-
Analyze Okta Data in Looker
Use CData Connect AI to connect to Okta Data from Looker and build custom apps using live Okta.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Act CRM
Provide connectivity to Act CRM through an SAP BusinessObjects universe.
-
How to connect Amazon QuickSight to Highrise Data
Create a connection to Highrise CRM in CData Connect AI and insert Highrise CRM into Amazon QuickSight SPICE to build interactive dashboards.
-
Automated Continuous Amazon Athena Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Amazon Athena replication to IBM DB2.
-
Write a Simple Go Application to work with Todoist Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Todoist.
-
Access Live Redshift Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Amazon Redshift in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Create Outreach.io-Connected Business Apps in AppSheet
Connect to Outreach.io Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Outreach.io.
-
Analyze SharePoint Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Microsoft SharePoint and visualize live Microsoft SharePoint in Infragistics Reveal.
-
How to Query Amplitude Data in MySQL Workbench
Execute MySQL queries against live Amplitude from MySQL Workbench.
-
Connect to NetSuite Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for NetSuite to connect to NetSuite CRM & ERP and execute queries in PowerBuilder.
-
Visualize Dropbox Data in TIBCO Spotfire through OData
Integrate Dropbox into dashboards in TIBCO Spotfire.
-
Add Printify Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Printify with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous Oracle SCM Replication to Snowflake
Use CData Sync for automated, continuous, customizable Oracle SCM replication to Snowflake.
-
Access Live Insightly Data in AWS Lambda
Connect to live Insightly in AWS Lambda using the CData JDBC Driver.
-
Integrate Live Lakebase Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Rapidly Develop SendInBlue-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 SendInBlue.
-
Create Data Visualizations in Cognos BI with GraphQL Data
Access GraphQL as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Excel Add-In Getting Started Guide
A basic guide to connecting Excel to data from anywhere using the CData Excel Add-In.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Omnisend
Provide connectivity to Omnisend through an SAP BusinessObjects universe.
-
How to import Adobe Experience Manager Data into Apache Solr
Use the CData Software JDBC Driver for Adobe Experience Manager in Data Import Handler and create an automated import of Adobe Experience Manager to Apache Solr Enterprise Search platform.
-
Integrate Theia IDE with Live Facebook Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Integrating LangChain with BigQuery Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Google BigQuery within automated workflows.
-
Connect to Pipeline CRM from a Connection Pool in WebLogic
Use the CData JDBC Driver for Pipeline CRM to connect to Pipeline CRM from Web applications running on WebLogic.
-
Create Wave Financial Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Wave Financial from PowerBI.com to create Power BI Dataflows with real-time data.