CData Software - Knowledge Base
Recent Articles
-
Edit and Search Dynamics 365 Business Central External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Dynamics 365 Business Central to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Dynamics 365 Business Central objects that you can access from apps and the dashboard.
-
Import Real-Time Oracle Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Oracle Database in ColdFusion.
-
Getting Started with the CData Python Connector for SageHR
Learn to install and license the CData Python Connector
-
Build Apollo-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData API Driver for MCP Server to explore live Apollo Data in Gemini Code Assist to assist with building Apollo-powered applications.
-
Analyze Live Dynamics CRM Data in SAS Viya
Use CData Connect AI to connect to Microsoft Dynamics CRM from SAS Viya and deploy self-service analytics using live Microsoft Dynamics CRM.
-
Connect to Live NetSuite Data in PostGresSQL Interface through CData Connect AI
Create a live connection to NetSuite in CData Connect AI and connect to your NetSuite CRM & ERP from PostgreSQL.
-
Replicate Multiple Float Accounts via the CData Sync CLI
Replicate multiple Float accounts to one or many databases.
-
Integrating LlamaIndex with ShipStation Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on ShipStation in real time.
-
Build Dashboards with MailerSend Data in DBxtra
Create dynamic dashboards and perform analytics based on MailerSend in DBxtra.
-
Automated Continuous Mailgun Replication to Databricks
Use CData Sync for automated, continuous, customizable Mailgun replication to Databricks.
-
Automated Continuous Raisers Edge NXT Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to Google Cloud SQL.
-
Access Live Supabase Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Supabase data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Use Azure AI Foundry to Talk to Your Asana Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Asana for you.
-
Analyze Tally Data in Cognos Analytics
Use CData Connect AI to connect to Tally Data from Cognos Analytics and analyze live Tally ERP.
-
Object-Relational Mapping (ORM) with HCL Domino Data 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 HCL Domino into a Java-based ORM framework, Hibernate.
-
Back Up Onfleet to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Onfleet data.
-
Connect Delighted to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Delighted with IBM WebSphere for seamless data integration and connectivity.
-
Query ActiveCampaign Data in ColdFusion
Write standard ColdFusion data access code to connect to ActiveCampaign.
-
Connect to Amazon DynamoDB Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Amazon DynamoDB and the Script function in FileMaker Pro to connect to Amazon DynamoDB and work with Amazon DynamoDB in your FileMaker application.
-
Use the CData ODBC Driver for PDFMonkey in Microsoft Power Query
You can use the CData PDFMonkey ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import PDFMonkey into Microsoft Power Query.
-
Connect to PivotalTracker Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for PivotalTracker in the Denodo Virtual DataPort Administrator.
-
Automated Continuous GitHub Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable GitHub replication to Google Cloud SQL.
-
Import Coda Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Coda. In this article, you will use the OData format to import Coda into Microsoft Power Query.
-
Build Voice Agents in ElevenLabs with access to Live Amazon DynamoDB Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Amazon DynamoDB.
-
Natively Connect to Sage Cloud Accounting Data in PHP
The CData ODBC driver for Sage Cloud Accounting enables you to create PHP applications with connectivity to Sage Business Cloud Accounting. Leverage the native support for ODBC in PHP.
-
Build Data Flows from SQL Server to Splunk through SSIS
Easily push SQL Server data to Splunk using the CData SSIS Tasks for Splunk.
-
Query Freshservice Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Freshservice from Node.js.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live SAP Hybris C4C using the Model Context Protocol.
-
Use the CData Software JDBC Driver for OData in MicroStrategy Web
Connect to OData in MicroStrategy Web using the CData Software JDBC Driver for OData.
-
Getting Started with the CData Tableau Connector for Yelp
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Connect to OnePageCrm Data in CloverDX (formerly CloverETL)
Transfer OnePageCrm using the visual workflow in the CloverDX data integration tool.
-
Connect to Cosmos DB Data in Claris FileMaker Pro
Use the CData ODBC Driver for Cosmos DB in FileMaker Pro to connect to Cosmos DB and work with Azure Cosmos DB in your FileMaker applications.
-
Connect to ADP Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with ADP Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Connect to Phoenix Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Apache Phoenix. Leverage the pyodbc module for ODBC in Python.
-
Connect to Dropbox Data in NetBeans
Connect to Dropbox in NetBeans with the data source configuration wizard.
-
Automate Power BI XMLA Data Replication to Azure Synapse
Use CData Sync to customize and automate Power BI XMLA replication to Azure Synapse.
-
How to create an RPA flow for Pinterest Data in UiPath Studio
Use the Pinterest ODBC Driver to create workflows that access real-time Pinterest without any coding.
-
How to Access Live OnePageCrm Data in Visual Studio Code via Cline
Run CData API Driver for MCP Server on Windows Subsytem for Linux (WSL) and connect to live OnePageCrm from the Cline extension in Visual Studio Code.
-
Access MongoDB Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live MongoDB from HeidiSQL.
-
Build SparkPost-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SparkPost and build web apps with connectivity to live SparkPost.
-
Automate SAP HANA Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live SAP HANA and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Build Charts with PivotalTracker Data in Clear Analytics
Create dynamic charts and perform analytics based on PivotalTracker in Clear Analytics.
-
Replicate LeadDesk Data from PowerShell
Write a quick PowerShell script to query LeadDesk. Use connectivity to the live data to replicate LeadDesk to SQL Server.
-
How to connect and process MailerSend from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live MailerSend.
-
Connecting GenSpark with Exact Online Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Exact Online without any replication or custom integration required.
-
Use Biml to Build SSIS Tasks to Replicate Tally Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Tally ERP to SQL Server.
-
Object-Relational Mapping (ORM) with QuickBooks Time Data 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.
-
Create Data Visualizations in Cognos BI with OpenWeatherMap Data
Access OpenWeatherMap as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Visualize Live PhantomBuster Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live PhantomBuster using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Publish MessageBird-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live MessageBird.
-
How to Connect DBeaver to SAP via a JDBC Driver
Manage SAP ERP/NetWeaver with visual tools in DBeaver like the query browser.
-
How to connect SharePoint with Yelp Data through external lists
Provide Yelp to SharePoint users as an external list.
-
How to Access Live Datadog Data in Visual Studio Code via Cline
Run CData API Driver for MCP Server on Windows Subsytem for Linux (WSL) and connect to live Datadog from the Cline extension in Visual Studio Code.
-
Integrate SAP Business Warehouse Data in Pentaho Data Integration
Build ETL pipelines based on SAP Business Warehouse in the Pentaho Data Integration tool.
-
How to connect Amazon QuickSight to Google Analytics Data
Create a connection to Google Analytics in CData Connect AI and insert Google Analytics into Amazon QuickSight SPICE to build interactive dashboards.
-
Create Power BI Reports on Real-Time HelloSign Data
Use the CData ODBC Driver for HelloSign to visualize HelloSign in Power BI Desktop.
-
Getting Started with the CData Tableau Connector for ServiceDesk Plus
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
How to Build an ETL App for ZohoInvoice Data in Python with CData
Create ETL applications and real-time data pipelines for ZohoInvoice in Python with petl.
-
Use the CData API Server to Access ServiceNow Data in Microsoft PowerPivot
Use the CData API Server to connect to live ServiceNow in the Power Pivot business intelligence tool.
-
Create Power BI Reports on Real-Time Accelo Data
Use the CData ODBC Driver for Accelo to visualize Accelo in Power BI Desktop.
-
Validate Auth0 Data with QuerySurge
Access and validate Auth0 in QuerySurge using the CData JDBC Driver.
-
How to Create Power BI Visual Reports with Real-Time Oracle HCM Cloud Data
Use CData Power BI Connectors to visualize Oracle HCM Cloud in Power BI.
-
Migrating data from CouchDB to Snowflake using CData SSIS Components.
Easily push Apache CouchDB to Snowflake using the CData SSIS Tasks for CouchDB and Snowflake.
-
Create SSAS Tabular Models from Oracle Eloqua Reporting Data
How to build a SQL Server Analysis Service Tabular Model from Oracle Eloqua Reporting using CData drivers.
-
Visualize Recurly Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Recurly.
-
How to Connect to Live Adobe Analytics Data 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 Adobe Analytics for you.
-
Publish Splunk-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Splunk.
-
Viewing Gmail Data in RAD Studio Data Explorer
How to view Gmail in RAD Studio Data Explorer using the CData ODBC Driver for Gmail.
-
Automated Continuous Mode Replication to Vertica
Use CData Sync for automated, continuous, customizable Mode replication to Vertica.
-
Integrate Open WebUI with Live Google Ad Manager Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Google Ad Manager from within the chat interface.
-
Automated Continuous Sage Intacct Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Sage Intacct replication to Google BigQuery.
-
Replicate Multiple SendGrid Accounts
Replicate multiple SendGrid accounts to one or many databases.
-
Create JSON-Connected Business Apps in AppSheet
Connect to JSON Services via CData Connect AI in Google AppSheet and create custom business applications with real-time access to JSON.
-
Query NetSuite Data in DataGrip
Create a Data Source for NetSuite in DataGrip and use SQL to query live NetSuite CRM & ERP.
-
How to Connect to Live DB2 Data 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 IBM DB2 for you.
-
Analyze Jira Assets Data in Cognos Analytics
Use CData Connect AI to connect to Jira Assets Data from Cognos Analytics and analyze live Jira Assets.
-
Create SAP ByDesign-Connected Applications in Appsmith
Connect to SAP ByDesign Data via CData Connect AI in Appsmith and create custom business applications with real-time access to SAP Business ByDesign.
-
How to Seamlessly Import Azure Data Catalog Data into IBM SPSS Modeler
Integrate Azure Data Catalog data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrate Live Google Spanner Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Connect to CockroachDB Data 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 CockroachDB.
-
Build Coinbase-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Coinbase and build web apps with connectivity to live Coinbase.
-
Integrate with SAP Ariba Source Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SAP Ariba Source to a JSON file on disk.
-
Create Power BI Reports on Real-Time Typeform Data
Use the CData ODBC Driver for Typeform to visualize Typeform in Power BI Desktop.
-
Provide OData Services of Impala Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Apache Impala by developing a WCF Service Application.
-
Choosing the Best Method to Connect SAP ByDesign to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SAP Business ByDesign from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Access FTP Data from MySQL in Amazon QuickSight
Connect to FTP and build visualizations of FTP Servers using a MySQL Connection in Amazon QuickSight.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Salesloft
Provide connectivity to Salesloft through an SAP BusinessObjects universe.
-
Getting Started with the CData SSIS Components for Google Translate
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Google Translate.
-
Query Omnisend Data in DataGrip
Create a Data Source for Omnisend in DataGrip and use SQL to query live Omnisend.
-
Build Dashboards with SAP Hybris C4C Data in Dundas BI
Create dynamic dashboards and perform analytics based on SAP Hybris C4C in Dundas BI.
-
Automated Continuous Mode Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Mode replication to Amazon S3.
-
Connect to Oracle Data in DBeaver
Use the CData ODBC Driver to connect to Oracle Database in DBeaver.
-
Validate Tally Data with QuerySurge
Access and validate Tally ERP in QuerySurge using the CData JDBC Driver.
-
Build Azure Table-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Azure Table Storage and build web apps with connectivity to live Azure Table Storage.
-
Getting Started with the CData ODBC Driver for Everhour
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Everhour.
-
Integrating LlamaIndex with Oracle Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Oracle Database in real time.
-
Figshare Reporting in OBIEE with the Figshare JDBC Driver
Deploy the Figshare JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Object-Relational Mapping (ORM) with RabbitMQ Data 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 RabbitMQ into a Java-based ORM framework, Hibernate.
-
Bind Live Demio Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Demio data
-
Getting Started with the CData JDBC Driver for Office 365
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Office 365.