CData Software - Knowledge Base
Recent Articles
-
Connect to Okta Data in ACL Analytics
Connect to Okta data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Okta data.
-
Connect to Real-Time Exact Online Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Exact Online and Dataflow to import and use Exact Online data in Power Apps.
-
How to Visualize Exact Online Data in Python with pandas
Use pandas and other modules to analyze and visualize live Exact Online data in Python.
-
A PostgreSQL Interface for Neo4J Data (MySQL Remoting via JDBC)
Use the Remoting features of the Neo4J JDBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze Salesforce CRM Analytics Data in Cognos Analytics
Use CData Connect AI to connect to Salesforce CRM Analytics Data from Cognos Analytics and analyze live Salesforce CRM Analytics data.
-
Connect to Google Forms Data from AWS Glue
Use CData Connect AI to gain access to live Google Forms data from your AWS Glue jobs.
-
Create Greenplum-Connected Nintex Workflows
Use CData Connect AI to connect to Greenplum Data from Nintex Workflow Cloud and build custom workflows using live Greenplum data.
-
Integrate Live Adobe Target Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Adobe Target data and integrate live Adobe Target data into apps built in Microsoft Power Apps.
-
How to Connect to Live Reckon 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 Reckon data for you.
-
Replicate Power BI XMLA Data in Heroku for Use in Salesforce Connect
Replicate Power BI XMLA data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Replicate Cohere Data to Multiple Databases via the CData Sync CLI
Replicate Cohere data to disparate databases with a single configuration.
-
Consume Dynamics 365 OData Feeds in PowerBuilder
This article demonstrates how to consume Dynamics 365 data as OData feeds from PowerBuilder using the API Server.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SurveyMonkey
Provide connectivity to SurveyMonkey data through an SAP BusinessObjects universe.
-
Publish Amazon S3-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Amazon S3 data.
-
Use the CData Software JDBC Driver for LaunchDarkly in MicroStrategy Desktop
Connect to LaunchDarkly data in MicroStrategy Desktop using the CData Software JDBC Driver for LaunchDarkly.
-
Connect to Tavily from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Tavily data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to integrate Metabase with Optimizely Data
Use CData Connect AI to connect to live Optimizely data and create an interactive dashboard in Metabase from Optimizely data.
-
Integrating LlamaIndex with QuickBooks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on QuickBooks data in real time.
-
Integrate with live Sugar CRM Data in Jitterbit
Use CData Connect AI to connect to and integrate live Sugar CRM data in Jitterbit.
-
Use Dash to Build to Web Apps on ZeroBounce Data
Create Python applications that use pandas and Dash to build ZeroBounce-connected web apps.
-
Build BenchmarkEmail Visualizations in Tableau Desktop
Use CData Connect AI to connect to live BenchmarkEmail data and build visualizations in Tableau.
-
How to Connect DBeaver to Zoho Creator via a JDBC Driver
Manage Zoho Creator data with visual tools in DBeaver like the query browser.
-
Connect to PingOne Data in DBArtisan
Use wizards in DBArtisan to configure PingOne data as a data source.
-
Connect to OData Services in DBArtisan
Use wizards in DBArtisan to configure OData services as a data source.
-
Connect to SAP Fieldglass from Asprova with CData Software ODBC Driver for SAP Fieldglass
This article shows how to connect faster to SAP Fieldglass data from Asprova.
-
How to Build an ETL App for Elasticsearch Data in Python with CData Connect AI
Build ETL pipelines that read and write live Elasticsearch data in Python with petl and the CData Connect AI Python SDK.
-
Access Live NASA Data in AWS Lambda (with IntelliJ IDEA)
Connect to live NASA data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build Active Directory-Connected Apps in Choreo
Use CData Connect AI to connect to Active Directory Data from Choreo and build custom apps using live Active Directory data.
-
Integrate Cline with Live Microsoft OneDrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Microsoft OneDrive data from within your IDE.
-
How to use SQLAlchemy ORM to access GraphQL Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of GraphQL data.
-
Enable the SharePoint Excel Services JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SharePoint Excel Services data.
-
Automate Google Cloud Storage Data Replication to Azure Synapse
Use CData Sync to customize and automate Google Cloud Storage data replication to Azure Synapse.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Couchbase
Provide connectivity to Couchbase data through an SAP BusinessObjects universe.
-
Connect to Sage Cloud Accounting Data from a Connection Pool in JBoss
Integrate Sage Cloud Accounting data into Java servlets: Use the Management Console in JBoss to install the Sage Cloud Accounting JDBC Driver.
-
Create Epicor Kinetic-Connected Nintex Workflows
Use CData Connect AI to connect to Epicor Kinetic Data from Nintex Workflow Cloud and build custom workflows using live Epicor Kinetic data.
-
SAS Data Sets Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SAS Data Sets facts in real time.
-
Automated Continuous Box Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Box replication to Google BigQuery.
-
Connect to Coda Data in ACL Analytics
Connect to Coda data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Coda data.
-
Build MYOB AccountRight Visualizations in Tableau Cloud
Use CData Connect AI to connect to live MYOB AccountRight data and build visualizations in Tableau Cloud.
-
How to Connect to & Open Splunk Data in Microsoft Excel
This article uses the CData ODBC driver for Splunk to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to LinkedIn Ads Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to LinkedIn Ads.
-
Connect to Dotmailer Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Dotmailer data in the Denodo Virtual DataPort Administrator.
-
Prepare, Blend, and Analyze Oracle Sales Data in Alteryx Designer (ODBC)
Build workflows to access live Oracle Sales data for self-service data analytics.
-
Bridge xBase Connectivity with Apache NiFi
Access and process xBase data in Apache NiFi using the CData JDBC Driver.
-
Integrate PayPal Data in Pentaho Data Integration
Build ETL pipelines based on PayPal data in the Pentaho Data Integration tool.
-
Integrating Cursor with Landbot Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Create Customer.io Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Customer.io from PowerBI.com to create Power BI Dataflows with real-time data.
-
Publish Reports with Avaza Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Avaza data.
-
Rapidly Develop JotForm-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 JotForm.
-
How to Build an ETL App for Nuclia Data in Python with CData
Create ETL applications and real-time data pipelines for Nuclia data in Python with petl.
-
How to Access Billsby Data Using Entity Framework
This article shows how to access Billsby data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrate with Live Microsoft Planner Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Microsoft Planner from the MuleSoft Anypoint Platform to integrate live Microsoft Planner data into custom reports and dashboards.
-
Query EmailOctopus Data in DataGrip
Create a Data Source for EmailOctopus in DataGrip and use SQL to query live EmailOctopus data.
-
Access Live LDAP Objects in TIBCO Data Virtualization
Use the LDAP Tibco DV Adapter to create a LDAP objects data source in TIBCO Data Virtualization Studio and gain access to live LDAP objects from your TDV Server.
-
How to Query Simplesat Data in MySQL Workbench
Execute MySQL queries against live Simplesat data from MySQL Workbench.
-
Visualize Live Onfleet Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Onfleet data.
-
Replicate NASA Data from PowerShell
Write a quick PowerShell script to query NASA data. Use connectivity to the live data to replicate NASA data to SQL Server.
-
Create SSAS Tabular Models from Zoho Creator Data
How to build a SQL Server Analysis Service Tabular Model from Zoho Creator data using CData drivers.
-
Getting Started with the CData Tableau Connector for Flowlu
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Create SuiteCRM-Connected Applications in Appsmith
Connect to SuiteCRM Data via CData Connect AI in Appsmith and create custom business applications with real-time access to SuiteCRM data.
-
Integrate AlloyDB Data in the Pentaho Report Designer
Publish reports based on AlloyDB data in the Pentaho BI tool.
-
Automated Continuous Parallel Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Parallel replication to Apache Cassandra.
-
Migrating data from Tanda to Databricks using CData SSIS Components.
Easily push Tanda data to Databricks using the CData SSIS Tasks for Tanda and Databricks.
-
Bidirectional Access to FTP Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate FTP data in Filemaker Pro for Mac or Windows.
-
Connect to Sybase IQ Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Sybase IQ and the SQL Gateway to access Sybase IQ data from Google Apps Script.
-
Integrate Cline with Live Instagram Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Instagram data from within your IDE.
-
Import Salesforce Pardot Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Salesforce Pardot Data and provide access to live Salesforce Pardot data for custom reports in the Power BI Service.
-
How to create Reply.io federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Reply.io data in MySQL .
-
Build Automated Microsoft Teams-Connected Workflows in Zapier
Use CData Connect AI to connect to live Microsoft Teams data and build automated workflows in Zapier.
-
Integrating Cursor with ZohoDesk Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
Integrate Trae with Live SAP HANA Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live SAP HANA data from within the AI-powered IDE.
-
How to connect SharePoint with Redis Data through external lists
Provide Redis data to SharePoint users as an external list.
-
Use the CData Software ODBC Driver for Epicor Kinetic in MicroStrategy
Connect to Epicor Kinetic data in MicroStrategy Developer using the CData Software ODBC Driver for Epicor Kinetic.
-
Integrate Jira Data into Power Automate Desktop using CData Connect
CData Connect for Jira Data enables you to integrate Jira data into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous TaxJar Replication to SQLite
Use CData Sync for automated, continuous, customizable TaxJar replication to SQLite.
-
How to integrate Metabase with Apify Data
Use CData Connect AI to connect to live Apify data and create an interactive dashboard in Metabase from Apify data.
-
Visualize BigCommerce Data in Tableau
The CData ODBC driver for BigCommerce enables you integrate BigCommerce data into Tableau dashboards.
-
Natively Connect to Greenplum Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Greenplum data. Leverage the native support for ODBC in PHP.
-
Build ChartMogul-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live ChartMogul data.
-
Visualize Live PostgreSQL Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live PostgreSQL data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Getting Started with the CData JDBC Driver for Zoho Books
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Zoho Books.
-
Access Live Confluence Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Confluence data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Automated Continuous Xero Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Xero data replication to OneLake in Microsoft Fabric.
-
SingleStore Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to SingleStore data through CData Connect AI using different applications and tools.
-
Create Dashboards and Visualize Live SAP SuccessFactors Data in Geckoboard
Use CData Connect AI to connect to live SAP SuccessFactors data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
View Reports on Real-Time Jira Data in Power BI Report Server
Use the CData ODBC Driver for Jira to visualize Jira data in Power BI Desktop and then publish them to Power BI Report Server.
-
Create WordPress-Connected Business Apps in AppSheet
Connect to WordPress Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to WordPress data.
-
Publish Crystal Reports on JobNimbus Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date JobNimbus data.
-
Automated Continuous Placid Replication to SQLite
Use CData Sync for automated, continuous, customizable Placid replication to SQLite.
-
Automated Continuous ZarMoney Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable ZarMoney replication to Amazon Redshift.
-
Use the CData SSIS Components to Insert New or Update Existing Microsoft Entra ID Records from SQL Server
Easily push SQL Server data to Microsoft Entra ID using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Microsoft Entra ID or update existing records with data from a SQL Server database.
-
Connect to Redshift Data in Google Apps Script via Connect AI
Use CData Connect AI to access Redshift data in Google Apps Script.
-
Create Data Visualizations Based On Sybase Data in Mode
Use CData Connect AI to connect to Sybase Data from Mode and build visualizations using live Sybase data.
-
Build Odoo-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Odoo data and build Odoo-connected web apps with Axios.
-
Replicate JobNimbus Data to Multiple Databases
Replicate JobNimbus data to disparate databases with a point-and-click configuration.
-
Create Bullhorn CRM-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Bullhorn CRM Data from OutSystems and build custom enterprise apps using live Bullhorn CRM data.
-
How to Work with Figshare Data in AWS Glue Jobs Using JDBC
Connect to Figshare from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Analyze Yelp Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Yelp from Power Pivot. You will use the Table Import Wizard to load Yelp data. You can visually build the import query or use any SQL supported by the driver.
-
Integrate Excel with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Excel with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Excel data.
-
How to load Auth0 data into Elasticsearch via Logstash
Introducing a simple method to load Auth0 data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.