CData Software - Knowledge Base
Recent Articles
-
Use CData Connect AI to Access Square Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Square in the Power Pivot business intelligence tool.
-
Build Dynamics 365-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Dynamics 365 Data from Zoho Analytics and import live Microsoft Dynamics 365.
-
Design BIRT Reports on Billsby Data
Provide current Billsby to your embedded analytics.
-
Integrating Gumloop with DocuSign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on DocuSign within automated workflows.
-
How to import NetSuite Data into Apache Solr
Use the CData Software JDBC Driver for NetSuite in Data Import Handler and create an automated import of NetSuite CRM & ERP to Apache Solr Enterprise Search platform.
-
Automate Azure Data Catalog Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Azure Data Catalog from PowerShell? This article demonstrates how to utilize the Azure Data Catalog Cmdlets for tasks like connecting to Azure Data Catalog, automating operations, downloading data, and more.
-
Automated Continuous Salesloft Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Salesloft replication to OneLake in Microsoft Fabric.
-
How to update ADP from Excel
This article explains how to transfer data from Excel to ADP using the Excel Add-In for ADP.
-
Use the CData Software JDBC Driver for JDBC-ODBC Bridge in MicroStrategy
Connect to JDBC-ODBC Bridge in MicroStrategy Developer using the CData Software JDBC Driver for JDBC-ODBC Bridge.
-
Build Zendesk-Connected Apps in Choreo
Use CData Connect AI to connect to Zendesk Data from Choreo and build custom apps using live Zendesk.
-
Automated Continuous ServiceNow Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable ServiceNow replication to Amazon Redshift.
-
Migrating data from Zoho Creator to Databricks using CData SSIS Components.
Easily push Zoho Creator to Databricks using the CData SSIS Tasks for Zoho Creator and Databricks.
-
Integrating BigQuery Data in Talend Cloud Data Management Platform
Connect BigQuery Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Google BigQuery.
-
Connect to ActiveCampaign from a Connection Pool in WebLogic
Use the CData JDBC Driver for ActiveCampaign to connect to ActiveCampaign from Web applications running on WebLogic.
-
Connect to OData Services from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for OData to connect to OData and execute queries in PowerBuilder.
-
How to Query Live Front Data in Claude Desktop
Connect to and query live Front Data in Claude Desktop using CData MCP Server.
-
Build Dashboards with Contentful Data in DBxtra
Create dynamic dashboards and perform analytics based on Contentful in DBxtra.
-
Query Planio Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Planio from Node.js.
-
Access Live ZohoSubscriptions Data in AWS Lambda
Connect to live ZohoSubscriptions in AWS Lambda using the CData JDBC Driver.
-
Create Datasets from Drip in Domo Workbench and Build Visualizations of Drip Data in Domo
Use the CData Software ODBC Driver for Drip to create datasets from Drip in Domo Workbench and then build visualizations in the Domo service.
-
Analyze Power BI XMLA Data in Cognos Analytics
Use CData Connect AI to connect to Power BI XMLA Data from Cognos Analytics and analyze live Power BI XMLA.
-
How to integrate SuiteCRM with Apache Airflow
Access and process SuiteCRM in Apache Airflow using the CData JDBC Driver.
-
Build Procore-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Procore Data and create custom apps in Bubble.
-
Connect to Planio Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Planio as an External Source in Dremio.
-
Connect to Mixpanel Data in Aqua Data Studio
Access Mixpanel from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Helpscout Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Helpscout and the SQL Gateway to access Helpscout from Google Apps Script.
-
How to Work with Google Translate Data in AWS Glue Jobs Using JDBC
Connect to Google Translate from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Moving Data from AgileCRM to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live AgileCRM data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrate Google Translate Data in Pentaho Data Integration
Build ETL pipelines based on Google Translate in the Pentaho Data Integration tool.
-
Connect to Teradata Data in JRuby
Create a simple JRuby app with access to live Teradata.
-
Use the CData API Server to Access Eventbrite Data in Microsoft PowerPivot
Use the CData API Server to connect to live Eventbrite in the Power Pivot business intelligence tool.
-
How to Connect to & Open Planio Data in Microsoft Excel
This article uses the CData ODBC driver for Planio to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build AI/ML Models with Live Accelo Data using Dataiku
Connect Accelo Data with Dataiku using the CData API Driver for JDBC.
-
Connect to MySQL from Asprova with CData Software ODBC Driver for MySQL
This article shows how to connect faster to MySQL data from Asprova.
-
Connect to ADP Data in RazorSQL
Connect to ADP from wizards and query ADP from the GUI in the RazorSQL database management tool.
-
DataBind Charts to HBase Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Apache HBase 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.
-
How to Connect to Google Cloud Storage Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Google Cloud Storage. Leverage the pyodbc module for ODBC in Python.
-
Replicate Multiple Sybase Accounts
Replicate multiple Sybase accounts to one or many databases.
-
How to connect to Short.io Data with Squirrel SQL client
Connect to Short.io and execute queries in the Squirrel SQL Client.
-
Model ServiceNow Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and ServiceNow, enabling the direct import of real-time ServiceNow.
-
DataBind Sentry Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Sentry to a chart.
-
How to work with Clari Data in Apache Spark using SQL
Access and process Clari Data in Apache Spark using the CData Software JDBC Driver.
-
Replicate Multiple XML Accounts
Replicate multiple XML accounts to one or many databases.
-
Getting Started with the CData Power BI Connector for Box
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Box.
-
Excel Spreadsheet Automation on Notion Data with the QUERY Formula
Pull data from Notion, automate spreadsheets, and more with the QUERY formula.
-
Integrating Kiro CLI with Klipfolio 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 Klipfolio Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Klipfolio using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automate ServiceNow Data Replication to Azure Synapse
Use CData Sync to customize and automate ServiceNow replication to Azure Synapse.
-
Connecting Pipedream with Zoho Projects Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Zoho Projects data in real time.
-
Extract, Transform, and Load Google Forms Data in Informatica PowerCenter
Create a simple Workflow for Google Forms in Informatica PowerCenter.
-
Create Blackbaud FE NXT-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Blackbaud FE NXT Data from OutSystems and build custom enterprise apps using live Blackbaud FE NXT.
-
Replicate ShipStation Data from PowerShell
Write a quick PowerShell script to query ShipStation. Use connectivity to the live data to replicate ShipStation to SQL Server.
-
Integrate Guru with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Guru with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Guru.
-
Build AI Agents with Snowflake Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Snowflake through CData Connect AI.
-
Moving Data from Neo4J to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Neo4J data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to Seamlessly Import SharePoint Data into IBM SPSS Modeler
Integrate SharePoint data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Xero-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Xero Accounting.
-
Access Live Autopilot Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Autopilot into the statistical analysis tools available in SAS JMP. This article shows how to use Autopilot in the Graph Builder and Query Builder.
-
Build MVC Applications with Connectivity to Google Campaign Manager 360 Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Google Campaign Manager 360 from an ASP.NET MVC application.
-
Replicate Multiple Google Ad Manager Accounts via the CData Sync CLI
Replicate multiple Google Ad Manager accounts to one or many databases.
-
Automated Continuous Dotmailer Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Dotmailer replication to Google Cloud SQL.
-
Add Paddle Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Paddle with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate Figshare Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Figshare from Informatica Cloud.
-
Natively Connect to Campaigner Data in PHP
The CData ODBC driver for Campaigner enables you to create PHP applications with connectivity to Campaigner. Leverage the native support for ODBC in PHP.
-
Connect to Google Contacts Data from AWS Glue
Use CData Connect AI to gain access to live Google Contacts from your AWS Glue jobs.
-
How to Query Live Oracle SCM Data in Perplexity MacOS Desktop
Connect to and query live Oracle SCM Data in Perplexity Desktop using CData MCP Server.
-
Integrate FHIR with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate FHIR with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to FHIR.
-
Getting Started with the CData Excel Add-In for PDFMonkey
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for PDFMonkey.
-
Access Live Jira Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Atlassian Jira from your Excel spreadsheets.
-
Connect to Cloudflare Data from PowerBuilder via ADO.NET
This article demonstrates how to access Cloudflare from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Explore Geographical Relationships in Adobe Analytics Data with Power Map
Create data visualizations with Adobe Analytics in Power Map.
-
Build Bullhorn CRM-Connected Apps in Choreo
Use CData Connect AI to connect to Bullhorn CRM Data from Choreo and build custom apps using live Bullhorn CRM.
-
Working with GitLab Data in LINQPad
Execute LINQ queries to GitLab in LINQPad.
-
Integrate Live JSON Services into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to JSON from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live JSON.
-
Automated Continuous Vault CRM Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Vault CRM replication to Apache Kafka.
-
Working with Bright Data Data in LINQPad
Execute LINQ queries to Bright Data in LINQPad.
-
Integrate Live SparkPost Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live SparkPost to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to Accelo Data in JRuby
Create a simple JRuby app with access to live Accelo.
-
Salesforce Pardot Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Salesforce Pardot through CData Connect AI using different applications and tools.
-
How to Query Live PolarTeamPro Data in Claude Desktop
Connect to and query live PolarTeamPro Data in Claude Desktop using CData MCP Server.
-
Automated Continuous AlloyDB Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable AlloyDB replication to Azure SQL Database.
-
How to work with Amazon Marketplace Data in Apache Spark using SQL
Access and process Amazon Marketplace Data in Apache Spark using the CData Software JDBC Driver.
-
Build Data Flows from ConvertAPI to SQL Server using SSIS
Easily back up ConvertAPI to SQL Server using the SSIS components for ConvertAPI.
-
Getting Started with the CData Python Connector for Salesforce CRM Analytics
Learn to install and license the CData Python Connector
-
Integrate Open WebUI with Live Elasticsearch Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Elasticsearch from within the chat interface.
-
Write a Simple Go Application to work with Facebook Ads Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Facebook Ads.
-
Connect to and Query Shopify Data in QlikView over ODBC
Create data visualizations with Shopify in QlikView.
-
Creating MarkLogic-Connected Applications in Unqork
You can use CData Connect AI to feed MarkLogic to Unqork and build custom business apps.
-
How to connect PolyBase to Zuora
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Zuora.
-
Access iContact Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live iContact from HeidiSQL.
-
Query Zuora Data as a MySQL Database in Node.js
Execute MySQL queries against Zuora from Node.js.
-
Visualize Cohere 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 Cohere into TIBCO Spotfire.
-
Access Live Attio Data in TIBCO Data Virtualization
Use the CData API Driver for Tibco DV to create a Attio data source in TIBCO Data Virtualization Studio and gain access to live Attio from your TDV Server.
-
Integrate Theia IDE with Live Neo4J Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Use the CData Software ODBC Driver for FreeAgent in MicroStrategy Web
Connect to FreeAgent in MicroStrategy Web using the CData Software ODBC Driver for FreeAgent.
-
Rapidly Develop Webex-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 Webex.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Microsoft Planner within intelligent workflows.
-
Query Guru Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Guru from Node.js.
-
How to Work with Mode Data in AWS Glue Jobs Using JDBC
Connect to Mode from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous Amplitude Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Amplitude replication to PostgreSQL.