CData Software - Knowledge Base
Recent Articles
-
Use Databricks Agent Bricks to Talk to Your Shopify Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Shopify for you.
-
Getting Started with the CData ODBC Driver for Demio
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Demio.
-
Connect to Flowlu in SpagoBI
Create reports featuring live Flowlu in SpagoBI Studio. Host Flowlu reports on SpagoBI Server.
-
Create Informatica Mappings From/To an ODBC Data Source for Facebook
Create an ODBC connection to Facebook in Informatica and browse and transfer Facebook.
-
Couchbase Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Couchbase facts in real time.
-
Validate Pipeliner CRM Data with QuerySurge
Access and validate Pipeliner CRM in QuerySurge using the CData JDBC Driver.
-
Rapidly Develop Salesforce-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 Salesforce.
-
Build MVC Applications with Connectivity to REST Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access REST from an ASP.NET MVC application.
-
DataBind Controls to SAS xpt Data in Delphi
DataBind to SAS XPORT in Delphi with standard data access components and controls.
-
Excel Spreadsheet Automation on Wave Financial Data with the QUERY Formula
Pull data from Wave Financial, automate spreadsheets, and more with the QUERY formula.
-
Feed Perplexity Data into FineReport
How to set Perplexity as a JDBC data source in FineReport.
-
Getting Started with the CData ADO.NET Provider for ScrapingBee
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Build Visualizations of Gorgias Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Gorgias in Birst.
-
How to connect to Tanda Data with Squirrel SQL client
Connect to Tanda and execute queries in the Squirrel SQL Client.
-
Build Automated NetSuite-Connected Workflows in Zapier
Use CData Connect AI to connect to live NetSuite CRM & ERP and build automated workflows in Zapier.
-
Migrating data from Stack Exchange to Google BigQuery using CData SSIS Components.
Easily push Stack Exchange to Google BigQuery using the CData SSIS Tasks for Stack Exchange and Google BigQuery.
-
Deploy the ADO.NET Provider for CSV on an SSRS Report Server
Connect to CSV/TSV Files 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.
-
Import Real-Time CockroachDB Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use CockroachDB in ColdFusion.
-
SAS xpt Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SAS xpt facts in real time.
-
Seamlessly Bring Google Drive Data into Retool Using CData Connect AI
Integrate Google Drive data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Integrate Live Oracle Financials Cloud Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Oracle Financials Cloud and integrate live Oracle Financials Cloud into apps built in Microsoft Power Apps.
-
Consume Confluence OData Feeds in PowerBuilder
This article demonstrates how to consume Atlassian Confluence as OData feeds from PowerBuilder using the API Server.
-
Use the CData Software JDBC Driver for IBM Cloud Object Storage in MicroStrategy Web
Connect to IBM Cloud Object Storage in MicroStrategy Web using the CData Software JDBC Driver for IBM Cloud Object Storage.
-
Object-Relational Mapping (ORM) with FormSite 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 FormSite into a Java-based ORM framework, Hibernate.
-
How to Seamlessly Import Redis Data into IBM SPSS Modeler
Integrate Redis data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Automated Continuous Impala Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Apache Impala replication to OneLake in Microsoft Fabric.
-
Moving Data from EnterpriseDB to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live EnterpriseDB data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to LeadDesk Data in DBArtisan
Use wizards in DBArtisan to configure LeadDesk as a data source.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Bitbucket
Provide connectivity to Bitbucket through an SAP BusinessObjects universe.
-
Automated Continuous Amplitude Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Amplitude replication to Google BigQuery.
-
DataBind SAP Netweaver Gateway Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for SAP Netweaver Gateway with the DevExpress Windows Forms and Web controls to provide SAP Netweaver Gateway to a chart.
-
Validate Freshdesk Data with QuerySurge
Access and validate Freshdesk in QuerySurge using the CData JDBC Driver.
-
How to use SQLAlchemy ORM to access Eventbrite Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Eventbrite.
-
Build Voice Agents in ElevenLabs with access to Live Shopify Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Shopify.
-
Access Live Google Calendar Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Google Calendar data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Build Dashboards with Hugging Face Data in DBxtra
Create dynamic dashboards and perform analytics based on Hugging Face in DBxtra.
-
Integrate Goose with Live Neo4J Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Neo4J from within the local AI agent.
-
How to Work with Dotmailer Data in AWS Glue Jobs Using JDBC
Connect to Dotmailer from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Use Biml to Build SSIS Tasks to Replicate ChartMogul Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate ChartMogul to SQL Server.
-
Connect to Omnisend Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Omnisend.
-
Access Live PayPal Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to PayPal from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Build MVC Applications with Connectivity to Brex Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Brex from an ASP.NET MVC application.
-
Build a PostgreSQL Interface for Zoho Books Data using the CData JDBC Driver
Use the Remoting features of the Zoho Books JDBC Driver to create a PostgreSQL entry-point for data access.
-
Design BIRT Reports on Azure Data Lake Storage Data
Provide current Azure Data Lake Storage to your embedded analytics.
-
Publish SAP Ariba Source-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SAP Ariba Source.
-
Automate SendInBlue Data Replication to SAP HANA
Use CData Sync to customize and automate SendInBlue replication to SAP HANA.
-
View Reports on Real-Time Pipedrive Data in Power BI Report Server
Use the CData ODBC Driver for Pipedrive to visualize Pipedrive in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Freshservice Data in CloverDX (formerly CloverETL)
Transfer Freshservice using the visual workflow in the CloverDX data integration tool.
-
Automate BenchmarkEmail Integration Tasks from PowerShell
Are you in search of a quick and easy way to access BenchmarkEmail from PowerShell? This article demonstrates how to utilize the BenchmarkEmail Cmdlets for tasks like connecting to BenchmarkEmail, automating operations, downloading data, and more.
-
Connect to JSON Services in DBArtisan
Use wizards in DBArtisan to configure JSON as a data source.
-
Build Reckon-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Reckon to explore live Reckon Data in Gemini Code Assist to assist with building Reckon-powered applications.
-
Connecting Pipedream with Salesforce Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Salesforce data in real time.
-
Build Outreach.io-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Outreach.io Data and create custom apps in Mendix.
-
Connect to Exa Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Exa using standard SQL.
-
Import SAP SuccessFactors LMS Data Using Azure Data Factory
Use CData Connect AI to connect to SAP SuccessFactors LMS Data from Azure Data Factory and import live SAP SuccessFactors LMS.
-
Configure the CData JDBC Driver for FreeAgent in a Connection Pool in Tomcat
Connect to FreeAgent from a connection pool in Tomcat.
-
Getting Started with the CData SSIS Components for ClickTime
Complete guide to installing, licensing, and connecting with the CData SSIS Components for ClickTime.
-
Visualize Cloudflare 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 Cloudflare into TIBCO Spotfire.
-
Integrating GitHub Copilot CLI with SparkPost 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 Access Live Wave Financial Data in Visual Studio Code via Cline
Run CData MCP Server for Wave Financial on Windows Subsytem for Linux (WSL) and connect to live Wave Financial from the Cline extension in Visual Studio Code.
-
Build MailChimp Visualizations in Tableau Cloud
Use CData Connect AI to connect to live MailChimp and build visualizations in Tableau Cloud.
-
Connect to HCL Domino Data from PowerBuilder via ADO.NET
This article demonstrates how to access HCL Domino from Appeon PowerBuilder using the CData ADO.NET Provider for HCL Domino.
-
Connect to Gorgias Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Gorgias in the Denodo Virtual DataPort Administrator.
-
Prepare, Blend, and Analyze Procore Data in Alteryx Designer (Connect AI)
Build workflows to access live Procore for self-service data analytics.
-
Automated Continuous Spark Replication to MongoDB
Use CData Sync for automated, continuous, customizable Spark replication to MongoDB.
-
Automated Continuous SAP BusinessObjects BI Replication to Snowflake
Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to Snowflake.
-
Getting Started with the CData Excel Add-In for Google Spanner
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Google Spanner.
-
Moving Data from Reply.io to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Reply.io data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrating LlamaIndex with FreshBooks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on FreshBooks in real time.
-
Connect to MySQL Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live MySQL.
-
Connect to GitLab Data from PowerBuilder via JDBC
This article demonstrates how to access GitLab from PowerBuilder using the GitLab JDBC Driver.
-
Analyze Kintone Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Kintone and visualize live Kintone in Infragistics Reveal.
-
Feed Avro Data into FineReport
How to set Apache Avro as a JDBC data source in FineReport.
-
Integrate Cline with Live QuickBooks Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live QuickBooks Online from within your IDE.
-
Create Missive Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Missive data access from reports, embedded analytics, and more.
-
Build Codat-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Codat and build web apps with connectivity to live Codat.
-
Load Google Search Results to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Google Search to a database.
-
How to connect to Oracle Eloqua Reporting Data in DBVisualizer
Integrate Oracle Eloqua Reporting with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Cassandra Data from a Connection Pool in Jetty
The Cassandra JDBC Driver supports connection pooling: This article shows how to connect faster to Apache Cassandra from Web apps in Jetty.
-
Connect to Highrise Data in Ruby
Connect to Highrise CRM in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Write a Simple Go Application to work with CampaignMonitor Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to CampaignMonitor.
-
Use JayDeBeApi to access Mistral AI Data in Python
Use standard Python scripting and the development environment of your choice to access live Mistral AI.
-
Analyze FTP Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze FTP Servers with the CData JDBC Driver for FTP.
-
Integrate with Live Oracle Financials Cloud Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Oracle Financials Cloud from the MuleSoft Anypoint Platform to integrate live Oracle Financials Cloud into custom reports and dashboards.
-
Build Data Flows from OData to SQL Server using SSIS
Easily back up OData to SQL Server using the SSIS components for OData.
-
Connect to SingleStore Data in Ruby
Connect to SingleStore in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to load Dynamics NAV data into Elasticsearch via Logstash
Introducing a simple method to load Dynamics NAV data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to connect PolyBase to EnterpriseDB
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live EnterpriseDB.
-
Getting Started with the CData ODBC Driver for ScrapingBee
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for ScrapingBee.
-
Connect to Chargebee Data in Aqua Data Studio
Access Chargebee from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Postmark Data in DBArtisan
Use wizards in DBArtisan to configure Postmark as a data source.
-
Object-Relational Mapping (ORM) with Mailgun 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 Mailgun into a Java-based ORM framework, Hibernate.
-
Getting Started with the CData SSIS Components for Invoiced
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Invoiced.
-
Working with Google Cloud Storage Data in LINQPad
Execute LINQ queries to Google Cloud Storage in LINQPad.
-
Visualize EmailOctopus Data in Sisense
Create an ElastiCube in Sisense app with access to EmailOctopus.
-
Deploy the ADO.NET Provider for Marketo on an SSRS Report Server
Connect to Marketo 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.
-
Migrating data from Snowflake to Databricks using CData SSIS Components.
Easily push Snowflake to Databricks using the CData SSIS Tasks for Snowflake and Databricks.
-
Analyze Google Translate Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Google Translate from Power Pivot. You will use the Table Import Wizard to load Google Translate. You can visually build the import query or use any SQL supported by the driver.
-
Connect to AdRoll Data in Aqua Data Studio
Access AdRoll from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
LINQ to Rebilly 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 Rebilly Data Provider.