CData Software - Knowledge Base
Recent Articles
-
How to Access Gorgias Data Using Entity Framework
This article shows how to access Gorgias data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to work with BenchmarkEmail Data in Apache Spark using SQL
Access and process BenchmarkEmail Data in Apache Spark using the CData Software JDBC Driver.
-
Getting Started with the CData Connect AI Python SDK for Teradata
Install the CData Connect AI Python SDK to read and write live Teradata data with standard DB-API 2.0 Python code.
-
Write a Simple Go Application to work with Trello Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Trello data.
-
Use Microsoft Copilot Studio to talk to your Quickbase 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 Quickbase data for you.
-
Build an OLAP Cube in SSAS from FHIR Data
Establish a connection to FHIR data data from SQL Server Analysis Services, and use the FHIR Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Azure Data Catalog Data from a Connection Pool in Jetty
The Azure Data Catalog JDBC Driver supports connection pooling: This article shows how to connect faster to Azure Data Catalog data from Web apps in Jetty.
-
Visualize SAP HANA XS Advanced Data in TIBCO Spotfire through OData
Integrate SAP HANA XS Advanced data into dashboards in TIBCO Spotfire.
-
How to Easily Query LightSpeedRetail Data in OpenOffice Base
Connect to LightSpeedRetail data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Automated Continuous Miro Replication to SQLite
Use CData Sync for automated, continuous, customizable Miro replication to SQLite.
-
Add Sentry Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Sentry with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous FreshBooks Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable FreshBooks replication to delimited files (CSV/TSV).
-
Natively Connect to SendGrid Data in PHP
The CData ODBC driver for SendGrid enables you to create PHP applications with connectivity to SendGrid data. Leverage the native support for ODBC in PHP.
-
Enable the Attio JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Attio data.
-
Integrate Teamwork with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Teamwork with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Teamwork data.
-
Connect to OneNote Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for OneNote Data and connect to OneNote data in Akorbi Digital RunMyProcess.
-
Connect to Amplitude Data in HULFT Integrate
Connect to Amplitude as a JDBC data source in HULFT Integrate
-
Connect to Vault CRM Data from a Connection Pool in JBoss
Integrate Vault CRM data into Java servlets: Use the Management Console in JBoss to install the Vault CRM JDBC Driver.
-
Automated Continuous Avalara AvaTax Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to AlloyDB.
-
Publish Google Sheets-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Google Sheets data.
-
Use Manus AI to Talk to Your Avalara AvaTax Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Avalara AvaTax data.
-
Connect to Live SharePoint Data in MicroStrategy through CData Connect AI
Create a live connection to SharePoint Data in CData Connect AI and connect to your SharePoint data from MicroStrategy.
-
How to Visualize SAP SuccessFactors LMS Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live SAP SuccessFactors LMS data in Python.
-
Create Datasets from Bullhorn CRM in Domo Workbench and Build Visualizations of Bullhorn CRM Data in Domo
Use the CData Software ODBC Driver for Bullhorn CRM to create datasets from Bullhorn CRM data in Domo Workbench and then build visualizations in the Domo service.
-
Explore Geographical Relationships in ElevenLabs Data with Power Map
Create data visualizations with ElevenLabs data in Power Map.
-
Use the CData Software ODBC Driver for DB2 in MicroStrategy Web
Connect to DB2 data in MicroStrategy Web using the CData Software ODBC Driver for DB2.
-
Build Semantic Layer Views for ZohoInvoice Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for ZohoInvoice data.
-
How to connect to CapsuleCRM Data in DBVisualizer
Integrate CapsuleCRM data with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous Google Ad Manager Replication to Databricks
Use CData Sync for automated, continuous, customizable Google Ad Manager replication to Databricks.
-
Automated Continuous Rootly Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Rootly replication to Google BigQuery.
-
Analyze Couchbase Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Couchbase data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
How to Connect to Bright Data Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Bright Data data. Leverage the pyodbc module for ODBC in Python.
-
Getting Started with the CData Python Connector for Freshdesk
Learn to install and license the CData Python Connector and configure a connection to live Freshdesk data.
-
Visualize QuickBooks Time Data in Tableau
The CData ODBC driver for QuickBooks Time enables you integrate QuickBooks Time data into Tableau dashboards.
-
How to publish and share Splunk Data dashboards with Tableau Server
The CData ODBC driver for Splunk enables you integrate Splunk data into Tableau dashboards.
-
Automated Continuous Pushbullet Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Pushbullet replication to Google BigQuery.
-
How to connect and process Landbot data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Landbot data.
-
DataBind Charts to Chargebee Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Chargebee data 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.
-
Access Bullhorn CRM Data from MySQL in PHP
Connect to Bullhorn CRM through the standard MySQL libraries in PHP.
-
Search External ZohoPeople Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of ZohoPeople data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create ZohoPeople Data objects that you can access from apps and the dashboard.
-
How to connect to MariaDB Data with Squirrel SQL client
Connect to MariaDB data and execute queries in the Squirrel SQL Client.
-
Rapidly Develop Kintone-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 Kintone.
-
How to work with Google Calendar Data in Apache Spark using SQL
Access and process Google Calendar Data in Apache Spark using the CData Software JDBC Driver.
-
Access Live Sage 300 Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Sage 300 data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Build Apps with Live SAP Ariba Source data in Adalo using CData Connect AI
Use CData Connect AI to integrate live SAP Ariba Source data into the Adalo platform and build custom mobile and web applications with real-time SAP Ariba Source data.
-
Model, Search, and Visualize Live Notion Data in ThoughtSpot
Use CData Connect AI to connect to live Notion data for modeling, searching, and visualizing.
-
Create Elasticsearch Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Elasticsearch from PowerBI.com to create Power BI Dataflows with real-time data.
-
Create a Data Access Object for Cvent Data using JDBI
A brief overview of creating a SQL Object API for Cvent data in JDBI.
-
Manage WordPress Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for WordPress.
-
Build Charts with Freshsales Data in Clear Analytics
Create dynamic charts and perform analytics based on Freshsales data in Clear Analytics.
-
Build Semantic Layer Views for Tanda Data in APOS Live Data Gateway
Use the CData Connector for Tanda in APOS Live Data Gateway to build Semantic Layer Views for Tanda data.
-
Work with Factorial Data in FoxPro
Load Factorial data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Import Okta Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Okta Data and provide access to live Okta data for custom reports in the Power BI Service.
-
How to Query Live Quickbase Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Quickbase data data in natural language using Python.
-
Connect to Google Ad Manager Data in RapidMiner
Integrate Google Ad Manager data with standard components and data source configuration wizards in RapidMiner Studio.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Reckon Accounts Hosted
Provide connectivity to Reckon Accounts Hosted data through an SAP BusinessObjects universe.
-
Bidirectional Access to Oracle Service Cloud Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Oracle Service Cloud data in Filemaker Pro for Mac or Windows.
-
How to create Intercom federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Intercom data in MySQL .
-
Connect to Dynamics CRM Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Dynamics CRM data in the Denodo Virtual DataPort Administrator.
-
Access Live Scrapfly Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Scrapfly data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Access Live Wrike Data in Coginiti Pro
Connect to and query live Wrike data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to connect PolyBase to ActiveCampaign
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live ActiveCampaign data.
-
Use Biml to Build SSIS Tasks to Replicate Oracle Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Oracle data to SQL Server.
-
Connect to HubDB Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for HubDB data in the Denodo Virtual DataPort Administrator.
-
Automate Lakebase Data Replication to Azure Synapse
Use CData Sync to customize and automate Lakebase data replication to Azure Synapse.
-
Use the CData ODBC Driver for Oracle Financials Cloud from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Oracle Financials Cloud to connect to Oracle Financials Cloud data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Oracle Financials Cloud data in Excel.
-
Integrate SAP Netweaver Gateway with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SAP Netweaver Gateway with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SAP Netweaver Gateway data.
-
Build Voice Agents in ElevenLabs with access to Live ActiveCampaign Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live ActiveCampaign data.
-
How to connect Amazon QuickSight to Sage Cloud Accounting Data
Create a connection to Sage Cloud Accounting data in CData Connect AI and insert Sage Cloud Accounting data into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect to PayPal Data as an External Source in Dremio
Use the CData JDBC Driver to connect to PayPal as an External Source in Dremio.
-
Automated Continuous Simplesat Replication to SQLite
Use CData Sync for automated, continuous, customizable Simplesat replication to SQLite.
-
Connect to Paddle Data in NetBeans
Connect to Paddle data in NetBeans with the data source configuration wizard.
-
How to import AdRoll Data into Apache Solr
Use the CData Software JDBC Driver for AdRoll in Data Import Handler and create an automated import of AdRoll data to Apache Solr Enterprise Search platform.
-
Automated Continuous Intercom Replication to MySQL
Use CData Sync for automated, continuous, customizable Intercom replication to MySQL.
-
Parquet Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Parquet facts in real time.
-
Integrate Open WebUI with Live Egnyte Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Egnyte data from within the chat interface.
-
Query Timely Data in DataGrip
Create a Data Source for Timely in DataGrip and use SQL to query live Timely data.
-
Build Microsoft Entra ID-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Microsoft Entra ID data.
-
Automated Continuous ZendeskSell Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable ZendeskSell replication to Amazon Redshift.
-
Connecting Agentforce with QuickBooks Time 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 QuickBooks Time data for you.
-
Use Databricks Agent Bricks to Talk to Your DB2 Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your DB2 data for you.
-
Choosing the Best Method to Connect Excel Online to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Excel Online data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Continuous Avro Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Avro replication to Amazon S3.
-
DataBind Controls to Tickspot Data in C++Builder
DataBind to Tickspot data in C++Builder with standard components and controls.
-
Integrating LlamaIndex with XML Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on XML data in real time.
-
Automate eBay Integration Tasks from PowerShell
Are you in search of a quick and easy way to access eBay data from PowerShell? This article demonstrates how to utilize the eBay Cmdlets for tasks like connecting to eBay data, automating operations, downloading data, and more.
-
Integrate Live Microsoft Teams Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Microsoft Teams data to Blue Prism using the CData ODBC Driver for Microsoft Teams to create automated workflows for repetitive business tasks.
-
Use ChatGPT to Talk to Your HubSpot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your HubSpot data for you.
-
Connect to Unbounce Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Unbounce as an External Source in Dremio.
-
How to Work with Azure Synapse Data in ETL Validator JDBC
Connect to Azure Synapse from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrating Boomi Agentstudio with Act-On Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Act-On data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Integrate Real-Time Access to SAP HANA in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SAP HANA data in real time.
-
Publish Crystal Reports on MessageBird Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date MessageBird data.
-
Integrate LibreChat with Live Omnisend Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Omnisend data from within the chat interface.
-
Use the CData Software JDBC Driver for ConvertKit in MicroStrategy
Connect to ConvertKit data in MicroStrategy Developer using the CData Software JDBC Driver for ConvertKit.
-
Getting Started with the CData JDBC Driver for Microsoft Ads
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Microsoft Ads.
-
Create SSAS Tabular Models from ServiceNow Data
How to build a SQL Server Analysis Service Tabular Model from ServiceNow data using CData drivers.
-
Analyze Excel Online Data in Looker
Use CData Connect AI to connect to Excel Online Data from Looker and build custom apps using live Excel Online data.
-
Use Manus AI to Talk to Your CouchDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on CouchDB data.
-
Connect Discourse Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Discourse data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.