CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData ADO.NET Provider for CapsuleCRM
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connect to Pingdom Data in DBArtisan
Use wizards in DBArtisan to configure Pingdom as a data source.
-
Use Grok to Talk to Your Amazon Athena 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 Amazon Athena for you.
-
Create Figshare Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Figshare data access from reports, embedded analytics, and more.
-
Build an OLAP Cube in SSAS from Workable Data
Establish a connection to Workable data from SQL Server Analysis Services, and use the Workable Data Provider to build OLAP cubes for use in analytics and reporting.
-
Use the CData ODBC Driver for Shortcut in Microsoft Power Query
You can use the CData Shortcut ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Shortcut into Microsoft Power Query.
-
Create Quickbase Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Quickbase from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Freshservice Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Freshservice using standard SQL.
-
Automate Klaviyo Data Replication to Azure Data Lake
Use CData Sync to customize and automate Klaviyo replication to Azure Data Lake.
-
Connect to Bitly Data from a Connection Pool in JBoss
Integrate Bitly into Java servlets: Use the Management Console in JBoss to install the Bitly JDBC Driver.
-
Import Real-Time Facebook Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Facebook in ColdFusion.
-
Automated Pinterest Data Replication to Teradata
Use CData Sync to Customize and automate Pinterest replication to Teradata.
-
Connect to Blackbaud FE NXT Data in Jaspersoft Studio
Execute SQL to remote Blackbaud FE NXT in Jaspersoft Studio.
-
Back Up GraphQL to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for GraphQL. In this article, we will employ an SSIS workflow to populate a database with GraphQL data.
-
Feed Telegram Data into FineReport
How to set Telegram as a JDBC data source in FineReport.
-
Connect to Databricks Data from AWS Glue
Use CData Connect AI to gain access to live Databricks from your AWS Glue jobs.
-
Publish LDAP-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live LDAP.
-
Automate Drift Data Replication to SAP HANA
Use CData Sync to customize and automate Drift replication to SAP HANA.
-
Import and Visualize Coinbase Data in Power View
Create data visualizations based on Coinbase in Excel.
-
Extend Google Sheets with Oracle Eloqua Reporting Data
Make calls to Oracle Eloqua Reporting from Google Apps Script via the API Server.
-
Access ADP Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live ADP from HeidiSQL.
-
Integrate Goose with Live Zoho CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Zoho CRM from within the local AI agent.
-
Connect to OnePageCrm Data as an External Source in Dremio
Use the CData JDBC Driver to connect to OnePageCrm as an External Source in Dremio.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for IBM Informix
Provide connectivity to IBM Informix through an SAP BusinessObjects universe.
-
Create Power BI Reports on Real-Time Coda Data
Use the CData ODBC Driver for Coda to visualize Coda in Power BI Desktop.
-
ETL Google Analytics in Oracle Data Integrator
This article shows how to transfer Google Analytics into a data warehouse using Oracle Data Integrator.
-
Integrating Dataiku with Cosmos DB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Azure Cosmos DB.
-
Getting Started with the CData ADO.NET Provider for LinkedIn
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for LinkedIn.
-
Publish xBase-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live xBase.
-
Automated Continuous Presto Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Presto replication to Amazon Redshift.
-
How to Connect Flowise AI Agents to Live NetSuite 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 NetSuite CRM & ERP without replication.
-
Integrating Antigravity CLI with Klaviyo via CData CLI
Connect Klaviyo to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Getting Started with the CData ADO.NET Provider for Perigon
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connect to and Visualize Live Amazon DynamoDB Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Amazon DynamoDB.
-
Deploy the ADO.NET Provider for Kafka on an SSRS Report Server
Connect to Apache Kafka from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Automated Continuous GetResponse Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable GetResponse replication to PostgreSQL.
-
Getting Started with the CData Tableau Connector for Oracle Eloqua
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Oracle Eloqua.
-
Connect and Query Live Zendesk Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Zendesk into Databricks
-
Connect to Microsoft OneDrive Data in CloverDX (formerly CloverETL)
Transfer Microsoft OneDrive using the visual workflow in the CloverDX data integration tool.
-
Connect to Quickbase Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Quickbase Data and connect to Quickbase in Akorbi Digital RunMyProcess.
-
Import HBase Data Using Azure Data Factory
Use CData Connect AI to connect to HBase Data from Azure Data Factory and import live Apache HBase.
-
Create Informatica Mappings From/To a JDBC Data Source for ConstantContact
Create ConstantContact data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Viewing LDAP Objects in RAD Studio Data Explorer
How to view LDAP in RAD Studio Data Explorer using the CData ODBC Driver for LDAP.
-
Analyze MySQL Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of MySQL and visualize live MySQL in Infragistics Reveal.
-
How to Query Attio Data in MySQL Workbench
Execute MySQL queries against live Attio from MySQL Workbench.
-
Connect Oracle Eloqua to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Oracle Eloqua with IBM WebSphere for seamless data integration and connectivity.
-
How to Query Live Acumatica Data in Claude Desktop
Connect to and query live Acumatica Data in Claude Desktop using CData MCP Server.
-
Connect to ConstantContact Data in NetBeans
Connect to ConstantContact in NetBeans with the data source configuration wizard.
-
Configure the CData JDBC Driver for Zoho Projects in a Connection Pool in Tomcat
Connect to Zoho Projects from a connection pool in Tomcat.
-
Import Real-Time iContact Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use iContact in ColdFusion.
-
Connect to Airtable Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Airtable in the Denodo Virtual DataPort Administrator.
-
Analyze xBase Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze xBase with the CData JDBC Driver for xBase.
-
Integrate FHIR Data into Power Automate Desktop using CData Connect
CData Connect for FHIR Data enables you to integrate FHIR into workflows built using Microsoft Power Automate Desktop.
-
Integrating Antigravity CLI with Billsby via CData CLI
Connect Billsby to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build Auth0-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Auth0 and build web apps with connectivity to live Auth0.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Presto within intelligent workflows.
-
How to Access Parquet Data Using Entity Framework
This article shows how to access Apache Parquet using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Create Data Visualizations in Cognos BI with Google Drive Data
Access Google Drive as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Model, Search, and Visualize Live Oracle Service Cloud Data in ThoughtSpot
Use CData Connect AI to connect to live Oracle Service Cloud for modeling, searching, and visualizing.
-
Build Apps with Live SAS xpt Data Using the Low-Code Development Platform of Mendix
Connect SAS XPORT with Mendix to build apps using the CData JDBC Driver for SAS xpt.
-
Integrating Antigravity CLI with Grafana via CData CLI
Connect Grafana to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Visualize Adobe Target Data in Sisense
Create an ElastiCube in Sisense app with access to Adobe Target.
-
Connect to Adobe Analytics Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Adobe Analytics and the Script function in FileMaker Pro to connect to Adobe Analytics and work with Adobe Analytics in your FileMaker application.
-
Replicate Oracle SCM Data to Multiple Databases
Replicate Oracle SCM to disparate databases with a point-and-click configuration.
-
Use the CData ODBC Driver for Mocean from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Mocean to connect to Mocean from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Mocean in Excel.
-
How to integrate Stripe with Apache Airflow
Access and process Stripe in Apache Airflow using the CData JDBC Driver.
-
Connect to ClickTime Data in Ruby
Connect to ClickTime in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Import CSV Data Using Azure Data Factory
Use CData Connect AI to connect to CSV Data from Azure Data Factory and import live CSV/TSV Files.
-
Access Live Kafka Data in Coginiti Pro
Connect to and query live Apache Kafka from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Analyze Anaplan Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Anaplan with the CData JDBC Driver for Anaplan.
-
Automated Continuous QuickBooks Time Replication to Databricks
Use CData Sync for automated, continuous, customizable QuickBooks Time replication to Databricks.
-
Connecting Agentforce with Facebook Ads 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 Facebook Ads for you.
-
Visualize Adobe Analytics 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 Adobe Analytics into TIBCO Spotfire.
-
Connect to FreshBooks Data in HULFT Integrate
Connect to FreshBooks as a JDBC data source in HULFT Integrate
-
Connecting Moonlit Workflow with BigQuery Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Google BigQuery in real time.
-
Connect to Raisers Edge NXT Data in RazorSQL
Connect to Raisers Edge NXT from wizards and query Raisers Edge NXT from the GUI in the RazorSQL database management tool.
-
Automated Continuous Zendesk Replication to SingleStore
Use CData Sync for automated, continuous, customizable Zendesk replication to SingleStore.
-
Connect to Cvent Data in JRuby
Create a simple JRuby app with access to live Cvent.
-
Using the CData Software ODBC Driver for Printify in PyCharm
Connect to Printify as an ODBC data source in PyCharm using the CData Software ODBC Driver for Printify.
-
Build a Singer.io Tap for RSS With the CData Python Connector
Learn how to easily build a Singer.io Tap for live RSS data using
-
How to Build an ETL App for Wave Financial Data in Python with CData
Create ETL applications and real-time data pipelines for Wave Financial in Python with petl.
-
Getting Started with the CData Python Connector for Oracle HCM Cloud
Learn to install and license the CData Python Connector
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Customer.io
Provide connectivity to Customer.io through an SAP BusinessObjects universe.
-
Connect to Teamwork Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Teamwork using standard SQL.
-
Visualize Live SingleStore Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SingleStore.
-
Use JayDeBeApi to access Attio Data in Python
Use standard Python scripting and the development environment of your choice to access live Attio.
-
Use Microsoft Copilot Studio to talk to your Workday Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Workday for you.
-
Connect to WordPress Data in NetBeans
Connect to WordPress in NetBeans with the data source configuration wizard.
-
Connect to SAS Data Sets Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for SAS Data Sets in Airbyte.
-
Integrate Acumatica Data into Power Automate Desktop using CData Connect
CData Connect for Acumatica Data enables you to integrate Acumatica ERP into workflows built using Microsoft Power Automate Desktop.
-
Visualize Live Cohere Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Cohere using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Amazon Marketplace-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Amazon Marketplace.
-
Build AI/ML Models with Live Clio Data using Dataiku
Connect Clio Data with Dataiku using the CData API Driver for JDBC.
-
Create Informatica Mappings From/To a JDBC Data Source for eBay
Create eBay data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Access Live Oracle Eloqua Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Oracle Eloqua into the statistical analysis tools available in SAS JMP. This article shows how to use Oracle Eloqua in the Graph Builder and Query Builder.
-
Integrate Open WebUI with Live JSON Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live JSON from within the chat interface.
-
Access Live Microsoft Exchange Data in Coginiti Pro
Connect to and query live Microsoft Exchange from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
View Reports on Real-Time Typeform Data in Power BI Report Server
Use the CData ODBC Driver for Typeform to visualize Typeform in Power BI Desktop and then publish them to Power BI Report Server.
-
Create Power BI Reports on Real-Time LaunchDarkly Data
Use the CData ODBC Driver for LaunchDarkly to visualize LaunchDarkly in Power BI Desktop.
-
Migrating data from Miro to Snowflake using CData SSIS Components.
Easily push Miro to Snowflake using the CData SSIS Tasks for Miro and Snowflake.