CData Software - Knowledge Base
Recent Articles
-
Connect to Google Ads in SpagoBI
Create reports featuring live Google Ads data 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 data 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 data from Web applications running on WebLogic.
-
Replicate Insightly Data in Heroku for Use in Salesforce Connect
Replicate Insightly data 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.
-
How to integrate Metabase with AfterShip Data
Use CData Connect AI to connect to live AfterShip data and create an interactive dashboard in Metabase from AfterShip data.
-
Build YouTube Analytics-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to YouTube Analytics data and build web apps with connectivity to live YouTube Analytics data.
-
Automated Continuous Gumroad Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Gumroad replication to PostgreSQL.
-
Analyze Cassandra Data in Looker
Use CData Connect AI to connect to Cassandra Data from Looker and build custom apps using live Cassandra data.
-
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 data 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 data 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 data 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 BigQuery data.
-
How to create Salesloft federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Salesloft data in MySQL .
-
Use ChatGPT to Talk to Your Jumpseller 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 Jumpseller data for you.
-
Connect to Act CRM Data in RapidMiner
Integrate Act CRM data with standard components and data source configuration wizards in RapidMiner Studio.
-
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 data 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 data.
-
Establish a Live Connection with Pinecone Data using Tableau Bridge
The CData ODBC Driver for Pinecone enables you to integrate live Pinecone data 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 data in QlikView.
-
Query OData Services through ODBC in Node.js
Use node-odbc to execute SQL queries against OData services 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 data into Tableau dashboards.
-
Automated Continuous Mixpanel Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Mixpanel replication to IBM DB2.
-
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 data. 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 data in your FileMaker applications.
-
Connect to ConstantContact Data in RapidMiner
Integrate ConstantContact data 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 data 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 data, 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 data 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 data.
-
Connect to Acumatica Data from PowerBuilder via JDBC
This article demonstrates how to access Acumatica data 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 data to Databricks using the CData SSIS Tasks for PagerDuty and Databricks.
-
Integrating Kiro 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 data and create an interactive dashboard in Metabase from BigCommerce data.
-
Use the CData Software JDBC Driver for Paymo in MicroStrategy Web
Connect to Paymo data in MicroStrategy Web using the CData Software JDBC Driver for Paymo.
-
Use Microsoft Copilot Studio to talk to your ZohoDesk 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 ZohoDesk data for you.
-
Consume Microsoft OneDrive OData Feeds in PowerBuilder
This article demonstrates how to consume Microsoft OneDrive data as OData feeds from PowerBuilder using the API Server.
-
Use the CData Software JDBC Driver for SurveyMonkey in MicroStrategy
Connect to SurveyMonkey data 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 data. Leverage the pyodbc module for ODBC in Python.
-
Validate Apollo Data with QuerySurge
Access and validate Apollo data in QuerySurge using the CData JDBC Driver.
-
Back Up Codat data 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 data.
-
Automated Continuous ZohoMarketingHub Replication to SingleStore
Use CData Sync for automated, continuous, customizable ZohoMarketingHub replication to SingleStore.
-
How to connect and process PhantomBuster data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live PhantomBuster data.
-
How to Query Live Paylocity Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Paylocity data data in natural language using Python.
-
Create Data Visualizations in Cognos BI with Snowflake Data
Access Snowflake data 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 data 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 data and integrate live Active Directory data 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 Cloudant data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous LDAP Replication to Amazon S3
Use CData Sync for automated, continuous, customizable LDAP replication to Amazon S3.
-
Build eBay Analytics-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to eBay Analytics data and build web apps with connectivity to live eBay Analytics data.
-
Automated Continuous Timely Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Timely replication to Amazon Redshift.
-
Connect and Query Live DocuSign Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live DocuSign data into Databricks and enable direct, live querying and analysis without replication.
-
Connect to Nethunt Data from a Connection Pool in Jetty
The Nethunt JDBC Driver supports connection pooling: This article shows how to connect faster to Nethunt data from Web apps in Jetty.
-
DataBind Controls to Raisers Edge NXT Data in C++Builder
DataBind to Raisers Edge NXT data in C++Builder with standard components and controls.
-
How to connect to CapsuleCRM Data from Spring Boot
Connect to CapsuleCRM in a Spring Boot Application using the CData API Driver for JDBC
-
Integrating Kiro with ShipEngine 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 Adobe Commerce Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Adobe Commerce data into custom reports in Power BI.
-
Use Manus AI to Talk to Your Jumpseller 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 Jumpseller data.
-
Create Informatica Mappings From/To a JDBC Data Source for SharePoint
Create SharePoint data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Import Real-Time JobNimbus Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use JobNimbus data in ColdFusion.
-
Integrate Goose with Live FTP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live FTP data from within the local AI agent.
-
Build a PostgreSQL Interface for Placid Data using the CData JDBC Driver
Use the Remoting features of the Placid JDBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData SSIS Components for Datadog
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Datadog.
-
Replicate AlloyDB Data from PowerShell
Write a quick PowerShell script to query AlloyDB data. Use connectivity to the live data to replicate AlloyDB data to SQL Server.
-
Visualize Stripe Data in TIBCO Spotfire through OData
Integrate Stripe data into dashboards in TIBCO Spotfire.
-
How to publish and share SurveyMonkey Data dashboards with Tableau Server
The CData ODBC driver for SurveyMonkey enables you integrate SurveyMonkey data into Tableau dashboards.
-
Getting Started with the CData SSIS Components for ClickUp
Complete guide to installing, licensing, and connecting with the CData SSIS Components for ClickUp.
-
How to Build an ETL App for Pinecone Data in Python with CData
Create ETL applications and real-time data pipelines for Pinecone data in Python with petl.
-
Connect Zoho Books to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Zoho Books data using the CData Python MCP Server.
-
Integrate Live ActiveCampaign 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 ActiveCampaign data from within the IDE.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for CockroachDB
Provide connectivity to CockroachDB data through an SAP BusinessObjects universe.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Hacker News
Provide connectivity to Hacker News data through an SAP BusinessObjects universe.
-
Automated Continuous BenchmarkEmail Replication to SingleStore
Use CData Sync for automated, continuous, customizable BenchmarkEmail replication to SingleStore.
-
Integrate CapsuleCRM with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate CapsuleCRM with External Services.
-
Stream SAP HANA XS Advanced Data into Apache Kafka Topics
Access and stream SAP HANA XS Advanced data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Auth0 Data in Jaspersoft Studio
Execute SQL to remote Auth0 data in Jaspersoft Studio.
-
Connect to Amazon Marketplace Data in Jaspersoft Studio
Execute SQL to remote Amazon Marketplace data in Jaspersoft Studio.
-
How to connect PolyBase to Slack
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Slack data.
-
Connect to AlloyDB Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for AlloyDB data in the Denodo Virtual DataPort Administrator.
-
Visualize WooCommerce 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 WooCommerce data into TIBCO Spotfire.
-
Integrating Antigravity CLI with Square data via CData CLI
Connect Square data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Provide OData Services of MYOB AccountRight Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for MYOB AccountRight data by developing a WCF Service Application.
-
Integrate Nethunt Data in Pentaho Data Integration
Build ETL pipelines based on Nethunt data in the Pentaho Data Integration tool.
-
Connect to Bitly Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Bitly data.
-
Integrate Goose with Live Lakebase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Lakebase data from within the local AI agent.
-
Visualize Live Salesloft Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Salesloft data into custom reports in Power BI.
-
Connect to FHIR Data in ACL Analytics
Connect to FHIR data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to FHIR data.
-
Import and Visualize Deel Data in Power View
Create data visualizations based on Deel data in Excel.
-
Integrate Trae with Live FreshBooks Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live FreshBooks data from within the AI-powered IDE.
-
A PostgreSQL Interface for Teamwork Data using the CData ODBC Driver
Use the SQL Gateway and Teamwork ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Gumroad Replication to SingleStore
Use CData Sync for automated, continuous, customizable Gumroad replication to SingleStore.
-
Build Cosmos DB-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Cosmos DB Data from Zoho Analytics and import live Cosmos DB data.
-
Connect to and Visualize Live MailChimp Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live MailChimp data.
-
3 Ways to Integrate External Data Sources with FileMaker via CData ODBC Drivers
Three ways to connect Claris FileMaker to external data via CData ODBC Drivers: ODBC import, FileMaker scripting, and live ESS through the SQL Gateway.
-
A PostgreSQL Interface for Box Data using the CData ODBC Driver
Use the SQL Gateway and Box ODBC Driver to create a PostgreSQL entry-point for data access.