CData Software - Knowledge Base
Recent Articles
-
Build Sage 200-Connected Apps in Choreo
Use CData Connect AI to connect to Sage 200 Data from Choreo and build custom apps using live Sage 200 data.
-
Query Live Highrise Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Highrise data through a conversational interface.
-
Build an OLAP Cube in SSAS from Landbot Data
Establish a connection to Landbot data data from SQL Server Analysis Services, and use the Landbot Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate iContact Data in Pentaho Data Integration
Build ETL pipelines based on iContact data in the Pentaho Data Integration tool.
-
Validate SAP Ariba Procurement Data with QuerySurge
Access and validate SAP Ariba Procurement data in QuerySurge using the CData JDBC Driver.
-
Choosing the Best Method to Connect Apify to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Apify data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrate FormSite Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live FormSite data from Informatica Cloud.
-
Query Live Dropbox Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Dropbox data directly from the development environment.
-
Getting Started with the CData Power BI Connector for Billsby
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to import ClickTime Data into Apache Solr
Use the CData Software JDBC Driver for ClickTime in Data Import Handler and create an automated import of ClickTime data to Apache Solr Enterprise Search platform.
-
Query, Visualize, and Share live SQL Analysis Services Data in Redash
Use CData Connect AI to connect to live SQL Analysis Services data in Redash for querying, visualizing, and sharing.
-
Use Grok to Talk to Your CockroachDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your CockroachDB data for you.
-
Use Databricks Agent Bricks to Talk to Your SageHR Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your SageHR data for you.
-
Use the CData Software ODBC Driver for Mistral AI in MicroStrategy Desktop
Connect to Mistral AI data in MicroStrategy Desktop using the CData Software ODBC Driver for Mistral AI.
-
Connect to and Query Todoist Data in QlikView over ODBC
Create data visualizations with Todoist data in QlikView.
-
Use the CData Software JDBC Driver for Wrike in MicroStrategy Desktop
Connect to Wrike data in MicroStrategy Desktop using the CData Software JDBC Driver for Wrike.
-
DataBind Controls to Postmark Data in C++Builder
DataBind to Postmark data in C++Builder with standard components and controls.
-
Easily Integrate Pipedrive Data in Lazarus Pascal IDE
Learn how to easily integrate live Pipedrive data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to and Visualize Live Avaza Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Avaza data.
-
DataBind Controls to Reckon Accounts Hosted Data in Delphi
DataBind to Reckon Accounts Hosted data in Delphi with standard data access components and controls.
-
Access Live Adobe Analytics Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Adobe Analytics data through MCP integration.
-
Connect to Couchbase Data in DBArtisan
Use wizards in DBArtisan to configure Couchbase data as a data source.
-
Rapidly Develop Oracle SCM-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 Oracle SCM.
-
Explore Geographical Relationships in Smartsheet Data with Power Map
Create data visualizations with Smartsheet data in Power Map.
-
Automated Continuous MarkLogic Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable MarkLogic replication to Google BigQuery.
-
Migrating data from Attio to Databricks using CData SSIS Components.
Easily push Attio data to Databricks using the CData SSIS Tasks for Attio and Databricks.
-
Query, Visualize, and Share live Microsoft OneDrive Data in Redash
Use CData Connect AI to connect to live Microsoft OneDrive data in Redash for querying, visualizing, and sharing.
-
Load Basecamp Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Basecamp data to a database.
-
Easily Integrate Beeminder Data in Lazarus Pascal IDE
Learn how to easily integrate live Beeminder data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Prepare, Blend, and Analyze Amazon DynamoDB Data in Alteryx Designer (ODBC)
Build workflows to access live Amazon DynamoDB data for self-service data analytics.
-
How to Connect to Live Hive Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Hive data for you.
-
Build Agents in Relevance AI with Access to Live OData Services via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on OData services within intelligent agent workflows.
-
Automated Continuous Placid Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Placid replication to Amazon Redshift.
-
Object-Relational Mapping (ORM) with MessageBird 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 MessageBird data into a Java-based ORM framework, Hibernate.
-
Migrating data from Wistia to Databricks using CData SSIS Components.
Easily push Wistia data to Databricks using the CData SSIS Tasks for Wistia and Databricks.
-
How to Connect to Live Zoho Inventory 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 Zoho Inventory data for you.
-
Getting Started with the CData Python Connector for Onfleet
Learn to install and license the CData Python Connector and configure a connection to live Onfleet data.
-
Connect to Tavily Data in ACL Analytics
Connect to Tavily data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Tavily data.
-
Integrate OpenCode with Live NetSuite SuiteAnalytics Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live NetSuite SuiteAnalytics data from within your AI coding agent.
-
Connect to Wave Financial Data in Jaspersoft Studio
Execute SQL to remote Wave Financial data in Jaspersoft Studio.
-
Use the CData Software ODBC Driver for Webflow in MicroStrategy
Connect to Webflow data in MicroStrategy Developer using the CData Software ODBC Driver for Webflow.
-
How to Connect to & Open VWO Data in Microsoft Excel
This article uses the CData ODBC driver for VWO to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connecting Mastra with BigCommerce 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 BigCommerce data, no replication required.
-
Connect to Shopify Data from PowerBuilder via ADO.NET
This article demonstrates how to access Shopify data from Appeon PowerBuilder using the CData ADO.NET Provider for Shopify.
-
Visualize Printful 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 Printful data into TIBCO Spotfire.
-
Analyze SAP SuccessFactors Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SAP SuccessFactors data in Microsoft R Open.
-
Publish Reports with Trello Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Trello data.
-
Getting Started with the CData Power BI Connector for Microsoft Ads
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Microsoft Ads.
-
Getting Started with the CData JDBC Driver for Amazon DynamoDB
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Amazon DynamoDB.
-
Migrating data from SAP Business One to Databricks using CData SSIS Components.
Easily push SAP Business One data to Databricks using the CData SSIS Tasks for SAP Business One and Databricks.
-
Establish a Live Connection with Clio Data using Tableau Bridge
The CData ODBC Driver for Clio enables you to integrate live Clio data into Tableau Cloud dashboards using the Tableau Bridge.
-
A PostgreSQL Interface for Cosmos DB Data (MySQL Remoting via JDBC)
Use the Remoting features of the Cosmos DB JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Odoo Data in Pentaho Data Integration
Build ETL pipelines based on Odoo data in the Pentaho Data Integration tool.
-
Automated Oracle SCM Data Replication to Teradata
Use CData Sync to Customize and automate Oracle SCM data replication to Teradata.
-
Integrating GitHub Copilot with Microsoft Entra ID 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.
-
Connect to Auth0 Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Auth0 data.
-
Integrate Dify with Live Bullhorn CRM Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Bullhorn CRM data.
-
How to Easily Query Google Ads Data in OpenOffice Base
Connect to Google Ads data in OpenOffice Base using the CData ODBC Driver for Google Ads and generate reports with live data insights.
-
How to Work with Apify Data in AWS Glue Jobs Using JDBC
Connect to Apify from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Design BIRT Reports on Egnyte Data
Provide current Egnyte data to your embedded analytics.
-
Extract, Transform, and Load Apify Data in Informatica PowerCenter
Create a simple Workflow for Apify data in Informatica PowerCenter.
-
Use Dash to Build to Web Apps on Oracle Service Cloud Data
Create Python applications that use pandas and Dash to build Oracle Service Cloud-connected web apps.
-
Build a PostgreSQL Interface for Hubstaff Data using the CData JDBC Driver
Use the Remoting features of the Hubstaff JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Postmark Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Postmark.
-
Trigger Exact Online IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Exact Online with standard wizards in Logic Apps.
-
Connect to Opsgenie Data in Jaspersoft Studio
Execute SQL to remote Opsgenie data in Jaspersoft Studio.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Facebook
Provide connectivity to Facebook data through an SAP BusinessObjects universe.
-
Integrate Live MYOB AccountRight 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 MYOB AccountRight data from within the IDE.
-
Build MVC Applications with Connectivity to Sage Cloud Accounting Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Sage Cloud Accounting from an ASP.NET MVC application.
-
Feed PDFMonkey Data into FineReport
How to set PDFMonkey data as a JDBC data source in FineReport.
-
ETL Highrise in Oracle Data Integrator
This article shows how to transfer Highrise data into a data warehouse using Oracle Data Integrator.
-
Integrating Claude Code CLI with SAP 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.
-
Getting Started with the CData ADO.NET Provider for Sybase
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Sybase.
-
Visualize Live Spark Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Spark data into custom reports in Power BI.
-
How to Connect to Live Reckon Accounts Hosted Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Reckon Accounts Hosted data for you.
-
View Reports on Real-Time Figshare Data in Power BI Report Server
Use the CData ODBC Driver for Figshare to visualize Figshare data in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Connect to Live MailChimp Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live MailChimp data securely in real time.
-
Create Bannerbear-Connected Applications in Appsmith
Connect to Bannerbear Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Bannerbear data.
-
Build an OLAP Cube in SSAS from Redis Data
Establish a connection to Redis data data from SQL Server Analysis Services, and use the Redis Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate LibreChat with Live Google Spanner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Google Spanner data from within the chat interface.
-
Manage SAP ByDesign Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SAP ByDesign.
-
Automated Continuous Google Forms Replication to Vertica
Use CData Sync for automated, continuous, customizable Google Forms replication to Vertica.
-
Visualize Suadeo Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Suadeo data.
-
How to Work with Drip Data in AWS Glue Jobs Using JDBC
Connect to Drip from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous Spotify Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Spotify replication to AlloyDB.
-
How to create an RPA flow for OnePageCrm Data in UiPath Studio
Use the OnePageCrm ODBC Driver to create workflows that access real-time OnePageCrm data without any coding.
-
Working with Spotify Data in LINQPad
Execute LINQ queries to Spotify data in LINQPad.
-
Access Live Microsoft Teams Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Microsoft Teams data through MCP integration.
-
How to Access Bitly Data Using Entity Framework
This article shows how to access Bitly data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Create Cloudflare-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Cloudflare Data from OutSystems and build custom enterprise apps using live Cloudflare data.
-
Create a Data Access Object for Parquet Data using JDBI
A brief overview of creating a SQL Object API for Parquet data in JDBI.
-
Explore Geographical Relationships in Azure Data Catalog Data with Power Map
Create data visualizations with Azure Data Catalog data in Power Map.
-
Automated Continuous ShipEngine Replication to Snowflake
Use CData Sync for automated, continuous, customizable ShipEngine replication to Snowflake.
-
Import and Visualize Databricks Data in Power View
Create data visualizations based on Databricks data in Excel.
-
Access Live Short.io Data in Coginiti Pro
Connect to and query live Short.io data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Deploy the ADO.NET Provider for SAP BusinessObjects BI on an SSRS Report Server
Connect to SAP BusinessObjects BI data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Build a Simple VCL Application for Accelo Data
How to build a simple VCL Application to view Accelo data in RAD Studio using the CData ODBC Driver for Accelo.
-
Access Live Facebook Ads Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Facebook Ads data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Migrating data from Dynamics 365 Business Central to Google BigQuery using CData SSIS Components.
Easily push Dynamics 365 Business Central data to Google BigQuery using the CData SSIS Tasks for Dynamics 365 Business Central and Google BigQuery.
-
How to create Highrise federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Highrise data in MySQL .