CData Software - Knowledge Base
Recent Articles
-
Analyze Bitbucket Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Bitbucket and visualize live Bitbucket in Infragistics Reveal.
-
Access Live Aweber Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Aweber in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate Real-Time Access to Raisers Edge NXT in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Raisers Edge NXT in real time.
-
Publish Crystal Reports on Bitly Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Bitly.
-
Build SQL Analysis Services-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for SQL Analysis Services Data and create custom apps in Bubble.
-
Automate ZohoInvoice Data Replication to Azure Synapse
Use CData Sync to customize and automate ZohoInvoice replication to Azure Synapse.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for iContact
Provide connectivity to iContact through an SAP BusinessObjects universe.
-
Automated Continuous CouchDB Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable CouchDB replication to PostgreSQL.
-
Integrate SAP Hybris C4C with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SAP Hybris C4C with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SAP Hybris C4C.
-
Publish Crystal Reports on MarkLogic Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date MarkLogic.
-
Use the CData Software JDBC Driver for HubDB in MicroStrategy
Connect to HubDB in MicroStrategy Developer using the CData Software JDBC Driver for HubDB.
-
Integrate iContact with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate iContact with External Services.
-
Automated Continuous Teradata Replication to Databricks
Use CData Sync for automated, continuous, customizable Teradata replication to Databricks.
-
Build SAP Hybris C4C-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for SAP Hybris C4C Data and create custom apps in Bubble.
-
Query PDFMonkey Data in ColdFusion
Write standard ColdFusion data access code to connect to PDFMonkey.
-
Build MVC Applications with Connectivity to Sybase Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Sybase from an ASP.NET MVC application.
-
Integrate Basecamp Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Basecamp from Informatica Cloud.
-
Working with SAP Data in LINQPad
Execute LINQ queries to SAP ERP/NetWeaver in LINQPad.
-
Integrating Claude Code CLI with ChargeOver 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.
-
Extend Google Sheets with Impala Data
Make calls to Impala from Google Apps Script via the API Server.
-
Analyze Auth0 Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Auth0 with the CData JDBC Driver for Auth0.
-
Integrate with eBay Analytics Data in JReport Designer
Create charts and reports based on eBay Analytics in JReport Designer.
-
Automated Continuous Trello Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Trello replication to OneLake in Microsoft Fabric.
-
Automated Continuous Recurly Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Recurly replication to AlloyDB.
-
Automated Continuous SAS xpt Replication to Amazon S3
Use CData Sync for automated, continuous, customizable SAS xpt replication to Amazon S3.
-
Automated Continuous Apify Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Apify replication to Google Cloud SQL.
-
Use the CData Software JDBC Driver for Microsoft Teams in MicroStrategy Web
Connect to Microsoft Teams in MicroStrategy Web using the CData Software JDBC Driver for Microsoft Teams.
-
Use the CData ODBC Driver for Aha! from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Aha! to connect to Aha! from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Aha! in Excel.
-
How to Query Live AdRoll Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live AdRoll data in natural language using Python.
-
Integrate with PostgreSQL Data in SnapLogic
Use CData Connect AI to connect to and integrate with live PostgreSQL in SnapLogic.
-
Replicate Quickbase Data from PowerShell
Write a quick PowerShell script to query Quickbase. Use connectivity to the live data to replicate Quickbase to SQL Server.
-
Getting Started with the CData Power BI Connector for Salesforce CRM Analytics
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Salesforce CRM Analytics.
-
How to connect to Planio Data from Spring Boot
Connect to Planio in a Spring Boot Application using the CData API Driver for JDBC
-
Integrate Cline with Live Databricks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Databricks from within your IDE.
-
LionDesk Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on LionDesk facts in real time.
-
Automated Continuous Authorize.Net Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Authorize.Net replication to Azure SQL Database.
-
How to Access Klaviyo Data Using Entity Framework
This article shows how to access Klaviyo using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Design BIRT Reports on Float Data
Provide current Float to your embedded analytics.
-
Automate Google Analytics Data Replication to Azure Data Lake
Use CData Sync to customize and automate Google Analytics replication to Azure Data Lake.
-
Connect to Live Salesforce Data in MicroStrategy through CData Connect AI
Create a live connection to Salesforce Data in CData Connect AI and connect to your Salesforce & Force.com from MicroStrategy.
-
Getting Started with the CData ODBC Driver for SAP Business Warehouse
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SAP Business Warehouse.
-
Create Dashboards and Visualize Live Amazon S3 Data in Geckoboard
Use CData Connect AI to connect to live Amazon S3 and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to Connect DBeaver to Mistral AI via a JDBC Driver
Manage Mistral AI with visual tools in DBeaver like the query browser.
-
Access FHIR Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live FHIR from HeidiSQL.
-
View Reports on Real-Time CapsuleCRM Data in Power BI Report Server
Use the CData ODBC Driver for CapsuleCRM to visualize CapsuleCRM in Power BI Desktop and then publish them to Power BI Report Server.
-
Getting Started with the CData JDBC Driver for Google Spanner
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Google Spanner.
-
Access Live Jira Assets Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Jira Assets in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automate Bullhorn CRM Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Bullhorn CRM and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Migrating data from Google Campaign Manager 360 to Google BigQuery using CData SSIS Components.
Easily push Google Campaign Manager 360 to Google BigQuery using the CData SSIS Tasks for Google Campaign Manager 360 and Google BigQuery.
-
Integrate with Dotmailer Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Dotmailer to a JSON file on disk.
-
Automate Blackbaud FE NXT Data Replication to Azure Synapse
Use CData Sync to customize and automate Blackbaud FE NXT replication to Azure Synapse.
-
Automated Continuous Retently Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Retently replication to IBM DB2.
-
How to Query Live Sybase IQ Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Sybase IQ data in natural language using Python.
-
Automated Continuous OnePageCrm Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable OnePageCrm replication to delimited files (CSV/TSV).
-
Automated Continuous SQL Server Replication to Vertica
Use CData Sync for automated, continuous, customizable SQL Server replication to Vertica.
-
Connect to and Query Elorus Data in QlikView over ODBC
Create data visualizations with Elorus in QlikView.
-
How to Connect DBeaver to ZohoSubscriptions via a JDBC Driver
Manage ZohoSubscriptions with visual tools in DBeaver like the query browser.
-
Build Data Flows from Datadog to SQL Server using SSIS
Easily back up Datadog to SQL Server using the SSIS components for Datadog.
-
Integrate SAP Business One with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SAP Business One with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SAP Business One.
-
Getting Started with the CData ODBC Driver for Salesforce Marketing
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Salesforce Marketing.
-
Connect to Cvent Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Cvent.
-
Use the CData Software ODBC Driver for Asana in MicroStrategy
Connect to Asana in MicroStrategy Developer using the CData Software ODBC Driver for Asana.
-
Visualize Live SAP Concur Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live SAP Concur into custom reports in Power BI.
-
Add HDFS Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for HDFS with the Informatica Enterprise Data Catalog to classify and organize data.
-
Back Up Microsoft Planner to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Microsoft Planner. In this article, we will employ an SSIS workflow to populate a database with Microsoft Planner data.
-
Automated Continuous MySQL Replication to AlloyDB
Use CData Sync for automated, continuous, customizable MySQL replication to AlloyDB.
-
How to Access Live JSON Services in Visual Studio Code via Cline
Run CData MCP Server for JSON on Windows Subsytem for Linux (WSL) and connect to live JSON from the Cline extension in Visual Studio Code.
-
Automate SharePoint Excel Services Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SharePoint Excel Services from PowerShell? This article demonstrates how to utilize the SharePoint Excel Services Cmdlets for tasks like connecting to SharePoint Excel Services, automating operations, downloading data, and more.
-
How to create an RPA flow for Timely Data in UiPath Studio
Use the Timely ODBC Driver to create workflows that access real-time Timely without any coding.
-
Integrating Cursor CLI with Suadeo 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.
-
Excel Spreadsheet Automation on Asana Data with the QUERY Formula
Pull data from Asana, automate spreadsheets, and more with the QUERY formula.
-
Automate SAS xpt Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SAS XPORT from PowerShell? This article demonstrates how to utilize the SAS xpt Cmdlets for tasks like connecting to SAS XPORT, automating operations, downloading data, and more.
-
Connect to MailChimp Data from a Connection Pool in Jetty
The MailChimp JDBC Driver supports connection pooling: This article shows how to connect faster to MailChimp from Web apps in Jetty.
-
Use the CData Software ODBC Driver for Sybase IQ in MicroStrategy Web
Connect to Sybase IQ in MicroStrategy Web using the CData Software ODBC Driver for Sybase IQ.
-
Access Live Cosmos DB Data in AWS Lambda
Connect to live Azure Cosmos DB in AWS Lambda using the CData JDBC Driver.
-
Connect to Gong Data in Ruby
Connect to Gong in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Replicate Azure Blob Storage Data to Multiple Databases
Replicate Azure Blob Storage to disparate databases with a point-and-click configuration.
-
Automated Continuous Float Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Float replication to Google BigQuery.
-
How to integrate Accelo with Apache Airflow
Access and process Accelo in Apache Airflow using the CData JDBC Driver.
-
Natively Connect to Campaigner Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Campaigner. Leverage the native support for ODBC in PHP.
-
Build a Simple VCL Application for Front Data
How to build a simple VCL Application to view Front in RAD Studio using the CData ODBC Driver for Front.
-
Working with Perplexity Data in LINQPad
Execute LINQ queries to Perplexity in LINQPad.
-
Use the CData ODBC Driver for Instantly in Microsoft Power Query
You can use the CData Instantly ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Instantly into Microsoft Power Query.
-
Publish Crystal Reports on PayPal Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date PayPal.
-
Connect to Coda Data in Aqua Data Studio
Access Coda from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Replicate Salesloft Data to Multiple Databases via the CData Sync CLI
Replicate Salesloft to disparate databases with a single configuration.
-
Create Dashboards and Visualize Live Klaviyo Data in Geckoboard
Use CData Connect AI to connect to live Klaviyo and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Automated Continuous Supabase Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Supabase replication to Apache Kafka.
-
Build HCL Domino-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to HCL Domino Data from Zoho Analytics and import live HCL Domino.
-
How to Access Live Exact Online Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Exact Online enables you to integrate Exact Online into workflows built using Microsoft Power Automate Desktop.
-
Analyze SharePoint Excel Services Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SharePoint Excel Services from Power Pivot. You will use the Table Import Wizard to load SharePoint Excel Services. You can visually build the import query or use any SQL supported by the driver.
-
How to Seamlessly Import PagerDuty Data into IBM SPSS Modeler
Integrate PagerDuty data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Create SSAS Tabular Models from Zendesk Data
How to build a SQL Server Analysis Service Tabular Model from Zendesk using CData drivers.
-
Use the CData ODBC Driver for SAP from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for SAP to connect to SAP ERP/NetWeaver from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SAP ERP/NetWeaver in Excel.
-
Deploy the ADO.NET Provider for Calendly on an SSRS Report Server
Connect to Calendly 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 Intercom Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Intercom in ColdFusion.
-
Automated Continuous Greenhouse Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Greenhouse replication to AlloyDB.
-
Operational Reporting on Avalara AvaTax Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Avalara AvaTax.
-
Connect to SAP SuccessFactors LMS Data in NetBeans
Connect to SAP SuccessFactors LMS in NetBeans with the data source configuration wizard.
-
Connect to CouchDB Data in HULFT Integrate
Connect to CouchDB as a JDBC data source in HULFT Integrate