CData Software - Knowledge Base
Recent Articles
-
Connect to Microsoft OneDrive Data from Crystal Reports
Use CData Connect AI to connect to and report on live Microsoft OneDrive from Crystal Reports.
-
Build Automated Workflows with Live Salesforce Data in Workato
Use CData Connect AI to connect to live Salesforce & Force.com and build automated workflows in Workato.
-
Getting Started with the CData SSIS Components for Strava
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Strava.
-
Build CouchDB-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Apache CouchDB and build CouchDB-connected web apps with Axios.
-
Replicate Multiple ShipStation Accounts
Replicate multiple ShipStation accounts to one or many databases.
-
Access Live Calendly Data in AWS Lambda
Connect to live Calendly in AWS Lambda using the CData JDBC Driver.
-
Connect to Salesforce Data in CloverDX (formerly CloverETL)
Transfer Salesforce & Force.com using the visual workflow in the CloverDX data integration tool.
-
How to Connect to & Open Teamwork Data in Microsoft Excel
This article uses the CData ODBC driver for Teamwork to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Query Shortcut Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Shortcut from Node.js.
-
Automated Continuous SQL Server Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SQL Server replication to PostgreSQL.
-
How to Connect to Live Freshdesk 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 Freshdesk for you.
-
How to Access Adobe Analytics Data Using Entity Framework
This article shows how to access Adobe Analytics 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 SAP Ariba Source in MicroStrategy Desktop
Connect to SAP Ariba Source in MicroStrategy Desktop using the CData Software ODBC Driver for SAP Ariba Source.
-
Create Dynamic Bugsnag Grids Using the Infragistics XamDataGrid
Learn how you can connect Bugsnag to Infragistics XamDataGrid to build dynamic grids.
-
Use Azure AI Foundry to Talk to Your ShipStation 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 ShipStation for you.
-
Use the CData Software ODBC Driver for AgileCRM in MicroStrategy Desktop
Connect to AgileCRM in MicroStrategy Desktop using the CData Software ODBC Driver for AgileCRM.
-
How to connect to Zoho Inventory Data in DBVisualizer
Integrate Zoho Inventory with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous SAP ByDesign Replication to Vertica
Use CData Sync for automated, continuous, customizable SAP ByDesign replication to Vertica.
-
DataBind Charts to Blackbaud FE NXT Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Blackbaud FE NXT 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.
-
Connect to Beeminder Data in Ruby
Connect to Beeminder in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Automated Workflows with Live SingleStore Data in Workato
Use CData Connect AI to connect to live SingleStore and build automated workflows in Workato.
-
Build Automated Shopify-Connected Workflows in Zapier
Use CData Connect AI to connect to live Shopify and build automated workflows in Zapier.
-
Publish SurveyMonkey-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live SurveyMonkey.
-
DataBind Controls to Coinbase Data in C++Builder
DataBind to Coinbase in C++Builder with standard components and controls.
-
Access Live Shortcut Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Shortcut into the statistical analysis tools available in SAS JMP. This article shows how to use Shortcut in the Graph Builder and Query Builder.
-
Build ZohoPeople-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to ZohoPeople and build web apps with connectivity to live ZohoPeople.
-
Getting Started with the CData ADO.NET Provider for Gmail
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Gmail.
-
Visualize Amazon Athena Data in TIBCO Spotfire through ADO.NET
Integrate Amazon Athena into dashboards in TIBCO Spotfire.
-
Automated Continuous Salesforce Marketing Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Salesforce Marketing Cloud replication to OneLake in Microsoft Fabric.
-
Create MarkLogic-Connected Business Apps in AppSheet
Connect to MarkLogic Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to MarkLogic.
-
Use the CData Software ODBC Driver for Mailgun in MicroStrategy Desktop
Connect to Mailgun in MicroStrategy Desktop using the CData Software ODBC Driver for Mailgun.
-
Integrate eBay Analytics Data in Pentaho Data Integration
Build ETL pipelines based on eBay Analytics in the Pentaho Data Integration tool.
-
How to create Front federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Front in MySQL .
-
Create Power BI Reports on Real-Time PagerDuty Data
Use the CData ODBC Driver for PagerDuty to visualize PagerDuty in Power BI Desktop.
-
Bridge Strava Connectivity with Apache NiFi
Access and process Strava in Apache NiFi using the CData JDBC Driver.
-
Bidirectional Access to Adobe Target Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Adobe Target in Filemaker Pro for Mac or Windows.
-
Create a Data Access Object for Ontraport Data using JDBI
A brief overview of creating a SQL Object API for Ontraport in JDBI.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Kintone to Power BI dashboards. Simply drag and drop Kintone into data visuals on the Power BI canvas.
-
Publish Yelp-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Yelp.
-
Access Live SAP SuccessFactors LMS 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 SAP SuccessFactors LMS through MCP integration.
-
Replicate Multiple Klaviyo Accounts
Replicate multiple Klaviyo accounts to one or many databases.
-
Connect to iContact Data in CloverDX (formerly CloverETL)
Transfer iContact using the visual workflow in the CloverDX data integration tool.
-
How to Design Bullhorn CRM Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Bullhorn CRM from mobile and tablet Power Apps.
-
Connect to OneNote Data in HULFT Integrate
Connect to OneNote as a JDBC data source in HULFT Integrate
-
Explore Geographical Relationships in Redshift Data with Power Map
Create data visualizations with Amazon Redshift in Power Map.
-
Query Google Analytics Data in DataGrip
Create a Data Source for Google Analytics in DataGrip and use SQL to query live Google Analytics.
-
Build OpenWeatherMap-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live OpenWeatherMap.
-
Rapidly Develop QuickBooks Time-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 QuickBooks Time.
-
Working with Wrike Data in LINQPad
Execute LINQ queries to Wrike in LINQPad.
-
Create Procore-Connected Nintex Workflows
Use CData Connect AI to connect to Procore Data from Nintex Workflow Cloud and build custom workflows using live Procore.
-
Integrate RabbitMQ with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate RabbitMQ with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to RabbitMQ.
-
Prepare, Blend, and Analyze Reckon Accounts Hosted Data in Alteryx Designer (ODBC)
Build workflows to access live Reckon Accounts Hosted for self-service data analytics.
-
How to Connect DBeaver to Power BI XMLA via a JDBC Driver
Manage Power BI XMLA with visual tools in DBeaver like the query browser.
-
Connecting GenSpark with Salesforce Marketing Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Salesforce Marketing Cloud without any replication or custom integration required.
-
A PostgreSQL Interface for Oracle Service Cloud Data (MySQL Remoting via JDBC)
Use the Remoting features of the Oracle Service Cloud JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to ShipStation Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live ShipStation from Filemaker Pro on Mac.
-
How to Visualize ConvertAPI Data in Python with pandas
Use pandas and other modules to analyze and visualize live ConvertAPI in Python.
-
Import and Visualize Google Ad Manager Data in Power View
Create data visualizations based on Google Ad Manager in Excel.
-
Integrate Live SAP Ariba Procurement Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to SAP Ariba Procurement from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live SAP Ariba Procurement.
-
Visualize ChartMogul 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 ChartMogul into TIBCO Spotfire.
-
How to Access Live Marketo Data in Visual Studio Code via Cline
Run CData MCP Server for Marketo on Windows Subsytem for Linux (WSL) and connect to live Marketo from the Cline extension in Visual Studio Code.
-
Connect to Shortcut Data in Ruby
Connect to Shortcut in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous Drift Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Drift replication to Apache Cassandra.
-
Create a Data Access Object for Salesforce CRM Analytics Data using JDBI
A brief overview of creating a SQL Object API for Salesforce CRM Analytics in JDBI.
-
Object-Relational Mapping (ORM) with ClickUp 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 ClickUp into a Java-based ORM framework, Hibernate.
-
Build Apps with Live SAP Business ByDesign in Adalo using CData Connect AI
Use CData Connect AI to integrate live SAP Business ByDesign into the Adalo platform and build custom mobile and web applications with real-time SAP Business ByDesign.
-
How to Easily Query ShipEngine Data in OpenOffice Base
Connect to ShipEngine data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Integrate with ADP Data in SnapLogic
Use CData Connect AI to connect to and integrate with live ADP in SnapLogic.
-
Integrate Live Authorize.Net Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Authorize.Net and integrate live Authorize.Net into apps built in Microsoft Power Apps.
-
Create Reports from Certinia Data in Looker Studio
Use CData Connect AI to gain access to live Certinia and create custom reports in Looker Studio.
-
Connect to Email Data in DBeaver
Use the CData ODBC Driver to connect to Email in DBeaver.
-
Visualize Live Discourse Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Discourse using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access Live LinkedIn Ads Data in Excel 365 Online (Excel for the web)
Connect to LinkedIn Ads from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Build AI Agents with Zoho Projects 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 Zoho Projects through CData Connect AI.
-
Working with Templated Data in LINQPad
Execute LINQ queries to Templated in LINQPad.
-
How to Create Power BI Visual Reports with Real-Time Dropbox Data
Use CData Power BI Connectors to visualize Dropbox in Power BI.
-
Connect to Zendesk Data in Ruby
Connect to Zendesk in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrate SharePoint Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Microsoft SharePoint from Informatica Cloud.
-
Getting Started with the CData Excel Add-In for EnterpriseDB
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for EnterpriseDB.
-
Replicate Basecamp Data to Multiple Databases via the CData Sync CLI
Replicate Basecamp to disparate databases with a single configuration.
-
Explore Geographical Relationships in Clio Data with Power Map
Create data visualizations with Clio in Power Map.
-
Connect to Rootly Data in CloverDX (formerly CloverETL)
Transfer Rootly using the visual workflow in the CloverDX data integration tool.
-
How to import ShipStation Data into Apache Solr
Use the CData Software JDBC Driver for ShipStation in Data Import Handler and create an automated import of ShipStation to Apache Solr Enterprise Search platform.
-
How to Access Live Dropbox Data in Visual Studio Code via Cline
Run CData MCP Server for Dropbox on Windows Subsytem for Linux (WSL) and connect to live Dropbox from the Cline extension in Visual Studio Code.
-
Connect to Printful Data in HULFT Integrate
Connect to Printful as a JDBC data source in HULFT Integrate
-
Publish Dotmailer-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Dotmailer.
-
Replicate Zoho CRM Data to Multiple Databases via the CData Sync CLI
Replicate Zoho CRM to disparate databases with a single configuration.
-
Connect to Zoho Recruit Data in DBeaver
Use the CData ODBC Driver to connect to Zoho Recruit in DBeaver.
-
Build FHIR-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live FHIR.
-
Automated Continuous Sybase IQ Replication to SQL Server
Use CData Sync for automated, continuous, customizable Sybase IQ replication to SQL Server.
-
Bidirectional Access to Mouseflow Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Mouseflow in Filemaker Pro for Mac or Windows.
-
Process & Analyze SAP Concur Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SAP Concur Data.
-
How to Work with SpaceX Data in ETL Validator JDBC
Connect to SpaceX from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrating Claude Code CLI with Tally 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.
-
Build Data Flows from Autopilot to SQL Server using SSIS
Easily back up Autopilot to SQL Server using the SSIS components for Autopilot.
-
How to Query Live Salesforce Marketing Data in Perplexity MacOS Desktop
Connect to and query live Salesforce Marketing Data in Perplexity Desktop using CData MCP Server.
-
Deploy the ADO.NET Provider for ServiceDesk Plus on an SSRS Report Server
Connect to ServiceDesk Plus 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.
-
How to Connect the Power BI Service to RSS: Complete Guide
Connect to the CData Software Power BI Connector for RSS from PowerBI.com to provide real-time RSS Feeds across the organization.
-
Create Clari Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Clari from PowerBI.com to create Power BI Dataflows with real-time data.
-
Import SAP Ariba Procurement Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to SAP Ariba Procurement Data and provide access to live SAP Ariba Procurement for custom reports in the Power BI Service.