CData Software - Knowledge Base
Recent Articles
-
Use Biml to Build SSIS Tasks to Replicate ZendeskSell Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate ZendeskSell data to SQL Server.
-
Explore Geographical Relationships in Factorial Data with Power Map
Create data visualizations with Factorial data in Power Map.
-
Getting Started with the CData Power BI Connector for Couchbase
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Couchbase.
-
Manage Azure DevOps Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Azure DevOps.
-
Analyze Anaplan Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Anaplan from Power Pivot. You will use the Table Import Wizard to load Anaplan data. You can visually build the import query or use any SQL supported by the driver.
-
Access Live Accelo Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Accelo data into the statistical analysis tools available in SAS JMP. This article shows how to use Accelo data in the Graph Builder and Query Builder.
-
Integrate Gong Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Gong data and integrate live Gong data into your Power Automate tasks.
-
Connect to PayPal Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live PayPal data.
-
Use Biml to Build SSIS Tasks to Replicate Teradata Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Teradata data to SQL Server.
-
Connect to Mistral AI Data in RapidMiner
Integrate Mistral AI data with standard components and data source configuration wizards in RapidMiner Studio.
-
Publish Placid-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Placid data.
-
Use the CData Software JDBC Driver for Tickspot in MicroStrategy Desktop
Connect to Tickspot data in MicroStrategy Desktop using the CData Software JDBC Driver for Tickspot.
-
How to Connect Zoho Inventory Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Zoho Inventory data in real time using natural language.
-
DataBind Controls to SQL Analysis Services Data in Delphi
DataBind to SQL Analysis Services data in Delphi with standard data access components and controls.
-
Build MVC Applications with Connectivity to SAP Ariba Source Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SAP Ariba Source from an ASP.NET MVC application.
-
Create Bright Data-Connected Nintex Workflows
Use CData Connect AI to connect to Bright Data Data from Nintex Workflow Cloud and build custom workflows using live Bright Data data.
-
Access ZohoInvoice Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for ZohoInvoice data.
-
Create Bitbucket Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Bitbucket from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrating Keap Data in Talend Cloud Data Management Platform
Connect Keap Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Integrate LibreChat with Live Moosend Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Moosend data from within the chat interface.
-
Connect to Scrapfly Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Scrapfly data.
-
Connect to OpenWeatherMap Data in DBArtisan
Use wizards in DBArtisan to configure OpenWeatherMap data as a data source.
-
Prepare, Blend, and Analyze Smartsheet Data in Alteryx Designer (Connect AI)
Build workflows to access live Smartsheet data for self-service data analytics.
-
Explore Geographical Relationships in Oracle HCM Cloud Data with Power Map
Create data visualizations with Oracle HCM Cloud data in Power Map.
-
Create a Data Access Object for Azure Table Data using JDBI
A brief overview of creating a SQL Object API for Azure Table data in JDBI.
-
Integrating LlamaIndex with Oracle Sales 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 Sales data in real time.
-
Build Charts with Presto Data in Clear Analytics
Create dynamic charts and perform analytics based on Presto data in Clear Analytics.
-
Analyze Jira Assets Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Jira Assets data in Microsoft R Open.
-
Access Contentful Data from MySQL in Amazon QuickSight
Connect to Contentful and build visualizations of Contentful data using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous Salesforce Marketing Replication to Vertica
Use CData Sync for automated, continuous, customizable Salesforce Marketing replication to Vertica.
-
Work with Live Slack Data in Power Query
Use CData Connect AI to connect to Slack data and work with live Slack data in Microsoft Power Query.
-
Connect to AfterShip from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from AfterShip data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Integrate OpenCode with Live Optimizely Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Optimizely data from within your AI coding agent.
-
Moving Data from QuickBooks to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live QuickBooks data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build an OLAP Cube in SSAS from NASA Data
Establish a connection to NASA data data from SQL Server Analysis Services, and use the NASA Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Google Ads Data in ACL Analytics
Connect to Google Ads data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Google Ads data.
-
Prepare, Blend, and Analyze Oracle Eloqua Reporting Data in Alteryx Designer (ODBC)
Build workflows to access live Oracle Eloqua Reporting data for self-service data analytics.
-
Edit and Search External MarkLogic Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of MarkLogic data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create MarkLogic Data objects that you can access from apps and the dashboard.
-
Rapidly Develop PabblySubscriptions-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 PabblySubscriptions.
-
Build Apps with Live Workable Data Using the Low-Code Development Platform of Mendix
Connect Workable data with Mendix to build apps using the CData API Driver for JDBC.
-
Getting Started with the CData SSIS Components for Facebook Ads
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Facebook Ads.
-
Model, Search, and Visualize Live Twitter Ads Data in ThoughtSpot
Use CData Connect AI to connect to live Twitter Ads data for modeling, searching, and visualizing.
-
Access Live EnterpriseDB Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live EnterpriseDB data from your Excel spreadsheets.
-
Connect to Oracle Sales Data in Aqua Data Studio
Access Oracle Sales data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
ETL SingleStore in Oracle Data Integrator
This article shows how to transfer SingleStore data into a data warehouse using Oracle Data Integrator.
-
Create HDFS Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time HDFS data access from reports, embedded analytics, and more.
-
Integrate with Live QuickBooks Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to QuickBooks from the MuleSoft Anypoint Platform to integrate live QuickBooks data into custom reports and dashboards.
-
Automate Mistral AI Data Replication to Azure Synapse
Use CData Sync to customize and automate Mistral AI data replication to Azure Synapse.
-
Design BIRT Reports on SharePoint Excel Services Data
Provide current SharePoint Excel Services data to your embedded analytics.
-
Build a PostgreSQL Interface for SharePoint Data using the CData JDBC Driver
Use the Remoting features of the SharePoint JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automate Google Ads Data Replication to Azure Data Lake
Use CData Sync to customize and automate Google Ads data replication to Azure Data Lake.
-
Integrate Microsoft Exchange Data in the Pentaho Report Designer
Publish reports based on Microsoft Exchange data in the Pentaho BI tool.
-
Build Data Flows from CockroachDB to SQL Server using SSIS
Easily back up CockroachDB data to SQL Server using the SSIS components for CockroachDB.
-
Import AlloyDB Data Using Azure Data Factory
Use CData Connect AI to connect to AlloyDB Data from Azure Data Factory and import live AlloyDB data.
-
Replicate MessageBird Data to Multiple Databases via the CData Sync CLI
Replicate MessageBird data to disparate databases with a single configuration.
-
How to Work with Apollo Data in AWS Glue Jobs Using JDBC
Connect to Apollo from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous Yelp Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Yelp replication to PostgreSQL.
-
Access Live Retently Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Retently data into the statistical analysis tools available in SAS JMP. This article shows how to use Retently data in the Graph Builder and Query Builder.
-
Visualize Live Monday.com Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Monday.com data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Visualize Live Microsoft Dataverse Data in the Power BI Service
Use CData Connect AI to connect to live Microsoft Dataverse data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create SSAS Tabular Models from Exact Online Data
How to build a SQL Server Analysis Service Tabular Model from Exact Online data using CData drivers.
-
Connect to and Visualize Live Bright Data Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Bright Data data.
-
Getting Started with the CData JDBC Driver for Cohere
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Cohere.
-
Connect to SAP SuccessFactors Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to SAP SuccessFactors.
-
Natively Connect to ZohoDesk Data in PHP
The CData ODBC driver for ZohoDesk enables you to create PHP applications with connectivity to ZohoDesk data. Leverage the native support for ODBC in PHP.
-
How to import Clockify Data into Apache Solr
Use the CData Software JDBC Driver for Clockify in Data Import Handler and create an automated import of Clockify data to Apache Solr Enterprise Search platform.
-
Create Informatica Mappings From/To an ODBC Data Source for Smartsheet
Create an ODBC connection to Smartsheet in Informatica and browse and transfer Smartsheet data.
-
Getting Started with the CData Excel Add-In for Reckon
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Reckon.
-
Choosing the Best Method to Connect Nethunt to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Nethunt data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Access Live Microsoft Planner Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Microsoft Planner data into the statistical analysis tools available in SAS JMP. This article shows how to use Microsoft Planner data in the Graph Builder and Query Builder.
-
How to Connect to Live Freshdesk Data 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 Freshdesk data for you.
-
Object-Relational Mapping (ORM) with OpenWeatherMap 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 OpenWeatherMap data into a Java-based ORM framework, Hibernate.
-
Query ElevenLabs Data through ODBC in Node.js
Use node-odbc to execute SQL queries against ElevenLabs data from Node.js.
-
Connect to Live Oracle Eloqua Data in MicroStrategy through CData Connect AI
Create a live connection to Oracle Eloqua Data in CData Connect AI and connect to your Oracle Eloqua data from MicroStrategy.
-
How to Connect to Live Typeform Data 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 Typeform data for you.
-
Connect SurveyMonkey to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SurveyMonkey with IBM WebSphere for seamless data integration and connectivity.
-
Use the CData Software ODBC Driver for Teamwork in MicroStrategy Web
Connect to Teamwork data in MicroStrategy Web using the CData Software ODBC Driver for Teamwork.
-
Connect to Real-Time FHIR Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for FHIR and Dataflow to import and use FHIR data in Power Apps.
-
Import Adobe Analytics Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Adobe Analytics Data and provide access to live Adobe Analytics data for custom reports in the Power BI Service.
-
Connect to Wrike Data in RazorSQL
Connect to Wrike from wizards and query Wrike data from the GUI in the RazorSQL database management tool.
-
Visualize Live Moosend Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Moosend data.
-
Connect to Jumpseller Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Jumpseller data in Airbyte.
-
Connect and Visualize Live SAP SuccessFactors Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live SAP SuccessFactors data into the Databricks platform and create visualization dashboards with real-time SAP SuccessFactors data.
-
How to connect to IBM Cloud Object Storage Data from Spring Boot
Connect to IBM Cloud Object Storage in a Spring Boot Application using the CData JDBC Driver for IBM Cloud Object Storage
-
Easily Integrate FormSite Data in Lazarus Pascal IDE
Learn how to easily integrate live FormSite data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build Dynamics 365 Business Central-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Dynamics 365 Business Central Data and create custom apps in Bubble.
-
Connecting Agentforce with Blackbaud FE NXT Data 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 Blackbaud FE NXT data for you.
-
Access Live Salesforce Pardot Data in Coginiti Pro
Connect to and query live Salesforce Pardot data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Trigger Google Ad Manager IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Google Ad Manager with standard wizards in Logic Apps.
-
Seamlessly Bring JSON Services into Retool Using CData Connect AI
Integrate JSON data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Access Live Klaviyo Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Klaviyo data from your Google Sheets.
-
Access Live ZendeskSell Data in Coginiti Pro
Connect to and query live ZendeskSell data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to integrate CockroachDB with Apache Airflow
Access and process CockroachDB data in Apache Airflow using the CData JDBC Driver.
-
Automated Continuous NetSuite SuiteAnalytics Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable NetSuite SuiteAnalytics replication to Apache Cassandra.
-
Access PhantomBuster Data from MySQL in Amazon QuickSight
Connect to PhantomBuster and build visualizations of PhantomBuster data using a MySQL Connection in Amazon QuickSight.
-
View Reports on Real-Time SFTP Data in Power BI Report Server
Use the CData ODBC Driver for SFTP to visualize SFTP data in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrate Kafka with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Kafka with External Services.
-
How to connect SharePoint with DB2 Data through external lists
Provide DB2 data to SharePoint users as an external list.
-
Connect to Twitter Ads Data in JRuby
Create a simple JRuby app with access to live Twitter Ads data.
-
Build a PostgreSQL Interface for ChartMogul Data using the CData JDBC Driver
Use the Remoting features of the ChartMogul JDBC Driver to create a PostgreSQL entry-point for data access.