CData Software - Knowledge Base
Recent Articles
-
How to Import Data from Square into Google Sheets
Import Square into a Google spreadsheet that is automatically refreshed.
-
Edit and Search External HBase Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Apache HBase to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create HBase Data objects that you can access from apps and the dashboard.
-
Access GitLab Data from MySQL in PHP
Connect to GitLab through the standard MySQL libraries in PHP.
-
How to Connect to Live Procore 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 Procore for you.
-
Connect and Query Live Okta Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Okta into Databricks
-
Bridge PivotalTracker Connectivity with Apache NiFi
Access and process PivotalTracker in Apache NiFi using the CData JDBC Driver.
-
Migrating data from Teradata to Databricks using CData SSIS Components.
Easily push Teradata to Databricks using the CData SSIS Tasks for Teradata and Databricks.
-
How to load Impala data into Elasticsearch via Logstash
Introducing a simple method to load Impala data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Consume Twilio OData Feeds in PowerBuilder
This article demonstrates how to consume Twilio as OData feeds from PowerBuilder using the API Server.
-
Create Data Visualizations in Cognos BI with Freshteam Data
Access Freshteam as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build Dashboards with Xero Data in Dundas BI
Create dynamic dashboards and perform analytics based on Xero Accounting in Dundas BI.
-
Work with Live Confluence Data in Power Query
Use CData Connect AI to connect to Atlassian Confluence and work with live Atlassian Confluence in Microsoft Power Query.
-
How to Query Stack Exchange Data in MySQL Workbench
Execute MySQL queries against live Stack Exchange from MySQL Workbench.
-
DataBind Controls to MailerSend Data in C++Builder
DataBind to MailerSend in C++Builder with standard components and controls.
-
Automate Adobe Target Data Replication to Couchbase
Use CData Sync to Customize and automate Adobe Target replication to Couchbase.
-
Using the CData Software ODBC Driver for SharePoint Excel Services in PyCharm
Connect to SharePoint Excel Services as an ODBC data source in PyCharm using the CData Software ODBC Driver for SharePoint Excel Services.
-
Connect ClickUp to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live ClickUp using the CData Python MCP Server.
-
View Reports on Real-Time Avaza Data in Power BI Report Server
Use the CData ODBC Driver for Avaza to visualize Avaza in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrating Cursor CLI with Access 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.
-
Connect to Live CSV Data in PostGresSQL Interface through CData Connect AI
Create a live connection to CSV in CData Connect AI and connect to your CSV/TSV Files from PostgreSQL.
-
Publish Crystal Reports on Accelo Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Accelo.
-
Import and Visualize Google Forms Data in Power View
Create data visualizations based on Google Forms in Excel.
-
Connect to Real-Time Airtable Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Airtable and Dataflow to import and use Airtable in Power Apps.
-
Automated Continuous Grafana Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Grafana replication to AlloyDB.
-
How to Query Xero Data in MySQL Workbench
Execute MySQL queries against live Xero Accounting from MySQL Workbench.
-
Getting Started with the CData Excel Add-In for Exact Online
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Exact Online.
-
Working with Couchbase Data in LINQPad
Execute LINQ queries to Couchbase in LINQPad.
-
Freshsales Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Freshsales facts in real time.
-
How to connect to FTP Data in DBVisualizer
Integrate FTP Servers with visual data analysis tools and data connection wizards in DBVisualizer
-
Import and Visualize Apify Data in Power View
Create data visualizations based on Apify in Excel.
-
Connect to MailerLite Data in HULFT Integrate
Connect to MailerLite as a JDBC data source in HULFT Integrate
-
Automated Continuous Notion Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Notion replication to Azure SQL Database.
-
How to use SQLAlchemy ORM to access Mistral AI Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Mistral AI.
-
Feed Vercel Data into FineReport
How to set Vercel as a JDBC data source in FineReport.
-
How to Build an ETL App for Oracle Service Cloud Data in Python with CData Connect AI
Build ETL pipelines that read and write live Oracle Service Cloud in Python with petl and the CData Connect AI Python SDK.
-
How to Connect to & Open SAP Fieldglass Data in Microsoft Excel
This article uses the CData ODBC driver for SAP Fieldglass to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Use the CData Software ODBC Driver for Reckon in SAS for Real-Time Reporting and Analytics
Connect to real-time Reckon in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Reckon.
-
Replicate Planio Data to Multiple Databases
Replicate Planio to disparate databases with a point-and-click configuration.
-
Visualize ZohoInvoice Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load ZohoInvoice into TIBCO Spotfire.
-
Integrate Live Amazon Marketplace Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Amazon Marketplace to Blue Prism using the CData ODBC Driver for Amazon Marketplace to create automated workflows for repetitive business tasks.
-
Query MarkLogic Data from Node.js
Use the OData endpoint of the CData API Server to connect to your MarkLogic and perform CRUD operations on MarkLogic from Node.js.
-
Publish Mocean-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Mocean.
-
How to connect to Facebook Ads Data from Spring Boot
Connect to Facebook Ads in a Spring Boot Application using the CData JDBC Driver for Facebook Ads
-
Getting Started with the CData ODBC Driver for Close
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Close.
-
DataBind Charts to OneNote Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Microsoft OneNote 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 Automated Google Analytics-Connected Workflows in Zapier
Use CData Connect AI to connect to live Google Analytics and build automated workflows in Zapier.
-
Connect to Zoom Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Zoom Data and connect to Zoom in Akorbi Digital RunMyProcess.
-
Visualize PivotalTracker Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load PivotalTracker into TIBCO Spotfire.
-
Use the CData Software ODBC Driver for FreshBooks in MicroStrategy Desktop
Connect to FreshBooks in MicroStrategy Desktop using the CData Software ODBC Driver for FreshBooks.
-
How to Connect the Power BI Service to Basecamp: Complete Guide
Connect to the CData Software Power BI Connector for Basecamp from PowerBI.com to provide real-time Basecamp across the organization.
-
Access Live Humanity Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Humanity into the statistical analysis tools available in SAS JMP. This article shows how to use Humanity in the Graph Builder and Query Builder.
-
Analyze Jumpseller Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Jumpseller in Microsoft R Open.
-
How to Connect DBeaver to IBM Cloud Object Storage via a JDBC Driver
Manage IBM Cloud Object Storage with visual tools in DBeaver like the query browser.
-
Import MongoDB Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to MongoDB Data and provide access to live MongoDB for custom reports in the Power BI Service.
-
Choosing the Best Method to Connect Twitter Ads to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Twitter Ads from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Publish Reports with MYOB AccountRight Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date MYOB AccountRight.
-
Access Quickbase Data from MySQL in PHP
Connect to Quickbase through the standard MySQL libraries in PHP.
-
How to create an RPA flow for SAP HANA XS Advanced Data in UiPath Studio
Use the SAP HANA XS Advanced ODBC Driver to create workflows that access real-time SAP HANA XS Advanced without any coding.
-
How to Connect DBeaver to Zoho Recruit via a JDBC Driver
Manage Zoho Recruit with visual tools in DBeaver like the query browser.
-
Connect to PivotalTracker Data from PowerBuilder via JDBC
This article demonstrates how to access PivotalTracker from PowerBuilder using the PivotalTracker JDBC Driver.
-
Connect to Keap Data in DBeaver
Use the CData ODBC Driver to connect to Keap in DBeaver.
-
How to Easily Query Google Translate Data in OpenOffice Base
Connect to Google Translate data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Integrate Elorus with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Elorus with External Services.
-
Connect to Spark Data in NetBeans
Connect to Apache Spark SQL in NetBeans with the data source configuration wizard.
-
Connect to and Visualize Live Postmark Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Postmark.
-
Process & Analyze Everhour Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Everhour Data.
-
Working with OData Services in LINQPad
Execute LINQ queries to OData in LINQPad.
-
Use the CData Software ODBC Driver for Google Campaign Manager 360 in MicroStrategy Desktop
Connect to Google Campaign Manager 360 in MicroStrategy Desktop using the CData Software ODBC Driver for Google Campaign Manager 360.
-
Visualize Google Translate Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Google Translate.
-
Integrate Cline with Live Oracle Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Oracle Database from within your IDE.
-
Use the CData Software ODBC Driver for Attio in MicroStrategy Desktop
Connect to Attio in MicroStrategy Desktop using the CData Software ODBC Driver for Attio.
-
Connect to Box Data in DBeaver
Use the CData ODBC Driver to connect to Box in DBeaver.
-
DataBind Controls to Pipeline CRM Data in C++Builder
DataBind to Pipeline CRM in C++Builder with standard components and controls.
-
Load PDFMonkey Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load PDFMonkey to a database.
-
How to Build an ETL App for Timely Data in Python with CData
Create ETL applications and real-time data pipelines for Timely in Python with petl.
-
How to connect to Workable Data from Spring Boot
Connect to Workable in a Spring Boot Application using the CData API Driver for JDBC
-
Import Zoom Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Zoom Data and provide access to live Zoom for custom reports in the Power BI Service.
-
How to Visualize Quickbase Data in Python with pandas
Use pandas and other modules to analyze and visualize live Quickbase in Python.
-
Build a Singer.io Tap for Scrapfly With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Scrapfly data using
-
How to Design Vault CRM Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Vault CRM from mobile and tablet Power Apps.
-
Access Live Google Directory Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Google Directory into the statistical analysis tools available in SAS JMP. This article shows how to use Google Directory in the Graph Builder and Query Builder.
-
How to Access Missive Data Using Entity Framework
This article shows how to access Missive using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build ChargeOver-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live ChargeOver.
-
Visualize Live Microsoft Ads Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Microsoft Ads into custom reports in Power BI.
-
Connect to Adobe Commerce Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Adobe Commerce and the SQL Gateway to access Adobe Commerce from Google Apps Script.
-
Access Paddle Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Paddle from your Oracle system.
-
Integrating Boomi Agentstudio with FreshBooks Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to FreshBooks, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Use the CData Software ODBC Driver for Flowlu in MicroStrategy
Connect to Flowlu in MicroStrategy Developer using the CData Software ODBC Driver for Flowlu.
-
Build a Singer.io Tap for Klaviyo With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Klaviyo data using
-
Visualize Live Paymo Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Paymo.
-
Publish Reports with SAP ByDesign Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP Business ByDesign.
-
How to Work with EmailOctopus Data in ETL Validator JDBC
Connect to EmailOctopus from ETL Validator jobs using the CData Software JDBC Driver.
-
Replicate Multiple OData Accounts via the CData Sync CLI
Replicate multiple OData accounts to one or many databases.
-
Use Dash to Build Web Apps on MySQL Data via CData Connect AI
Build interactive Dash web apps on live MySQL using pandas and the CData Connect AI Python SDK.
-
Access Live Everhour Data in AWS Lambda
Connect to live Everhour in AWS Lambda using the CData JDBC Driver.
-
Access Live Workday Data in AWS Lambda
Connect to live Workday in AWS Lambda using the CData JDBC Driver.
-
Analyze Oracle Financials Cloud Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Oracle Financials Cloud and visualize live Oracle Financials Cloud in Infragistics Reveal.
-
Visualize Live Shippo Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Shippo using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create Dynamic Jumpseller Grids Using the Infragistics XamDataGrid
Learn how you can connect Jumpseller to Infragistics XamDataGrid to build dynamic grids.
-
Publish Reports with DocuSign Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date DocuSign.