CData Software - Knowledge Base
Recent Articles
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for DocuSign
Provide connectivity to DocuSign through an SAP BusinessObjects universe.
-
Create Facebook Ads-Connected Dashboards in Grafana
Connect to Facebook Ads Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Facebook Ads.
-
Use the CData Software ODBC Driver for EnterpriseDB in MicroStrategy
Connect to EnterpriseDB in MicroStrategy Developer using the CData Software ODBC Driver for EnterpriseDB.
-
Automated Continuous CockroachDB Replication to MongoDB
Use CData Sync for automated, continuous, customizable CockroachDB replication to MongoDB.
-
Build Neo4J Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Neo4J and build visualizations in Tableau Cloud.
-
Connect to Deel Data in DBArtisan
Use wizards in DBArtisan to configure Deel as a data source.
-
Access Live SendPulse Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SendPulse into the statistical analysis tools available in SAS JMP. This article shows how to use SendPulse in the Graph Builder and Query Builder.
-
Connect and Visualize Live Avro Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Apache Avro into the Databricks platform and create visualization dashboards with real-time Apache Avro.
-
Integrate Active Directory with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Active Directory with External Services.
-
Connect to Notion Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Notion as an External Source in Dremio.
-
Integrate with Microsoft OneDrive Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Microsoft OneDrive in SnapLogic.
-
Integrate with Live Vault CRM Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Vault CRM from the MuleSoft Anypoint Platform to integrate live Veeva Vault & Vault CRM into custom reports and dashboards.
-
Create Dynamic Datadog Grids Using the Infragistics XamDataGrid
Learn how you can connect Datadog to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Postmark Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Postmark using standard SQL.
-
Model Salesforce Pardot Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Salesforce Pardot, enabling the direct import of real-time Salesforce Pardot.
-
Front Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Front facts in real time.
-
Connecting Moonlit Workflow with Zendesk Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Zendesk in real time.
-
Getting Started with the CData Power BI Connector for Simplesat
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Visualize Gumroad Data in TIBCO Spotfire through ADO.NET
Integrate Gumroad into dashboards in TIBCO Spotfire.
-
Connect to Sage 300 Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Sage 300 to connect to Sage 300 and execute queries in PowerBuilder.
-
Consume Redshift OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Redshift feeds that reflect any changes in SAP Lumira.
-
Create SSAS Tabular Models from MailChimp Data
How to build a SQL Server Analysis Service Tabular Model from MailChimp using CData drivers.
-
Build ZendeskSell-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live ZendeskSell.
-
Create Xero-Connected Business Apps in AppSheet
Connect to Xero Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Xero Accounting.
-
Connect Guru to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Guru with IBM WebSphere for seamless data integration and connectivity.
-
Use the CData Software ODBC Driver for Salesforce in MicroStrategy
Connect to Salesforce & Force.com in MicroStrategy Developer using the CData Software ODBC Driver for Salesforce.
-
Automate Kintone Data Replication to Azure Data Lake
Use CData Sync to customize and automate Kintone replication to Azure Data Lake.
-
Connect to Real-Time Missive Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Missive in Power Apps.
-
Automated Continuous Splunk Replication to Vertica
Use CData Sync for automated, continuous, customizable Splunk replication to Vertica.
-
Create Microsoft Dataverse Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Microsoft Dataverse from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Dynamics CRM Data from AWS Glue
Use CData Connect AI to gain access to live Microsoft Dynamics CRM from your AWS Glue jobs.
-
Build Semantic Layer Views for Excel Online Data in APOS Live Data Gateway
Use the CData Connector for Excel Online in APOS Live Data Gateway to build Semantic Layer Views for Microsoft Excel Online.
-
Connect to SharePoint Excel Services Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for SharePoint Excel Services.
-
Create Data Visualizations in Cognos BI with TaxJar Data
Access TaxJar as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to HCL Domino Data from a Connection Pool in Jetty
The HCL Domino JDBC Driver supports connection pooling: This article shows how to connect faster to HCL Domino from Web apps in Jetty.
-
Automated Continuous DB2 Replication to SingleStore
Use CData Sync for automated, continuous, customizable DB2 replication to SingleStore.
-
Create FormSite Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time FormSite data access from reports, embedded analytics, and more.
-
Add Azure Data Lake Storage Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Azure Data Lake Storage with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Query Notion Data in MySQL Workbench
Execute MySQL queries against live Notion from MySQL Workbench.
-
Use the CData Software ODBC Driver for Dynamics CRM in MicroStrategy Desktop
Connect to Microsoft Dynamics CRM in MicroStrategy Desktop using the CData Software ODBC Driver for Dynamics CRM.
-
Create Foursquare Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Foursquare from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build Data Flows from SQL Server to ADP through SSIS
Easily push SQL Server data to ADP using the CData SSIS Tasks for ADP.
-
How to Build an ETL App for Salesforce Data in Python with CData
Create ETL applications and real-time data pipelines for Salesforce & Force.com in Python with petl.
-
How to Access Live Cloudant Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Cloudant enables you to integrate IBM Cloudant into workflows built using Microsoft Power Automate Desktop.
-
Natively Connect to Strava Data in PHP
The CData ODBC driver for Strava enables you to create PHP applications with connectivity to Strava. Leverage the native support for ODBC in PHP.
-
Connecting GenSpark with OneNote Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Microsoft OneNote without any replication or custom integration required.
-
Connecting Moonlit Workflow with Dynamics 365 Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Microsoft Dynamics 365 in real time.
-
Connect to Okta Data in ACL Analytics
Connect to Okta via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Okta.
-
Connect to MariaDB Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with MariaDB Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Getting Started with the CData Excel Add-In for Parallel
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Parallel.
-
Build SurveyMonkey-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for SurveyMonkey to explore live SurveyMonkey Data in Gemini Code Assist to assist with building SurveyMonkey-powered applications.
-
Integrate Live SQL Analysis Services Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to SQL Analysis Services and integrate live SQL Analysis Services into apps built in Microsoft Power Apps.
-
Import Real-Time Billsby Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Billsby in ColdFusion.
-
Working with SFTP Data in LINQPad
Execute LINQ queries to SFTP in LINQPad.
-
Seamlessly Bring LinkedIn Data into Retool Using CData Connect AI
Integrate LinkedIn data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Automated Continuous Apify Replication to Oracle
Use CData Sync for automated, continuous, customizable Apify replication to Oracle.
-
Import and Visualize CloudConvert Data in Power View
Create data visualizations based on CloudConvert in Excel.
-
Replicate Accelo Data in Heroku for Use in Salesforce Connect
Replicate Accelo to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Validate Jira Assets Data with QuerySurge
Access and validate Jira Assets in QuerySurge using the CData JDBC Driver.
-
How to Query Live Salesforce Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Salesforce & Force.com data in natural language using Python.
-
Create Informatica Mappings From/To a JDBC Data Source for Zoho CRM
Create Zoho CRM data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Bidirectional Access to Outreach.io Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Outreach.io in Filemaker Pro for Mac or Windows.
-
Connect to and Query FormSite Data in QlikView over ODBC
Create data visualizations with FormSite in QlikView.
-
Use the CData ODBC Driver for MailerSend in Microsoft Power Query
You can use the CData MailerSend ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import MailerSend into Microsoft Power Query.
-
Consume Dynamics 365 OData Feeds in PowerBuilder
This article demonstrates how to consume Microsoft Dynamics 365 as OData feeds from PowerBuilder using the API Server.
-
Connect to Mailjet Data in Jaspersoft Studio
Execute SQL to remote Mailjet in Jaspersoft Studio.
-
How to Query Live SAP Hybris C4C Data in Perplexity MacOS Desktop
Connect to and query live SAP Hybris C4C Data in Perplexity Desktop using CData MCP Server.
-
Deploy the ADO.NET Provider for Suadeo on an SSRS Report Server
Connect to Suadeo 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.
-
Enable the Pipeliner CRM JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Pipeliner CRM.
-
DataBind Charts to AlloyDB Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Google AlloyDB 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.
-
Validate Drip Data with QuerySurge
Access and validate Drip in QuerySurge using the CData JDBC Driver.
-
How to Access Sage Intacct Data Using Entity Framework
This article shows how to access Sage Intacct using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Use the CData Software ODBC Driver for Autopilot in MicroStrategy
Connect to Autopilot in MicroStrategy Developer using the CData Software ODBC Driver for Autopilot.
-
How to Visualize JobNimbus Data in Python with pandas
Use pandas and other modules to analyze and visualize live JobNimbus in Python.
-
Build Adobe Experience Manager-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Adobe Experience Manager and build web apps with connectivity to live Adobe Experience Manager.
-
How to Connect DBeaver to Zoho Creator via a JDBC Driver
Manage Zoho Creator with visual tools in DBeaver like the query browser.
-
Connect to SAP HANA XS Advanced Data in JRuby
Create a simple JRuby app with access to live SAP HANA XS Advanced.
-
A PostgreSQL Interface for PingOne Data using the CData ODBC Driver
Use the SQL Gateway and PingOne ODBC Driver to create a PostgreSQL entry-point for data access.
-
Create MailChimp Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time MailChimp data access from reports, embedded analytics, and more.
-
Automated Continuous DB2 Replication to SQLite
Use CData Sync for automated, continuous, customizable DB2 replication to SQLite.
-
How to Build an ETL App for Elasticsearch Data in Python with CData Connect AI
Build ETL pipelines that read and write live Elasticsearch in Python with petl and the CData Connect AI Python SDK.
-
Build AI Agents with Jira Assets Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Jira Assets through CData Connect AI.
-
Connect to Datadog Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Datadog.
-
Integrating Dynamics 365 Business Central Data in Talend Cloud Data Management Platform
Connect Dynamics 365 Business Central Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Dynamics 365 Business Central.
-
Natively Connect to Azure Data Lake Storage Data in PHP
The CData ODBC driver for Azure Data Lake Storage enables you to create PHP applications with connectivity to Azure Data Lake Storage. Leverage the native support for ODBC in PHP.
-
Build Pipelines with Live Salesforce CRM Analytics Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Salesforce CRM Analytics from Google Cloud Data Fusion, enabling the integration of live Salesforce CRM Analytics into the building and management of effective data pipelines.
-
Bidirectional Access to Facebook Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Facebook in Filemaker Pro for Mac or Windows.
-
Extend Google Sheets with Azure Synapse Data
Make calls to Azure Synapse from Google Apps Script via the API Server.
-
Build Charts with Qualaroo Data in Clear Analytics
Create dynamic charts and perform analytics based on Qualaroo in Clear Analytics.
-
Build MVC Applications with Connectivity to JSON Services
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access JSON from an ASP.NET MVC application.
-
Connect to HelloSign Data from a Connection Pool in Jetty
The HelloSign JDBC Driver supports connection pooling: This article shows how to connect faster to HelloSign from Web apps in Jetty.
-
Analyze OpenWeatherMap Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze OpenWeatherMap with the CData JDBC Driver for OpenWeatherMap.
-
Create Apps from Square Data in Qlik Sense Cloud
Use CData Connect AI to connect to Square Data and build apps from live Square in Qlik Sense Cloud.
-
Getting Started with the CData Excel Add-In for SAP Fieldglass
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SAP Fieldglass.
-
How to use SQLAlchemy ORM to access Chargebee Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Chargebee.
-
DataBind Charts to ServiceNow Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to ServiceNow 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.
-
Build Certinia-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Certinia to explore live Certinia Data in Gemini Code Assist to assist with building Certinia-powered applications.
-
Viewing Superchat Data in RAD Studio Data Explorer
How to view Superchat in RAD Studio Data Explorer using the CData ODBC Driver for Superchat.
-
Enable the Microsoft Dataverse JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Microsoft Dataverse (CDS).
-
Build Microsoft Teams-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Microsoft Teams to explore live Microsoft Teams Data in GitHub Copilot to assist with building Microsoft Teams-powered applications.