CData Software - Knowledge Base
Recent Articles
-
How to Query Live Shopify Data in Claude Desktop
Connect to and query live Shopify Data in Claude Desktop using CData MCP Server.
-
Import Real-Time Printful Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Printful in ColdFusion.
-
Automated Continuous Monday.com Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Monday.com replication to Google BigQuery.
-
Connect Zendesk to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Zendesk using the CData Python MCP Server.
-
Use Agno to Talk to Your Outreach.io Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Outreach.io for you.
-
Automate Elorus Data Replication to Couchbase
Use CData Sync to Customize and automate Elorus replication to Couchbase.
-
Query Aha! Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Aha! from Node.js.
-
Automated Continuous Todoist Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Todoist replication to AlloyDB.
-
Integrate Cline with Live Apollo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Apollo from within your IDE.
-
ETL Sendwithus in Oracle Data Integrator
This article shows how to transfer Sendwithus into a data warehouse using Oracle Data Integrator.
-
How to load Amplitude data into Elasticsearch via Logstash
Introducing a simple method to load Amplitude data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Import Real-Time SQL Server Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Microsoft SQL Server in ColdFusion.
-
Visualize Live Mode Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Mode using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create Datasets from ZendeskSell in Domo Workbench and Build Visualizations of ZendeskSell Data in Domo
Use the CData Software ODBC Driver for ZendeskSell to create datasets from ZendeskSell in Domo Workbench and then build visualizations in the Domo service.
-
Create Data Visualizations in Cognos BI with Acumatica Data
Access Acumatica ERP as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Automated DocuSign Data Replication to Teradata
Use CData Sync to Customize and automate DocuSign replication to Teradata.
-
Create Guru Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Guru from PowerBI.com to create Power BI Dataflows with real-time data.
-
Migrating data from AgileCRM to Databricks using CData SSIS Components.
Easily push AgileCRM to Databricks using the CData SSIS Tasks for AgileCRM and Databricks.
-
Analyze Microsoft Ads Data in Cognos Analytics
Use CData Connect AI to connect to Microsoft Ads Data from Cognos Analytics and analyze live Microsoft Ads.
-
Getting Started with the CData Excel Add-In for PagerDuty
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for PagerDuty.
-
Visualize Live Sybase IQ Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Sybase IQ using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate Goose with Live Spark Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Apache Spark SQL from within the local AI agent.
-
Integrate with Live MailChimp Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to MailChimp from the MuleSoft Anypoint Platform to integrate live MailChimp into custom reports and dashboards.
-
Import SAP Fieldglass Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access SAP Fieldglass. In this article, you will use the OData format to import SAP Fieldglass into Microsoft Power Query.
-
Use JayDeBeApi to access Parallel Data in Python
Use standard Python scripting and the development environment of your choice to access live Parallel.
-
Build an OLAP Cube in SSAS from MySQL Data
Establish a connection to MySQL data from SQL Server Analysis Services, and use the MySQL Data Provider to build OLAP cubes for use in analytics and reporting.
-
Confluence Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Atlassian Confluence through CData Connect AI using different applications and tools.
-
Connect to Hive from a Connection Pool in WebLogic
Use the CData JDBC Driver for Hive to connect to Apache Hive from Web applications running on WebLogic.
-
Publish Reports with SAP Netweaver Gateway Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP Netweaver Gateway.
-
Migrating data from Beeminder to Google BigQuery using CData SSIS Components.
Easily push Beeminder to Google BigQuery using the CData SSIS Tasks for Beeminder and Google BigQuery.
-
Connect to Google Directory Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Google Directory.
-
Build Data Flows from SQL Server to Couchbase through SSIS
Easily push SQL Server data to Couchbase using the CData SSIS Tasks for Couchbase.
-
Establish a Live Connection with Omnisend Data using Tableau Bridge
The CData ODBC Driver for Omnisend enables you to integrate live Omnisend into Tableau Cloud dashboards using the Tableau Bridge.
-
Use CData Connect AI to Access Act CRM Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Act CRM in the Power Pivot business intelligence tool.
-
Use Microsoft Copilot Studio to talk to your Microsoft Teams 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 Microsoft Teams for you.
-
How to Connect to Zoho Books Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Zoho Books. Leverage the pyodbc module for ODBC in Python.
-
Visualize Live Sybase IQ Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Sybase IQ.
-
Use Dash to Build to Web Apps on FreshBooks Data
Create Python applications that use pandas and Dash to build FreshBooks-connected web apps.
-
Integrating Antigravity CLI with Klipfolio via CData CLI
Connect Klipfolio to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Visualize Live Flowlu Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Flowlu.
-
Visualize DocuSign Data in TIBCO Spotfire through OData
Integrate DocuSign into dashboards in TIBCO Spotfire.
-
Extract, Transform, and Load Grafana Data in Informatica PowerCenter
Create a simple Workflow for Grafana in Informatica PowerCenter.
-
Connect to ShipEngine Data from PowerBuilder via ADO.NET
This article demonstrates how to access ShipEngine from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Use the CData Software JDBC Driver for ZendeskSell in MicroStrategy
Connect to ZendeskSell in MicroStrategy Developer using the CData Software JDBC Driver for ZendeskSell.
-
Integrate PDFMonkey Data in the Pentaho Report Designer
Publish reports based on PDFMonkey in the Pentaho BI tool.
-
Integrate Google Cloud Storage with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Google Cloud Storage with External Services.
-
Automate BigQuery Data Replication to SAP HANA
Use CData Sync to customize and automate Google BigQuery replication to SAP HANA.
-
Create Instagram-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Instagram Data from Klipfolio and build custom visualizations using live Instagram.
-
How to Build an ETL App for Oracle HCM Cloud Data in Python with CData
Create ETL applications and real-time data pipelines for Oracle HCM Cloud in Python with petl.
-
Connect to Google Ads in SpagoBI
Create reports featuring live Google Ads in SpagoBI Studio. Host Google Ads reports on SpagoBI Server.
-
Create Power BI Reports on Real-Time ZohoExpense Data
Use the CData ODBC Driver for ZohoExpense to visualize ZohoExpense in Power BI Desktop.
-
Connect to Azure Synapse from a Connection Pool in WebLogic
Use the CData JDBC Driver for Azure Synapse to connect to Azure Synapse from Web applications running on WebLogic.
-
Replicate Insightly Data in Heroku for Use in Salesforce Connect
Replicate Insightly to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Seamlessly Import Quaderno Data into IBM SPSS Modeler
Integrate Quaderno data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Process & Analyze AdRoll Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live AdRoll Data.
-
Build YouTube Analytics-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to YouTube Analytics and build web apps with connectivity to live YouTube Analytics.
-
Analyze Cassandra Data in Looker
Use CData Connect AI to connect to Cassandra Data from Looker and build custom apps using live Apache Cassandra.
-
How to import Foursquare Data into Apache Solr
Use the CData Software JDBC Driver for Foursquare in Data Import Handler and create an automated import of Foursquare to Apache Solr Enterprise Search platform.
-
Use Azure AI Foundry to Talk to Your NetSuite SuiteAnalytics 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 NetSuite SuiteAnalytics for you.
-
Provide OData Services of Freshteam Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Freshteam by developing a WCF Service Application.
-
Connect to and Visualize Live BigQuery Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Google BigQuery.
-
Analyze Sybase Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Sybase and visualize live Sybase in Infragistics Reveal.
-
How to create Salesloft federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Salesloft in MySQL .
-
Connect to Act CRM Data in RapidMiner
Integrate Act CRM with standard components and data source configuration wizards in RapidMiner Studio.
-
Choosing the Best Method to Connect Drift to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Drift from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Continuous FreeAgent Replication to AlloyDB
Use CData Sync for automated, continuous, customizable FreeAgent replication to AlloyDB.
-
Integrating Anaplan Data in Talend Cloud Data Management Platform
Connect Anaplan Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Anaplan.
-
Back Up SAP HANA XS Advanced to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SAP HANA XS Advanced. In this article, we will employ an SSIS workflow to populate a database with SAP HANA XS Advanced data.
-
Establish a Live Connection with Pinecone Data using Tableau Bridge
The CData ODBC Driver for Pinecone enables you to integrate live Pinecone into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Work with ClickUp Data in ETL Validator JDBC
Connect to ClickUp from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to and Query Clockify Data in QlikView over ODBC
Create data visualizations with Clockify in QlikView.
-
Query OData Services through ODBC in Node.js
Use node-odbc to execute SQL queries against OData from Node.js.
-
How to publish and share Act CRM Data dashboards with Tableau Server
The CData ODBC driver for Act CRM enables you integrate Act CRM into Tableau dashboards.
-
Natively Connect to Oracle SCM Data in PHP
The CData ODBC driver for Oracle SCM enables you to create PHP applications with connectivity to Oracle SCM. Leverage the native support for ODBC in PHP.
-
Connect to Recurly Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Recurly and work with Recurly in your FileMaker applications.
-
Connect to ConstantContact Data in RapidMiner
Integrate ConstantContact with standard components and data source configuration wizards in RapidMiner Studio.
-
Build Dashboards with Act CRM Data in Dundas BI
Create dynamic dashboards and perform analytics based on Act CRM in Dundas BI.
-
Connect to Microsoft Ads from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Microsoft Ads, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Create SSAS Tabular Models from Codat Data
How to build a SQL Server Analysis Service Tabular Model from Codat using CData drivers.
-
Build a PostgreSQL Interface for SAP Ariba Procurement Data using the CData JDBC Driver
Use the Remoting features of the SAP Ariba Procurement JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Presto-Connected Dashboards in Grafana
Connect to Presto Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Presto.
-
Connect to Acumatica Data from PowerBuilder via JDBC
This article demonstrates how to access Acumatica ERP from PowerBuilder using the Acumatica JDBC Driver.
-
Connect to Klaviyo Data in HULFT Integrate
Connect to Klaviyo as a JDBC data source in HULFT Integrate
-
Migrating data from PagerDuty to Databricks using CData SSIS Components.
Easily push PagerDuty to Databricks using the CData SSIS Tasks for PagerDuty and Databricks.
-
Integrating Kiro CLI with Salesforce Marketing 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 integrate Metabase with BigCommerce Data
Use CData Connect AI to connect to live BigCommerce and create an interactive dashboard in Metabase from BigCommerce.
-
Build Office 365-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Office 365 to explore live Office 365 Data in GitHub Copilot to assist with building Office 365-powered applications.
-
Use the CData Software JDBC Driver for Paymo in MicroStrategy Web
Connect to Paymo in MicroStrategy Web using the CData Software JDBC Driver for Paymo.
-
Consume Microsoft OneDrive OData Feeds in PowerBuilder
This article demonstrates how to consume Microsoft OneDrive as OData feeds from PowerBuilder using the API Server.
-
Use the CData Software JDBC Driver for SurveyMonkey in MicroStrategy
Connect to SurveyMonkey in MicroStrategy Developer using the CData Software JDBC Driver for SurveyMonkey.
-
How to Connect to Tally Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Tally ERP. Leverage the pyodbc module for ODBC in Python.
-
Validate Apollo Data with QuerySurge
Access and validate Apollo in QuerySurge using the CData JDBC Driver.
-
Back Up Codat 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 Codat data.
-
Automated Continuous ZohoMarketingHub Replication to SingleStore
Use CData Sync for automated, continuous, customizable ZohoMarketingHub replication to SingleStore.
-
How to connect and process PhantomBuster from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live PhantomBuster.
-
How to Query Live Paylocity Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Paylocity data in natural language using Python.
-
Create Data Visualizations in Cognos BI with Snowflake Data
Access Snowflake as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Use the CData Software ODBC Driver for SparkPost in MicroStrategy Desktop
Connect to SparkPost in MicroStrategy Desktop using the CData Software ODBC Driver for SparkPost.
-
Integrate Live Active Directory Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Active Directory and integrate live Active Directory into apps built in Microsoft Power Apps.
-
Visualize Live Cloudant Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live IBM Cloudant using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.