CData Software - Knowledge Base
Recent Articles
-
Rapidly Develop Exa-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 Exa.
-
Working with SAP Business One Data in LINQPad
Execute LINQ queries to SAP Business One in LINQPad.
-
Automated Continuous Attio Replication to Vertica
Use CData Sync for automated, continuous, customizable Attio replication to Vertica.
-
How to Access Live Power BI XMLA Data in Visual Studio Code via Cline
Run CData MCP Server for Power BI XMLA on Windows Subsytem for Linux (WSL) and connect to live Power BI XMLA from the Cline extension in Visual Studio Code.
-
Publish Crystal Reports on Coinbase Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Coinbase.
-
Integrating Cursor CLI with ZendeskSell 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.
-
Creating Google Contacts-Connected Applications in Unqork
You can use CData Connect AI to feed Google Contacts to Unqork and build custom business apps.
-
Build Impala-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Impala to explore live Impala Data in Cursor to assist with building Impala-powered applications.
-
Use Dash to Build Web Apps on Trello Data via CData Connect AI
Build interactive Dash web apps on live Trello using pandas and the CData Connect AI Python SDK.
-
Integrating LangGraph with Lakebase Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Lakebase within automated workflows.
-
Provide OData Services of AfterShip Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for AfterShip by developing a WCF Service Application.
-
Use ChatGPT to Talk to Your QuickBooks Online 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 QuickBooks Online for you.
-
Connect to HCL Domino Data from Crystal Reports
Use CData Connect AI to connect to and report on live HCL Domino from Crystal Reports.
-
Connect to Reckon Accounts Hosted Data in Aqua Data Studio
Access Reckon Accounts Hosted from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automated Continuous Klaviyo Replication to MongoDB
Use CData Sync for automated, continuous, customizable Klaviyo replication to MongoDB.
-
Create a Data Access Object for ConstantContact Data using JDBI
A brief overview of creating a SQL Object API for ConstantContact in JDBI.
-
Create Informatica Mappings From/To an ODBC Data Source for Oracle Eloqua
Create an ODBC connection to Oracle Eloqua in Informatica and browse and transfer Oracle Eloqua.
-
Automate SuiteCRM Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live SuiteCRM and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Automated Continuous SAP Fieldglass Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SAP Fieldglass replication to delimited files (CSV/TSV).
-
How to Connect to Live Avalara AvaTax Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Avalara AvaTax without replication.
-
Use the CData Software ODBC Driver for Deel in SAS for Real-Time Reporting and Analytics
Connect to real-time Deel in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Deel.
-
How to Connect the Power BI Service to Zoom: Complete Guide
Connect to the CData Software Power BI Connector for Zoom from PowerBI.com to provide real-time Zoom across the organization.
-
How to import FreshBooks Data into Apache Solr
Use the CData Software JDBC Driver for FreshBooks in Data Import Handler and create an automated import of FreshBooks to Apache Solr Enterprise Search platform.
-
View Reports on Real-Time Google Ad Manager Data in Power BI Report Server
Use the CData ODBC Driver for Google Ad Manager to visualize Google Ad Manager in Power BI Desktop and then publish them to Power BI Report Server.
-
Manage Parallel Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Parallel.
-
Choosing the Best Method to Connect Microsoft Teams to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Microsoft Teams from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Aweber from a Connection Pool in WebLogic
Use the CData JDBC Driver for Aweber to connect to Aweber from Web applications running on WebLogic.
-
A PostgreSQL Interface for JotForm Data using the CData ODBC Driver
Use the SQL Gateway and JotForm ODBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live CouchDB Data in TIBCO Data Virtualization
Use the CouchDB Tibco DV Adapter to create a Apache CouchDB data source in TIBCO Data Virtualization Studio and gain access to live Apache CouchDB from your TDV Server.
-
Trigger Hive IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Hive with standard wizards in Logic Apps.
-
Add AgileCRM Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for AgileCRM with the Informatica Enterprise Data Catalog to classify and organize data.
-
Deploy the ADO.NET Provider for Yelp on an SSRS Report Server
Connect to Yelp 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.
-
Getting Started with the CData ODBC Driver for Microsoft Teams
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Microsoft Teams.
-
LINQ to MailChimp 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 MailChimp Data Provider.
-
Build a Singer.io Tap for Okta With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Okta data using
-
Build Semantic Layer Views for SAP SuccessFactors LMS Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for SAP SuccessFactors LMS.
-
Visualize Live Azure Synapse Data in the Power BI Service
Use CData Connect AI to connect to live Azure Synapse and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build a Singer.io Tap for ZeroBounce With the CData Python Connector
Learn how to easily build a Singer.io Tap for live ZeroBounce data using
-
Use Dash to Build to Web Apps on Freshservice Data
Create Python applications that use pandas and Dash to build Freshservice-connected web apps.
-
Connect Qualaroo to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Qualaroo with IBM WebSphere for seamless data integration and connectivity.
-
Automated Continuous Dotmailer Replication to Databricks
Use CData Sync for automated, continuous, customizable Dotmailer replication to Databricks.
-
Create FHIR Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time FHIR data access from reports, embedded analytics, and more.
-
Creating Marketo-Connected Applications in Unqork
You can use CData Connect AI to feed Marketo to Unqork and build custom business apps.
-
Import and Visualize Oracle Sales Data in Power View
Create data visualizations based on Oracle Sales in Excel.
-
Automated Continuous OData Replication to MongoDB
Use CData Sync for automated, continuous, customizable OData replication to MongoDB.
-
Feed Short.io Data into FineReport
How to set Short.io as a JDBC data source in FineReport.
-
Analyze ActiveCampaign Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for ActiveCampaign from Power Pivot. You will use the Table Import Wizard to load ActiveCampaign. You can visually build the import query or use any SQL supported by the driver.
-
Migrating data from Autopilot to Databricks using CData SSIS Components.
Easily push Autopilot to Databricks using the CData SSIS Tasks for Autopilot and Databricks.
-
DataBind Controls to CampaignMonitor Data in C++Builder
DataBind to CampaignMonitor in C++Builder with standard components and controls.
-
Integrating FreshBooks Data in Talend Cloud Data Management Platform
Connect FreshBooks Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Connecting Moonlit Workflow with Excel Online Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Microsoft Excel Online in real time.
-
View Reports on Real-Time ZohoMarketingHub Data in Power BI Report Server
Use the CData ODBC Driver for ZohoMarketingHub to visualize ZohoMarketingHub in Power BI Desktop and then publish them to Power BI Report Server.
-
Load ClickTime Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load ClickTime to a database.
-
Automated Continuous Spark Replication to Databricks
Use CData Sync for automated, continuous, customizable Spark replication to Databricks.
-
Automate Missive Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Missive from PowerShell? This article demonstrates how to utilize the Missive Cmdlets for tasks like connecting to Missive, automating operations, downloading data, and more.
-
Create Dynamic Sugar CRM Grids Using the Infragistics XamDataGrid
Learn how you can connect Sugar CRM to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Copper Data in JRuby
Create a simple JRuby app with access to live Copper.
-
Connect to Codat Data in NetBeans
Connect to Codat in NetBeans with the data source configuration wizard.
-
Analyze SingleStore Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of SingleStore and visualize SingleStore in SAP Analytics Cloud.
-
How to use SQLAlchemy ORM to access Freshteam Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Freshteam.
-
Access Live GitLab Data in AWS Lambda (with IntelliJ IDEA)
Connect to live GitLab in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Validate Highrise Data with QuerySurge
Access and validate Highrise CRM in QuerySurge using the CData JDBC Driver.
-
Integrating Claude Code CLI with Keap 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 Excel Add-In for Google Analytics
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Google Analytics.
-
Use Dash to Build Web Apps on Oracle Data via CData Connect AI
Build interactive Dash web apps on live Oracle Database using pandas and the CData Connect AI Python SDK.
-
How to Build an ETL App for Twitter Ads Data in Python with CData Connect AI
Build ETL pipelines that read and write live Twitter Ads in Python with petl and the CData Connect AI Python SDK.
-
How to connect Amazon QuickSight to Oracle Service Cloud Data
Create a connection to Oracle Service Cloud in CData Connect AI and insert Oracle Service Cloud into Amazon QuickSight SPICE to build interactive dashboards.
-
How to use SQLAlchemy ORM to access Foursquare Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Foursquare.
-
Connect to Dynamics 365 Data in DBArtisan
Use wizards in DBArtisan to configure Microsoft Dynamics 365 as a data source.
-
Getting Started with the CData ODBC Driver for Instagram
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Instagram.
-
How to Connect to Workable Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Workable. Leverage the pyodbc module for ODBC in Python.
-
Opsgenie Reporting in OBIEE with the Opsgenie JDBC Driver
Deploy the Opsgenie JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to SAS Data Sets Data in Claris FileMaker Pro
Use the CData ODBC Driver for SAS Data Sets in FileMaker Pro to connect to SAS Data Sets and work with SAS Data Sets in your FileMaker applications.
-
Visualize Sybase Data in Tableau
The CData ODBC driver for Sybase enables you integrate Sybase into Tableau dashboards.
-
Integrate with Vertica Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Vertica in SnapLogic.
-
Connect Teamwork to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Teamwork with IBM WebSphere for seamless data integration and connectivity.
-
Visualize Live Gorgias Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Gorgias.
-
DataBind Controls to HubDB Data in C++Builder
DataBind to HubDB in C++Builder with standard components and controls.
-
Access Live Cloudant Data in AWS Lambda
Connect to live IBM Cloudant in AWS Lambda using the CData JDBC Driver.
-
How to connect Amazon QuickSight to SingleStore Data
Create a connection to SingleStore in CData Connect AI and insert SingleStore into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect to Hive Data from AWS Glue
Use CData Connect AI to gain access to live Apache Hive from your AWS Glue jobs.
-
Load SAP HANA XS Advanced Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SAP HANA XS Advanced to a database.
-
Integrate with Onfleet Data in JReport Designer
Create charts and reports based on Onfleet in JReport Designer.
-
How to Connect to QuickBooks Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to QuickBooks Desktop. Leverage the pyodbc module for ODBC in Python.
-
Integrate Cline with Live Google Ad Manager Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Google Ad Manager from within your IDE.
-
Automated Continuous Couchbase Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Couchbase replication to delimited files (CSV/TSV).
-
Connecting Moonlit Workflow with SAP Ariba Source Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your SAP Ariba Source in real time.
-
Build Apps with Live Salesforce Pardot in Adalo using CData Connect AI
Use CData Connect AI to integrate live Salesforce Pardot into the Adalo platform and build custom mobile and web applications with real-time Salesforce Pardot.
-
Use the CData Software JDBC Driver for ServiceDesk Plus in MicroStrategy Web
Connect to ServiceDesk Plus in MicroStrategy Web using the CData Software JDBC Driver for ServiceDesk Plus.
-
Connect to Google Ad Manager Data in DBArtisan
Use wizards in DBArtisan to configure Google Ad Manager as a data source.
-
Automated Continuous AfterShip Replication to IBM DB2
Use CData Sync for automated, continuous, customizable AfterShip replication to IBM DB2.
-
Access Live Pipedrive Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Pipedrive from your Excel spreadsheets.
-
How to create an RPA flow for Foursquare Data in UiPath Studio
Use the Foursquare ODBC Driver to create workflows that access real-time Foursquare without any coding.
-
Connect to GitLab Data from a Connection Pool in JBoss
Integrate GitLab into Java servlets: Use the Management Console in JBoss to install the GitLab JDBC Driver.
-
Model, Search, and Visualize Live Google Search Results in ThoughtSpot
Use CData Connect AI to connect to live Google Search for modeling, searching, and visualizing.
-
Access Live SAP BusinessObjects BI Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live SAP BusinessObjects BI data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Create Power BI Reports on Real-Time Moosend Data
Use the CData ODBC Driver for Moosend to visualize Moosend in Power BI Desktop.
-
A PostgreSQL Interface for Freshdesk Data (MySQL Remoting via JDBC)
Use the Remoting features of the Freshdesk JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Twilio-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Twilio.
-
How to Work with Adobe Experience Manager Data in AWS Glue Jobs Using JDBC
Connect to Adobe Experience Manager from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.