CData Software - Knowledge Base
Recent Articles
-
Create Zendesk-Connected Applications in Appsmith
Connect to Zendesk Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Zendesk.
-
How to Work with WordPress Data in ETL Validator JDBC
Connect to WordPress from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Dynamics 365 Business Central Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Dynamics 365 Business Central to connect to Dynamics 365 Business Central and execute queries in PowerBuilder.
-
Use the CData Software ODBC Driver for HCL Domino in MicroStrategy
Connect to HCL Domino in MicroStrategy Developer using the CData Software ODBC Driver for HCL Domino.
-
Create Reports with Vercel Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Vercel.
-
Create Confluence Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Confluence from PowerBI.com to create Power BI Dataflows with real-time data.
-
DataBind Controls to PingOne Data in Delphi
DataBind to PingOne in Delphi with standard data access components and controls.
-
Use the CData Software ODBC Driver for SAP SuccessFactors LMS in MicroStrategy Web
Connect to SAP SuccessFactors LMS in MicroStrategy Web using the CData Software ODBC Driver for SAP SuccessFactors LMS.
-
Connect to Instagram Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Instagram.
-
How to Design Salesforce Marketing Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Salesforce Marketing from mobile and tablet Power Apps.
-
Automate Facebook Data Replication to Couchbase
Use CData Sync to Customize and automate Facebook replication to Couchbase.
-
Import Mistral AI Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Mistral AI. In this article, you will use the OData format to import Mistral AI into Microsoft Power Query.
-
Connect to Real-Time HBase Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for HBase and Dataflow to import and use Apache HBase in Power Apps.
-
Visualize SageHR Data in TIBCO Spotfire through OData
Integrate SageHR into dashboards in TIBCO Spotfire.
-
Integrate Live Vertica Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Vertica from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Vertica.
-
Eventbrite Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Eventbrite facts in real time.
-
Enable the SharePoint JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Microsoft SharePoint.
-
Integrating OpenCode Terminal with ZohoExpense 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.
-
Automated Continuous LinkedIn Ads Replication to Amazon S3
Use CData Sync for automated, continuous, customizable LinkedIn Ads replication to Amazon S3.
-
How to Connect to Live Gong 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 Gong for you.
-
Analyze Avaza Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Avaza from Power Pivot. You will use the Table Import Wizard to load Avaza. You can visually build the import query or use any SQL supported by the driver.
-
Create Informatica Mappings From/To a JDBC Data Source for Splunk
Create Splunk data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build Amazon Athena-Connected Apps in Choreo
Use CData Connect AI to connect to Amazon Athena Data from Choreo and build custom apps using live Amazon Athena.
-
Migrating data from Dynamics 365 to Databricks using CData SSIS Components.
Easily push Microsoft Dynamics 365 to Databricks using the CData SSIS Tasks for Dynamics 365 and Databricks.
-
Integrate with Slack Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Slack to a JSON file on disk.
-
Integrate AgileCRM with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate AgileCRM with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to AgileCRM.
-
Create a Data Access Object for Okta Data using JDBI
A brief overview of creating a SQL Object API for Okta in JDBI.
-
Import Real-Time Airtable Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Airtable in ColdFusion.
-
How to Connect the Power BI Service to Instagram: Complete Guide
Connect to the CData Software Power BI Connector for Instagram from PowerBI.com to provide real-time Instagram across the organization.
-
How to connect to PhantomBuster Data from Spring Boot
Connect to PhantomBuster in a Spring Boot Application using the CData API Driver for JDBC
-
Migrating data from Parquet to Google BigQuery using CData SSIS Components.
Easily push Apache Parquet to Google BigQuery using the CData SSIS Tasks for Parquet and Google BigQuery.
-
Connect to Ontraport Data from PowerBuilder via ADO.NET
This article demonstrates how to access Ontraport from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Import and Visualize GetResponse Data in Power View
Create data visualizations based on GetResponse in Excel.
-
Use the CData Software ODBC Driver for Hugging Face in MicroStrategy Web
Connect to Hugging Face in MicroStrategy Web using the CData Software ODBC Driver for Hugging Face.
-
How to Import Data from OpenWeatherMap into Google Sheets
Import OpenWeatherMap into a Google spreadsheet that is automatically refreshed.
-
Extract, Transform, and Load Simplesat Data in Informatica PowerCenter
Create a simple Workflow for Simplesat in Informatica PowerCenter.
-
How to connect to PagerDuty Data in DBVisualizer
Integrate PagerDuty with visual data analysis tools and data connection wizards in DBVisualizer
-
Getting Started with the CData Excel Add-In for SAP Netweaver Gateway
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SAP Netweaver Gateway.
-
How to Work with Coinbase Data in AWS Glue Jobs Using JDBC
Connect to Coinbase from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Visualize Microsoft Entra ID Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Microsoft Entra ID.
-
Connect to ChartMogul Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time ChartMogul using standard SQL.
-
Replicate Printful Data to Multiple Databases via the CData Sync CLI
Replicate Printful to disparate databases with a single configuration.
-
Explore Geographical Relationships in ClickUp Data with Power Map
Create data visualizations with ClickUp in Power Map.
-
Access Live Lakebase Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Lakebase through MCP integration.
-
Connect to PivotalTracker from a Connection Pool in WebLogic
Use the CData JDBC Driver for PivotalTracker to connect to PivotalTracker from Web applications running on WebLogic.
-
Access Freshservice 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 Freshservice.
-
Build an OLAP Cube in SSAS from HCL Domino Data
Establish a connection to HCL Domino data from SQL Server Analysis Services, and use the HCL Domino Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to load Amazon DynamoDB data into Elasticsearch via Logstash
Introducing a simple method to load Amazon DynamoDB data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate Live SurveyMonkey Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live SurveyMonkey to Blue Prism using the CData ODBC Driver for SurveyMonkey to create automated workflows for repetitive business tasks.
-
Use CData Connect AI to Access Google Calendar Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Google Calendar in the Power Pivot business intelligence tool.
-
Visualize Office 365 Data in Tableau
The CData ODBC driver for Office 365 enables you integrate Microsoft Office 365 into Tableau dashboards.
-
Connect to Excel Online Data in DBeaver
Use the CData ODBC Driver to connect to Microsoft Excel Online in DBeaver.
-
Automated Continuous ChargeOver Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable ChargeOver replication to Apache Kafka.
-
Visualize SQL Server 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 Microsoft SQL Server into TIBCO Spotfire.
-
Automated Continuous Google Cloud Storage Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Google Cloud Storage replication to Apache Kafka.
-
Integrate Theia IDE with Live SAP Concur Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
DataBind Controls to EmailOctopus Data in Delphi
DataBind to EmailOctopus in Delphi with standard data access components and controls.
-
Stream SAP Business Warehouse Data into Apache Kafka Topics
Access and stream SAP Business Warehouse in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Enable the Campaigner JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Campaigner.
-
How to connect to Postmark Data from Spring Boot
Connect to Postmark in a Spring Boot Application using the CData API Driver for JDBC
-
Analyze BambooHR Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze BambooHR with the CData JDBC Driver for BambooHR.
-
How to Work with Demio Data in ETL Validator JDBC
Connect to Demio from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrate SQL Analysis Services with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SQL Analysis Services with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SQL Analysis Services.
-
Automated Continuous Freshdesk Replication to MySQL
Use CData Sync for automated, continuous, customizable Freshdesk replication to MySQL.
-
Visualize MailerLite 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 MailerLite into TIBCO Spotfire.
-
Create Facebook Ads Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Facebook Ads from PowerBI.com to create Power BI Dataflows with real-time data.
-
Load Brex Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Brex to a database.
-
Design BIRT Reports on Google Directory Data
Provide current Google Directory to your embedded analytics.
-
Consume Planio OData Feeds in PowerBuilder
This article demonstrates how to consume Planio as OData feeds from PowerBuilder using the API Server.
-
Create Datasets from Cloudant in Domo Workbench and Build Visualizations of Cloudant Data in Domo
Use the CData Software ODBC Driver for Cloudant to create datasets from IBM Cloudant in Domo Workbench and then build visualizations in the Domo service.
-
Integrate GraphQL Data in Pentaho Data Integration
Build ETL pipelines based on GraphQL in the Pentaho Data Integration tool.
-
How to Query Telegram Data in MySQL Workbench
Execute MySQL queries against live Telegram from MySQL Workbench.
-
Visualize Testmonitor Data in Tableau
The CData ODBC driver for Testmonitor enables you integrate Testmonitor into Tableau dashboards.
-
Automated Continuous SAS xpt Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SAS xpt replication to Apache Cassandra.
-
Connect to Outreach.io Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Visualize Billsby Data in Tableau
The CData ODBC driver for Billsby enables you integrate Billsby into Tableau dashboards.
-
Connect to LinkedIn Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time LinkedIn using standard SQL.
-
Bidirectional Access to RabbitMQ Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate RabbitMQ in Filemaker Pro for Mac or Windows.
-
Bridge Sybase IQ Connectivity with Apache NiFi
Access and process Sybase IQ in Apache NiFi using the CData JDBC Driver.
-
Build Semantic Layer Views for Avaza Data in APOS Live Data Gateway
Use the CData Connector for Avaza in APOS Live Data Gateway to build Semantic Layer Views for Avaza.
-
Build a Singer.io Tap for Bannerbear With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Bannerbear data using
-
Connect to Invoiced Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Invoiced using standard SQL.
-
Consume Humanity OData Feeds in PowerBuilder
This article demonstrates how to consume Humanity as OData feeds from PowerBuilder using the API Server.
-
Create SSAS Tabular Models from Simplesat Data
How to build a SQL Server Analysis Service Tabular Model from Simplesat using CData drivers.
-
Connect to Kintone Data in Google Apps Script via Connect AI
Use CData Connect AI to access Kintone in Google Apps Script.
-
How to Connect Flowise AI Agents to Live MYOB AccountRight 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 MYOB AccountRight without replication.
-
How to Query Live Teamwork Data in Perplexity MacOS Desktop
Connect to and query live Teamwork Data in Perplexity Desktop using CData MCP Server.
-
Connect to and Query SendInBlue Data in QlikView over ODBC
Create data visualizations with SendInBlue in QlikView.
-
Creating FHIR-Connected Applications in Unqork
You can use CData Connect AI to feed FHIR to Unqork and build custom business apps.
-
Replicate Multiple Keap Accounts
Replicate multiple Keap accounts to one or many databases.
-
Integrate with Live Avro Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Avro from the MuleSoft Anypoint Platform to integrate live Apache Avro into custom reports and dashboards.
-
Build Outreach.io Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Outreach.io and build visualizations in Tableau Cloud.
-
Getting Started with the CData JDBC Driver for Superchat
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Superchat.
-
Bind Live SurveyMonkey Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SurveyMonkey data
-
Xero Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Xero Accounting through CData Connect AI using different applications and tools.
-
A PostgreSQL Interface for Act CRM Data using the CData ODBC Driver
Use the SQL Gateway and Act CRM ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate with live PostgreSQL Data in Jitterbit
Use CData Connect AI to connect to and integrate live PostgreSQL in Jitterbit.
-
Access Live Azure DevOps Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Azure DevOps from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Integrate Salesforce Pardot Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Salesforce Pardot from Informatica Cloud.
-
Import Jira Assets Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Jira Assets Data and provide access to live Jira Assets for custom reports in the Power BI Service.