CData Software - Knowledge Base
Recent Articles
-
Consume Unbounce OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Unbounce feeds that reflect any changes in SAP Lumira.
-
Viewing BigQuery in RAD Studio Data Explorer
How to view Google BigQuery in RAD Studio Data Explorer using the CData ODBC Driver for BigQuery.
-
Choosing the Best Method to Connect DB2 to SQL Server: 5 Options Explained
Discover multiple ways to connect and use IBM DB2 from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build Voice Agents in ElevenLabs with access to Live Workday
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Workday.
-
Connect to Typeform from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Typeform using standard SQL.
-
How to connect PolyBase to Couchbase
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Couchbase.
-
Build Semantic Layer Views for SQL Analysis Services in APOS Live Data Gateway
Use the CData Connector for SQL Analysis Services in APOS Live Data Gateway to build Semantic Layer Views for SQL Analysis Services.
-
Connect to PostgreSQL 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 PostgreSQL.
-
Access Twitter Ads from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Twitter Ads from HeidiSQL.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Microsoft Exchange to Power BI dashboards. Simply drag and drop Microsoft Exchange into data visuals on the Power BI canvas.
-
Automate Paylocity Replication to Azure Data Lake
Use CData Sync to customize and automate Paylocity replication to Azure Data Lake.
-
Integrate Theia IDE with Live Splunk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Use Dash to Build to Web Apps on Dynamics 365 Business Central
Create Python applications that use pandas and Dash to build Dynamics 365 Business Central-connected web apps.
-
How to connect SharePoint with Zoho Books through external lists
Provide Zoho Books to SharePoint users as an external list.
-
Connect to BigCommerce in DBeaver
Use the CData ODBC Driver to connect to BigCommerce in DBeaver.
-
Getting Started with the CData JDBC Driver for Microsoft Dataverse
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Microsoft Dataverse.
-
Analyze Kintone in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Kintone and visualize live Kintone in Infragistics Reveal.
-
Stream Dynamics NAV into Apache Kafka Topics
Access and stream Microsoft Dynamics NAV in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Rapidly Develop WordPress-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
Build Agents in Relevance AI with Access to Live Zoho Inventory via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Zoho Inventory within intelligent agent workflows.
-
Analyze Sage 300 in Infragistics Reveal
Use the CData API Server to create an OData API on top of Sage 300 and visualize live Sage 300 in Infragistics Reveal.
-
How to connect and process Snapchat Ads from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Snapchat Ads.
-
Query, Visualize, and Share live Greenplum in Redash
Use CData Connect AI to connect to live Pivotal GreenPlum in Redash for querying, visualizing, and sharing.
-
How to create Visio diagrams from Redshift
Automatically update Amazon Redshift with the changes you make to Visio master shapes.
-
Connect to Calendly in RazorSQL
Connect to Calendly from wizards and query Calendly from the GUI in the RazorSQL database management tool.
-
Automated Continuous Tableau CRM Analytics Replication to Oracle
Use CData Sync for automated, continuous, customizable Tableau CRM Analytics replication to Oracle.
-
How to Visualize Google Calendar Data in Python with pandas
Use pandas and other modules to analyze and visualize live Google Calendar in Python.
-
Connect to Eventbrite in SpagoBI
Create reports featuring live Eventbrite in SpagoBI Studio. Host Eventbrite reports on SpagoBI Server.
-
Building Dynamic Web Pages with QuickBooks Using AngularJS
Create single-page applications with live connectivity to QuickBooks using the CData API Server.
-
Integrate Trello with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Trello with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Trello.
-
Connect to Neo4J from a Connection Pool in Jetty
The Neo4J JDBC Driver supports connection pooling: This article shows how to connect faster to Neo4J from Web apps in Jetty.
-
Build a Simple VCL Application for YouTube Analytics
How to build a simple VCL Application to view YouTube Analytics in RAD Studio using the CData ODBC Driver for YouTube Analytics.
-
Build a Singer.io Tap for SendGrid With the CData Python Connector
Learn how to easily build a Singer.io Tap for live SendGrid data using
-
Access Live Twilio in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Twilio into the statistical analysis tools available in SAS JMP. This article shows how to use Twilio in the Graph Builder and Query Builder.
-
Connect to Dropbox in DBArtisan
Use wizards in DBArtisan to configure Dropbox as a data source.
-
How to Connect to Live GitHub from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your GitHub for you.
-
Visualize Live Pipedrive of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Pipedrive using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
View Reports on Real-Time QuickBooks Time in Power BI Report Server
Use the CData ODBC Driver for QuickBooks Time to visualize QuickBooks Time in Power BI Desktop and then publish them to Power BI Report Server.
-
PowerShell Scripting to Replicate Dropbox to MySQL
Write a simple PowerShell script to replicate Dropbox to a MySQL database.
-
How to Access Live Trello in Power Automate Desktop via ODBC
The CData ODBC Driver for Trello enables you to integrate Trello into workflows built using Microsoft Power Automate Desktop.
-
Access Sage Cloud Accounting from MySQL in Amazon QuickSight
Connect to Sage Cloud Accounting and build visualizations of Sage Business Cloud Accounting using a MySQL Connection in Amazon QuickSight.
-
Automate DB2 Replication to Couchbase
Use CData Sync to Customize and automate IBM DB2 replication to Couchbase.
-
Connecting Agentforce with Avalara AvaTax 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 Avalara AvaTax for you.
-
Integrate with live Impala in Jitterbit
Use CData Connect AI to connect to and integrate live Apache Impala in Jitterbit.
-
Access Live Gmail in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Gmail through MCP integration.
-
Create SSAS Tabular Models from Google Sheets
How to build a SQL Server Analysis Service Tabular Model from Google Sheets using CData drivers.
-
How to publish and share Teradata dashboards with Tableau Server
The CData ODBC driver for Teradata enables you integrate Teradata into Tableau dashboards.
-
Connect to Azure Data Lake Storage in HULFT Integrate
Connect to Azure Data Lake Storage as a JDBC data source in HULFT Integrate
-
Automated Continuous SuiteCRM Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SuiteCRM replication to delimited files (CSV/TSV).
-
Connect to HDFS in Aqua Data Studio
Access Apache HDFS from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build a Simple VCL Application for Avalara AvaTax
How to build a simple VCL Application to view Avalara AvaTax in RAD Studio using the CData ODBC Driver for Avalara AvaTax.
-
How to create Basecamp federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Basecamp in MySQL .
-
Connect to Basecamp from a Connection Pool in JBoss
Integrate Basecamp into Java servlets: Use the Management Console in JBoss to install the Basecamp JDBC Driver.
-
Connect to Google Drive in Jaspersoft Studio
Execute SQL to remote Google Drive in Jaspersoft Studio.
-
View Reports on Real-Time Xero in Power BI Report Server
Use the CData ODBC Driver for Xero to visualize Xero Accounting in Power BI Desktop and then publish them to Power BI Report Server.
-
Create Dynamic Sybase IQ Grids Using the Infragistics XamDataGrid
Learn how you can connect Sybase IQ to Infragistics XamDataGrid to build dynamic grids.
-
Access Live LDAP Objects in Coginiti Pro
Connect to and query live LDAP from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automated Continuous SharePoint Excel Services Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to Apache Cassandra.
-
Connect to Stripe in DBArtisan
Use wizards in DBArtisan to configure Stripe as a data source.
-
Import and Visualize Avro in Power View
Create data visualizations based on Apache Avro in Excel.
-
Import Real-Time SharePoint Excel Services via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SharePoint Excel Services in ColdFusion.
-
Integrate with Live NetSuite in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to NetSuite from the MuleSoft Anypoint Platform to integrate live NetSuite CRM & ERP into custom reports and dashboards.
-
Automated Continuous LinkedIn Replication to MongoDB
Use CData Sync for automated, continuous, customizable LinkedIn replication to MongoDB.
-
Connect to Phoenix as an External Source in Dremio
Use the CData JDBC Driver to connect to Phoenix as an External Source in Dremio.
-
Easily Integrate Stripe in Lazarus Pascal IDE
Learn how to easily integrate live Stripe in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Deploy the ADO.NET Provider for IBM Informix on an SSRS Report Server
Connect to IBM Informix 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.
-
Connecting Agentforce with Facebook Ads 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 Facebook Ads for you.
-
Build OData-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live OData and build OData-connected web apps with Axios.
-
Impala Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Apache Impala through CData Connect AI using different applications and tools.
-
Connecting GenSpark with Sugar CRM via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to enterprise data across hundreds of systems without any replication or custom integration required.
-
Bidirectional Access to Salesforce from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Salesforce & Force.com in Filemaker Pro for Mac or Windows.
-
How to connect and process Adobe Experience Manager from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Adobe Experience Manager.
-
Back Up Google AlloyDB to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for AlloyDB. In this article, we will employ an SSIS workflow to populate a database with Google AlloyDB data.
-
How to connect PolyBase to Oracle Eloqua
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Oracle Eloqua.
-
Prepare, Blend, and Analyze Sybase in Alteryx Designer (ODBC)
Build workflows to access live Sybase for self-service data analytics.
-
Automate Authorize.Net Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Authorize.Net from PowerShell? This article demonstrates how to utilize the Authorize.Net Cmdlets for tasks like connecting to Authorize.Net, automating operations, downloading data, and more.
-
Using the CData Software ODBC Driver for Amazon S3 in PyCharm
Connect to Amazon S3 as an ODBC data source in PyCharm using the CData Software ODBC Driver for Amazon S3.
-
Replicate IBM Informix in Heroku for Use in Salesforce Connect
Replicate IBM Informix to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Edit and Search External WooCommerce Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of WooCommerce to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create WooCommerce objects that you can access from apps and the dashboard.
-
Automated Continuous Raisers Edge NXT Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to Amazon S3.
-
Query Sugar CRM in DataGrip
Create a Data Source for Sugar CRM in DataGrip and use SQL to query live Sugar CRM.
-
SurveyMonkey Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SurveyMonkey facts in real time.
-
Access Live Parquet Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Parquet data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
DataBind Azure Synapse to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for Azure Synapse with the DevExpress Windows Forms and Web controls to provide Azure Synapse to a chart.
-
Automate Hive Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Apache Hive and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Design BIRT Reports on Adobe Experience Manager
Provide current Adobe Experience Manager to your embedded analytics.
-
How to integrate Metabase with Oracle Eloqua
Use CData Connect AI to connect to live Oracle Eloqua and create an interactive dashboard in Metabase from Oracle Eloqua.
-
How to Connect to Live NetSuite Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live NetSuite CRM & ERP securely in real time.
-
Automated Continuous eBay Replication to Oracle
Use CData Sync for automated, continuous, customizable eBay replication to Oracle.
-
Access Live Facebook Ads in AWS Lambda
Connect to live Facebook Ads in AWS Lambda using the CData JDBC Driver.
-
Use the CData Software ODBC Driver for HCL Domino in MicroStrategy Desktop
Connect to HCL Domino in MicroStrategy Desktop using the CData Software ODBC Driver for HCL Domino.
-
How to connect to Square in DBVisualizer
Integrate Square with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Oracle Eloqua from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Oracle Eloqua to connect to Oracle Eloqua and execute queries in PowerBuilder.
-
Access Live BigCommerce in Excel 365 Online (Excel for the web)
Connect to BigCommerce from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Build MVC Applications with Connectivity to Splunk
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Splunk from an ASP.NET MVC application.
-
Connect and Visualize Live Xero Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Xero Accounting into the Databricks platform and create visualization dashboards with real-time Xero Accounting.
-
Automated Continuous ShipStation Replication to Snowflake
Use CData Sync for automated, continuous, customizable ShipStation replication to Snowflake.
-
Create Avalara AvaTax-Connected Dashboards in Grafana
Connect to Avalara AvaTax via CData Connect AI in Grafana and create custom business dashboards with real-time access to Avalara AvaTax.
-
Prepare, Blend, and Analyze CSV in Alteryx Designer (ODBC)
Build workflows to access live CSV/TSV Files for self-service data analytics.
-
Access Live SAP Ariba Source in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live SAP Ariba Source through MCP integration.