CData Software - Knowledge Base
Recent Articles
-
Create Dashboards and Visualize Live Bannerbear Data in Geckoboard
Use CData Connect AI to connect to live Bannerbear data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Create Dashboards and Visualize Live Microsoft Exchange Data in Geckoboard
Use CData Connect AI to connect to live Microsoft Exchange data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Working with Datetime Values Using CData Drivers
Use the API Server and React to Build Dynamic Web Apps with Live Database Data.
-
Create Reckon Accounts Hosted-Connected Dashboards in Grafana
Connect to Reckon Accounts Hosted Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Reckon Accounts Hosted data.
-
Integrate with live Freshteam Data in Jitterbit
Use CData Connect AI to connect to and integrate live Freshteam data in Jitterbit.
-
How to Build an ETL App for Elasticsearch Data in Python with CData
Create ETL applications and real-time data pipelines for Elasticsearch data in Python with petl.
-
How to Connect DBeaver to ScrapingBee via a JDBC Driver
Manage ScrapingBee data with visual tools in DBeaver like the query browser.
-
Connect to Shortcut Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Shortcut data.
-
Integrate Reckon Accounts Hosted with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Reckon Accounts Hosted with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Reckon Accounts Hosted data.
-
Publish Crystal Reports on Pushbullet Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Pushbullet data.
-
Access Live Smartsheet Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Smartsheet data from your Excel spreadsheets.
-
Create a Data Access Object for Vimeo Data using JDBI
A brief overview of creating a SQL Object API for Vimeo data in JDBI.
-
Create Microsoft Ads-Connected Nintex Workflows
Use CData Connect AI to connect to Microsoft Ads Data from Nintex Workflow Cloud and build custom workflows using live Microsoft Ads data.
-
Integrate Dotmailer Data in the Pentaho Report Designer
Publish reports based on Dotmailer data in the Pentaho BI tool.
-
Creating Shortcut-Connected Applications in Unqork
You can use CData Connect AI to feed Shortcut data to Unqork and build custom business apps.
-
Work with Live Microsoft Dataverse Data in Power Query
Use CData Connect AI to connect to Microsoft Dataverse data and work with live Microsoft Dataverse data in Microsoft Power Query.
-
Build Apps with Live Tally Data Using the Low-Code Development Platform of Mendix
Connect Tally data with Mendix to build apps using the CData JDBC Driver for Tally.
-
Integrating Boomi Agentstudio with Sybase Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Sybase data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Visualize Azure DevOps Data in Tableau
The CData ODBC driver for Azure DevOps enables you integrate Azure DevOps data into Tableau dashboards.
-
Publish Reports with Reply.io Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Reply.io data.
-
Getting Started with the CData Excel Add-In for Ontraport
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Ontraport.
-
Build a Simple VCL Application for EmailOctopus Data
How to build a simple VCL Application to view EmailOctopus data in RAD Studio using the CData ODBC Driver for EmailOctopus.
-
Integrate SQL Server Data into Power Automate Desktop using CData Connect
CData Connect for SQL Server Data enables you to integrate SQL Server data into workflows built using Microsoft Power Automate Desktop.
-
Connect to Zoho Books Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Zoho Books and the Script function in FileMaker Pro to connect to Zoho Books and work with Zoho Books data in your FileMaker application.
-
Access Live Workday 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 Workday data through MCP integration.
-
Automated Continuous Aweber Replication to Databricks
Use CData Sync for automated, continuous, customizable Aweber replication to Databricks.
-
A PostgreSQL Interface for Mailjet Data using the CData ODBC Driver
Use the SQL Gateway and Mailjet ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Cursor with Office 365 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 SendGrid Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with SendGrid Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to and Query Phoenix Data in QlikView over ODBC
Create data visualizations with Phoenix data in QlikView.
-
Build Optimizely-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Optimizely Data from Zoho Analytics and import live Optimizely data.
-
Feed CircleCI Data into FineReport
How to set CircleCI data as a JDBC data source in FineReport.
-
Connect to Google Directory Data from PowerBuilder via JDBC
This article demonstrates how to access Google Directory data from PowerBuilder using the Google Directory JDBC Driver.
-
Model, Search, and Visualize Live ZohoExpense Data in ThoughtSpot
Use CData Connect AI to connect to live ZohoExpense data for modeling, searching, and visualizing.
-
Visualize Planio Data in Tableau
The CData ODBC driver for Planio enables you integrate Planio data into Tableau dashboards.
-
Integrate Live LDAP Objects into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to LDAP objects and integrate live LDAP objects into apps built in Microsoft Power Apps.
-
Connect to Workday Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Workday data in Airbyte.
-
Publish Planio-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Planio data.
-
Use Dash to Build to Web Apps on Salesforce Data 360 Data
Create Python applications that use pandas and Dash to build Salesforce Data 360-connected web apps.
-
Model, Search, and Visualize Live Monday.com Data in ThoughtSpot
Use CData Connect AI to connect to live Monday.com data for modeling, searching, and visualizing.
-
Connect to SharePoint from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from SharePoint data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Enable the Gong JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Gong data.
-
Using the CData Software ODBC Driver for Timely in PyCharm
Connect to Timely as an ODBC data source in PyCharm using the CData Software ODBC Driver for Timely.
-
Automated Continuous Mailgun Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Mailgun replication to Amazon Redshift.
-
Integrate OpenCode with Live Timely Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Timely data from within your AI coding agent.
-
Access Live FHIR Data in Excel 365 Online (Excel for the web)
Connect to FHIR data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to Microsoft OneDrive Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Microsoft OneDrive.
-
Build a Simple VCL Application for Bugsnag Data
How to build a simple VCL Application to view Bugsnag data in RAD Studio using the CData ODBC Driver for Bugsnag.
-
Automated Continuous Outlook Replication to MySQL
Use CData Sync for automated, continuous, customizable Outlook replication to MySQL.
-
Using the CData Software ODBC Driver for PDFMonkey in PyCharm
Connect to PDFMonkey as an ODBC data source in PyCharm using the CData Software ODBC Driver for PDFMonkey.
-
DataBind Controls to Google Cloud Storage Data in Delphi
DataBind to Google Cloud Storage data in Delphi with standard data access components and controls.
-
Integrating Dataiku with Oracle Sales Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Oracle Sales data.
-
Extract, Transform, and Load CapsuleCRM Data in Informatica PowerCenter
Create a simple Workflow for CapsuleCRM data in Informatica PowerCenter.
-
Analyze Freshdesk Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Freshdesk data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connecting Mastra with Acumatica 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 Acumatica data, no replication required.
-
Visualize BenchmarkEmail Data in Sisense
Create an ElastiCube in Sisense app with access to BenchmarkEmail data.
-
Connect to Stripe from a Connection Pool in WebLogic
Use the CData JDBC Driver for Stripe to connect to Stripe data from Web applications running on WebLogic.
-
Build AI Agents with Pipedrive 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 Pipedrive data through CData Connect AI.
-
Query Stripe Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Stripe entities in PHP by modeling them as objects.
-
Automate Google Forms Data Replication to Couchbase
Use CData Sync to Customize and automate Google Forms data replication to Couchbase.
-
Build Semantic Layer Views for Figshare Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Figshare data.
-
How to Connect to & Open Box Data in Microsoft Excel
This article uses the CData ODBC driver for Box to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Use the CData Software JDBC Driver for Codat in MicroStrategy
Connect to Codat data in MicroStrategy Developer using the CData Software JDBC Driver for Codat.
-
Integrate Simplesat with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Simplesat with External Services.
-
Automated Continuous Factorial Replication to Oracle
Use CData Sync for automated, continuous, customizable Factorial replication to Oracle.
-
Connect to Stack Exchange Data in JRuby
Create a simple JRuby app with access to live Stack Exchange data.
-
Connect to Elorus Data in RapidMiner
Integrate Elorus data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to CSV from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from CSV data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Build Agents in Relevance AI with Access to Live Sage Cloud Accounting Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Sage Cloud Accounting data within intelligent agent workflows.
-
Use Grok to Talk to Your xBase 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 xBase data for you.
-
How to Seamlessly Import Oracle HCM Cloud Data into IBM SPSS Modeler
Integrate Oracle HCM Cloud data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Automated Continuous Amplitude Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Amplitude replication to Amazon S3.
-
Automated Continuous MariaDB Replication to Snowflake
Use CData Sync for automated, continuous, customizable MariaDB replication to Snowflake.
-
Migrating data from SAP Ariba Source to Snowflake using CData SSIS Components.
Easily push SAP Ariba Source data to Snowflake using the CData SSIS Tasks for SAP Ariba Source and Snowflake.
-
Connect and Visualize Live WooCommerce Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live WooCommerce data into the Databricks platform and create visualization dashboards with real-time WooCommerce data.
-
Bridge Calendly Connectivity with Apache NiFi
Access and process Calendly data in Apache NiFi using the CData JDBC Driver.
-
Create CSV Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time CSV data access from reports, embedded analytics, and more.
-
Use the CData Software ODBC Driver for Klaviyo in SAS for Real-Time Reporting and Analytics
Connect to real-time Klaviyo data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Klaviyo.
-
How to Query Live Pipedrive Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Pipedrive data data in natural language using Python.
-
Build Qualaroo-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Qualaroo data and build web apps with connectivity to live Qualaroo data.
-
Automated Continuous Bitly Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Bitly replication to Azure SQL Database.
-
Create Power BI Reports on Real-Time HCL Domino Data
Use the CData ODBC Driver for HCL Domino to visualize HCL Domino data in Power BI Desktop.
-
How to connect SharePoint with Active Directory Data through external lists
Provide Active Directory data to SharePoint users as an external list.
-
Use the CData Software ODBC Driver for Adobe Target in MicroStrategy
Connect to Adobe Target data in MicroStrategy Developer using the CData Software ODBC Driver for Adobe Target.
-
Visualize Procore Data in Sisense
Create an ElastiCube in Sisense app with access to Procore data.
-
How to connect to MessageBird Data in DBVisualizer
Integrate MessageBird data with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Apps with Live CSV data in Adalo using CData Connect AI
Use CData Connect AI to integrate live CSV data into the Adalo platform and build custom mobile and web applications with real-time CSV data.
-
How to import Customer.io Data into Apache Solr
Use the CData Software JDBC Driver for Customer.io in Data Import Handler and create an automated import of Customer.io data to Apache Solr Enterprise Search platform.
-
Visualize Opsgenie Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Opsgenie data.
-
Build a PostgreSQL Interface for Reckon Accounts Hosted Data using the CData JDBC Driver
Use the Remoting features of the Reckon Accounts Hosted JDBC Driver to create a PostgreSQL entry-point for data access.
-
Work with Gumroad Data in FoxPro
Load Gumroad data into a FoxPro database. This article includes full code and a walk-through of the process.
-
A PostgreSQL Interface for Microsoft Teams Data (MySQL Remoting via JDBC)
Use the Remoting features of the Microsoft Teams JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Datasets from Zoho Recruit in Domo Workbench and Build Visualizations of Zoho Recruit Data in Domo
Use the CData Software ODBC Driver for Zoho Recruit to create datasets from Zoho Recruit data in Domo Workbench and then build visualizations in the Domo service.
-
Use the CData ODBC Driver for Clockify in Microsoft Power Query
You can use the CData Clockify ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Clockify data into Microsoft Power Query.
-
How to create Oracle Service Cloud federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Oracle Service Cloud data in MySQL .
-
How to work with SQL Analysis Services Data in Apache Spark using SQL
Access and process SQL Analysis Services Data in Apache Spark using the CData Software JDBC Driver.
-
Build Instagram-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Instagram data.
-
Access Azure Table Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Azure Table data from HeidiSQL.
-
Access Sybase Data from MySQL in Amazon QuickSight
Connect to Sybase and build visualizations of Sybase data using a MySQL Connection in Amazon QuickSight.
-
Visualize Microsoft Dataverse Data in TIBCO Spotfire through ADO.NET
Integrate Microsoft Dataverse data into dashboards in TIBCO Spotfire.