CData Software - Knowledge Base
Recent Articles
-
Create SSAS Tabular Models from Google Calendar Data
How to build a SQL Server Analysis Service Tabular Model from Google Calendar data using CData drivers.
-
Connect to Zuora Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Zuora and the SQL Gateway to access Zuora data from Google Apps Script.
-
Add Omnisend Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Omnisend with the Informatica Enterprise Data Catalog to classify and organize data.
-
Prepare, Blend, and Analyze Rootly Data in Alteryx Designer (ODBC)
Build workflows to access live Rootly data for self-service data analytics.
-
DataBind Charts to Dropbox Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Dropbox data 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.
-
Integrate with PhantomBuster Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy PhantomBuster data to a JSON file on disk.
-
Analyze JSON Services with Power Pivot
This article walks you through the process of using the CData ODBC Driver for JSON from Power Pivot. You will use the Table Import Wizard to load JSON services. You can visually build the import query or use any SQL supported by the driver.
-
Build Dashboards with Quickbase Data in Dundas BI
Create dynamic dashboards and perform analytics based on Quickbase data in Dundas BI.
-
Automate Workable Data Replication to SAP HANA
Use CData Sync to customize and automate Workable data replication to SAP HANA.
-
How to Create Power BI Visual Reports with Real-Time SparkPost Data
Use CData Power BI Connectors to visualize SparkPost data in Power BI.
-
Analyze Adobe Target Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Adobe Target data and visualize Adobe Target data in SAP Analytics Cloud.
-
Automated Continuous Vault CRM Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Vault CRM data replication to OneLake in Microsoft Fabric.
-
How to connect to WordPress Data with Squirrel SQL client
Connect to WordPress data and execute queries in the Squirrel SQL Client.
-
Connect to and Visualize Live Procore Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Procore data.
-
View Reports on Real-Time LinkedIn Ads Data in Power BI Report Server
Use the CData ODBC Driver for LinkedIn Ads to visualize LinkedIn Ads data in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to DocuSign Data in ACL Analytics
Connect to DocuSign data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to DocuSign data.
-
Automated Continuous Amazon S3 Replication to Oracle
Use CData Sync for automated, continuous, customizable Amazon S3 replication to Oracle.
-
Automated Continuous ClickTime Replication to MongoDB
Use CData Sync for automated, continuous, customizable ClickTime replication to MongoDB.
-
Integrate Elorus Data in the Pentaho Report Designer
Publish reports based on Elorus data in the Pentaho BI tool.
-
Build OneNote-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for OneNote Data and create custom apps in Mendix.
-
Visualize iContact Data in Sisense
Create an ElastiCube in Sisense app with access to iContact data.
-
How to Connect to Live Jira Assets Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Jira Assets data without replication.
-
How to Connect to Live Pinterest Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Pinterest data for you.
-
Build Agents in Relevance AI with Access to Live Impala Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Impala data within intelligent agent workflows.
-
Integrate Greenhouse Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Greenhouse data and integrate live Greenhouse data into your Power Automate tasks.
-
Migrating data from ZarMoney to Google BigQuery using CData SSIS Components.
Easily push ZarMoney data to Google BigQuery using the CData SSIS Tasks for ZarMoney and Google BigQuery.
-
Getting Started with the CData Tableau Connector for Lakebase
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Lakebase.
-
Connect Mocean to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Mocean with IBM WebSphere for seamless data integration and connectivity.
-
Bidirectional Access to Zoho CRM Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Zoho CRM data in Filemaker Pro for Mac or Windows.
-
Use the CData ODBC Driver for Sybase IQ in Microsoft Power Query
You can use the CData Sybase IQ ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Sybase IQ data into Microsoft Power Query.
-
Build Moosend-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Moosend data and build Moosend-connected web apps with Axios.
-
Automated Continuous Dynamics 365 Replication to SQL Server
Use CData Sync for automated, continuous, customizable Dynamics 365 replication to SQL Server.
-
Connect to Wistia Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Wistia data in Airbyte.
-
Connect to MailerSend Data in NetBeans
Connect to MailerSend data in NetBeans with the data source configuration wizard.
-
Smartsheet Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Smartsheet data through CData Connect AI using different applications and tools.
-
How to Query Live Keap Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Keap data data in natural language using Python.
-
Rapidly Develop CSV-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by CSV.
-
How to connect to Samanage Data in DBVisualizer
Integrate Samanage data with visual data analysis tools and data connection wizards in DBVisualizer
-
How to connect Amazon QuickSight to eBay Data
Create a connection to eBay data in CData Connect AI and insert eBay data into Amazon QuickSight SPICE to build interactive dashboards.
-
Replicate Sybase Data in Heroku for Use in Salesforce Connect
Replicate Sybase data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Migrating data from MySQL to Google BigQuery using CData SSIS Components.
Easily push MySQL data to Google BigQuery using the CData SSIS Tasks for MySQL and Google BigQuery.
-
Access Live EmailOctopus Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate EmailOctopus data into the statistical analysis tools available in SAS JMP. This article shows how to use EmailOctopus data in the Graph Builder and Query Builder.
-
Getting Started with the CData JDBC Driver for Cloudant
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Cloudant.
-
Connect and Visualize Live Reckon Accounts Hosted Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Reckon Accounts Hosted data into the Databricks platform and create visualization dashboards with real-time Reckon Accounts Hosted data.
-
Load HCL Domino Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load HCL Domino data to a database.
-
Publish Monday.com-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Monday.com data.
-
Automated Continuous Microsoft Teams Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Microsoft Teams replication to Apache Cassandra.
-
Access Bugsnag 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 Bugsnag data.
-
Build AI/ML Models with Live Bullhorn CRM Data using Dataiku
Connect Bullhorn CRM Data with Dataiku using the CData JDBC Driver for Bullhorn CRM.
-
Connect to Billsby Data in RapidMiner
Integrate Billsby data with standard components and data source configuration wizards in RapidMiner Studio.
-
Build Data Flows from SQL Server to Zoho CRM through SSIS
Easily push SQL Server data to Zoho CRM using the CData SSIS Tasks for Zoho CRM.
-
Analyze Salesforce Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Salesforce data with the CData JDBC Driver for Salesforce.
-
Connect to ChargeOver Data in Ruby
Connect to ChargeOver data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automate Figshare Data Replication to Azure Synapse
Use CData Sync to customize and automate Figshare data replication to Azure Synapse.
-
Automate Yelp Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Yelp data from PowerShell? This article demonstrates how to utilize the Yelp Cmdlets for tasks like connecting to Yelp data, automating operations, downloading data, and more.
-
Getting Started with the CData ADO.NET Provider for PDFMonkey
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
How to Connect DBeaver to Google Translate via a JDBC Driver
Manage Google Translate data with visual tools in DBeaver like the query browser.
-
How to import Twilio Data into Apache Solr
Use the CData Software JDBC Driver for Twilio in Data Import Handler and create an automated import of Twilio data to Apache Solr Enterprise Search platform.
-
Integrating Boomi Agentstudio with Vault CRM Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Vault CRM data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Integrate with SQL Analysis Services Data in SnapLogic
Use CData Connect AI to connect to and integrate with live SQL Analysis Services data in SnapLogic.
-
Create Asana-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Asana Data from Klipfolio and build custom visualizations using live Asana data.
-
Connect to and Query Webflow Data in QlikView over ODBC
Create data visualizations with Webflow data in QlikView.
-
Connect to Presto Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Presto data in Airbyte.
-
Integrate Open WebUI with Live MongoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live MongoDB data from within the chat interface.
-
How to work with Amazon Athena Data in Apache Spark using SQL
Access and process Amazon Athena Data in Apache Spark using the CData Software JDBC Driver.
-
Use the CData Software ODBC Driver for HBase in MicroStrategy
Connect to HBase data in MicroStrategy Developer using the CData Software ODBC Driver for HBase.
-
Getting Started with the CData JDBC Driver for ChartMogul
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for ChartMogul.
-
Use Manus AI to Talk to Your Bullhorn CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Bullhorn CRM data.
-
Access Live Square Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Square data into the statistical analysis tools available in SAS JMP. This article shows how to use Square data in the Graph Builder and Query Builder.
-
Connect to Avalara AvaTax Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Avalara AvaTax Data and connect to Avalara AvaTax data in Akorbi Digital RunMyProcess.
-
Automated Continuous QuickBooks Online Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable QuickBooks Online replication to PostgreSQL.
-
Connect to Mistral AI Data in RazorSQL
Connect to Mistral AI from wizards and query Mistral AI data from the GUI in the RazorSQL database management tool.
-
How to Connect Campaigner Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Campaigner data in real time using natural language.
-
Connect to QuickBooks Time Data in ACL Analytics
Connect to QuickBooks Time data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to QuickBooks Time data.
-
Query NetSuite Data as a MySQL Database in Node.js
Execute MySQL queries against NetSuite data from Node.js.
-
Connect to Zoho Projects Data in RapidMiner
Integrate Zoho Projects data with standard components and data source configuration wizards in RapidMiner Studio.
-
Import SFTP Data Using Azure Data Factory
Use CData Connect AI to connect to SFTP Data from Azure Data Factory and import live SFTP data.
-
Connect to Sage 300 Data in Jaspersoft Studio
Execute SQL to remote Sage 300 data in Jaspersoft Studio.
-
Back Up Mode data 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 Mode data data.
-
How to create Adobe Experience Manager federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Adobe Experience Manager data in MySQL .
-
Write a Simple Go Application to work with Missive Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Missive data.
-
Automated Continuous Contentful Replication to SQL Server
Use CData Sync for automated, continuous, customizable Contentful replication to SQL Server.
-
Analyze Jira Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Jira data with the CData JDBC Driver for Jira.
-
Integrate LibreChat with Live Dynamics 365 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Dynamics 365 data from within the chat interface.
-
Automated Continuous Acumatica Replication to MySQL
Use CData Sync for automated, continuous, customizable Acumatica replication to MySQL.
-
Connect to Apify Data in DBArtisan
Use wizards in DBArtisan to configure Apify data as a data source.
-
Connect to Mocean Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Mocean data.
-
Edit and Search External Facebook Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Facebook data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Facebook Data objects that you can access from apps and the dashboard.
-
AlloyDB Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to AlloyDB data through CData Connect AI using different applications and tools.
-
How to Connect Flowise AI Agents to Live Exa 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 Exa data without replication.
-
How to Connect to Live Apollo Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Apollo data for you.
-
Connect to Zuora Data in RazorSQL
Connect to Zuora from wizards and query Zuora data from the GUI in the RazorSQL database management tool.
-
Access Live Shortcut Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Shortcut data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Import Acumatica Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Acumatica Data and provide access to live Acumatica data for custom reports in the Power BI Service.
-
Create Informatica Mappings From/To an ODBC Data Source for Google Translate
Create an ODBC connection to Google Translate in Informatica and browse and transfer Google Translate data.
-
How to integrate Zoho Books with Apache Airflow
Access and process Zoho Books data in Apache Airflow using the CData JDBC Driver.
-
Connect to Humanity Data in Jaspersoft Studio
Execute SQL to remote Humanity data in Jaspersoft Studio.
-
Migrating data from iContact to Google BigQuery using CData SSIS Components.
Easily push iContact data to Google BigQuery using the CData SSIS Tasks for iContact and Google BigQuery.
-
Visualize Access Data in TIBCO Spotfire through OData
Integrate Access data into dashboards in TIBCO Spotfire.
-
How to connect to Parquet Data with Squirrel SQL client
Connect to Parquet data and execute queries in the Squirrel SQL Client.