CData Software - Knowledge Base
Recent Articles
-
Create Dynamic ElevenLabs Grids Using the Infragistics XamDataGrid
Learn how you can connect ElevenLabs to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Instagram from Asprova with CData Software ODBC Driver for Instagram
This article shows how to connect faster to Instagram data from Asprova.
-
Connect to Sage Intacct from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Sage Intacct data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Publish Reports with Brex Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Brex data.
-
Design BIRT Reports on Perplexity Data
Provide current Perplexity data to your embedded analytics.
-
Provide OData Services of SAP Concur Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SAP Concur data by developing a WCF Service Application.
-
Access Live Dropbox Data in TIBCO Data Virtualization
Use the Dropbox Tibco DV Adapter to create a Dropbox data data source in TIBCO Data Virtualization Studio and gain access to live Dropbox data from your TDV Server.
-
Build Automated ZohoMarketingHub-Connected Workflows in Zapier
Use CData Connect AI to connect to live ZohoMarketingHub data and build automated workflows in Zapier.
-
Analyze Zoho Projects Data in Looker
Use CData Connect AI to connect to Zoho Projects Data from Looker and build custom apps using live Zoho Projects data.
-
Automated Continuous SAP Fieldglass Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable SAP Fieldglass replication to Google BigQuery.
-
Build Dashboards with Teradata Data in Dundas BI
Create dynamic dashboards and perform analytics based on Teradata data in Dundas BI.
-
Build Paylocity-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Paylocity Data and create custom apps in Mendix.
-
Build Semantic Layer Views for Zoom Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Zoom data.
-
Explore Geographical Relationships in Zendesk Data with Power Map
Create data visualizations with Zendesk data in Power Map.
-
Integrate Cloudant Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Cloudant data and integrate live Cloudant data into your Power Automate tasks.
-
How to Build an ETL App for Facebook Ads Data in Python with CData Connect AI
Build ETL pipelines that read and write live Facebook Ads data in Python with petl and the CData Connect AI Python SDK.
-
Integrating LangGraph with SuiteCRM Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on SuiteCRM data within automated workflows.
-
Automated Continuous Adobe Commerce Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Adobe Commerce replication to AlloyDB.
-
How to Build an ETL App for Vimeo Data in Python with CData
Create ETL applications and real-time data pipelines for Vimeo data in Python with petl.
-
Access Live Impala Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Impala data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
LINQ to Dynamics CRM Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Dynamics CRM Data Provider.
-
How to Create Power BI Visual Reports with Real-Time Elorus Data
Use CData Power BI Connectors to visualize Elorus data in Power BI.
-
Maximizing SQL Server Linked Server Efficiency with CData SQL Gateway
With the help of a series of performance tests, this article demonstrates how the newer version of CData SQL Gateway optimizes the efficiency of SQL Server Linked Server, enabling seamless reading and writing of Snowflake data within SQL Server.
-
Visualize Azure Synapse 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 Azure Synapse data into TIBCO Spotfire.
-
Configure the CData JDBC Driver for ChartMogul in a Connection Pool in Tomcat
Connect to ChartMogul data from a connection pool in Tomcat.
-
Integrate FormSite Data in the Pentaho Report Designer
Publish reports based on FormSite data in the Pentaho BI tool.
-
LINQ to Qualaroo Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Qualaroo Data Provider.
-
Validate Microsoft OneDrive Data with QuerySurge
Access and validate Microsoft OneDrive data in QuerySurge using the CData JDBC Driver.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Avalara AvaTax
Provide connectivity to Avalara AvaTax data through an SAP BusinessObjects universe.
-
Connect to Salesforce CRM Analytics from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Salesforce CRM Analytics data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Automated Continuous Dynamics CRM Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Dynamics CRM replication to IBM DB2.
-
Create ZohoSubscriptions-Connected Dashboards in Grafana
Connect to ZohoSubscriptions Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to ZohoSubscriptions data.
-
Connecting Mastra with Google Ad Manager 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 Google Ad Manager data, no replication required.
-
Automated Continuous HDFS Replication to Snowflake
Use CData Sync for automated, continuous, customizable HDFS replication to Snowflake.
-
Connect to Salesloft Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Salesloft data in Airbyte.
-
DataBind Controls to ShipStation Data in Delphi
DataBind to ShipStation data in Delphi with standard data access components and controls.
-
Replicate Sendwithus Data in Heroku for Use in Salesforce Connect
Replicate Sendwithus data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Automated Continuous Hubstaff Replication to MongoDB
Use CData Sync for automated, continuous, customizable Hubstaff replication to MongoDB.
-
Getting Started with the CData Excel Add-In for Guru
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Guru.
-
Create Apps from Azure Synapse Data in Qlik Sense Cloud
Use CData Connect AI to connect to Azure Synapse Data and build apps from live Azure Synapse data in Qlik Sense Cloud.
-
Automated Continuous Sage 300 Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Sage 300 replication to Apache Kafka.
-
Query Cloudant Data as a SQL Server Database in Node.js
Execute SQL Server queries against Cloudant data from Node.js.
-
How to Connect Box Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Box data in real time using natural language.
-
How to Connect to & Open SurveyMonkey Data in Microsoft Excel
This article uses the CData ODBC driver for SurveyMonkey to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create Power BI Reports on Real-Time Teamgate Data
Use the CData ODBC Driver for Teamgate to visualize Teamgate data in Power BI Desktop.
-
Getting Started with the CData Tableau Connector for JobNimbus
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Getting Started with the CData ODBC Driver for Azure Synapse
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Azure Synapse.
-
Connect to Office 365 Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Office 365 data.
-
How to connect to Adobe Experience Manager Data from Spring Boot
Connect to Adobe Experience Manager in a Spring Boot Application using the CData JDBC Driver for Adobe Experience Manager
-
Build AI Agents with Google Ad Manager 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 Google Ad Manager data through CData Connect AI.
-
Connect to CockroachDB Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for CockroachDB data in Airbyte.
-
Integrating Boomi Agentstudio with Basecamp Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Basecamp data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to Easily Query Microsoft Teams Data in OpenOffice Base
Connect to Microsoft Teams data in OpenOffice Base using the CData ODBC Driver for Microsoft Teams and generate reports with live data insights.
-
Connect to Live API Data in MicroStrategy through CData Connect AI
Create a live connection to API Data in CData Connect AI and connect to your API data from MicroStrategy.
-
Build a Simple VCL Application for HubDB Data
How to build a simple VCL Application to view HubDB data in RAD Studio using the CData ODBC Driver for HubDB.
-
How to Connect to & Open Neo4J Data in Microsoft Excel
This article uses the CData ODBC driver for Neo4J to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Foursquare Data in Jaspersoft Studio
Execute SQL to remote Foursquare data in Jaspersoft Studio.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Quickbase
Provide connectivity to Quickbase data through an SAP BusinessObjects universe.
-
How to Work with FreeAgent Data in ETL Validator JDBC
Connect to FreeAgent from ETL Validator jobs using the CData Software JDBC Driver.
-
Build Automated Tavily-Connected Workflows in Zapier
Use CData Connect AI to connect to live Tavily data and build automated workflows in Zapier.
-
Integrating Claude Code CLI with MarkLogic 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.
-
Migrating data from Sage 300 to Google BigQuery using CData SSIS Components.
Easily push Sage 300 data to Google BigQuery using the CData SSIS Tasks for Sage 300 and Google BigQuery.
-
Prepare, Blend, and Analyze Wrike Data in Alteryx Designer (ODBC)
Build workflows to access live Wrike data for self-service data analytics.
-
Explore Geographical Relationships in Missive Data with Power Map
Create data visualizations with Missive data in Power Map.
-
How to Connect the Power BI Service to LaunchDarkly: Complete Guide
Connect to the CData Software Power BI Connector for LaunchDarkly from PowerBI.com to provide real-time LaunchDarkly data across the organization.
-
Connect to Samanage Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Samanage to connect to Samanage data and execute queries in PowerBuilder.
-
Prepare, Blend, and Analyze PostgreSQL Data in Alteryx Designer (ODBC)
Build workflows to access live PostgreSQL data for self-service data analytics.
-
How to connect PolyBase to Optimizely
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Optimizely data.
-
How to connect to HDFS Data with Squirrel SQL client
Connect to HDFS data and execute queries in the Squirrel SQL Client.
-
Automated Continuous Billsby Replication to SingleStore
Use CData Sync for automated, continuous, customizable Billsby replication to SingleStore.
-
Create Datasets from Parallel in Domo Workbench and Build Visualizations of Parallel Data in Domo
Use the CData Software ODBC Driver for Parallel to create datasets from Parallel data in Domo Workbench and then build visualizations in the Domo service.
-
Build Data Flows from SQL Server to Zoho Creator through SSIS
Easily push SQL Server data to Zoho Creator using the CData SSIS Tasks for Zoho Creator.
-
Use Agno to Talk to Your Active Directory 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 Active Directory data for you.
-
Use the CData Software ODBC Driver for ElevenLabs in MicroStrategy
Connect to ElevenLabs data in MicroStrategy Developer using the CData Software ODBC Driver for ElevenLabs.
-
Automate Trello Data Replication to Azure Data Lake
Use CData Sync to customize and automate Trello data replication to Azure Data Lake.
-
Integrating Kiro with Gorgias 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.
-
Automate Google Forms Data Replication to SAP HANA
Use CData Sync to customize and automate Google Forms data replication to SAP HANA.
-
DataBind Controls to SQL Server Data in C++Builder
DataBind to SQL Server data in C++Builder with standard components and controls.
-
Build Visualizations of Bugsnag Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Bugsnag data in Birst.
-
Integrate Trae with Live Azure Table Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Azure Table data from within the AI-powered IDE.
-
Connect Mouseflow to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Mouseflow with IBM WebSphere for seamless data integration and connectivity.
-
Getting Started with the CData Power BI Connector for Notion
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Publish Datadog-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Datadog data.
-
Perform Batch Operations with TaxJar Data in Apache NiFi
Connect to TaxJar data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Import Real-Time SingleStore Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SingleStore data in ColdFusion.
-
Access Teamgate Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Teamgate data from HeidiSQL.
-
Printify Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Printify facts in real time.
-
Object-Relational Mapping (ORM) with Google Cloud Storage Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Google Cloud Storage data into a Java-based ORM framework, Hibernate.
-
Integrate Theia IDE with Live Paylocity 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 Paylocity data from within the development environment.
-
Visualize Live Brex Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Brex data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build a PostgreSQL Interface for BigQuery Data using the CData JDBC Driver
Use the Remoting features of the BigQuery JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to and Query Greenplum Data in QlikView over ODBC
Create data visualizations with Greenplum data in QlikView.
-
How to connect to Dynamics CRM Data in DBVisualizer
Integrate Dynamics CRM data with visual data analysis tools and data connection wizards in DBVisualizer
-
How to connect SharePoint with Shopify Data through external lists
Provide Shopify data to SharePoint users as an external list.
-
Connect to Power BI XMLA Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Power BI XMLA.
-
Integrate Live Reckon Accounts Hosted Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Reckon Accounts Hosted data to Blue Prism using the CData ODBC Driver for Reckon Accounts Hosted to create automated workflows for repetitive business tasks.
-
Validate OnePageCrm Data with QuerySurge
Access and validate OnePageCrm data in QuerySurge using the CData JDBC Driver.
-
Integrating Antigravity CLI with ChargeOver data via CData CLI
Connect ChargeOver data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to connect to BambooHR Data from IntelliJ
Integrate connectivity to BambooHR data with wizards in IntelliJ.
-
Connect to CouchDB Data in Claris FileMaker Pro
Use the CData ODBC Driver for CouchDB in FileMaker Pro to connect to CouchDB and work with CouchDB data in your FileMaker applications.