CData Software - Knowledge Base
Recent Articles
-
Connect to Foursquare Data in RapidMiner
Integrate Foursquare with standard components and data source configuration wizards in RapidMiner Studio.
-
DataBind Charts to Chargebee Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Chargebee from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Choosing the Best Method to Connect Rootly to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Rootly from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Query Live SparkPost Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SparkPost data in natural language using Python.
-
Build HCL Domino-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live HCL Domino.
-
How to Visualize Facebook Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Facebook in Python.
-
Replicate Klaviyo Data from PowerShell
Write a quick PowerShell script to query Klaviyo. Use connectivity to the live data to replicate Klaviyo to SQL Server.
-
Publish SpaceX-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live SpaceX.
-
How to work with Google Calendar Data in Apache Spark using SQL
Access and process Google Calendar Data in Apache Spark using the CData Software JDBC Driver.
-
Build Apps with Live SAP Ariba Source in Adalo using CData Connect AI
Use CData Connect AI to integrate live SAP Ariba Source into the Adalo platform and build custom mobile and web applications with real-time SAP Ariba Source.
-
Build Apps with Live Reckon Accounts Hosted in Adalo using CData Connect AI
Use CData Connect AI to integrate live Reckon Accounts Hosted into the Adalo platform and build custom mobile and web applications with real-time Reckon Accounts Hosted.
-
Build Semantic Layer Views for Tanda Data in APOS Live Data Gateway
Use the CData Connector for Tanda in APOS Live Data Gateway to build Semantic Layer Views for Tanda.
-
Build MVC Applications with Connectivity to Act-On Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Act-On from an ASP.NET MVC application.
-
How to Access Jodoo Data Using Entity Framework
This article shows how to access Jodoo using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Use the CData Software ODBC Driver for Landbot in MicroStrategy
Connect to Landbot in MicroStrategy Developer using the CData Software ODBC Driver for Landbot.
-
Build Voice Agents in ElevenLabs with access to Live Couchbase Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Couchbase.
-
Analyze Xero Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Xero Accounting and visualize live Xero Accounting in Infragistics Reveal.
-
Import Okta Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Okta Data and provide access to live Okta for custom reports in the Power BI Service.
-
Automated Continuous BigCommerce Replication to SQL Server
Use CData Sync for automated, continuous, customizable BigCommerce replication to SQL Server.
-
Viewing AdRoll Data in RAD Studio Data Explorer
How to view AdRoll in RAD Studio Data Explorer using the CData ODBC Driver for AdRoll.
-
Integrating GitHub Copilot CLI with Chargebee 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 Access Live Mode Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Mode enables you to integrate Mode into workflows built using Microsoft Power Automate Desktop.
-
Connect to Jira Data in Google Apps Script via Connect AI
Use CData Connect AI to access Atlassian Jira in Google Apps Script.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Reckon Accounts Hosted
Provide connectivity to Reckon Accounts Hosted through an SAP BusinessObjects universe.
-
How to work with Blackbaud FE NXT Data in Apache Spark using SQL
Access and process Blackbaud FE NXT Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Salesforce CRM Analytics Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Salesforce CRM Analytics from Filemaker Pro on Mac.
-
Access Live PDFMonkey Data in AWS Lambda
Connect to live PDFMonkey in AWS Lambda using the CData JDBC Driver.
-
Visualize JSON Services in Sisense
Create an ElastiCube in Sisense app with access to JSON.
-
Build Voice Agents in ElevenLabs with access to Live ActiveCampaign Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live ActiveCampaign.
-
Automated Continuous Azure Data Catalog Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Azure Data Catalog replication to Apache Cassandra.
-
Automated Continuous SAP BusinessObjects BI Replication to SingleStore
Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to SingleStore.
-
How to Visualize Power BI XMLA Data in Python with pandas
Use pandas and other modules to analyze and visualize live Power BI XMLA in Python.
-
ETL SAP HANA in Oracle Data Integrator
This article shows how to transfer SAP HANA into a data warehouse using Oracle Data Integrator.
-
Getting Started with the CData JDBC Driver for Harvest
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Harvest.
-
Choosing the Best Method to Connect SAP HANA XS Advanced to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SAP HANA XS Advanced from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Create Reports with Google Forms Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Forms.
-
ETL Azure Data Catalog in Oracle Data Integrator
This article shows how to transfer Azure Data Catalog into a data warehouse using Oracle Data Integrator.
-
Bind Live DB2 Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live DB2 data
-
Create SSAS Tabular Models from Vault CRM Data
How to build a SQL Server Analysis Service Tabular Model from Veeva Vault & Vault CRM using CData drivers.
-
Create DocuSign-Connected Dashboards in Grafana
Connect to DocuSign Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to DocuSign.
-
Automated Continuous ZendeskSell Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable ZendeskSell replication to Amazon Redshift.
-
Choosing the Best Method to Connect Excel Online to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Microsoft Excel Online from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Access Avalara AvaTax Data from MySQL in Amazon QuickSight
Connect to Avalara AvaTax and build visualizations of Avalara AvaTax using a MySQL Connection in Amazon QuickSight.
-
How to Design Avalara AvaTax Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Avalara AvaTax from mobile and tablet Power Apps.
-
Create HubSpot-Connected Business Apps in AppSheet
Connect to HubSpot Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to HubSpot.
-
Build GraphQL-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to GraphQL and build web apps with connectivity to live GraphQL.
-
DataBind Charts to Testmonitor Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Testmonitor from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Connecting Mastra with PayPal Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time PayPal, no replication required.
-
Automated Continuous SAP Concur Replication to MongoDB
Use CData Sync for automated, continuous, customizable SAP Concur replication to MongoDB.
-
Build AI/ML Models with Live Miro Data using Dataiku
Connect Miro Data with Dataiku using the CData API Driver for JDBC.
-
Replicate Multiple Attio Accounts via the CData Sync CLI
Replicate multiple Attio accounts to one or many databases.
-
Create Data Visualizations in Cognos BI with Zoho Books Data
Access Zoho Books as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Work with Zoho Books Data in AWS Glue Jobs Using JDBC
Connect to Zoho Books from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous Teamgate Replication to MySQL
Use CData Sync for automated, continuous, customizable Teamgate replication to MySQL.
-
Connect to Zoho Inventory Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Zoho Inventory.
-
Replicate Couchbase Data from PowerShell
Write a quick PowerShell script to query Couchbase. Use connectivity to the live data to replicate Couchbase to SQL Server.
-
Using the CData Software ODBC Driver for MessageBird in PyCharm
Connect to MessageBird as an ODBC data source in PyCharm using the CData Software ODBC Driver for MessageBird.
-
Feed Authorize.Net Data into FineReport
How to set Authorize.Net as a JDBC data source in FineReport.
-
Feed Zoho Inventory Data into FineReport
How to set Zoho Inventory as a JDBC data source in FineReport.
-
Use the CData Software ODBC Driver for Trello in MicroStrategy Desktop
Connect to Trello in MicroStrategy Desktop using the CData Software ODBC Driver for Trello.
-
How to Build an ETL App for Certinia Data in Python with CData
Create ETL applications and real-time data pipelines for Certinia in Python with petl.
-
Automate Oracle SCM Data Replication to Couchbase
Use CData Sync to Customize and automate Oracle SCM replication to Couchbase.
-
Build Visualizations of ClickTime Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of ClickTime in Birst.
-
Establish a Live Connection with CircleCI Data using Tableau Bridge
The CData ODBC Driver for CircleCI enables you to integrate live CircleCI into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Optimizely Data in Aqua Data Studio
Access Optimizely from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect HubSpot to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect HubSpot with IBM WebSphere for seamless data integration and connectivity.
-
Getting Started with the CData ADO.NET Provider for Zuora
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Zuora.
-
Connect to CapsuleCRM Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to CapsuleCRM and work with CapsuleCRM in your FileMaker application.
-
Access Yelp Data from MySQL in Amazon QuickSight
Connect to Yelp and build visualizations of Yelp using a MySQL Connection in Amazon QuickSight.
-
Create Informatica Mappings From/To an ODBC Data Source for Highrise
Create an ODBC connection to Highrise in Informatica and browse and transfer Highrise CRM.
-
How to Connect the Power BI Service to SpaceX: Complete Guide
Connect to the CData Software Power BI Connector for SpaceX from PowerBI.com to provide real-time SpaceX across the organization.
-
Visualize Oracle HCM Cloud Data in TIBCO Spotfire through ADO.NET
Integrate Oracle HCM Cloud into dashboards in TIBCO Spotfire.
-
Configure the CData JDBC Driver for PabblySubscriptions in a Connection Pool in Tomcat
Connect to PabblySubscriptions from a connection pool in Tomcat.
-
Automated Continuous Quickbase Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Quickbase replication to Azure SQL Database.
-
Use the CData ODBC Driver for Humanity in Microsoft Power Query
You can use the CData Humanity ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Humanity into Microsoft Power Query.
-
Build Freshdesk-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Freshdesk Data and create custom apps in Bubble.
-
Connecting Agentforce with Freshservice Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Freshservice for you.
-
Validate Bitly Data with QuerySurge
Access and validate Bitly in QuerySurge using the CData JDBC Driver.
-
Visualize Live Zoho CRM Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Zoho CRM.
-
Analyze SAP ByDesign Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of SAP Business ByDesign and visualize live SAP Business ByDesign in Infragistics Reveal.
-
How to create Onfleet federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Onfleet in MySQL .
-
Import Google Calendar Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Google Calendar. In this article, you will use the OData format to import Google Calendar into Microsoft Power Query.
-
Create Shortcut Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Shortcut from PowerBI.com to create Power BI Dataflows with real-time data.
-
Visualize Act-On Data in Tableau
The CData ODBC driver for Act-On enables you integrate Act-On into Tableau dashboards.
-
Manage CockroachDB Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for CockroachDB.
-
Replicate Google Forms Data to Multiple Databases via the CData Sync CLI
Replicate Google Forms to disparate databases with a single configuration.
-
Process & Analyze Mixpanel Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Mixpanel Data.
-
Import and Visualize HDFS Data in Power View
Create data visualizations based on Apache HDFS in Excel.
-
How to Query Live Lakebase Data in Perplexity MacOS Desktop
Connect to and query live Lakebase Data in Perplexity Desktop using CData MCP Server.
-
How to Connect to Live SAP HANA 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 SAP HANA for you.
-
Query Facebook Ads Data in ColdFusion
Write standard ColdFusion data access code to connect to Facebook Ads.
-
Connect to Live Sybase Data in MicroStrategy through CData Connect AI
Create a live connection to Sybase Data in CData Connect AI and connect to your Sybase from MicroStrategy.
-
Getting Started with the CData Python Connector for Figshare
Learn to install and license the CData Python Connector
-
Connect to HCL Domino Data in ACL Analytics
Connect to HCL Domino via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to HCL Domino.
-
Integrating LlamaIndex with SAP SuccessFactors LMS Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on SAP SuccessFactors LMS in real time.
-
How to connect to Freshdesk Data with Squirrel SQL client
Connect to Freshdesk and execute queries in the Squirrel SQL Client.
-
Create Azure Synapse-Connected Business Apps in AppSheet
Connect to Azure Synapse Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Azure Synapse.
-
Connect to Amplitude Data in DBeaver
Use the CData ODBC Driver to connect to Amplitude in DBeaver.
-
Automate Sendwithus Data Replication to SAP HANA
Use CData Sync to customize and automate Sendwithus replication to SAP HANA.
-
Query Mocean Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Mocean from Node.js.