CData Software - Knowledge Base
Recent Articles
-
Connect to Shippo in Google Apps Script via SQL Gateway
Use the ODBC Driver for Shippo and the SQL Gateway to access Shippo from Google Apps Script.
-
Connect to Slack in ACL Analytics
Connect to Slack via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Slack.
-
Build Agents in Relevance AI with Access to Live DocuSign via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on DocuSign within intelligent agent workflows.
-
Create Dynamics 365 Business Central-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Dynamics 365 Business Central from OutSystems and build custom enterprise apps using live Dynamics 365 Business Central.
-
How to connect to Access in DBVisualizer
Integrate Microsoft Access with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to SAP Ariba Source from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SAP Ariba Source using standard SQL.
-
How to Connect to & Open Asana in Microsoft Excel
This article uses the CData ODBC driver for Asana to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Query Live Databricks in Perplexity MacOS Desktop
Connect to and query live Databricks in Perplexity Desktop using CData Code Assist MCP.
-
Automated Excel Online Replication to Teradata
Use CData Sync to Customize and automate Microsoft Excel Online replication to Teradata.
-
Automated Continuous Adobe Analytics Replication to Snowflake
Use CData Sync for automated, continuous, customizable Adobe Analytics replication to Snowflake.
-
DataBind SAP SuccessFactors LMS to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for SAP SuccessFactors LMS with the DevExpress Windows Forms and Web controls to provide SAP SuccessFactors LMS to a chart.
-
Access Reckon from MySQL in Amazon QuickSight
Connect to Reckon and build visualizations of Reckon using a MySQL Connection in Amazon QuickSight.
-
Analyze Office 365 in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Microsoft Office 365 in Microsoft R Open.
-
How to Connect to Live SQL Server 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 Microsoft SQL Server for you.
-
Publish Reports with Calendly in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Calendly.
-
Establish a Live Connection with QuickBooks Time using Tableau Bridge
The CData ODBC Driver for QuickBooks Time enables you to integrate live QuickBooks Time into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Dropbox as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Dropbox.
-
Visualize Live Paylocity of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Paylocity using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to SAP Concur from a Connection Pool in Jetty
The SAP Concur JDBC Driver supports connection pooling: This article shows how to connect faster to SAP Concur from Web apps in Jetty.
-
Build MVC Applications with Connectivity to Adobe Target
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Adobe Target from an ASP.NET MVC application.
-
Automated Continuous SAP Fieldglass Replication to MongoDB
Use CData Sync for automated, continuous, customizable SAP Fieldglass replication to MongoDB.
-
Publish Reports with Outreach.io in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Outreach.io.
-
How to Work with Zoho Projects in AWS Glue Jobs Using JDBC
Connect to Zoho Projects from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Query Twilio in ColdFusion
Write standard ColdFusion data access code to connect to Twilio.
-
Build Dashboards with FHIR in Dundas BI
Create dynamic dashboards and perform analytics based on FHIR in Dundas BI.
-
Edit and Search External DocuSign Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of DocuSign to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create DocuSign objects that you can access from apps and the dashboard.
-
Add Hive to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Hive with the Informatica Enterprise Data Catalog to classify and organize data.
-
Viewing SAS xpt in RAD Studio Data Explorer
How to view SAS XPORT in RAD Studio Data Explorer using the CData ODBC Driver for SAS xpt.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Act-On within intelligent workflows.
-
Connect to and Visualize Live Google Drive in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Google Drive.
-
Automated Continuous Microsoft Project Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Microsoft Project replication to PostgreSQL.
-
Connect to Kafka from PowerBuilder via ADO.NET
This article demonstrates how to access Apache Kafka from Appeon PowerBuilder using the CData ADO.NET Provider for Kafka.
-
Visualize SAP Fieldglass in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load SAP Fieldglass into TIBCO Spotfire.
-
Stream Zoom into Apache Kafka Topics
Access and stream Zoom in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Visualize ServiceNow in TIBCO Spotfire through ADO.NET
Integrate ServiceNow into dashboards in TIBCO Spotfire.
-
Import Real-Time Amazon Marketplace via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Amazon Marketplace in ColdFusion.
-
Automated Continuous QuickBooks Online Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable QuickBooks Online replication to Google Cloud SQL.
-
Connect to Cvent from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Cvent using standard SQL.
-
Automated Continuous Calendly Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Calendly replication to Apache Cassandra.
-
Integrate Slack into Power Automate Desktop using CData Connect
CData Connect for Slack enables you to integrate Slack into workflows built using Microsoft Power Automate Desktop.
-
How to Connect to Live GitHub 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 GitHub for you.
-
Build MariaDB-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to MariaDB from Zoho Analytics and import live MariaDB.
-
Replicate GitHub to Multiple Databases via the CData Sync CLI
Replicate GitHub to disparate databases with a single configuration.
-
Integrate Jira Assets in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Jira Assets from Informatica Cloud.
-
Connect to Splunk in Google Apps Script via SQL Gateway
Use the ODBC Driver for Splunk and the SQL Gateway to access Splunk from Google Apps Script.
-
Use Dash to Build to Web Apps on Adobe Analytics
Create Python applications that use pandas and Dash to build Adobe Analytics-connected web apps.
-
Use Biml to Build SSIS Tasks to Replicate Microsoft Exchange to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Microsoft Exchange to SQL Server.
-
How to Connect to Live SAP ByDesign from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your SAP Business ByDesign for you.
-
View Reports on Real-Time Klipfolio in Power BI Report Server
Use the CData ODBC Driver for Klipfolio to visualize Klipfolio in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Google Search from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Google Search, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to Access OneNote Using Entity Framework
This article shows how to access Microsoft OneNote using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to Design Cloudant Power Apps with Database-Like Connectivity
This article shows how to gain real-time, database-like connectivity from mobile and tablet Power Apps.
-
Create SSAS Tabular Models from Microsoft OneDrive
How to build a SQL Server Analysis Service Tabular Model from Microsoft OneDrive using CData drivers.
-
Publish Crystal Reports on EnterpriseDB
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date EnterpriseDB.
-
Access Live Zoho Inventory in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Zoho Inventory from your Excel spreadsheets.
-
Visualize DocuSign from Tableau
Use the Tableau Desktop business intelligence tool to connect to DocuSign.
-
Connect to Oracle Financials Cloud in Jaspersoft Studio
Execute SQL to remote Oracle Financials Cloud in Jaspersoft Studio.
-
Build Pipelines with Live Raisers Edge NXT in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Raisers Edge NXT from Google Cloud Data Fusion, enabling the integration of live Raisers Edge NXT into the building and management of effective data pipelines.
-
Automated Power BI XMLA Replication to Teradata
Use CData Sync to Customize and automate Power BI XMLA replication to Teradata.
-
Easily Integrate Google Calendar in Lazarus Pascal IDE
Learn how to easily integrate live Google Calendar in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Migrating data from Salesforce Data Cloud to Snowflake using CData SSIS Components.
Easily push Salesforce Data Cloud to Snowflake using the CData SSIS Tasks for Salesforce Data Cloud and Snowflake.
-
How to create Visio diagrams from Excel Online
Automatically update Microsoft Excel Online with the changes you make to Visio master shapes.
-
Write a Simple Go Application to work with Twilio on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Twilio.
-
Build MVC Applications with Connectivity to Zoho CRM
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Zoho CRM from an ASP.NET MVC application.
-
Object-Relational Mapping (ORM) with QuickBooks Time Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to QuickBooks Time into a Java-based ORM framework, Hibernate.
-
Access Live Google Calendar in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Calendar from your Excel spreadsheets.
-
Build OneNote-Powered Applications in Gemini Code Assist with CData Code Assist MCP
-