CData Software - Knowledge Base
Recent Articles
-
Build Dashboards with ZarMoney Data in DBxtra
Create dynamic dashboards and perform analytics based on ZarMoney in DBxtra.
-
Build Visualizations of Stripe Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Stripe in Birst.
-
Build Agents in Relevance AI with Access to Live Email Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Email within intelligent agent workflows.
-
Connect to Samanage in SpagoBI
Create reports featuring live Samanage in SpagoBI Studio. Host Samanage reports on SpagoBI Server.
-
How to use SQLAlchemy ORM to access Postmark Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Postmark.
-
How to Connect to Unbounce Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Unbounce. Leverage the pyodbc module for ODBC in Python.
-
Build Data Flows from SQL Server to Sage Intacct through SSIS
Easily push SQL Server data to Sage Intacct using the CData SSIS Tasks for Sage Intacct.
-
How to create an RPA flow for Elasticsearch Data in UiPath Studio
Use the Elasticsearch ODBC Driver to create workflows that access real-time Elasticsearch without any coding.
-
Build a PostgreSQL Interface for Bitbucket Data using the CData JDBC Driver
Use the Remoting features of the Bitbucket JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to publish and share Printify Data dashboards with Tableau Server
The CData ODBC driver for Printify enables you integrate Printify into Tableau dashboards.
-
How to Connect to Live GraphQL Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your GraphQL through natural language.
-
Add CouchDB Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for CouchDB with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous ConvertKit Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable ConvertKit replication to Google Cloud SQL.
-
Use the CData Software ODBC Driver for SQL Analysis Services in MicroStrategy
Connect to SQL Analysis Services in MicroStrategy Developer using the CData Software ODBC Driver for SQL Analysis Services.
-
How to Connect to Google Tasks Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Google Tasks. Leverage the pyodbc module for ODBC in Python.
-
Use JayDeBeApi to access Power BI XMLA Data in Python
Use standard Python scripting and the development environment of your choice to access live Power BI XMLA.
-
Build DocuSign-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live DocuSign.
-
Automated Continuous Authorize.Net Replication to MySQL
Use CData Sync for automated, continuous, customizable Authorize.Net replication to MySQL.
-
Create SurveyMonkey Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SurveyMonkey from PowerBI.com to create Power BI Dataflows with real-time data.
-
Replicate AlloyDB Data in Heroku for Use in Salesforce Connect
Replicate Google AlloyDB to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrate Jira Data in Pentaho Data Integration
Build ETL pipelines based on Atlassian Jira in the Pentaho Data Integration tool.
-
Build Confluence-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Confluence to explore live Confluence Data in Cursor to assist with building Confluence-powered applications.
-
Excel Spreadsheet Automation on Pipeline CRM Data with the QUERY Formula
Pull data from Pipeline CRM, automate spreadsheets, and more with the QUERY formula.
-
Extract, Transform, and Load Printful Data in Informatica PowerCenter
Create a simple Workflow for Printful in Informatica PowerCenter.
-
Replicate Multiple Azure Blob Storage Accounts
Replicate multiple Azure Blob Storage accounts to one or many databases.
-
How to Visualize ZohoMarketingHub Data in Python with pandas
Use pandas and other modules to analyze and visualize live ZohoMarketingHub in Python.
-
How to Connect DBeaver to CockroachDB via a JDBC Driver
Manage CockroachDB with visual tools in DBeaver like the query browser.
-
How to connect and process Microsoft Office 365 from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Microsoft Office 365.
-
Build HBase Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Apache HBase and build visualizations in Tableau Cloud.
-
Validate SAP Data with QuerySurge
Access and validate SAP ERP/NetWeaver in QuerySurge using the CData JDBC Driver.
-
Build Charts with Google Cloud Storage Data in Clear Analytics
Create dynamic charts and perform analytics based on Google Cloud Storage in Clear Analytics.
-
Connect to Databricks Data from HeidiSQL
Use CData Connect AI to connect to and query live Databricks from HeidiSQL.
-
Build Highrise-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Highrise to explore live Highrise Data in GitHub Copilot to assist with building Highrise-powered applications.
-
How to Import Data from Shopify into Google Sheets
Import Shopify into a Google spreadsheet that is automatically refreshed.
-
ETL Databricks in Oracle Data Integrator
This article shows how to transfer Databricks into a data warehouse using Oracle Data Integrator.
-
Integrating GitHub Copilot CLI with WordPress 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.
-
How to publish and share HCL Domino Data dashboards with Tableau Server
The CData ODBC driver for HCL Domino enables you integrate HCL Domino into Tableau dashboards.
-
Integrate Sage 300 with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Sage 300 with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Sage 300.
-
Connect to Pipeliner CRM in SpagoBI
Create reports featuring live Pipeliner CRM in SpagoBI Studio. Host Pipeliner CRM reports on SpagoBI Server.
-
Use the CData Software ODBC Driver for PingOne in MicroStrategy Desktop
Connect to PingOne in MicroStrategy Desktop using the CData Software ODBC Driver for PingOne.
-
Automated Continuous Acumatica Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Acumatica replication to Google Cloud SQL.
-
Publish SharePoint-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Microsoft SharePoint.
-
How to Connect Flowise AI Agents to Live Dynamics CRM Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Microsoft Dynamics CRM without replication.
-
Using the CData Software ODBC Driver for Snapchat Ads in PyCharm
Connect to Snapchat Ads as an ODBC data source in PyCharm using the CData Software ODBC Driver for Snapchat Ads.
-
Build an OLAP Cube in SSAS from Azure Analysis Services Data
Establish a connection to Azure Analysis Services data from SQL Server Analysis Services, and use the Azure Analysis Services Data Provider to build OLAP cubes for use in analytics and reporting.
-
Bidirectional Access to Accelo Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Accelo in Filemaker Pro for Mac or Windows.
-
Use the CData Software ODBC Driver for Databricks in SAS for Real-Time Reporting and Analytics
Connect to real-time Databricks in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Databricks.
-
Connect to Trello from Asprova with CData Software ODBC Driver for Trello
This article shows how to connect faster to Trello data from Asprova.
-
Integrate Live Microsoft Planner Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Prepare, Blend, and Analyze Outreach.io Data in Alteryx Designer (Connect AI)
Build workflows to access live Outreach.io for self-service data analytics.
-
How to Work with Kintone Data in AWS Glue Jobs Using JDBC
Connect to Kintone from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build Vercel-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Vercel.
-
Connect to SharePoint Data in RazorSQL
Connect to SharePoint from wizards and query Microsoft SharePoint from the GUI in the RazorSQL database management tool.
-
Consume Azure Synapse OData Feeds in PowerBuilder
This article demonstrates how to consume Azure Synapse as OData feeds from PowerBuilder using the API Server.
-
Configure the CData JDBC Driver for Aircall in a Connection Pool in Tomcat
Connect to Aircall from a connection pool in Tomcat.
-
Access Live WordPress Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to WordPress from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to Google Spanner Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Google Spanner to connect to Google Spanner and execute queries in PowerBuilder.
-
Use the CData ODBC Driver for Mode from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Mode to connect to Mode from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Mode in Excel.
-
Automated Continuous Google Contacts Replication to Vertica
Use CData Sync for automated, continuous, customizable Google Contacts replication to Vertica.
-
Access Live Lakebase Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Lakebase into the statistical analysis tools available in SAS JMP. This article shows how to use Lakebase in the Graph Builder and Query Builder.
-
Connect to Real-Time Bugsnag Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Bugsnag in Power Apps.
-
Connect Microsoft Ads to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Microsoft Ads using the CData Python MCP Server.
-
Integrate with SAP HANA Data in SnapLogic
Use CData Connect AI to connect to and integrate with live SAP HANA in SnapLogic.
-
LeadDesk Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on LeadDesk facts in real time.
-
Access Live SAS xpt Data in Excel 365 Online (Excel for the web)
Connect to SAS XPORT from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Use the CData Software ODBC Driver for JobNimbus in SAS for Real-Time Reporting and Analytics
Connect to real-time JobNimbus in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for JobNimbus.
-
Bidirectional Access to Aha! Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Aha! in Filemaker Pro for Mac or Windows.
-
How to connect to Marketo Data from IntelliJ
Integrate connectivity to Marketo with wizards in IntelliJ.
-
Connect EnterpriseDB to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live EnterpriseDB using the CData Python MCP Server.
-
Visualize Live Splunk Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Splunk into custom reports in Power BI.
-
Automated Continuous Oracle Eloqua Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to delimited files (CSV/TSV).
-
Connect to and Query Bright Data Data in QlikView over ODBC
Create data visualizations with Bright Data in QlikView.
-
Process & Analyze Bugsnag Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Bugsnag Data.
-
DataBind Controls to ConstantContact Data in Delphi
DataBind to ConstantContact in Delphi with standard data access components and controls.
-
View Reports on Real-Time Autopilot Data in Power BI Report Server
Use the CData ODBC Driver for Autopilot to visualize Autopilot in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Create Power BI Visual Reports with Real-Time ChargeOver Data
Use CData Power BI Connectors to visualize ChargeOver in Power BI.
-
Analyze Epicor Kinetic Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Epicor Kinetic in Microsoft R Open.
-
Query Bitbucket Data as a MySQL Database in Node.js
Execute MySQL queries against Bitbucket from Node.js.
-
Analyze LinkedIn Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of LinkedIn and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Automate SAP Business One Data Replication to Azure Synapse
Use CData Sync to customize and automate SAP Business One replication to Azure Synapse.
-
Working with Adobe Experience Manager Data in LINQPad
Execute LINQ queries to Adobe Experience Manager in LINQPad.
-
Create Informatica Mappings From/To an ODBC Data Source for Basecamp
Create an ODBC connection to Basecamp in Informatica and browse and transfer Basecamp.
-
Analyze SAP Netweaver Gateway Data in Looker
Use CData Connect AI to connect to SAP Netweaver Gateway Data from Looker and build custom apps using live SAP Netweaver Gateway.
-
Use the CData Software ODBC Driver for Placid in MicroStrategy Desktop
Connect to Placid in MicroStrategy Desktop using the CData Software ODBC Driver for Placid.
-
Create Power BI Reports on Real-Time Anaplan Data
Use the CData ODBC Driver for Anaplan to visualize Anaplan in Power BI Desktop.
-
A PostgreSQL Interface for Salesforce Pardot Data using the CData ODBC Driver
Use the SQL Gateway and Salesforce Pardot ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Mode Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Mode as an External Source in Dremio.
-
Integrating Stripe Data in Talend Cloud Data Management Platform
Connect Stripe Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Stripe.
-
Add FHIR Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for FHIR with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Connect to Live Salesforce CRM Analytics 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 Salesforce CRM Analytics for you.
-
Connect to Zoom from a Connection Pool in WebLogic
Use the CData JDBC Driver for Zoom to connect to Zoom from Web applications running on WebLogic.
-
Connect to DocuSign Data in JRuby
Create a simple JRuby app with access to live DocuSign.
-
Use Grok to Talk to Your SAP Hybris C4C Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your SAP Hybris C4C for you.
-
Create Datasets from Moosend in Domo Workbench and Build Visualizations of Moosend Data in Domo
Use the CData Software ODBC Driver for Moosend to create datasets from Moosend in Domo Workbench and then build visualizations in the Domo service.
-
How to Access Live ConvertKit Data in Power Automate Desktop via ODBC
The CData ODBC Driver for ConvertKit enables you to integrate ConvertKit into workflows built using Microsoft Power Automate Desktop.
-
Connect to Sage 300 Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Enable the Freshteam JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Freshteam.
-
Connect to Instagram Data in Claris FileMaker Pro
Use the CData ODBC Driver for Instagram in FileMaker Pro to connect to Instagram and work with Instagram in your FileMaker applications.
-
Integrating Boomi Agentstudio with SAP Business One Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to SAP Business One, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Manage SQL Server Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SQL Server.