CData Software - Knowledge Base
Recent Articles
-
Provide OData Services of Cosmos DB Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Cosmos DB data by developing a WCF Service Application.
-
Migrating data from Microsoft Exchange to Google BigQuery using CData SSIS Components.
Easily push Microsoft Exchange data to Google BigQuery using the CData SSIS Tasks for Microsoft Exchange and Google BigQuery.
-
Create Data Visualizations Based On Avro Data in Mode
Use CData Connect AI to connect to Avro Data from Mode and build visualizations using live Avro data.
-
Build Automated Workflows with Live DocuSign Data in Workato
Use CData Connect AI to connect to live DocuSign data and build automated workflows in Workato.
-
Integrate Quaderno Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Quaderno data from Informatica Cloud.
-
Integrate with live Mailjet Data in Jitterbit
Use CData Connect AI to connect to and integrate live Mailjet data in Jitterbit.
-
Create VWO-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to VWO Data from Klipfolio and build custom visualizations using live VWO data.
-
A PostgreSQL Interface for Azure Data Catalog Data using the CData ODBC Driver
Use the SQL Gateway and Azure Data Catalog ODBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Microsoft Teams Data in TIBCO Spotfire through ADO.NET
Integrate Microsoft Teams data into dashboards in TIBCO Spotfire.
-
Build Visualizations of Productboard Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Productboard data in Birst.
-
Connect to Tavily Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Tavily data from Filemaker Pro on Mac.
-
Automated Continuous MongoDB Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable MongoDB replication to Google BigQuery.
-
How to connect to Xero Data with Squirrel SQL client
Connect to Xero data and execute queries in the Squirrel SQL Client.
-
Deploy the ADO.NET Provider for CockroachDB on an SSRS Report Server
Connect to CockroachDB data 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.
-
Integrate Theia IDE with Live Confluence Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Confluence data from within the development environment.
-
Automated Continuous PhantomBuster Replication to SQLite
Use CData Sync for automated, continuous, customizable PhantomBuster replication to SQLite.
-
Integrating OpenCode with JobNimbus 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.
-
Load Neo4J Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Neo4J data to a database.
-
Getting Started with the CData Python Connector for Shortcut
Learn to install and license the CData Python Connector and configure a connection to live Shortcut data.
-
Excel Spreadsheet Automation on DocuSign Data with the QUERY Formula
Pull data from DocuSign, automate spreadsheets, and more with the QUERY formula.
-
Analyze Clockify Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Clockify data in Microsoft R Open.
-
Create Informatica Mappings From/To an ODBC Data Source for Microsoft Entra ID
Create an ODBC connection to Microsoft Entra ID in Informatica and browse and transfer Microsoft Entra ID data.
-
Prepare, Blend, and Analyze Timely Data in Alteryx Designer (ODBC)
Build workflows to access live Timely data for self-service data analytics.
-
How to connect to Act CRM Data from IntelliJ
Integrate connectivity to Act CRM data with wizards in IntelliJ.
-
MailerSend Reporting in OBIEE with the MailerSend JDBC Driver
Deploy the MailerSend JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build a PostgreSQL Interface for Shippo Data using the CData JDBC Driver
Use the Remoting features of the Shippo JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Automated Wistia-Connected Workflows in Zapier
Use CData Connect AI to connect to live Wistia data and build automated workflows in Zapier.
-
LINQ to Elasticsearch 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 Elasticsearch Data Provider.
-
Automate Pipeline CRM Data Replication to SAP HANA
Use CData Sync to customize and automate Pipeline CRM data replication to SAP HANA.
-
How to Connect DBeaver to PayPal via a JDBC Driver
Manage PayPal data with visual tools in DBeaver like the query browser.
-
Create Dynamic Salesforce Grids Using the Infragistics XamDataGrid
Learn how you can connect Salesforce to Infragistics XamDataGrid to build dynamic grids.
-
Access Live OData Services in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live OData services from your Excel spreadsheets.
-
Access Sage Cloud Accounting Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Sage Cloud Accounting data.
-
Automated Continuous Billsby Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Billsby replication to Azure SQL Database.
-
Design BIRT Reports on MarkLogic Data
Provide current MarkLogic data to your embedded analytics.
-
How to Connect to Live SAP BusinessObjects BI Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live SAP BusinessObjects BI data securely in real time.
-
Provide OData Services of YouTube Analytics Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for YouTube Analytics data by developing a WCF Service Application.
-
Integrating Claude Code CLI with Facebook Ads 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.
-
Visualize ZohoInvoice Data in Sisense
Create an ElastiCube in Sisense app with access to ZohoInvoice data.
-
Integrate Live CSV Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live CSV data to Blue Prism using the CData ODBC Driver for CSV to create automated workflows for repetitive business tasks.
-
Choosing the Best Method to Connect Zoho CRM to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Zoho CRM data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build Dashboards with Anaplan Data in Dundas BI
Create dynamic dashboards and perform analytics based on Anaplan data in Dundas BI.
-
Easily Integrate Twilio Data in Lazarus Pascal IDE
Learn how to easily integrate live Twilio data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Work with Live Act-On Data in Power Query
Use CData Connect AI to connect to Act-On data and work with live Act-On data in Microsoft Power Query.
-
Stream Chargebee Data into Apache Kafka Topics
Access and stream Chargebee data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to connect and process Gmail data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Gmail data.
-
Use the CData ODBC Driver for Google Cloud Storage in Microsoft Power Query
You can use the CData Google Cloud Storage ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Google Cloud Storage data into Microsoft Power Query.
-
How to Work with SAS Data Sets Data in AWS Glue Jobs Using JDBC
Connect to SAS Data Sets from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Use Microsoft Copilot Studio to talk to your Bitly Data 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 Bitly data for you.
-
Publish HubDB-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live HubDB data.
-
Query Basecamp Data in DataGrip
Create a Data Source for Basecamp in DataGrip and use SQL to query live Basecamp data.
-
Access Hugging Face Data from MySQL in Amazon QuickSight
Connect to Hugging Face and build visualizations of Hugging Face data using a MySQL Connection in Amazon QuickSight.
-
How to Connect to Live Authorize.Net Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Authorize.Net data through natural language.
-
How to load Rebilly data into Elasticsearch via Logstash
Introducing a simple method to load Rebilly data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Automated Continuous Airtable Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Airtable data replication to OneLake in Microsoft Fabric.
-
Automate CouchDB Data Replication to SAP HANA
Use CData Sync to customize and automate CouchDB data replication to SAP HANA.
-
Integrate Google's Vertex AI Agent with Live BenchmarkEmail Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live BenchmarkEmail data within intelligent workflows.
-
Automate WooCommerce Data Replication to Couchbase
Use CData Sync to Customize and automate WooCommerce data replication to Couchbase.
-
Natively Connect to eBay Analytics Data in PHP
The CData ODBC driver for eBay Analytics enables you to create PHP applications with connectivity to eBay Analytics data. Leverage the native support for ODBC in PHP.
-
How to publish and share Oracle Financials Cloud Data dashboards with Tableau Server
The CData ODBC driver for Oracle Financials Cloud enables you integrate Oracle Financials Cloud data into Tableau dashboards.
-
How to Seamlessly Import Office 365 Data into IBM SPSS Modeler
Integrate Office 365 data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Voice Agents in ElevenLabs with access to Live Dynamics 365 Business Central Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Dynamics 365 Business Central data.
-
Replicate HCL Domino Data in Heroku for Use in Salesforce Connect
Replicate HCL Domino data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Connect to DocuSign Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to DocuSign data. Leverage the pyodbc module for ODBC in Python.
-
Build API-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for API Data and create custom apps in Bubble.
-
Integrate Google's Vertex AI Agent with Live FHIR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live FHIR data within intelligent workflows.
-
Integrate Devin with Live Slack Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Slack data.
-
Connect to Reckon Accounts Hosted Data from a Connection Pool in JBoss
Integrate Reckon Accounts Hosted data into Java servlets: Use the Management Console in JBoss to install the Reckon Accounts Hosted JDBC Driver.
-
Connect to Miro Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Miro.
-
Analyze Paylocity Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Paylocity from Power Pivot. You will use the Table Import Wizard to load Paylocity data. You can visually build the import query or use any SQL supported by the driver.
-
Connect ConstantContact to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live ConstantContact data using the CData Python MCP Server.
-
Bridge Hacker News Connectivity with Apache NiFi
Access and process Hacker News data in Apache NiFi using the CData JDBC Driver.
-
Connect to Shippo Data from PowerBuilder via JDBC
This article demonstrates how to access Shippo data from PowerBuilder using the Shippo JDBC Driver.
-
Operational Reporting on Azure DevOps Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Azure DevOps data.
-
How to publish and share ZohoDesk Data dashboards with Tableau Server
The CData ODBC driver for ZohoDesk enables you integrate ZohoDesk data into Tableau dashboards.
-
Sage 200 Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Sage 200 facts in real time.
-
How to connect to Mailjet Data from IntelliJ
Integrate connectivity to Mailjet data with wizards in IntelliJ.
-
Integrate with Couchbase Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Couchbase data in SnapLogic.
-
Visualize Spark Data in TIBCO Spotfire through OData
Integrate Spark data into dashboards in TIBCO Spotfire.
-
Query SAP BusinessObjects BI Data in ColdFusion
Write standard ColdFusion data access code to connect to SAP BusinessObjects BI data.
-
Build ActiveCampaign-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for ActiveCampaign Data and create custom apps in Bubble.
-
Visualize FTP Data in TIBCO Spotfire through OData
Integrate FTP data into dashboards in TIBCO Spotfire.
-
Replicate Multiple AlloyDB Accounts via the CData Sync CLI
Replicate multiple AlloyDB accounts to one or many databases.
-
Use Dash to Build to Web Apps on SpaceX Data
Create Python applications that use pandas and Dash to build SpaceX-connected web apps.
-
How to Connect the Power BI Service to DB2: Complete Guide
Connect to the CData Software Power BI Connector for DB2 from PowerBI.com to provide real-time DB2 data across the organization.
-
Connect to Gmail Data from a Connection Pool in Jetty
The Gmail JDBC Driver supports connection pooling: This article shows how to connect faster to Gmail data from Web apps in Jetty.
-
Model, Search, and Visualize Live Google Analytics Data in ThoughtSpot
Use CData Connect AI to connect to live Google Analytics data for modeling, searching, and visualizing.
-
Build Apps with Live IBM Informix data in Adalo using CData Connect AI
Use CData Connect AI to integrate live IBM Informix data into the Adalo platform and build custom mobile and web applications with real-time IBM Informix data.
-
Build Visualizations of ActiveCampaign Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of ActiveCampaign data in Birst.
-
Analyze eBay Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze eBay data in Microsoft R Open.
-
Connect to Microsoft Dataverse Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Microsoft Dataverse to connect to Microsoft Dataverse data and execute queries in PowerBuilder.
-
Integrate Optimizely Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Optimizely data from Informatica Cloud.
-
Analyze Workable Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Workable data in Microsoft R Open.
-
Integrate Devin with Live MySQL Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live MySQL data.
-
Use Dash to Build to Web Apps on Toggl Data
Create Python applications that use pandas and Dash to build Toggl-connected web apps.
-
Integrating Boomi Agentstudio with Certinia Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Certinia data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Replicate Multiple Azure Data Lake Storage Accounts via the CData Sync CLI
Replicate multiple Azure Data Lake Storage accounts to one or many databases.
-
Getting Started with the CData Tableau Connector for LinkedIn Ads
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for LinkedIn Ads.
-
Connect to BambooHR Data in Ruby
Connect to BambooHR data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Replicate Freshdesk Data in Heroku for Use in Salesforce Connect
Replicate Freshdesk data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.