CData Software - Knowledge Base
Recent Articles
-
Integrating MongoDB Data in Talend Cloud Data Management Platform
Connect MongoDB Data with Talend Cloud Data Management Platform using the CData JDBC Driver for MongoDB.
-
Work with Live Highrise Data in Power Query
Use CData Connect AI to connect to Highrise CRM and work with live Highrise CRM in Microsoft Power Query.
-
Getting Started with the CData Power BI Connector for Salesforce
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Salesforce.
-
Connect to SAP Netweaver Gateway Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live SAP Netweaver Gateway.
-
Build AI/ML Models with Live SAP Concur Data using Dataiku
Connect SAP Concur Data with Dataiku using the CData JDBC Driver for SAP Concur.
-
Integrating OpenCode Terminal with Postmark 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.
-
Connect to Instantly from a Connection Pool in WebLogic
Use the CData JDBC Driver for Instantly to connect to Instantly from Web applications running on WebLogic.
-
Use Grok to Talk to Your SAP BusinessObjects BI Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your SAP BusinessObjects BI for you.
-
How to Connect DBeaver to SAS Data Sets via a JDBC Driver
Manage SAS Data Sets with visual tools in DBeaver like the query browser.
-
Connect Exa to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Exa using the CData Python MCP Server.
-
Write a Simple Go Application to work with Google Spanner Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Google Spanner.
-
LINQ to SAP Concur 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 SAP Concur Data Provider.
-
Automated Continuous Drift Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Drift replication to IBM DB2.
-
Automated Continuous Clockify Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Clockify replication to Azure SQL Database.
-
Build Google Analytics-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Google Analytics to explore live Google Analytics Data in Claude Code to assist with building Google Analytics-powered applications.
-
Replicate GraphQL Data to Multiple Databases via the CData Sync CLI
Replicate GraphQL to disparate databases with a single configuration.
-
Integrating Claude Code CLI with CampaignMonitor 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.
-
Access Microsoft Teams Data from MySQL in Amazon QuickSight
Connect to Microsoft Teams and build visualizations of Microsoft Teams using a MySQL Connection in Amazon QuickSight.
-
Getting Started with the CData Connect AI Python SDK for Presto
Install the CData Connect AI Python SDK to read and write live Presto with standard DB-API 2.0 Python code.
-
Build Power BI XMLA-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Power BI XMLA Data from Zoho Analytics and import live Power BI XMLA.
-
Automated Continuous SharePoint Excel Services Replication to IBM DB2
Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to IBM DB2.
-
Automate Drip Data Replication to Couchbase
Use CData Sync to Customize and automate Drip replication to Couchbase.
-
How to Connect to Live GitLab Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your GitLab for you.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Redshift actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Edit and Search DocuSign External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of DocuSign to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create DocuSign objects that you can access from apps and the dashboard.
-
Create Datasets from Calendly in Domo Workbench and Build Visualizations of Calendly Data in Domo
Use the CData Software ODBC Driver for Calendly to create datasets from Calendly in Domo Workbench and then build visualizations in the Domo service.
-
Build Data Flows from Basecamp to SQL Server using SSIS
Easily back up Basecamp to SQL Server using the SSIS components for Basecamp.
-
Email Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Email facts in real time.
-
Connect and Visualize Live Azure Data Lake Storage Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Azure Data Lake Storage into the Databricks platform and create visualization dashboards with real-time Azure Data Lake Storage.
-
Connect to Google Directory Data from AWS Glue
Use CData Connect AI to gain access to live Google Directory from your AWS Glue jobs.
-
How to Query Live Reckon Accounts Hosted Data in Claude Desktop
Connect to and query live Reckon Accounts Hosted Data in Claude Desktop using CData MCP Server.
-
Analyze Dynamics 365 Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Microsoft Dynamics 365 and visualize Microsoft Dynamics 365 in SAP Analytics Cloud.
-
Integrate Live Square Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Square to Blue Prism using the CData ODBC Driver for Square to create automated workflows for repetitive business tasks.
-
Create Power BI Reports on Real-Time Google Sheets Data
Use the CData ODBC Driver for Google Sheets to visualize Google Sheets in Power BI Desktop.
-
Migrating data from Google Ads to Databricks using CData SSIS Components.
Easily push Google Ads to Databricks using the CData SSIS Tasks for Google Ads and Databricks.
-
Replicate Multiple Intercom Accounts via the CData Sync CLI
Replicate multiple Intercom accounts to one or many databases.
-
How to import Nuclia Data into Apache Solr
Use the CData Software JDBC Driver for Nuclia in Data Import Handler and create an automated import of Nuclia to Apache Solr Enterprise Search platform.
-
LINQ to Factorial 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 Factorial Data Provider.
-
Design BIRT Reports on Pinecone Data
Provide current Pinecone to your embedded analytics.
-
Build an OLAP Cube in SSAS from AfterShip Data
Establish a connection to AfterShip data from SQL Server Analysis Services, and use the AfterShip Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous LeadDesk Replication to SQL Server
Use CData Sync for automated, continuous, customizable LeadDesk replication to SQL Server.
-
Create Apps from Microsoft OneDrive Data in Qlik Sense Cloud
Use CData Connect AI to connect to Microsoft OneDrive Data and build apps from live Microsoft OneDrive in Qlik Sense Cloud.
-
Moving Data from Salesforce Data 360 to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Salesforce Data 360 data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Visualize Cosmos DB Data in Tableau
The CData ODBC driver for Cosmos DB enables you integrate Azure Cosmos DB into Tableau dashboards.
-
How to publish and share Datadog Data dashboards with Tableau Server
The CData ODBC driver for Datadog enables you integrate Datadog into Tableau dashboards.
-
Automated Continuous Kintone Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Kintone replication to Amazon S3.
-
How to Work with Lakebase Data in ETL Validator JDBC
Connect to Lakebase from ETL Validator jobs using the CData Software JDBC Driver.
-
FreshBooks Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on FreshBooks facts in real time.
-
Build Data Flows from Front to SQL Server using SSIS
Easily back up Front to SQL Server using the SSIS components for Front.
-
Prepare, Blend, and Analyze SAP HANA Data in Alteryx Designer (Connect AI)
Build workflows to access live SAP HANA for self-service data analytics.
-
Getting Started with the CData Connect AI Python SDK for Microsoft Teams
Install the CData Connect AI Python SDK to read and write live Microsoft Teams with standard DB-API 2.0 Python code.
-
Automated Continuous Dynamics CRM Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Dynamics CRM replication to Amazon Redshift.
-
Connect to Nuclia Data in RazorSQL
Connect to Nuclia from wizards and query Nuclia from the GUI in the RazorSQL database management tool.
-
Connect to Samanage Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Samanage.
-
Connect to Anaplan Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Anaplan to connect to Anaplan and execute queries in PowerBuilder.
-
Build a PostgreSQL Interface for SAP Hybris C4C Data using the CData JDBC Driver
Use the Remoting features of the SAP Hybris C4C JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Query Helpscout Data in MySQL Workbench
Execute MySQL queries against live Helpscout from MySQL Workbench.
-
Work with Excel Online Data in FoxPro
Load Microsoft Excel Online into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Shortcut Data in RapidMiner
Integrate Shortcut with standard components and data source configuration wizards in RapidMiner Studio.
-
Process & Analyze Microsoft Dataverse Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Microsoft Dataverse Data.
-
Build Visualizations of Oracle SCM Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Oracle SCM in Birst.
-
Integrate Real-Time Access to Google Cloud Storage in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Google Cloud Storage in real time.
-
Connect to Missive Data in Ruby
Connect to Missive in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Create Reports with AlloyDB Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google AlloyDB.
-
Getting Started with the CData SSIS Components for YouTube Analytics
Complete guide to installing, licensing, and connecting with the CData SSIS Components for YouTube Analytics.
-
Use the CData Software ODBC Driver for ChargeOver in SAS for Real-Time Reporting and Analytics
Connect to real-time ChargeOver in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ChargeOver.
-
Connect to Hacker News from a Connection Pool in WebLogic
Use the CData JDBC Driver for Hacker News to connect to Hacker News from Web applications running on WebLogic.
-
How to connect and process CircleCI from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live CircleCI.
-
Automated Continuous Dynamics 365 Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Dynamics 365 replication to Apache Kafka.
-
How to Connect to & Open Databricks Data in Microsoft Excel
This article uses the CData ODBC driver for Databricks to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Dashboards with Intercom Data in Dundas BI
Create dynamic dashboards and perform analytics based on Intercom in Dundas BI.
-
Automated Continuous Parquet Replication to Vertica
Use CData Sync for automated, continuous, customizable Parquet replication to Vertica.
-
Integrate Real-Time Access to Cassandra in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Apache Cassandra in real time.
-
Configure the CData JDBC Driver for SAP ByDesign in a Connection Pool in Tomcat
Connect to SAP Business ByDesign from a connection pool in Tomcat.
-
Visualize MarkLogic Data in Tableau
The CData ODBC driver for MarkLogic enables you integrate MarkLogic into Tableau dashboards.
-
Perform Batch Operations with MarkLogic Data in Apache NiFi
Connect to MarkLogic and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Connect to Pushbullet Data in DBeaver
Use the CData ODBC Driver to connect to Pushbullet in DBeaver.
-
Integrating Acumatica Data in Talend Cloud Data Management Platform
Connect Acumatica Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Acumatica.
-
How to Create Power BI Visual Reports with Real-Time Asana Data
Use CData Power BI Connectors to visualize Asana in Power BI.
-
Integrate Procore Data in Pentaho Data Integration
Build ETL pipelines based on Procore in the Pentaho Data Integration tool.
-
Enable the Epicor Kinetic JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Epicor Kinetic.
-
Access Cohere Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Cohere from HeidiSQL.
-
Use JayDeBeApi to access Shippo Data in Python
Use standard Python scripting and the development environment of your choice to access live Shippo.
-
Analyze Helpscout Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Helpscout with the CData JDBC Driver for Helpscout.
-
Connect to TaxJar Data in DBeaver
Use the CData ODBC Driver to connect to TaxJar in DBeaver.
-
Use JayDeBeApi to access PabblySubscriptions Data in Python
Use standard Python scripting and the development environment of your choice to access live PabblySubscriptions.
-
Bridge Vimeo Connectivity with Apache NiFi
Access and process Vimeo in Apache NiFi using the CData JDBC Driver.
-
Use the CData Software ODBC Driver for Deel in MicroStrategy
Connect to Deel in MicroStrategy Developer using the CData Software ODBC Driver for Deel.
-
Connect Intercom to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Intercom with IBM WebSphere for seamless data integration and connectivity.
-
Integrate Live Oracle SCM Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Oracle SCM and integrate live Oracle SCM into apps built in Microsoft Power Apps.
-
Provide OData Services of Foursquare Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Foursquare by developing a WCF Service Application.
-
Connect to Google Directory 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 Google Directory.
-
Import and Visualize OpenWeatherMap Data in Power View
Create data visualizations based on OpenWeatherMap in Excel.
-
Create Informatica Mappings From/To an ODBC Data Source for Sentry
Create an ODBC connection to Sentry in Informatica and browse and transfer Sentry.
-
Create SSAS Tabular Models from Invoiced Data
How to build a SQL Server Analysis Service Tabular Model from Invoiced using CData drivers.
-
Integrate Printify Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Printify from Informatica Cloud.
-
How to work with Helpscout Data in Apache Spark using SQL
Access and process Helpscout Data in Apache Spark using the CData Software JDBC Driver.
-
Integrate Mouseflow with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Mouseflow with External Services.
-
How to Connect the Power BI Service to Airtable: Complete Guide
Connect to the CData Software Power BI Connector for Airtable from PowerBI.com to provide real-time Airtable across the organization.
-
Publish Pinterest-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Pinterest.