CData Software - Knowledge Base
Recent Articles
-
Create SSAS Tabular Models from SAP Ariba Source Data
How to build a SQL Server Analysis Service Tabular Model from SAP Ariba Source using CData drivers.
-
Perform Batch Operations with eBay Data in Apache NiFi
Connect to eBay and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Operational Reporting on Dynamics 365 Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Microsoft Dynamics 365.
-
Access Live SAP SuccessFactors LMS Data in AWS Lambda (with IntelliJ IDEA)
Connect to live SAP SuccessFactors LMS in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use Dash to Build to Web Apps on Vault CRM Data
Create Python applications that use pandas and Dash to build Vault CRM-connected web apps.
-
Create Data Visualizations in Cognos BI with Toggl Data
Access Toggl as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to create an RPA flow for RSS Feeds in UiPath Studio
Use the RSS ODBC Driver to create workflows that access real-time RSS Feeds without any coding.
-
Model, Search, and Visualize Live SingleStore Data in ThoughtSpot
Use CData Connect AI to connect to live SingleStore for modeling, searching, and visualizing.
-
Build Apps with Live FTP Servers in Adalo using CData Connect AI
Use CData Connect AI to integrate live FTP Servers into the Adalo platform and build custom mobile and web applications with real-time FTP Servers.
-
How to Connect to Live Authorize.Net Data 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 Authorize.Net for you.
-
Use Claude to Talk to Your SurveyMonkey Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your SurveyMonkey for you.
-
How to Connect to Live Microsoft Exchange Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Microsoft Exchange without replication.
-
Use the CData Software JDBC Driver for Freshteam in MicroStrategy Web
Connect to Freshteam in MicroStrategy Web using the CData Software JDBC Driver for Freshteam.
-
Migrating data from Tavily to Databricks using CData SSIS Components.
Easily push Tavily to Databricks using the CData SSIS Tasks for Tavily and Databricks.
-
Migrating data from Superchat to Databricks using CData SSIS Components.
Easily push Superchat to Databricks using the CData SSIS Tasks for Superchat and Databricks.
-
Automated Continuous Wistia Replication to MongoDB
Use CData Sync for automated, continuous, customizable Wistia replication to MongoDB.
-
Build Azure Data Lake Storage-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Azure Data Lake Storage to explore live Azure Data Lake Storage Data in Cursor to assist with building Azure Data Lake Storage-powered applications.
-
Automated Continuous ZohoExpense Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable ZohoExpense replication to OneLake in Microsoft Fabric.
-
How to Connect to & Open Exa Data in Microsoft Excel
This article uses the CData ODBC driver for Exa to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Microsoft OneDrive-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Microsoft OneDrive and build web apps with connectivity to live Microsoft OneDrive.
-
How to work with Dynamics CRM Data in Apache Spark using SQL
Access and process Dynamics CRM Data in Apache Spark using the CData Software JDBC Driver.
-
Create Dynamic CloudConvert Grids Using the Infragistics XamDataGrid
Learn how you can connect CloudConvert to Infragistics XamDataGrid to build dynamic grids.
-
Load QuickBooks Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load QuickBooks Desktop to a database.
-
Use the CData ODBC Driver for ADP in Microsoft Power Query
You can use the CData ADP ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import ADP into Microsoft Power Query.
-
View Reports on Real-Time Intercom Data in Power BI Report Server
Use the CData ODBC Driver for Intercom to visualize Intercom in Power BI Desktop and then publish them to Power BI Report Server.
-
Build Data Flows from CircleCI to SQL Server using SSIS
Easily back up CircleCI to SQL Server using the SSIS components for CircleCI.
-
Build MailerLite-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to MailerLite and build web apps with connectivity to live MailerLite.
-
Connect to SAP HANA Data in DBArtisan
Use wizards in DBArtisan to configure SAP HANA as a data source.
-
Prepare, Blend, and Analyze Vault CRM Data in Alteryx Designer (Connect AI)
Build workflows to access live Veeva Vault & Vault CRM for self-service data analytics.
-
Build Automated Workflows with Live Google Cloud Storage Data in Workato
Use CData Connect AI to connect to live Google Cloud Storage and build automated workflows in Workato.
-
Connect to TigerGraph Data from a Connection Pool in Jetty
The TigerGraph JDBC Driver supports connection pooling: This article shows how to connect faster to TigerGraph from Web apps in Jetty.
-
Build an OLAP Cube in SSAS from Typeform Data
Establish a connection to Typeform data from SQL Server Analysis Services, and use the Typeform Data Provider to build OLAP cubes for use in analytics and reporting.
-
Getting Started with the CData Power BI Connector for Coda
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Back Up Authorize.Net to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Authorize.Net. In this article, we will employ an SSIS workflow to populate a database with Authorize.Net data.
-
Use the CData SSIS Components to Insert New or Update Existing Certinia Records from SQL Server
Easily push SQL Server data to Certinia using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Certinia or update existing records with data from a SQL Server database.
-
Getting Started with the CData JDBC Driver for CloudConvert
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for CloudConvert.
-
Bind Live Sage Intacct Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Sage Intacct data
-
Automate Campaigner Data Replication to Azure Synapse
Use CData Sync to customize and automate Campaigner replication to Azure Synapse.
-
Extract, Transform, and Load Postmark Data in Informatica PowerCenter
Create a simple Workflow for Postmark in Informatica PowerCenter.
-
Creating Oracle HCM Cloud-Connected Applications in Unqork
You can use CData Connect AI to feed Oracle HCM Cloud to Unqork and build custom business apps.
-
Connect to EnterpriseDB Data in Aqua Data Studio
Access EnterpriseDB from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Rapidly Develop SAP Netweaver Gateway-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 SAP Netweaver Gateway.
-
Build AI/ML Models with Live Pipeline CRM Data using Dataiku
Connect Pipeline CRM Data with Dataiku using the CData API Driver for JDBC.
-
Create Eventbrite Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Eventbrite data access from reports, embedded analytics, and more.
-
Stream Everhour Data into Apache Kafka Topics
Access and stream Everhour in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous Avalara AvaTax Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to Amazon S3.
-
Use the CData ODBC Driver for Zoho Creator in Microsoft Power Query
You can use the CData Zoho Creator ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Zoho Creator into Microsoft Power Query.
-
Build MVC Applications with Connectivity to Sage Intacct Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Sage Intacct from an ASP.NET MVC application.
-
Connect to Live MariaDB Data in MicroStrategy through CData Connect AI
Create a live connection to MariaDB Data in CData Connect AI and connect to your MariaDB from MicroStrategy.
-
Connect to and Query SAP Business Warehouse Data in QlikView over ODBC
Create data visualizations with SAP Business Warehouse in QlikView.
-
Use the CData Software JDBC Driver for ZohoSubscriptions in MicroStrategy Desktop
Connect to ZohoSubscriptions in MicroStrategy Desktop using the CData Software JDBC Driver for ZohoSubscriptions.
-
Visualize Tally Data in Tableau
The CData ODBC driver for Tally enables you integrate Tally ERP into Tableau dashboards.
-
Integrate Real-Time Access to SAP Business Warehouse in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SAP Business Warehouse in real time.
-
Connect to Snowflake Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Snowflake in Airbyte.
-
How to Access Live SAP SuccessFactors Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SAP SuccessFactors enables you to integrate SAP SuccessFactors into workflows built using Microsoft Power Automate Desktop.
-
Getting Started with the CData SSIS Components for Discord
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Discord.
-
How to work with Power BI XMLA Data in Apache Spark using SQL
Access and process Power BI XMLA Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Nethunt Data in NetBeans
Connect to Nethunt in NetBeans with the data source configuration wizard.
-
Query Wistia Data as a MySQL Database in Node.js
Execute MySQL queries against Wistia from Node.js.
-
Connect to Real-Time Cohere Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Cohere in Power Apps.
-
Automated Continuous Tanda Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Tanda replication to OneLake in Microsoft Fabric.
-
Integrate Odoo with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Odoo with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Odoo ERP.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live SAP BusinessObjects BI within intelligent workflows.
-
Create Datasets from Dropbox in Domo Workbench and Build Visualizations of Dropbox Data in Domo
Use the CData Software ODBC Driver for Dropbox to create datasets from Dropbox in Domo Workbench and then build visualizations in the Domo service.
-
LINQ to Microsoft Planner Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Microsoft Planner Data Provider.
-
Connect to Microsoft Dataverse Data in NetBeans
Connect to Microsoft Dataverse (CDS) in NetBeans with the data source configuration wizard.
-
Using the CData Software ODBC Driver for XML in PyCharm
Connect to XML as an ODBC data source in PyCharm using the CData Software ODBC Driver for XML.
-
How to Connect DBeaver to Bannerbear via a JDBC Driver
Manage Bannerbear with visual tools in DBeaver like the query browser.
-
Connect to RSS Feeds in JRuby
Create a simple JRuby app with access to live RSS Feeds.
-
Integrate LaunchDarkly with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate LaunchDarkly with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to LaunchDarkly.
-
Create LionDesk Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time LionDesk data access from reports, embedded analytics, and more.
-
Integrate Live DB2 Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to IBM DB2 and integrate live IBM DB2 into apps built in Microsoft Power Apps.
-
How to Work with Microsoft OneDrive Data in AWS Glue Jobs Using JDBC
Connect to Microsoft OneDrive from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Access Live Cassandra Data in Coginiti Pro
Connect to and query live Apache Cassandra from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to SAP Hybris C4C Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live SAP Hybris C4C.
-
Deploy the ADO.NET Provider for HBase on an SSRS Report Server
Connect to Apache HBase 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.
-
Use the CData Software JDBC Driver for Datadog in MicroStrategy
Connect to Datadog in MicroStrategy Developer using the CData Software JDBC Driver for Datadog.
-
How to Connect to Live Freshservice 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 Freshservice for you.
-
Connect Act CRM Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Act CRM using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Adobe Experience Manager Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Adobe Experience Manager.
-
Access Demio Data from MySQL in PHP
Connect to Demio through the standard MySQL libraries in PHP.
-
Create SAP Netweaver Gateway Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SAP Netweaver Gateway from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to connect to Microsoft Entra ID Data with Squirrel SQL client
Connect to Microsoft Entra ID and execute queries in the Squirrel SQL Client.
-
Build Paylocity-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Paylocity Data and create custom apps in Mendix.
-
Use Biml to Build SSIS Tasks to Replicate Bullhorn CRM Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Bullhorn CRM to SQL Server.
-
Connecting GenSpark with Salesforce Pardot Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Salesforce Pardot without any replication or custom integration required.
-
Getting Started with the CData ADO.NET Provider for Auth0
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Access SAP Hybris C4C Data from MySQL in Amazon QuickSight
Connect to SAP Hybris C4C and build visualizations of SAP Hybris C4C using a MySQL Connection in Amazon QuickSight.
-
Create Data Visualizations in Cognos BI with Campaigner Data
Access Campaigner as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build Dashboards with Postmark Data in DBxtra
Create dynamic dashboards and perform analytics based on Postmark in DBxtra.
-
How to Visualize BigCommerce 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 BigCommerce in Python.
-
Integrate RabbitMQ Data in the Pentaho Report Designer
Publish reports based on RabbitMQ in the Pentaho BI tool.
-
Build Automated Twitter Ads-Connected Workflows in Zapier
Use CData Connect AI to connect to live Twitter Ads and build automated workflows in Zapier.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Freshdesk
Provide connectivity to Freshdesk through an SAP BusinessObjects universe.
-
Connect to Neo4J Data 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.
-
Import Real-Time SAS xpt Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SAS XPORT in ColdFusion.
-
Connect to Teradata Data in DBeaver
Use the CData ODBC Driver to connect to Teradata in DBeaver.
-
Use the CData Software ODBC Driver for Supabase in MicroStrategy
Connect to Supabase in MicroStrategy Developer using the CData Software ODBC Driver for Supabase.
-
Connecting Mastra with Google Ad Manager Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Google Ad Manager, no replication required.
-
Access Live Microsoft Dataverse Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Microsoft Dataverse data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.