CData Software - Knowledge Base
Recent Articles
-
Publish Slack-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Slack data.
-
Process & Analyze Intercom Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Intercom Data.
-
Build a Singer.io Tap for SingleStore With the CData Python Connector
Learn how to easily build a Singer.io Tap for live SingleStore data using the CData Python Connector.
-
Connect to Quaderno Data from a Connection Pool in Jetty
The Quaderno JDBC Driver supports connection pooling: This article shows how to connect faster to Quaderno data from Web apps in Jetty.
-
How to Connect to Superchat Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Superchat data. Leverage the pyodbc module for ODBC in Python.
-
Connect to and Query Paylocity Data in QlikView over ODBC
Create data visualizations with Paylocity data in QlikView.
-
Stripe Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Stripe data through CData Connect AI using different applications and tools.
-
How to create Elasticsearch federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Elasticsearch data in MySQL .
-
Automated Continuous Cvent Replication to MongoDB
Use CData Sync for automated, continuous, customizable Cvent replication to MongoDB.
-
Automated Continuous Jumpseller Replication to Snowflake
Use CData Sync for automated, continuous, customizable Jumpseller replication to Snowflake.
-
Connect to ShipEngine Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for ShipEngine data.
-
Build Automated Workflows with Live Hive Data in Workato
Use CData Connect AI to connect to live Hive data and build automated workflows in Workato.
-
Create BenchmarkEmail-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to BenchmarkEmail Data from OutSystems and build custom enterprise apps using live BenchmarkEmail data.
-
Getting Started with the CData JDBC Driver for SAP SuccessFactors
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SAP SuccessFactors.
-
Create Reports with ZohoExpense Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ZohoExpense data.
-
Query Zoho Creator Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Zoho Creator entities in PHP by modeling them as objects.
-
Automated Continuous Oracle Sales Replication to MongoDB
Use CData Sync for automated, continuous, customizable Oracle Sales replication to MongoDB.
-
Excel Spreadsheet Automation on MariaDB Data with the QUERY Formula
Pull data from MariaDB, automate spreadsheets, and more with the QUERY formula.
-
Connect Teamgate to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Teamgate with IBM WebSphere for seamless data integration and connectivity.
-
Connect to Zendesk Data from HeidiSQL
Use CData Connect AI to connect to and query live Zendesk data from HeidiSQL.
-
Build xBase-Connected Apps in Choreo
Use CData Connect AI to connect to xBase Data from Choreo and build custom apps using live xBase data.
-
A PostgreSQL Interface for SAP Business One Data (MySQL Remoting via JDBC)
Use the Remoting features of the SAP Business One JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Build an ETL App for Avro Data in Python with CData Connect AI
Extract and transform live Avro data in Python with petl and the CData Connect AI Python SDK.
-
Access Microsoft Teams Data from MySQL in PHP
Connect to Microsoft Teams through the standard MySQL libraries in PHP.
-
Establish a Live Connection with Sybase Data using Tableau Bridge
The CData ODBC Driver for Sybase enables you to integrate live Sybase data into Tableau Cloud dashboards using the Tableau Bridge.
-
Getting Started with the CData ADO.NET Provider for MailChimp
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for MailChimp.
-
Nethunt Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Nethunt facts in real time.
-
How to connect PolyBase to ZarMoney
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live ZarMoney data.
-
Build Agents in Relevance AI with Access to Live Google Drive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Google Drive data within intelligent agent workflows.
-
Prepare, Blend, and Analyze Simplesat Data in Alteryx Designer (ODBC)
Build workflows to access live Simplesat data for self-service data analytics.
-
Integrating LangChain with ShipEngine Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on ShipEngine data within automated workflows.
-
Create Power BI Reports on Real-Time PingOne Data
Use the CData ODBC Driver for PingOne to visualize PingOne data in Power BI Desktop.
-
Build a Simple VCL Application for Omnisend Data
How to build a simple VCL Application to view Omnisend data in RAD Studio using the CData ODBC Driver for Omnisend.
-
Build Paymo-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Paymo data without replication.
-
Integrating Antigravity CLI with Google Contacts data via CData CLI
Connect Google Contacts data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build an OLAP Cube in SSAS from PabblySubscriptions Data
Establish a connection to PabblySubscriptions data data from SQL Server Analysis Services, and use the PabblySubscriptions Data Provider to build OLAP cubes for use in analytics and reporting.
-
Use Databricks Agent Bricks to Talk to Your Highrise Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Highrise data for you.
-
Publish Crystal Reports on Reply.io Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Reply.io data.
-
Build ZeroBounce-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to ZeroBounce data and build web apps with connectivity to live ZeroBounce data.
-
Integrate Workday Data in the Pentaho Report Designer
Publish reports based on Workday data in the Pentaho BI tool.
-
Create OData-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to OData Services from OutSystems and build custom enterprise apps using live OData services.
-
Create Dynamic CapsuleCRM Grids Using the Infragistics XamDataGrid
Learn how you can connect CapsuleCRM to Infragistics XamDataGrid to build dynamic grids.
-
Replicate Multiple Simplesat Accounts
Replicate multiple Simplesat accounts to one or many databases.
-
How to Access BenchmarkEmail Data Using Entity Framework
This article shows how to access BenchmarkEmail data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build Dashboards with FreeAgent Data in Dundas BI
Create dynamic dashboards and perform analytics based on FreeAgent data in Dundas BI.
-
Connect and Visualize Live OneNote Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live OneNote data into the Databricks platform and create visualization dashboards with real-time OneNote data.
-
Connect to Coinbase in SpagoBI
Create reports featuring live Coinbase data in SpagoBI Studio. Host Coinbase reports on SpagoBI Server.
-
Integrate Webflow with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Webflow with External Services.
-
Visualize Live Azure Data Lake Storage Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Azure Data Lake Storage data into custom reports in Power BI.
-
Use CData Connect AI to Access SendGrid Data in Microsoft Power Pivot
Use CData Connect AI to connect to live SendGrid data in the Power Pivot business intelligence tool.
-
Use the CData ODBC Driver for Amazon DynamoDB from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Amazon DynamoDB to connect to Amazon DynamoDB data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Amazon DynamoDB data in Excel.
-
Getting Started with the CData Excel Add-In for Dropbox
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Dropbox.
-
Replicate FreshBooks Data to Multiple Databases
Replicate FreshBooks data to disparate databases with a point-and-click configuration.
-
Stream Typeform Data into Apache Kafka Topics
Access and stream Typeform data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous Presto Replication to SingleStore
Use CData Sync for automated, continuous, customizable Presto replication to SingleStore.
-
How to Visualize Figshare Data in Python with pandas
Use pandas and other modules to analyze and visualize live Figshare data in Python.
-
Connect to Monday.com from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Monday.com data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Replicate Multiple Gorgias Accounts
Replicate multiple Gorgias accounts to one or many databases.
-
Choosing the Best Method to Connect Postmark to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Postmark data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Connect to Live Wistia Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Wistia data for you.
-
Automated Continuous HCL Domino Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable HCL Domino replication to Google Cloud SQL.
-
Integrate with SparkPost Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SparkPost data to a JSON file on disk.
-
How to Visualize OData Data in Python with pandas
Use pandas and other modules to analyze and visualize live OData services in Python.
-
Stream Anaplan Data into Apache Kafka Topics
Access and stream Anaplan data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to integrate Metabase with WooCommerce Data
Use CData Connect AI to connect to live WooCommerce data and create an interactive dashboard in Metabase from WooCommerce data.
-
Access Yelp Data from MySQL in PHP
Connect to Yelp through the standard MySQL libraries in PHP.
-
Replicate Outlook Data to Multiple Databases via the CData Sync CLI
Replicate Outlook data to disparate databases with a single configuration.
-
Query CapsuleCRM Data in DataGrip
Create a Data Source for CapsuleCRM in DataGrip and use SQL to query live CapsuleCRM data.
-
Create Klipfolio-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Klipfolio Data from Klipfolio and build custom visualizations using live Klipfolio data.
-
How to connect to MessageBird Data from IntelliJ
Integrate connectivity to MessageBird data with wizards in IntelliJ.
-
Create SSAS Tabular Models from Customer.io Data
How to build a SQL Server Analysis Service Tabular Model from Customer.io data using CData drivers.
-
Automated Continuous Active Directory Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Active Directory replication to Google BigQuery.
-
Automated Continuous Insightly Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Insightly replication to AlloyDB.
-
Replicate Excel Online Data from PowerShell
Write a quick PowerShell script to query Excel Online data. Use connectivity to the live data to replicate Excel Online data to SQL Server.
-
Build a Singer.io Tap for ConstantContact With the CData Python Connector
Learn how to easily build a Singer.io Tap for live ConstantContact data using the CData Python Connector.
-
Edit and Search External Outreach.io Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Outreach.io data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Outreach.io Data objects that you can access from apps and the dashboard.
-
Replicate Multiple Zoho Creator Accounts
Replicate multiple Zoho Creator accounts to one or many databases.
-
Connect to HDFS Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for HDFS data in Airbyte.
-
Integrate Cline with Live Elasticsearch Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Elasticsearch data from within your IDE.
-
Create Dynamic Qualaroo Grids Using the Infragistics XamDataGrid
Learn how you can connect Qualaroo to Infragistics XamDataGrid to build dynamic grids.
-
Integrate Live Square Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Square data and integrate live Square data into apps built in Microsoft Power Apps.
-
Automated Continuous Wistia Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Wistia replication to Amazon S3.
-
Automated Continuous Pingdom Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Pingdom replication to Google BigQuery.
-
How to Connect the Power BI Service to Salesforce Marketing: Complete Guide
Connect to the CData Software Power BI Connector for Salesforce Marketing from PowerBI.com to provide real-time Salesforce Marketing data across the organization.
-
How to update Dynamics NAV from Excel
This article explains how to transfer data from Excel to Dynamics NAV using the Excel Add-In for Dynamics NAV.
-
Access Live Jumpseller Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Jumpseller data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Build Charts with Placid Data in Clear Analytics
Create dynamic charts and perform analytics based on Placid data in Clear Analytics.
-
Create Dynamic ScrapingBee Grids Using the Infragistics XamDataGrid
Learn how you can connect ScrapingBee to Infragistics XamDataGrid to build dynamic grids.
-
Use Dash to Build Web Apps on ActiveCampaign Data via CData Connect AI
Build interactive Dash web apps on live ActiveCampaign data using pandas and the CData Connect AI Python SDK.
-
Connect to Zoho Inventory from a Connection Pool in WebLogic
Use the CData JDBC Driver for Zoho Inventory to connect to Zoho Inventory data from Web applications running on WebLogic.
-
Connect to Clari Data in Jaspersoft Studio
Execute SQL to remote Clari data in Jaspersoft Studio.
-
Build Automated Workflows with Live MongoDB Data in Workato
Use CData Connect AI to connect to live MongoDB data and build automated workflows in Workato.
-
DataBind Charts to SAP Netweaver Gateway Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SAP Netweaver Gateway 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.
-
Create ServiceDesk Plus-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to ServiceDesk Plus Data from Klipfolio and build custom visualizations using live ServiceDesk Plus data.
-
Create Data Visualizations Based On Microsoft Dataverse Data in Mode
Use CData Connect AI to connect to Microsoft Dataverse Data from Mode and build visualizations using live Microsoft Dataverse data.
-
Create Dynamic Twitter Ads Grids Using the Infragistics XamDataGrid
Learn how you can connect Twitter Ads to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Amazon Athena Data in Google Apps Script via Connect AI
Use CData Connect AI to access Amazon Athena data in Google Apps Script.
-
How to connect and process Yelp data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Yelp data.
-
Connect to Oracle Service Cloud Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Oracle Service Cloud data in the Denodo Virtual DataPort Administrator.
-
How to connect to FHIR Data with Squirrel SQL client
Connect to FHIR data and execute queries in the Squirrel SQL Client.