CData Software - Knowledge Base
Recent Articles
-
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 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 data 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 data 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 data 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 data. 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 data 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 data.
-
Analyze Google Translate Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Google Translate data 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 data in natural language using Python.
-
Build Data Flows from Aweber to SQL Server using SSIS
Easily back up Aweber data to SQL Server using the SSIS components for Aweber.
-
Working with PagerDuty Data in LINQPad
Execute LINQ queries to PagerDuty data in LINQPad.
-
Connect to Shortcut from a Connection Pool in WebLogic
Use the CData JDBC Driver for Shortcut to connect to Shortcut data from Web applications running on WebLogic.
-
Integrating Gumloop with XML Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on XML data within automated workflows.
-
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.
-
How to connect Amazon QuickSight to Discord Data
Create a connection to Discord data in CData Connect AI and insert Discord data into Amazon QuickSight SPICE to build interactive dashboards.
-
Create Mailgun-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Mailgun Data from OutSystems and build custom enterprise apps using live Mailgun data.
-
Query Zoho Inventory Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Zoho Inventory data from Node.js.
-
Connect to Salesforce Pardot Data from PowerBuilder via ADO.NET
This article demonstrates how to access Salesforce Pardot data from Appeon PowerBuilder using the CData ADO.NET Provider for Salesforce Pardot.
-
Connect and Visualize Live Bannerbear Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Bannerbear data into the Databricks platform and create visualization dashboards with real-time Bannerbear data.
-
Connect to Google Ad Manager Data from a Connection Pool in JBoss
Integrate Google Ad Manager data 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 data 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 data in ColdFusion.
-
Analyze Live Bitbucket Data in SAS Viya
Use CData Connect AI to connect to Bitbucket data from SAS Viya and deploy self-service analytics using live Bitbucket data.
-
Bridge Customer.io Connectivity with Apache NiFi
Access and process Customer.io data in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous AlloyDB Replication to Amazon S3
Use CData Sync for automated, continuous, customizable AlloyDB replication to Amazon S3.
-
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 data.
-
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 data for you.
-
Build Dashboards with Auth0 Data in DBxtra
Create dynamic dashboards and perform analytics based on Auth0 data 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.
-
Work with Live HubDB Data in Power Query
Use CData Connect AI to connect to HubDB data and work with live HubDB data in Microsoft Power Query.
-
Visualize BambooHR Data in Tableau
The CData ODBC driver for BambooHR enables you integrate BambooHR data into Tableau dashboards.
-
Use the CData Software ODBC Driver for Quickbase in MicroStrategy Desktop
Connect to Quickbase data 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 data in Microsoft R Open.
-
Automate Clari Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Clari data from PowerShell? This article demonstrates how to utilize the Clari Cmdlets for tasks like connecting to Clari data, 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 data in JDBI.
-
How to Visualize SuiteCRM Data in Python with pandas
Use pandas and other modules to analyze and visualize live SuiteCRM data in Python.
-
Use the CData Software ODBC Driver for Anaplan in SAS for Real-Time Reporting and Analytics
Connect to real-time Anaplan data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Anaplan.
-
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 data for you.
-
Create Reports from OneNote Data in Looker Studio
Use CData Connect AI to gain access to live OneNote data and create custom reports in Looker Studio.
-
Build Okta Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Okta data 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 data 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.
-
Visualize Live Moosend Data in the Power BI Service
Use CData Connect AI to connect to live Moosend data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
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 data for you.
-
How to connect to Zoho Recruit Data in DBVisualizer
Integrate Zoho Recruit data 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 data 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 data 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 data 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 data replication to SAP HANA.
-
Use Dash to Build Web Apps on Cassandra Data via CData Connect AI
Build interactive Dash web apps on live Cassandra data 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 data in ColdFusion.
-
Interact with Live SAP Netweaver Gateway Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live SAP Netweaver Gateway data.
-
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 data 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 data 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 data 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 data.
-
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 Redshift data.
-
Integrate Live Google Forms Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Google Forms data and integrate live Google Forms data into apps built in Microsoft Power Apps.
-
Migrating data from Google Tasks to Snowflake using CData SSIS Components.
Easily push Google Tasks data to Snowflake using the CData SSIS Tasks for Google Tasks and Snowflake.
-
Interact with Live GitLab Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live GitLab data.
-
Analyze CockroachDB Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of CockroachDB data and visualize CockroachDB data in SAP Analytics Cloud.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for CampaignMonitor
Provide connectivity to CampaignMonitor data 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 data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Act CRM
Provide connectivity to Act CRM data through an SAP BusinessObjects universe.
-
How to connect Amazon QuickSight to Highrise Data
Create a connection to Highrise data in CData Connect AI and insert Highrise data 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 data.
-
Access Live Redshift Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Redshift data 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 data.
-
Integrating Claude Code with AgileCRM Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on AgileCRM data within assisted coding and automated development workflows.
-
Analyze SharePoint Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of SharePoint data and visualize live SharePoint data in Infragistics Reveal.
-
How to Query Amplitude Data in MySQL Workbench
Execute MySQL queries against live Amplitude data 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 data and execute queries in PowerBuilder.
-
Visualize Dropbox Data in TIBCO Spotfire through OData
Integrate Dropbox data 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 data 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's Cascade agent to securely access and query live Lakebase data from within the IDE.
-
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 xBase-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to xBase Data from OutSystems and build custom enterprise apps using live xBase data.
-
Create Data Visualizations in Cognos BI with GraphQL Data
Access GraphQL data 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 data 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 data 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's built-in AI agents to securely access and query live Facebook Ads data from within the development environment.
-
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 BigQuery data 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 data 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.