CData Software - Knowledge Base
Recent Articles
-
How to connect and process Amplitude from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Amplitude.
-
Edit and Search External Azure Analysis Services Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Azure Analysis Services to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Azure Analysis Services Data objects that you can access from apps and the dashboard.
-
Replicate LDAP Objects in Heroku for Use in Salesforce Connect
Replicate LDAP to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Extend Google Sheets with Amazon DynamoDB Data
Make calls to Amazon DynamoDB from Google Apps Script via the API Server.
-
Seamlessly Bring MySQL Data into Retool Using CData Connect AI
Integrate MySQL data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Automate Google Campaign Manager 360 Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Google Campaign Manager 360 from PowerShell? This article demonstrates how to utilize the Google Campaign Manager 360 Cmdlets for tasks like connecting to Google Campaign Manager 360, automating operations, downloading data, and more.
-
A PostgreSQL Interface for Guru Data (MySQL Remoting via JDBC)
Use the Remoting features of the Guru JDBC Driver to create a PostgreSQL entry-point for data access.
-
Import Box Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Box. In this article, you will use the OData format to import Box into Microsoft Power Query.
-
Analyze Google Ads Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Google Ads in Microsoft R Open.
-
How to publish and share Google Search Results dashboards with Tableau Server
The CData ODBC driver for Google Search enables you integrate Google Search into Tableau dashboards.
-
Salesloft Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Salesloft facts in real time.
-
Automated Optimizely Data Replication to Teradata
Use CData Sync to Customize and automate Optimizely replication to Teradata.
-
Replicate ZohoMarketingHub Data to Multiple Databases
Replicate ZohoMarketingHub to disparate databases with a point-and-click configuration.
-
Automated Continuous Freshdesk Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Freshdesk replication to delimited files (CSV/TSV).
-
LINQ to Mode 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 Mode Data Provider.
-
Connect to SAP Hybris C4C Data from a Connection Pool in JBoss
Integrate SAP Hybris C4C into Java servlets: Use the Management Console in JBoss to install the SAP Hybris C4C JDBC Driver.
-
Load ChartMogul Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load ChartMogul to a database.
-
Use the CData Software JDBC Driver for Azure Synapse in MicroStrategy Desktop
Connect to Azure Synapse in MicroStrategy Desktop using the CData Software JDBC Driver for Azure Synapse.
-
Build Dashboards with Zuora Data in Dundas BI
Create dynamic dashboards and perform analytics based on Zuora in Dundas BI.
-
Connecting Moonlit Workflow with SAP Fieldglass Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your SAP Fieldglass in real time.
-
Publish Reports with Freshdesk Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Freshdesk.
-
Access Couchbase Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Couchbase from HeidiSQL.
-
Visualize Notion Data in Sisense
Create an ElastiCube in Sisense app with access to Notion.
-
Connect to LinkedIn Ads Data in DBeaver
Use the CData ODBC Driver to connect to LinkedIn Ads in DBeaver.
-
Use the CData SSIS Components to Insert New or Update Existing Bullhorn CRM Records from SQL Server
Easily push SQL Server data to Bullhorn CRM using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Bullhorn CRM or update existing records with data from a SQL Server database.
-
Replicate Multiple IBM Cloud Object Storage Accounts via the CData Sync CLI
Replicate multiple IBM Cloud Object Storage accounts to one or many databases.
-
Building Dynamic Web Pages with Blackbaud FE NXT Data Using AngularJS
Create single-page applications with live connectivity to Blackbaud FE NXT using the CData API Server.
-
Integrating LangChain with Bullhorn CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Bullhorn CRM within automated workflows.
-
Feed Opsgenie Data into FineReport
How to set Opsgenie as a JDBC data source in FineReport.
-
Use Dash to Build to Web Apps on Parquet Data
Create Python applications that use pandas and Dash to build Parquet-connected web apps.
-
Getting Started with the CData JDBC Driver for Dotmailer
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Dotmailer.
-
Use Azure AI Foundry to Talk to Your Square 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 Square for you.
-
Access Live Cloudflare Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Cloudflare in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connecting Agentforce with Oracle SCM Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Oracle SCM for you.
-
Build Data Flows from Contentful to SQL Server using SSIS
Easily back up Contentful to SQL Server using the SSIS components for Contentful.
-
Connect to Aweber Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Aweber and the SQL Gateway to access Aweber from Google Apps Script.
-
How to import Placid Data into Apache Solr
Use the CData Software JDBC Driver for Placid in Data Import Handler and create an automated import of Placid to Apache Solr Enterprise Search platform.
-
How to Build an ETL App for HubSpot Data in Python with CData
Create ETL applications and real-time data pipelines for HubSpot in Python with petl.
-
YouTube Analytics Reporting in OBIEE with the YouTube Analytics JDBC Driver
Deploy the YouTube Analytics JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Visualize Float Data in Sisense
Create an ElastiCube in Sisense app with access to Float.
-
Use the CData Software ODBC Driver for SAS Data Sets in SAS for Real-Time Reporting and Analytics
Connect to real-time SAS Data Sets in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SAS Data Sets.
-
Mouseflow Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Mouseflow facts in real time.
-
Consume Microsoft Ads OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Microsoft Ads feeds that reflect any changes in SAP Lumira.
-
Choosing the Best Method to Connect ElevenLabs to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ElevenLabs from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
DataBind Charts to Productboard Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Productboard 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.
-
Query Live Oracle Financials Cloud Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Oracle Financials Cloud directly from the development environment.
-
How to connect and process Chargebee from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Chargebee.
-
Create Zoho Books Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Zoho Books data access from reports, embedded analytics, and more.
-
Provide OData Services of Dynamics 365 Business Central Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Dynamics 365 Business Central by developing a WCF Service Application.
-
Integrating LangChain with Snowflake Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Snowflake within automated workflows.
-
LINQ to Invoiced 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 Invoiced Data Provider.
-
Getting Started with the CData ODBC Driver for SQL Server
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SQL Server.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Mocean
Provide connectivity to Mocean through an SAP BusinessObjects universe.
-
How to Connect the Power BI Service to REST: Complete Guide
Connect to the CData Software Power BI Connector for REST from PowerBI.com to provide real-time REST across the organization.
-
Build Semantic Layer Views for Accelo Data in APOS Live Data Gateway
Use the CData Connector for Accelo in APOS Live Data Gateway to build Semantic Layer Views for Accelo.
-
Publish Crystal Reports on Microsoft Ads Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Microsoft Ads.
-
Connect to Qualaroo Data in RapidMiner
Integrate Qualaroo with standard components and data source configuration wizards in RapidMiner Studio.
-
Extract, Transform, and Load PostgreSQL Data in Informatica PowerCenter
Create a simple Workflow for PostgreSQL in Informatica PowerCenter.
-
Connect to and Visualize Live Mistral AI Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Mistral AI.
-
Access Raisers Edge NXT Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Raisers Edge NXT from your Oracle system.
-
Build Automated Workflows with Live Presto Data in Workato
Use CData Connect AI to connect to live Presto and build automated workflows in Workato.
-
Access Live Stack Exchange Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Stack Exchange into the statistical analysis tools available in SAS JMP. This article shows how to use Stack Exchange in the Graph Builder and Query Builder.
-
Query Delighted Data in ColdFusion
Write standard ColdFusion data access code to connect to Delighted.
-
Integrating Claude Code CLI with CSV 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 load ConvertKit data into Elasticsearch via Logstash
Introducing a simple method to load ConvertKit data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Use a Microsoft Access Database to Update Certinia Data in Real Time
Update Certinia data by creating a linked table in Microsoft Access with the CData Certinia ODBC Driver.
-
Natively Connect to Oracle SCM Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Oracle SCM. Leverage the native support for ODBC in PHP.
-
How to Work with Cloudflare Data in ETL Validator JDBC
Connect to Cloudflare from ETL Validator jobs using the CData Software JDBC Driver.
-
How to import Pushbullet Data into Apache Solr
Use the CData Software JDBC Driver for Pushbullet in Data Import Handler and create an automated import of Pushbullet to Apache Solr Enterprise Search platform.
-
Migrating data from Suadeo to Google BigQuery using CData SSIS Components.
Easily push Suadeo to Google BigQuery using the CData SSIS Tasks for Suadeo and Google BigQuery.
-
Integrate Planio with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Planio with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Planio.
-
Getting Started with the CData ODBC Driver for Lakebase
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Lakebase.
-
Connect to and Query Azure Analysis Services Data in QlikView over ODBC
Create data visualizations with Azure Analysis Services in QlikView.
-
View Reports on Real-Time Workday Data in Power BI Report Server
Use the CData ODBC Driver for Workday to visualize Workday in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Seamlessly Import Jira Data into IBM SPSS Modeler
Integrate Jira data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Visualize Live Autopilot Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Autopilot using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Import Real-Time CircleCI Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use CircleCI in ColdFusion.
-
Connect to Sentry from Asprova with CData Software ODBC Driver for Sentry
This article shows how to connect faster to Sentry data from Asprova.
-
How to Work with Attio Data in ETL Validator JDBC
Connect to Attio from ETL Validator jobs using the CData Software JDBC Driver.
-
Use Dash to Build Web Apps on Facebook Data via CData Connect AI
Build interactive Dash web apps on live Facebook using pandas and the CData Connect AI Python SDK.
-
Design BIRT Reports on EnterpriseDB Data
Provide current EnterpriseDB to your embedded analytics.
-
Build a PostgreSQL Interface for Google Forms Data using the CData JDBC Driver
Use the Remoting features of the Google Forms JDBC Driver to create a PostgreSQL entry-point for data access.
-
Publish Wistia-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Wistia.
-
Build AI/ML Models with Live Todoist Data using Dataiku
Connect Todoist Data with Dataiku using the CData API Driver for JDBC.
-
Manage Amazon Marketplace Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Amazon Marketplace.
-
Provide OData Services of Outlook Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Outlook by developing a WCF Service Application.
-
Natively Connect to Excel Online Data in PHP
The CData ODBC driver for Excel Online enables you to create PHP applications with connectivity to Microsoft Excel Online. Leverage the native support for ODBC in PHP.
-
Automated Continuous SharePoint Replication to IBM DB2
Use CData Sync for automated, continuous, customizable SharePoint replication to IBM DB2.
-
Connect to Omnisend Data from PowerBuilder via ADO.NET
This article demonstrates how to access Omnisend from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to Work with Vimeo Data in ETL Validator JDBC
Connect to Vimeo from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Work with Onfleet Data in ETL Validator JDBC
Connect to Onfleet from ETL Validator jobs using the CData Software JDBC Driver.
-
Use Databricks Agent Bricks to Talk to Your SAP ByDesign Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your SAP Business ByDesign for you.
-
How to Access Live Monday.com Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Monday.com enables you to integrate Monday.com into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous Dynamics 365 Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Dynamics 365 replication to IBM DB2.
-
Query Stack Exchange Data as a MySQL Database in Node.js
Execute MySQL queries against Stack Exchange from Node.js.
-
Build FTP-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for FTP Data and create custom apps in Bubble.
-
Automated Continuous CapsuleCRM Replication to Amazon S3
Use CData Sync for automated, continuous, customizable CapsuleCRM replication to Amazon S3.
-
Connect to Pipeline CRM Data from a Connection Pool in JBoss
Integrate Pipeline CRM into Java servlets: Use the Management Console in JBoss to install the Pipeline CRM JDBC Driver.
-
Build a Simple VCL Application for Productboard Data
How to build a simple VCL Application to view Productboard in RAD Studio using the CData ODBC Driver for Productboard.
-
Provide OData Services of Salesforce CRM Analytics Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Salesforce CRM Analytics by developing a WCF Service Application.