CData Software - Knowledge Base
Recent Articles
-
Access Live MongoDB Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate MongoDB into the statistical analysis tools available in SAS JMP. This article shows how to use MongoDB in the Graph Builder and Query Builder.
-
Automated Continuous MySQL Replication to SingleStore
Use CData Sync for automated, continuous, customizable MySQL replication to SingleStore.
-
Query BenchmarkEmail Data in ColdFusion
Write standard ColdFusion data access code to connect to BenchmarkEmail.
-
Integrate Live Sage Cloud Accounting Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Sage Cloud Accounting from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Sage Business Cloud Accounting.
-
Using the CData Software ODBC Driver for Excel Online in PyCharm
Connect to Excel Online as an ODBC data source in PyCharm using the CData Software ODBC Driver for Excel Online.
-
How to Seamlessly Import Tavily Data into IBM SPSS Modeler
Integrate Tavily data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrating Cursor CLI with Xero 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.
-
Automate SAP Fieldglass Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SAP Fieldglass from PowerShell? This article demonstrates how to utilize the SAP Fieldglass Cmdlets for tasks like connecting to SAP Fieldglass, automating operations, downloading data, and more.
-
Connect to ClickUp Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for ClickUp to connect to ClickUp and execute queries in PowerBuilder.
-
Viewing Microsoft Entra ID Data in RAD Studio Data Explorer
How to view Microsoft Entra ID in RAD Studio Data Explorer using the CData ODBC Driver for Microsoft Entra ID.
-
Analyze AlloyDB Data in Looker
Use CData Connect AI to connect to AlloyDB Data from Looker and build custom apps using live Google AlloyDB.
-
Easily Integrate TigerGraph Data in Lazarus Pascal IDE
Learn how to easily integrate live TigerGraph in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Analyze MySQL Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze MySQL with the CData JDBC Driver for MySQL.
-
Manage ClickTime Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for ClickTime.
-
Connect to Bullhorn CRM Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Access Jodoo Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Jodoo from HeidiSQL.
-
Publish Amplitude-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Amplitude.
-
How to Import Data from Jira into Google Sheets
Import Atlassian Jira into a Google spreadsheet that is automatically refreshed.
-
Visualize Live SAP Business One Data in the Power BI Service
Use CData Connect AI to connect to live SAP Business One and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Reply.io Data in RazorSQL
Connect to Reply.io from wizards and query Reply.io from the GUI in the RazorSQL database management tool.
-
Getting Started with the CData Python Connector for ScrapingBee
Learn to install and license the CData Python Connector
-
Connect to Delighted Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Delighted to connect to Delighted and execute queries in PowerBuilder.
-
How to Build an ETL App for Elorus Data in Python with CData
Create ETL applications and real-time data pipelines for Elorus in Python with petl.
-
Getting Started with the CData SSIS Components for Amazon Athena
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Amazon Athena.
-
Build Pipelines with Live Klaviyo Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Klaviyo from Google Cloud Data Fusion, enabling the integration of live Klaviyo into the building and management of effective data pipelines.
-
DataBind SAP Business One Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for SAP Business One with the DevExpress Windows Forms and Web controls to provide SAP Business One to a chart.
-
How to Seamlessly Import Beeminder Data into IBM SPSS Modeler
Integrate Beeminder data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Apps with Live Amplitude Data Using the Low-Code Development Platform of Mendix
Connect Amplitude with Mendix to build apps using the CData API Driver for JDBC.
-
How to Import Data from Google Directory into Google Sheets
Import Google Directory into a Google spreadsheet that is automatically refreshed.
-
Process & Analyze ZohoSubscriptions Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live ZohoSubscriptions Data.
-
Connect to Placid Data in RapidMiner
Integrate Placid with standard components and data source configuration wizards in RapidMiner Studio.
-
Build Semantic Layer Views for Databricks Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Databricks.
-
Build Semantic Layer Views for GitHub Data in APOS Live Data Gateway
Use the CData Connector for GitHub in APOS Live Data Gateway to build Semantic Layer Views for GitHub.
-
How to Access Live Amazon DynamoDB Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Amazon DynamoDB enables you to integrate Amazon DynamoDB into workflows built using Microsoft Power Automate Desktop.
-
Building Dynamic Web Pages with Sugar CRM Data Using AngularJS
Create single-page applications with live connectivity to Sugar CRM using the CData API Server.
-
Automated Continuous Microsoft Exchange Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Microsoft Exchange replication to Google BigQuery.
-
Perform Batch Operations with Adobe Commerce Data in Apache NiFi
Connect to Adobe Commerce and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Query Attio Data in ColdFusion
Write standard ColdFusion data access code to connect to Attio.
-
Connect Drift Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Drift using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Analyze Live Splunk Data in SAS Viya
Use CData Connect AI to connect to Splunk from SAS Viya and deploy self-service analytics using live Splunk.
-
Seamlessly Bring Google Calendar Data into Retool Using CData Connect AI
Integrate Google Calendar data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Replicate Aha! Data in Heroku for Use in Salesforce Connect
Replicate Aha! to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrate with Pingdom Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Pingdom to a JSON file on disk.
-
Create Blackbaud FE NXT Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Blackbaud FE NXT data access from reports, embedded analytics, and more.
-
Use Dash to Build Web Apps on Google Campaign Manager 360 Data via CData Connect AI
Build interactive Dash web apps on live Google Campaign Manager 360 using pandas and the CData Connect AI Python SDK.
-
Add Twilio Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Twilio with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Access Recurly Data Using Entity Framework
This article shows how to access Recurly using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
DataBind Charts to Act CRM Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Act CRM 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 Live Blackbaud FE NXT Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Create Informatica Mappings From/To a JDBC Data Source for AlloyDB
Create AlloyDB data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to MySQL Data in Aqua Data Studio
Access MySQL from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build Dashboards with Authorize.Net Data in Dundas BI
Create dynamic dashboards and perform analytics based on Authorize.Net in Dundas BI.
-
Creating Sage 200-Connected Applications in Unqork
You can use CData Connect AI to feed Sage 200 to Unqork and build custom business apps.
-
Connect to and Visualize Live PostgreSQL Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live PostgreSQL.
-
Visualize Google Ads Data in TIBCO Spotfire through ADO.NET
Integrate Google Ads into dashboards in TIBCO Spotfire.
-
Build SendGrid-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for SendGrid to explore live SendGrid Data in Cursor to assist with building SendGrid-powered applications.
-
Connect to Lakebase Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to PagerDuty Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to PagerDuty and work with PagerDuty in your FileMaker applications.
-
Visualize Phoenix Data in TIBCO Spotfire through OData
Integrate Apache Phoenix into dashboards in TIBCO Spotfire.
-
Connect to SAP Data in DBArtisan
Use wizards in DBArtisan to configure SAP ERP/NetWeaver as a data source.
-
Integrate Moosend with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Moosend with External Services.
-
Connect to Google Cloud Storage in SpagoBI
Create reports featuring live Google Cloud Storage in SpagoBI Studio. Host Google Cloud Storage reports on SpagoBI Server.
-
Getting Started with the CData JDBC Driver for MYOB AccountRight
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for MYOB AccountRight.
-
Use the CData Software JDBC Driver for Jira Assets in MicroStrategy Desktop
Connect to Jira Assets in MicroStrategy Desktop using the CData Software JDBC Driver for Jira Assets.
-
Replicate Multiple Elasticsearch Accounts
Replicate multiple Elasticsearch accounts to one or many databases.
-
Access Live Scrapfly Data in AWS Lambda
Connect to live Scrapfly in AWS Lambda using the CData JDBC Driver.
-
Automated Continuous FormSite Replication to Databricks
Use CData Sync for automated, continuous, customizable FormSite replication to Databricks.
-
Connect to Coda Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Coda and the SQL Gateway to access Coda from Google Apps Script.
-
Add Stack Exchange Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Stack Exchange with the Informatica Enterprise Data Catalog to classify and organize data.
-
Query Epicor Kinetic Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Epicor Kinetic entities in PHP by modeling them as objects.
-
Getting Started with the CData Tableau Connector for LeadDesk
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Bidirectional Access to FreshBooks Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate FreshBooks in Filemaker Pro for Mac or Windows.
-
Automate Clari Data Replication to SAP HANA
Use CData Sync to customize and automate Clari replication to SAP HANA.
-
Use JayDeBeApi to access ZohoInvoice Data in Python
Use standard Python scripting and the development environment of your choice to access live ZohoInvoice.
-
Connect to Dropbox Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Dropbox.
-
Automated Continuous Rebilly Replication to Vertica
Use CData Sync for automated, continuous, customizable Rebilly replication to Vertica.
-
Automated Continuous Exact Online Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Exact Online replication to Amazon Redshift.
-
Connect to RSS Feeds as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for RSS Feeds.
-
Analyze eBay Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for eBay from Power Pivot. You will use the Table Import Wizard to load eBay. You can visually build the import query or use any SQL supported by the driver.
-
Load Discord Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Discord to a database.
-
Query Live Amazon DynamoDB Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Amazon DynamoDB directly from the development environment.
-
Use the CData Software JDBC Driver for GraphQL in MicroStrategy Desktop
Connect to GraphQL in MicroStrategy Desktop using the CData Software JDBC Driver for GraphQL.
-
Build Charts with HubSpot Data in Clear Analytics
Create dynamic charts and perform analytics based on HubSpot in Clear Analytics.
-
How to Query Live Freshsales Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Freshsales data in natural language using Python.
-
Create Dashboards and Visualize Live ActiveCampaign Data in Geckoboard
Use CData Connect AI to connect to live ActiveCampaign and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Build Voice Agents in ElevenLabs with access to Live Freshdesk Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Freshdesk.
-
Import Real-Time Planio Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Planio in ColdFusion.
-
How to Build an ETL App for Sage 200 Data in Python with CData
Create ETL applications and real-time data pipelines for Sage 200 in Python with petl.
-
Connect to and Visualize Live ServiceNow Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live ServiceNow.
-
Connect to SFTP Data in RazorSQL
Connect to SFTP from wizards and query SFTP from the GUI in the RazorSQL database management tool.
-
How to Connect Flowise AI Agents to Live BambooHR 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 BambooHR without replication.
-
How to Visualize Freshsales Data in Python with pandas
Use pandas and other modules to analyze and visualize live Freshsales in Python.
-
Connect to Stripe in SpagoBI
Create reports featuring live Stripe in SpagoBI Studio. Host Stripe reports on SpagoBI Server.
-
How to connect to JobNimbus Data from IntelliJ
Integrate connectivity to JobNimbus with wizards in IntelliJ.
-
Connect to SFTP Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connecting Agentforce with Greenhouse 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 Greenhouse for you.
-
Load Gmail Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Gmail to a database.
-
How to Connect to Live Confluence Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Atlassian Confluence through natural language.
-
Visualize Amazon Athena Data in Tableau
The CData ODBC driver for Amazon Athena enables you integrate Amazon Athena into Tableau dashboards.
-
Replicate Calendly Data to Multiple Databases
Replicate Calendly to disparate databases with a point-and-click configuration.