CData Software - Knowledge Base
Recent Articles
-
How to work with Avaza Data in Apache Spark using SQL
Access and process Avaza Data in Apache Spark using the CData Software JDBC Driver.
-
Access Stack Exchange 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 Stack Exchange.
-
Migrating data from ZarMoney to Google BigQuery using CData SSIS Components.
Easily push ZarMoney to Google BigQuery using the CData SSIS Tasks for ZarMoney and Google BigQuery.
-
Getting Started with the CData Power BI Connector for Sentry
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Build Reckon Accounts Hosted-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Reckon Accounts Hosted and build web apps with connectivity to live Reckon Accounts Hosted.
-
How to create Azure Data Lake Storage federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Azure Data Lake Storage in MySQL .
-
Connect to ADP Data as an External Source in Dremio
Use the CData JDBC Driver to connect to ADP as an External Source in Dremio.
-
A PostgreSQL Interface for Rebilly Data using the CData ODBC Driver
Use the SQL Gateway and Rebilly ODBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData Power BI Connector for Google Tasks
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Add Customer.io Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Customer.io with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect and Visualize Live SurveyMonkey Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live SurveyMonkey into the Databricks platform and create visualization dashboards with real-time SurveyMonkey.
-
Integrating Dataiku with ActiveCampaign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live ActiveCampaign.
-
Create Sugar CRM Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Sugar CRM from PowerBI.com to create Power BI Dataflows with real-time data.
-
Access Live Azure Data Catalog Data in TIBCO Data Virtualization
Use the Azure Data Catalog Tibco DV Adapter to create a Azure Data Catalog data source in TIBCO Data Virtualization Studio and gain access to live Azure Data Catalog from your TDV Server.
-
Use Azure AI Foundry to Talk to Your Facebook Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Facebook Ads for you.
-
Connect to SendGrid Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for SendGrid and the Script function in FileMaker Pro to connect to SendGrid and work with SendGrid in your FileMaker application.
-
Connect to Exact Online Data in ACL Analytics
Connect to Exact Online via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Exact Online.
-
Build AI/ML Models with Live OData Data using Dataiku
Connect OData Data with Dataiku using the CData JDBC Driver for OData.
-
Connect to Aweber Data in DBeaver
Use the CData ODBC Driver to connect to Aweber in DBeaver.
-
Integrating Antigravity CLI with Microsoft Dynamics NAV via CData CLI
Connect Microsoft Dynamics NAV to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Import Real-Time Couchbase Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Couchbase in ColdFusion.
-
Add Google Analytics Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Google Analytics with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to and Query Azure Table Data in QlikView over ODBC
Create data visualizations with Azure Table Storage in QlikView.
-
Connect to Clari Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Clari and work with Clari in your FileMaker applications.
-
How to Connect DBeaver to Factorial via a JDBC Driver
Manage Factorial with visual tools in DBeaver like the query browser.
-
Access Google Search Results from MySQL in Amazon QuickSight
Connect to Google Search and build visualizations of Google Search using a MySQL Connection in Amazon QuickSight.
-
Connect to Miro Data in Jaspersoft Studio
Execute SQL to remote Miro in Jaspersoft Studio.
-
Connect to and Query Productboard Data in QlikView over ODBC
Create data visualizations with Productboard in QlikView.
-
Connecting GenSpark with Microsoft Ads Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Microsoft Ads without any replication or custom integration required.
-
Connect Zoho Projects Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Zoho Projects using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create Okta Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Okta data access from reports, embedded analytics, and more.
-
Create Dynamic SendPulse Grids Using the Infragistics XamDataGrid
Learn how you can connect SendPulse to Infragistics XamDataGrid to build dynamic grids.
-
Automate Yelp Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Yelp from PowerShell? This article demonstrates how to utilize the Yelp Cmdlets for tasks like connecting to Yelp, automating operations, downloading data, and more.
-
How to connect and process GetResponse from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live GetResponse.
-
Migrating data from Access to Databricks using CData SSIS Components.
Easily push Microsoft Access to Databricks using the CData SSIS Tasks for Access and Databricks.
-
Access Live Splunk Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Splunk from your Excel spreadsheets.
-
How to connect to OnePageCrm Data with Squirrel SQL client
Connect to OnePageCrm and execute queries in the Squirrel SQL Client.
-
Connect to and Query Webflow Data in QlikView over ODBC
Create data visualizations with Webflow in QlikView.
-
Build an OLAP Cube in SSAS from ServiceNow Data
Establish a connection to ServiceNow data from SQL Server Analysis Services, and use the ServiceNow Data Provider to build OLAP cubes for use in analytics and reporting.
-
Getting Started with the CData Python Connector for Azure Synapse
Learn to install and license the CData Python Connector
-
Connect HCL Domino Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your HCL Domino using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Access Vault CRM 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 Veeva Vault & Vault CRM.
-
Automated Continuous OneNote Replication to Amazon S3
Use CData Sync for automated, continuous, customizable OneNote replication to Amazon S3.
-
Using the CData Software ODBC Driver for Telegram in PyCharm
Connect to Telegram as an ODBC data source in PyCharm using the CData Software ODBC Driver for Telegram.
-
Integrate with CloudConvert Data in JReport Designer
Create charts and reports based on CloudConvert in JReport Designer.
-
Visualize Perigon Data in TIBCO Spotfire through ADO.NET
Integrate Perigon into dashboards in TIBCO Spotfire.
-
Integrate Goose with Live Google Campaign Manager 360 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Google Campaign Manager 360 from within the local AI agent.
-
Use Grok to Talk to Your SAP HANA 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 HANA for you.
-
Connect to Quickbase from Asprova with CData Software ODBC Driver for Quickbase
This article shows how to connect faster to Quickbase data from Asprova.
-
Connect and Query Live Quickbase Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Quickbase into Databricks
-
Create Power BI Reports on Real-Time Intercom Data
Use the CData ODBC Driver for Intercom to visualize Intercom in Power BI Desktop.
-
Query NetSuite Data as a MySQL Database in Node.js
Execute MySQL queries against NetSuite CRM & ERP from Node.js.
-
Replicate Multiple Spark Accounts via the CData Sync CLI
Replicate multiple Spark accounts to one or many databases.
-
How to integrate Zoho Inventory with Apache Airflow
Access and process Zoho Inventory in Apache Airflow using the CData JDBC Driver.
-
Import Real-Time Oracle Eloqua Reporting Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Oracle Eloqua Reporting in ColdFusion.
-
How to Query Live Phoenix Data in Claude Desktop
Connect to and query live Phoenix Data in Claude Desktop using CData MCP Server.
-
How to connect to Stripe Data with Squirrel SQL client
Connect to Stripe and execute queries in the Squirrel SQL Client.
-
Connect to Dynamics 365 Business Central Data in Google Apps Script via Connect AI
Use CData Connect AI to access Dynamics 365 Business Central in Google Apps Script.
-
Analyze Jira Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Atlassian Jira with the CData JDBC Driver for Jira.
-
Getting Started with the CData Tableau Connector for Couchbase
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Couchbase.
-
Connect to Apify Data in DBArtisan
Use wizards in DBArtisan to configure Apify as a data source.
-
Connect to IBM Cloud Object Storage Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with IBM Cloud Object Storage Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Bridge IBM Informix Connectivity with Apache NiFi
Access and process IBM Informix in Apache NiFi using the CData JDBC Driver.
-
Integrating Kiro CLI with Teradata 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 Printful Data from a Connection Pool in JBoss
Integrate Printful into Java servlets: Use the Management Console in JBoss to install the Printful JDBC Driver.
-
Connect Keap Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Keap using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Work with Avro Data in FoxPro
Load Apache Avro into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create Reports with QuickBooks Online Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date QuickBooks Online.
-
Use ChatGPT to Talk to Your Microsoft Dataverse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Microsoft Dataverse (CDS) for you.
-
Connect to Cassandra Data in DBArtisan
Use wizards in DBArtisan to configure Apache Cassandra as a data source.
-
Connect to Clio Data in HULFT Integrate
Connect to Clio as a JDBC data source in HULFT Integrate
-
Publish Reports with Shippo Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Shippo.
-
Create Informatica Mappings From/To a JDBC Data Source for SAS xpt
Create SAS xpt data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Analyze Impala Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Apache Impala and visualize live Apache Impala in Infragistics Reveal.
-
How to Seamlessly Import YouTube Analytics Data into IBM SPSS Modeler
Integrate YouTube Analytics data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Automated Continuous Cosmos DB Replication to Snowflake
Use CData Sync for automated, continuous, customizable Cosmos DB replication to Snowflake.
-
Working with MailerSend Data in LINQPad
Execute LINQ queries to MailerSend in LINQPad.
-
Create a Private/Public Key Pair with Certificate Generator
Information on how to use the Certificate Generator application to create public and private keypairs.
-
Build BambooHR-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live BambooHR.
-
Visualize Live Instantly Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Instantly using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create Reports with Vimeo Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Vimeo.
-
Automated Continuous Azure DevOps Replication to Snowflake
Use CData Sync for automated, continuous, customizable Azure DevOps replication to Snowflake.
-
Getting Started with the CData ODBC Driver for Strava
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Strava.
-
Build AI/ML Models with Live Strava Data using Dataiku
Connect Strava Data with Dataiku using the CData API Driver for JDBC.
-
Integrating GitHub Copilot CLI with QuickBooks Time 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.
-
Migrating data from Jumpseller to Databricks using CData SSIS Components.
Easily push Jumpseller to Databricks using the CData SSIS Tasks for Jumpseller and Databricks.
-
Create Datasets from Perigon in Domo Workbench and Build Visualizations of Perigon Data in Domo
Use the CData Software ODBC Driver for Perigon to create datasets from Perigon in Domo Workbench and then build visualizations in the Domo service.
-
Model SharePoint Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SharePoint, enabling the direct import of real-time Microsoft SharePoint.
-
Use JayDeBeApi to access Stack Exchange Data in Python
Use standard Python scripting and the development environment of your choice to access live Stack Exchange.
-
Automated Continuous Facebook Replication to MySQL
Use CData Sync for automated, continuous, customizable Facebook replication to MySQL.
-
How to Connect to Live Oracle Sales 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 Oracle Sales for you.
-
Access Live Drip Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Drip into the statistical analysis tools available in SAS JMP. This article shows how to use Drip in the Graph Builder and Query Builder.
-
Seamlessly Bring NetSuite Data into Retool Using CData Connect AI
Integrate NetSuite data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to Access Live NASA Data in Power Automate Desktop via ODBC
The CData ODBC Driver for NASA enables you to integrate NASA into workflows built using Microsoft Power Automate Desktop.
-
Connect Perigon Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Perigon using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
ShipEngine Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on ShipEngine facts in real time.
-
How to Connect to Live Microsoft OneDrive 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 Microsoft OneDrive for you.
-
Back Up LeadDesk to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with LeadDesk data.
-
Build Semantic Layer Views for Mouseflow Data in APOS Live Data Gateway
Use the CData Connector for Mouseflow in APOS Live Data Gateway to build Semantic Layer Views for Mouseflow.
-
Analyze Phoenix Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Apache Phoenix with the CData JDBC Driver for Phoenix.