CData Software - Knowledge Base
Recent Articles
-
Connect to SQL Server Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for SQL Server and the Script function in FileMaker Pro to connect to SQL Server and work with SQL Server data in your FileMaker application.
-
How to connect PolyBase to Placid
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Placid data.
-
Access Live LaunchDarkly Data in Coginiti Pro
Connect to and query live LaunchDarkly data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Perplexity Data from a Connection Pool in JBoss
Integrate Perplexity data into Java servlets: Use the Management Console in JBoss to install the Perplexity JDBC Driver.
-
Connect to Stripe Data in RazorSQL
Connect to Stripe from wizards and query Stripe data from the GUI in the RazorSQL database management tool.
-
Create Informatica Mappings From/To a JDBC Data Source for Google Analytics
Create Google Analytics data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to OData from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from OData services, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Analyze BigCommerce Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of BigCommerce data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
How to Connect to Live Databricks Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Databricks data without replication.
-
Automate ActiveCampaign Data Replication to Couchbase
Use CData Sync to Customize and automate ActiveCampaign data replication to Couchbase.
-
Build MVC Applications with Connectivity to Outreach.io Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Outreach.io from an ASP.NET MVC application.
-
Build a Simple VCL Application for Freshservice Data
How to build a simple VCL Application to view Freshservice data in RAD Studio using the CData ODBC Driver for Freshservice.
-
Getting Started with the CData Power BI Connector for PDFMonkey
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Build Semantic Layer Views for Freshdesk Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Freshdesk data.
-
Access Live BenchmarkEmail Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to BenchmarkEmail data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to ZarMoney Data in NetBeans
Connect to ZarMoney data in NetBeans with the data source configuration wizard.
-
Create a Data Access Object for ConvertAPI Data using JDBI
A brief overview of creating a SQL Object API for ConvertAPI data in JDBI.
-
Automated Continuous Placid Replication to Vertica
Use CData Sync for automated, continuous, customizable Placid replication to Vertica.
-
Connect to TigerGraph Data in Aqua Data Studio
Access TigerGraph data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Access Helpscout Data Using Entity Framework
This article shows how to access Helpscout data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Prepare, Blend, and Analyze SurveyMonkey Data in Alteryx Designer (ODBC)
Build workflows to access live SurveyMonkey data for self-service data analytics.
-
Connect to ZohoPeople Data in NetBeans
Connect to ZohoPeople data in NetBeans with the data source configuration wizard.
-
Use the CData Software JDBC Driver for Zoho Inventory in MicroStrategy Web
Connect to Zoho Inventory data in MicroStrategy Web using the CData Software JDBC Driver for Zoho Inventory.
-
Getting Started with the CData SSIS Components for Excel Online
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Excel Online.
-
Work with SAP Data in FoxPro
Load SAP data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Import Odoo Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Odoo Data and provide access to live Odoo data for custom reports in the Power BI Service.
-
Integrate with Tickspot Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Tickspot data to a JSON file on disk.
-
Edit and Search NetSuite External Objects in Salesforce
Consume NetSuite objects in Salesforce filter lists.
-
Establish a Live Connection with Short.io Data using Tableau Bridge
The CData ODBC Driver for Short.io enables you to integrate live Short.io data into Tableau Cloud dashboards using the Tableau Bridge.
-
Visualize Live Reckon Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Reckon data into custom reports in Power BI.
-
Viewing ConstantContact Data in RAD Studio Data Explorer
How to view ConstantContact data in RAD Studio Data Explorer using the CData ODBC Driver for ConstantContact.
-
How to connect PolyBase to SAS Data Sets
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SAS Data Sets data.
-
Back Up Dynamics 365 data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Dynamics 365. In this article, we will employ an SSIS workflow to populate a database with Dynamics 365 data data.
-
Access Live Aweber Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Aweber data from your Excel spreadsheets.
-
Migrating data from Teamgate to Snowflake using CData SSIS Components.
Easily push Teamgate data to Snowflake using the CData SSIS Tasks for Teamgate and Snowflake.
-
Automated Continuous CampaignMonitor Replication to Oracle
Use CData Sync for automated, continuous, customizable CampaignMonitor replication to Oracle.
-
Use Azure AI Foundry to Talk to Your PostgreSQL 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 PostgreSQL data for you.
-
How to connect and process Salesforce Data 360 data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Salesforce Data 360 data.
-
How to Access Live Brex Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Brex enables you to integrate Brex data into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous Close Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Close replication to Google Cloud SQL.
-
Access Sage Cloud Accounting Data from MySQL in PHP
Connect to Sage Cloud Accounting through the standard MySQL libraries in PHP.
-
Build Data Flows from Elorus to SQL Server using SSIS
Easily back up Elorus data to SQL Server using the SSIS components for Elorus.
-
Integrate ServiceNow Data in the Pentaho Report Designer
Publish reports based on ServiceNow data in the Pentaho BI tool.
-
DataBind Controls to Oracle Sales Data in Delphi
DataBind to Oracle Sales data in Delphi with standard data access components and controls.
-
Access SpaceX Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for SpaceX data.
-
Replicate Google Forms Data to Multiple Databases
Replicate Google Forms data to disparate databases with a point-and-click configuration.
-
How to Build an ETL App for Clari Data in Python with CData
Create ETL applications and real-time data pipelines for Clari data in Python with petl.
-
Visualize Bugsnag Data in Tableau
The CData ODBC driver for Bugsnag enables you integrate Bugsnag data into Tableau dashboards.
-
Publish Reports with Scrapfly Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Scrapfly data.
-
Auth0 Reporting in OBIEE with the Auth0 JDBC Driver
Deploy the Auth0 JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrating Cursor with Zoho Inventory 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 MVC Applications with Connectivity to HubSpot Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access HubSpot from an ASP.NET MVC application.
-
Build Charts with DocuSign Data in Clear Analytics
Create dynamic charts and perform analytics based on DocuSign data in Clear Analytics.
-
Integrate Live Avro Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Avro data and integrate live Avro data into apps built in Microsoft Power Apps.
-
Publish Reports with Confluence Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Confluence data.
-
Analyze Eventbrite Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Eventbrite data with the CData JDBC Driver for Eventbrite.
-
Rapidly Develop Mixpanel-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 Mixpanel.
-
Publish Hive-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Hive data.
-
Object-Relational Mapping (ORM) with FTP 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 FTP data into a Java-based ORM framework, Hibernate.
-
Perplexity Reporting in OBIEE with the Perplexity JDBC Driver
Deploy the Perplexity JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build Visualizations of Short.io Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Short.io data in Birst.
-
Publish Reports with Opsgenie Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Opsgenie data.
-
Query Opsgenie Data in ColdFusion
Write standard ColdFusion data access code to connect to Opsgenie data.
-
Use JayDeBeApi to access Outlook Data in Python
Use standard Python scripting and the development environment of your choice to access live Outlook data.
-
Build Salesforce Marketing-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Salesforce Marketing Data from Zoho Analytics and import live Salesforce Marketing data.
-
Build a Simple VCL Application for Demio Data
How to build a simple VCL Application to view Demio data in RAD Studio using the CData ODBC Driver for Demio.
-
Connect to Drip in SpagoBI
Create reports featuring live Drip data in SpagoBI Studio. Host Drip reports on SpagoBI Server.
-
How to Access Live ElevenLabs Data in Power Automate Desktop via ODBC
The CData ODBC Driver for ElevenLabs enables you to integrate ElevenLabs data into workflows built using Microsoft Power Automate Desktop.
-
Use the CData Software ODBC Driver for SendInBlue in MicroStrategy
Connect to SendInBlue data in MicroStrategy Developer using the CData Software ODBC Driver for SendInBlue.
-
Getting Started with the CData Tableau Connector for CampaignMonitor
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
How to Connect to Live Reckon Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Reckon data for you.
-
Automated Continuous ConvertAPI Replication to AlloyDB
Use CData Sync for automated, continuous, customizable ConvertAPI replication to AlloyDB.
-
Connect to Teamwork Data in Aqua Data Studio
Access Teamwork data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Access Live SAP BusinessObjects BI Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAP BusinessObjects BI data from your Excel spreadsheets.
-
Access FHIR Data from MySQL in PHP
Connect to FHIR through the standard MySQL libraries in PHP.
-
Connect to Azure Data Lake Storage Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Azure Data Lake Storage data using standard SQL.
-
Establish a Live Connection with Google Ads Data using Tableau Bridge
The CData ODBC Driver for Google Ads enables you to integrate live Google Ads data into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrating Claude Code with Active Directory Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Active Directory data within assisted coding and automated development workflows.
-
Analyze ConvertAPI Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze ConvertAPI data with the CData JDBC Driver for ConvertAPI.
-
Import Snowflake Data Using Azure Data Factory
Use CData Connect AI to connect to Snowflake Data from Azure Data Factory and import live Snowflake data.
-
Automated Continuous Eventbrite Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Eventbrite replication to Amazon S3.
-
Integrating GitHub Copilot with Shortcut 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.
-
Integrate Sendwithus with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Sendwithus with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Sendwithus data.
-
Build a PostgreSQL Interface for Facebook Ads Data using the CData JDBC Driver
Use the Remoting features of the Facebook Ads JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use JayDeBeApi to access Workday Data in Python
Use standard Python scripting and the development environment of your choice to access live Workday data.
-
Connect and Query Live AfterShip Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live AfterShip data into Databricks and enable direct, live querying and analysis without replication.
-
A PostgreSQL Interface for ConvertKit Data using the CData ODBC Driver
Use the SQL Gateway and ConvertKit ODBC Driver to create a PostgreSQL entry-point for data access.
-
Moving Data from iContact to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live iContact data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to Real-Time Teradata Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Teradata and Dataflow to import and use Teradata data in Power Apps.
-
Use Dash to Build to Web Apps on Close Data
Create Python applications that use pandas and Dash to build Close-connected web apps.
-
Build AI Agents with Apollo 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 Apollo data through CData Connect AI.
-
How to Create Power BI Visual Reports with Real-Time Autopilot Data
Use CData Power BI Connectors to visualize Autopilot data in Power BI.
-
Connect to Shortcut in SpagoBI
Create reports featuring live Shortcut data in SpagoBI Studio. Host Shortcut reports on SpagoBI Server.
-
Use JayDeBeApi to access Xero Data in Python
Use standard Python scripting and the development environment of your choice to access live Xero data.
-
How to Connect to Live SendGrid 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 SendGrid data for you.
-
Model Azure Table Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Azure Table, enabling the direct import of real-time Azure Table data.
-
Automate Snowflake Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Snowflake data from PowerShell? This article demonstrates how to utilize the Snowflake Cmdlets for tasks like connecting to Snowflake data, automating operations, downloading data, and more.
-
Use Microsoft Copilot Studio to talk to your ServiceNow Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your ServiceNow data for you.
-
How to update BigQuery from Excel
This article explains how to transfer data from Excel to BigQuery using the Excel Add-In for BigQuery.
-
Integrate Tally Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Tally data and integrate live Tally data into your Power Automate tasks.