CData Software - Knowledge Base
Recent Articles
-
Automate IBM Cloud Object Storage Integration Tasks from PowerShell
Are you in search of a quick and easy way to access IBM Cloud Object Storage data from PowerShell? This article demonstrates how to utilize the IBM Cloud Object Storage Cmdlets for tasks like connecting to IBM Cloud Object Storage data, automating operations, downloading data, and more.
-
Write a Simple Go Application to work with Placid Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Placid data.
-
SendPulse Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SendPulse facts in real time.
-
Connect to DocuSign in SpagoBI
Create reports featuring live DocuSign data in SpagoBI Studio. Host DocuSign reports on SpagoBI Server.
-
Load Vimeo Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Vimeo data to a database.
-
Create Data Visualizations in Cognos BI with Twitter Ads Data
Access Twitter Ads data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Use the CData Software JDBC Driver for Reckon Accounts Hosted in MicroStrategy Desktop
Connect to Reckon Accounts Hosted data in MicroStrategy Desktop using the CData Software JDBC Driver for Reckon Accounts Hosted.
-
Object-Relational Mapping (ORM) with Zoom 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 Zoom data into a Java-based ORM framework, Hibernate.
-
Automated Continuous LaunchDarkly Replication to Snowflake
Use CData Sync for automated, continuous, customizable LaunchDarkly replication to Snowflake.
-
Query Google Campaign Manager 360 Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Google Campaign Manager 360 data from Node.js.
-
Automate Act CRM Data Replication to SAP HANA
Use CData Sync to customize and automate Act CRM data replication to SAP HANA.
-
Integrating Gumloop with eBay Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on eBay Analytics data within automated workflows.
-
Use Azure AI Foundry to Talk to Your ShipEngine 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 ShipEngine data for you.
-
View Reports on Real-Time Coda Data in Power BI Report Server
Use the CData ODBC Driver for Coda to visualize Coda data in Power BI Desktop and then publish them to Power BI Report Server.
-
How to update Gmail from Excel
This article explains how to transfer data from Excel to Gmail using the Excel Add-In for Gmail.
-
Viewing Klaviyo Data in RAD Studio Data Explorer
How to view Klaviyo data in RAD Studio Data Explorer using the CData ODBC Driver for Klaviyo.
-
Use the CData Software ODBC Driver for Gumroad in MicroStrategy Web
Connect to Gumroad data in MicroStrategy Web using the CData Software ODBC Driver for Gumroad.
-
How to connect to Elorus Data in DBVisualizer
Integrate Elorus data with visual data analysis tools and data connection wizards in DBVisualizer
-
How to Connect the Power BI Service to Demio: Complete Guide
Connect to the CData Software Power BI Connector for Demio from PowerBI.com to provide real-time Demio data across the organization.
-
Automate MongoDB Data Replication to Azure Synapse
Use CData Sync to customize and automate MongoDB data replication to Azure Synapse.
-
Explore Geographical Relationships in Hive Data with Power Map
Create data visualizations with Hive data in Power Map.
-
Connect to Real-Time SurveyMonkey Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for SurveyMonkey and Dataflow to import and use SurveyMonkey data in Power Apps.
-
Use the CData ODBC Driver for Bullhorn CRM from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Bullhorn CRM to connect to Bullhorn CRM data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Bullhorn CRM data in Excel.
-
Automated Continuous Toggl Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Toggl replication to Google BigQuery.
-
Create OData Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time OData data access from reports, embedded analytics, and more.
-
Build Visualizations of Reckon Accounts Hosted Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Reckon Accounts Hosted data in Birst.
-
Connect Vault CRM to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Vault CRM data using the CData Python MCP Server.
-
Integrate Cursor with Live iContact Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live iContact data from within the editor.
-
How to Easily Query FreeAgent Data in OpenOffice Base
Connect to FreeAgent data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Excel Spreadsheet Automation on Toggl Data with the QUERY Formula
Pull data from Toggl, automate spreadsheets, and more with the QUERY formula.
-
Load ConvertKit Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load ConvertKit data to a database.
-
Publish Crystal Reports on Sage 200 Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Sage 200 data.
-
A PostgreSQL Interface for Bugsnag Data (MySQL Remoting via JDBC)
Use the Remoting features of the Bugsnag JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Qualaroo Data in Ruby
Connect to Qualaroo data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Publish Invoiced-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Invoiced data.
-
Connect to Google Cloud Storage Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Google Cloud Storage data in Airbyte.
-
Connect to Oracle Sales Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Oracle Sales data using standard SQL.
-
Connect to Google Sheets Data in Google Apps Script via Connect AI
Use CData Connect AI to access Google Sheets data in Google Apps Script.
-
Build a Simple VCL Application for Dynamics NAV Data
How to build a simple VCL Application to view Dynamics NAV data in RAD Studio using the CData ODBC Driver for Dynamics NAV.
-
Create SSAS Tabular Models from ConvertKit Data
How to build a SQL Server Analysis Service Tabular Model from ConvertKit data using CData drivers.
-
Connect to Odoo Data in CloverDX (formerly CloverETL)
Transfer Odoo data using the visual workflow in the CloverDX data integration tool.
-
DataBind Controls to GetResponse Data in Delphi
DataBind to GetResponse data in Delphi with standard data access components and controls.
-
Use the CData ODBC Driver for Power BI XMLA from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Power BI XMLA to connect to Power BI XMLA data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Power BI XMLA data in Excel.
-
Connect and Query Live SQL Server Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live SQL Server data into Databricks and enable direct, live querying and analysis without replication.
-
Integrate Devin with Live Power BI XMLA Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Power BI XMLA data.
-
Analyze SAS Data Sets Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of SAS Data Sets data and visualize live SAS Data Sets data in Infragistics Reveal.
-
Create SSAS Tabular Models from FreeAgent Data
How to build a SQL Server Analysis Service Tabular Model from FreeAgent data using CData drivers.
-
How to Easily Query FormSite Data in OpenOffice Base
Connect to FormSite data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Edit and Search External Exact Online Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Exact Online data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Exact Online Data objects that you can access from apps and the dashboard.
-
Automated Continuous Salesforce Marketing Replication to Oracle
Use CData Sync for automated, continuous, customizable Salesforce Marketing replication to Oracle.
-
Getting Started with the CData JDBC Driver for Asana
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Asana.
-
Automated Continuous Google Directory Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Google Directory replication to Google BigQuery.
-
Connect to Freshservice in SpagoBI
Create reports featuring live Freshservice data in SpagoBI Studio. Host Freshservice reports on SpagoBI Server.
-
Connect to Okta Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Okta Data and connect to Okta data in Akorbi Digital RunMyProcess.
-
Visualize ClickTime 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 ClickTime data into TIBCO Spotfire.
-
Connect to Omnisend Data in HULFT Integrate
Connect to Omnisend as a JDBC data source in HULFT Integrate
-
How to Query Live Neo4J Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Neo4J data data in natural language using Python.
-
Connect to FTP Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for FTP and the Script function in FileMaker Pro to connect to FTP and work with FTP data in your FileMaker application.
-
Integrating Codex with Typeform 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.
-
How to connect to MarkLogic Data in DBVisualizer
Integrate MarkLogic data with visual data analysis tools and data connection wizards in DBVisualizer
-
Replicate Oracle Eloqua Data to Multiple Databases
Replicate Oracle Eloqua data to disparate databases with a point-and-click configuration.
-
Extract, Transform, and Load Marketo Data in Informatica PowerCenter
Create a simple Workflow for Marketo data in Informatica PowerCenter.
-
Connect to WordPress Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for WordPress and the Script function in FileMaker Pro to connect to WordPress and work with WordPress data in your FileMaker application.
-
Connect to Simplesat Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Simplesat to connect to Simplesat data and execute queries in PowerBuilder.
-
Analyze Teamgate Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Teamgate data with the CData JDBC Driver for Teamgate.
-
Create Data Visualizations in Cognos BI with Azure Analysis Services Data
Access Azure Analysis Services data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Monday.com in SpagoBI
Create reports featuring live Monday.com data in SpagoBI Studio. Host Monday.com reports on SpagoBI Server.
-
Object-Relational Mapping (ORM) with Microsoft Teams 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 Microsoft Teams data into a Java-based ORM framework, Hibernate.
-
How to Connect Flowise AI Agents to Live Square Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Square data without replication.
-
Build Automated Workflows with Live Google Spanner Data in Workato
Use CData Connect AI to connect to live Google Spanner data and build automated workflows in Workato.
-
Connect to SFTP Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for SFTP Data and connect to SFTP data in Akorbi Digital RunMyProcess.
-
Using the CData Software ODBC Driver for SageHR in PyCharm
Connect to SageHR as an ODBC data source in PyCharm using the CData Software ODBC Driver for SageHR.
-
Load Dotmailer Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Dotmailer data to a database.
-
Getting Started with the CData ODBC Driver for Retently
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Retently.
-
Automated Continuous Gorgias Replication to MySQL
Use CData Sync for automated, continuous, customizable Gorgias replication to MySQL.
-
Use Microsoft Copilot Studio to talk to your Jumpseller 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 Jumpseller data for you.
-
Visualize Salesforce CRM Analytics 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 Salesforce CRM Analytics data into TIBCO Spotfire.
-
Integrate Theia IDE with Live Facebook Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Facebook data from within the development environment.
-
Build Salesforce CRM Analytics-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Salesforce CRM Analytics Data and create custom apps in Mendix.
-
Integrate Live SurveyMonkey Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to SurveyMonkey from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live SurveyMonkey data.
-
How to Query Teamgate Data in MySQL Workbench
Execute MySQL queries against live Teamgate data from MySQL Workbench.
-
Connect to Codat Data in DBArtisan
Use wizards in DBArtisan to configure Codat data as a data source.
-
Bidirectional Access to Freshdesk Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Freshdesk data in Filemaker Pro for Mac or Windows.
-
Analyze NASA Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for NASA from Power Pivot. You will use the Table Import Wizard to load NASA data. You can visually build the import query or use any SQL supported by the driver.
-
Design BIRT Reports on Jira Data
Provide current Jira data to your embedded analytics.
-
Integrating Claude Code with Snapchat Ads Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Snapchat Ads data within assisted coding and automated development workflows.
-
Use Biml to Build SSIS Tasks to Replicate QuickBooks Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate QuickBooks data to SQL Server.
-
Moving Data from Workday to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Workday data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to Connect to Live Adobe Commerce 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 Adobe Commerce data without replication.
-
Integrate Theia IDE with Live HubSpot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live HubSpot data from within the development environment.
-
Using the CData Software ODBC Driver for Everhour in PyCharm
Connect to Everhour as an ODBC data source in PyCharm using the CData Software ODBC Driver for Everhour.
-
Stream Harvest Data into Apache Kafka Topics
Access and stream Harvest data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Access Live Twilio Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Twilio data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to Connect to Live Google Cloud Storage Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Google Cloud Storage data securely in real time.
-
Connect to RSS Feeds from a Connection Pool in Jetty
The RSS JDBC Driver supports connection pooling: This article shows how to connect faster to RSS feeds from Web apps in Jetty.
-
Load Freshteam Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Freshteam data to a database.
-
Integrating Antigravity CLI with iContact data via CData CLI
Connect iContact data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect Dynamics 365 Business Central to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Dynamics 365 Business Central with IBM WebSphere for seamless data integration and connectivity.
-
How to update REST from Excel
This article explains how to transfer data from Excel to REST using the Excel Add-In for REST.
-
How to Access Office 365 Data Using Entity Framework
This article shows how to access Office 365 data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.