CData Software - Knowledge Base
Recent Articles
-
Integrate RSS Feeds in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live RSS Feeds from Informatica Cloud.
-
Build a Singer.io Tap for QuickBooks With the CData Python Connector
Learn how to easily build a Singer.io Tap for live QuickBooks data using
-
Analyze SAP Ariba Procurement Data in Looker
Use CData Connect AI to connect to SAP Ariba Procurement Data from Looker and build custom apps using live SAP Ariba Procurement.
-
Prepare, Blend, and Analyze GitLab Data in Alteryx Designer (Connect AI)
Build workflows to access live GitLab for self-service data analytics.
-
Getting Started with the CData ODBC Driver for Wave Financial
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Wave Financial.
-
Access Live YouTube Analytics Data in AWS Lambda (with IntelliJ IDEA)
Connect to live YouTube Analytics in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Publish Reports with Tickspot Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Tickspot.
-
Act CRM Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Act CRM through CData Connect AI using different applications and tools.
-
Access Live JSON Services in Coginiti Pro
Connect to and query live JSON from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrating CloudConvert Data in Talend Cloud Data Management Platform
Connect CloudConvert Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Build MVC Applications with Connectivity to Google Tasks Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Google Tasks from an ASP.NET MVC application.
-
DataBind Controls to SAP Concur Data in Delphi
DataBind to SAP Concur in Delphi with standard data access components and controls.
-
Getting Started with the CData Excel Add-In for Qualaroo
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Qualaroo.
-
Use the CData ODBC Driver for PolarTeamPro from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for PolarTeamPro to connect to PolarTeamPro from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring PolarTeamPro in Excel.
-
Use the CData ODBC Driver for Scrapfly from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Scrapfly to connect to Scrapfly from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Scrapfly in Excel.
-
Replicate Multiple LionDesk Accounts via the CData Sync CLI
Replicate multiple LionDesk accounts to one or many databases.
-
Connect to Oracle SCM from a Connection Pool in WebLogic
Use the CData JDBC Driver for Oracle SCM to connect to Oracle SCM from Web applications running on WebLogic.
-
Access MYOB AccountRight Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access MYOB AccountRight from your Oracle system.
-
Publish Harvest-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Harvest.
-
Connect to Raisers Edge NXT Data in Ruby
Connect to Raisers Edge NXT in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Natively Connect to SendPulse Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to SendPulse. Leverage the native support for ODBC in PHP.
-
How to update Microsoft Dataverse from Excel
This article explains how to transfer data from Excel to Microsoft Dataverse using the Excel Add-In for Microsoft Dataverse.
-
Getting Started with the CData Power BI Connector for Twilio
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Twilio.
-
Automated Continuous iContact Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable iContact replication to Google BigQuery.
-
Connect to Typeform from a Connection Pool in WebLogic
Use the CData JDBC Driver for Typeform to connect to Typeform from Web applications running on WebLogic.
-
Write a Simple Go Application to work with Klipfolio Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Klipfolio.
-
Provide OData Services of Azure Data Catalog Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Azure Data Catalog by developing a WCF Service Application.
-
Visualize Parquet Data in Sisense
Create an ElastiCube in Sisense app with access to Apache Parquet.
-
Create a Data Access Object for BenchmarkEmail Data using JDBI
A brief overview of creating a SQL Object API for BenchmarkEmail in JDBI.
-
Build QuickBooks-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live QuickBooks Desktop.
-
Connect to Adobe Target Data in DBArtisan
Use wizards in DBArtisan to configure Adobe Target as a data source.
-
Use CData Connect AI to Access Airtable Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Airtable in the Power Pivot business intelligence tool.
-
Build an OLAP Cube in SSAS from Oracle Eloqua Data
Establish a connection to Oracle Eloqua data from SQL Server Analysis Services, and use the Oracle Eloqua Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous Shortcut Replication to SQL Server
Use CData Sync for automated, continuous, customizable Shortcut replication to SQL Server.
-
Enable the eBay JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with eBay.
-
Integrate Open WebUI with Live Microsoft Entra ID Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Microsoft Entra ID from within the chat interface.
-
How to Connect to Live Workday Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Workday securely in real time.
-
Establish a Live Connection with Strava Data using Tableau Bridge
The CData ODBC Driver for Strava enables you to integrate live Strava into Tableau Cloud dashboards using the Tableau Bridge.
-
Use Microsoft Copilot Studio to talk to your JSON Services 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 JSON for you.
-
Getting Started with the CData Excel Add-In for Amazon S3
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Amazon S3.
-
Automated Continuous Acumatica Replication to Snowflake
Use CData Sync for automated, continuous, customizable Acumatica replication to Snowflake.
-
Model Redshift Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Redshift, enabling the direct import of real-time Amazon Redshift.
-
Create Reports from Okta Data in Looker Studio
Use CData Connect AI to gain access to live Okta and create custom reports in Looker Studio.
-
Access Live Spark Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Apache Spark SQL in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Access Live AfterShip Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate AfterShip into the statistical analysis tools available in SAS JMP. This article shows how to use AfterShip in the Graph Builder and Query Builder.
-
Rapidly Develop Flowlu-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 Flowlu.
-
A PostgreSQL Interface for PabblySubscriptions Data (MySQL Remoting via JDBC)
Use the Remoting features of the PabblySubscriptions JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Kiro CLI with Keap 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 with Testmonitor Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Testmonitor to a JSON file on disk.
-
Use JayDeBeApi to access SharePoint Data in Python
Use standard Python scripting and the development environment of your choice to access live Microsoft SharePoint.
-
How to work with SharePoint Data in Apache Spark using SQL
Access and process SharePoint Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to SAP ByDesign 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 SAP Business ByDesign.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live CockroachDB within intelligent workflows.
-
Integrating Antigravity CLI with Paylocity via CData CLI
Connect Paylocity to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Retently Reporting in OBIEE with the Retently JDBC Driver
Deploy the Retently JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for CouchDB
Provide connectivity to Apache CouchDB through an SAP BusinessObjects universe.
-
Manage Aircall Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Aircall.
-
Visualize Beeminder Data in TIBCO Spotfire through ADO.NET
Integrate Beeminder into dashboards in TIBCO Spotfire.
-
Operational Reporting on Okta Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Okta.
-
Build a Singer.io Tap for Datadog With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Datadog data using
-
How to Query Nuclia Data in MySQL Workbench
Execute MySQL queries against live Nuclia from MySQL Workbench.
-
Build Data Flows from NetSuite to SQL Server using SSIS
Easily back up NetSuite CRM & ERP to SQL Server using the SSIS components for NetSuite.
-
Natively Connect to Datadog Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Datadog. Leverage the native support for ODBC in PHP.
-
Build MVC Applications with Connectivity to BambooHR Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access BambooHR from an ASP.NET MVC application.
-
Integrating GitHub Copilot CLI with Azure Data Lake Storage 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.
-
Query Azure Synapse Data in ColdFusion
Write standard ColdFusion data access code to connect to Azure Synapse.
-
How to Access Live Xero Data in Visual Studio Code via Cline
Run CData MCP Server for Xero on Windows Subsytem for Linux (WSL) and connect to live Xero Accounting from the Cline extension in Visual Studio Code.
-
Use the CData Software JDBC Driver for Cohere in MicroStrategy Desktop
Connect to Cohere in MicroStrategy Desktop using the CData Software JDBC Driver for Cohere.
-
Choosing the Best Method to Connect Optimizely to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Optimizely from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrate Zoho CRM Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Zoho CRM and integrate live Zoho CRM into your Power Automate tasks.
-
How to load Anaplan data into Elasticsearch via Logstash
Introducing a simple method to load Anaplan data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use Biml to Build SSIS Tasks to Replicate Clio Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Clio to SQL Server.
-
Back Up Splunk to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Splunk. In this article, we will employ an SSIS workflow to populate a database with Splunk data.
-
Consume REST OData Feeds in PowerBuilder
This article demonstrates how to consume REST as OData feeds from PowerBuilder using the API Server.
-
Connect to Microsoft Ads Data in RapidMiner
Integrate Microsoft Ads with standard components and data source configuration wizards in RapidMiner Studio.
-
Build Dashboards with Azure Data Lake Storage Data in DBxtra
Create dynamic dashboards and perform analytics based on Azure Data Lake Storage in DBxtra.
-
How to connect SharePoint with Impala Data through external lists
Provide Apache Impala to SharePoint users as an external list.
-
Process & Analyze REST Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live REST Data.
-
Getting Started with the CData Excel Add-In for Strava
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Strava.
-
Build Data Flows from SFTP to SQL Server using SSIS
Easily back up SFTP to SQL Server using the SSIS components for SFTP.
-
Analyze Salesforce Pardot Data in Cognos Analytics
Use CData Connect AI to connect to Salesforce Pardot Data from Cognos Analytics and analyze live Salesforce Pardot.
-
Access Live Beeminder Data in AWS Lambda
Connect to live Beeminder in AWS Lambda using the CData JDBC Driver.
-
Load Microsoft OneDrive Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Microsoft OneDrive to a database.
-
Visualize Sage Cloud Accounting Data in TIBCO Spotfire through OData
Integrate Sage Business Cloud Accounting into dashboards in TIBCO Spotfire.
-
Connect SparkPost to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SparkPost with IBM WebSphere for seamless data integration and connectivity.
-
Explore Geographical Relationships in SendInBlue Data with Power Map
Create data visualizations with SendInBlue in Power Map.
-
Rapidly Develop Cohere-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 Cohere.
-
Import Real-Time Oracle Sales Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Oracle Sales in ColdFusion.
-
Explore Geographical Relationships in Supabase Data with Power Map
Create data visualizations with Supabase in Power Map.
-
Natively Connect to MailChimp Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to MailChimp. Leverage the native support for ODBC in PHP.
-
Integrating OpenCode Terminal with Microsoft Dataverse 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 Live Sugar CRM Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Sugar CRM securely in real time.
-
Replicate Multiple Authorize.Net Accounts via the CData Sync CLI
Replicate multiple Authorize.Net accounts to one or many databases.
-
Use the CData Software ODBC Driver for SAS xpt in MicroStrategy Desktop
Connect to SAS XPORT in MicroStrategy Desktop using the CData Software ODBC Driver for SAS xpt.
-
Replicate Multiple Facebook Ads Accounts via the CData Sync CLI
Replicate multiple Facebook Ads accounts to one or many databases.
-
DataBind Controls to Moosend Data in C++Builder
DataBind to Moosend in C++Builder with standard components and controls.
-
Edit and Search Microsoft Teams External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Microsoft Teams to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Microsoft Teams objects that you can access from apps and the dashboard.
-
Integrate Odoo Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Odoo ERP from Informatica Cloud.
-
Analyze Microsoft Planner Data in Looker
Use CData Connect AI to connect to Microsoft Planner Data from Looker and build custom apps using live Microsoft Planner.
-
Enable the Odoo JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Odoo ERP.