CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData Excel Add-In for Databricks
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Databricks.
-
Work with QuickBooks Online Data in FoxPro
Load QuickBooks Online data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous Strava Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Strava replication to delimited files (CSV/TSV).
-
Integrate with Shopify Data in JReport Designer
Create charts and reports based on Shopify data in JReport Designer.
-
Connect to Hacker News Data in RazorSQL
Connect to Hacker News from wizards and query Hacker News data from the GUI in the RazorSQL database management tool.
-
Integrating Zoho Creator Data in Talend Cloud Data Management Platform
Connect Zoho Creator Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Zoho Creator.
-
Automate ScrapingBee Integration Tasks from PowerShell
Are you in search of a quick and easy way to access ScrapingBee data from PowerShell? This article demonstrates how to utilize the ScrapingBee Cmdlets for tasks like connecting to ScrapingBee data, automating operations, downloading data, and more.
-
Query Timely Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Timely data from Node.js.
-
Bidirectional Access to Dropbox Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Dropbox data in Filemaker Pro for Mac or Windows.
-
How to Connect to Foursquare Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Foursquare data. Leverage the pyodbc module for ODBC in Python.
-
Connect to Azure Table Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Azure Table data from Filemaker Pro on Mac.
-
Integrate OpenCode with Live Zoho Projects Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Zoho Projects data from within your AI coding agent.
-
How to create LeadDesk federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for LeadDesk data in MySQL .
-
Visualize Airtable Data in Sisense
Create an ElastiCube in Sisense app with access to Airtable data.
-
Integrate with live SFTP Data in Jitterbit
Use CData Connect AI to connect to and integrate live SFTP data in Jitterbit.
-
Use the CData ODBC Driver for Sage Intacct from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Sage Intacct to connect to Sage Intacct data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Sage Intacct data in Excel.
-
Integrating LangGraph with LinkedIn Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on LinkedIn data within automated workflows.
-
How to connect to ZohoDesk Data from IntelliJ
Integrate connectivity to ZohoDesk data with wizards in IntelliJ.
-
Build Data Flows from SQL Server to Microsoft Planner through SSIS
Easily push SQL Server data to Microsoft Planner using the CData SSIS Tasks for Microsoft Planner.
-
Automated Continuous Salesforce CRM Analytics Replication to SingleStore
Use CData Sync for automated, continuous, customizable Salesforce CRM Analytics replication to SingleStore.
-
How to load Supabase data into Elasticsearch via Logstash
Introducing a simple method to load Supabase data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build MVC Applications with Connectivity to ZohoSubscriptions Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access ZohoSubscriptions from an ASP.NET MVC application.
-
Publish GraphQL-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live GraphQL data.
-
Create a Data Access Object for Aircall Data using JDBI
A brief overview of creating a SQL Object API for Aircall data in JDBI.
-
Automated Continuous BenchmarkEmail Replication to SQL Server
Use CData Sync for automated, continuous, customizable BenchmarkEmail replication to SQL Server.
-
Connect to Tanda Data in JRuby
Create a simple JRuby app with access to live Tanda data.
-
How to Visualize SAP Data in Python with pandas
Use pandas and other modules to analyze and visualize live SAP data in Python.
-
Import Real-Time Rebilly Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Rebilly data in ColdFusion.
-
Build Apps with Live Mailjet Data Using the Low-Code Development Platform of Mendix
Connect Mailjet data with Mendix to build apps using the CData API Driver for JDBC.
-
Automated Continuous Sentry Replication to Oracle
Use CData Sync for automated, continuous, customizable Sentry replication to Oracle.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for RSS
Provide connectivity to RSS feeds through an SAP BusinessObjects universe.
-
Create Informatica Mappings From/To an ODBC Data Source for Amazon Athena
Create an ODBC connection to Amazon Athena in Informatica and browse and transfer Amazon Athena data.
-
How to create an RPA flow for ChargeOver Data in UiPath Studio
Use the ChargeOver ODBC Driver to create workflows that access real-time ChargeOver data without any coding.
-
Import Real-Time Copper Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Copper data in ColdFusion.
-
Use the CData Software ODBC Driver for Teamgate in MicroStrategy Desktop
Connect to Teamgate data in MicroStrategy Desktop using the CData Software ODBC Driver for Teamgate.
-
Automate Humanity Data Replication to SAP HANA
Use CData Sync to customize and automate Humanity data replication to SAP HANA.
-
Integrate with Campaigner Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Campaigner data in SnapLogic.
-
Model, Search, and Visualize Live Microsoft Exchange Data in ThoughtSpot
Use CData Connect AI to connect to live Microsoft Exchange data for modeling, searching, and visualizing.
-
Build an OLAP Cube in SSAS from Procore Data
Establish a connection to Procore data data from SQL Server Analysis Services, and use the Procore Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to create an RPA flow for Close Data in UiPath Studio
Use the Close ODBC Driver to create workflows that access real-time Close data without any coding.
-
Build Charts with QuickBooks Online Data in Clear Analytics
Create dynamic charts and perform analytics based on QuickBooks Online data in Clear Analytics.
-
Use the CData ODBC Driver for Salesforce Pardot in Microsoft Power Query
You can use the CData Salesforce Pardot ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Salesforce Pardot data into Microsoft Power Query.
-
Connect to Authorize.Net Data from AWS Glue
Use CData Connect AI to gain access to live Authorize.Net data from your AWS Glue jobs.
-
Excel Spreadsheet Automation on Customer.io Data with the QUERY Formula
Pull data from Customer.io, automate spreadsheets, and more with the QUERY formula.
-
Integrate with Live BambooHR Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to BambooHR from the MuleSoft Anypoint Platform to integrate live BambooHR data into custom reports and dashboards.
-
Natively Connect to Stack Exchange Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Stack Exchange data. Leverage the native support for ODBC in PHP.
-
Build Visualizations of Wistia Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Wistia data in Birst.
-
Building Dynamic Web Pages with SAP Business Warehouse Data Using AngularJS
Create single-page applications with live connectivity to SAP Business Warehouse using the CData API Server.
-
Automated CircleCI Data Replication to Teradata
Use CData Sync to Customize and automate CircleCI data replication to Teradata.
-
Bind Live Adobe Commerce Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Adobe Commerce data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Choosing the Best Method to Connect Sage Intacct to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Sage Intacct data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build a Simple VCL Application for Beeminder Data
How to build a simple VCL Application to view Beeminder data in RAD Studio using the CData ODBC Driver for Beeminder.
-
How to integrate Webflow with Apache Airflow
Access and process Webflow data in Apache Airflow using the CData JDBC Driver.
-
Build a PostgreSQL Interface for Figshare Data using the CData JDBC Driver
Use the Remoting features of the Figshare JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Salesforce Pardot Data in Pentaho Data Integration
Build ETL pipelines based on Salesforce Pardot data in the Pentaho Data Integration tool.
-
Visualize SAS Data Sets Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to SAS Data Sets data.
-
Integrate Goose with Live Smartsheet Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Smartsheet data from within the local AI agent.
-
Replicate Unbounce Data in Heroku for Use in Salesforce Connect
Replicate Unbounce data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build Apps with Live TaxJar data in Adalo using CData Connect AI
Use CData Connect AI to integrate live TaxJar data into the Adalo platform and build custom mobile and web applications with real-time TaxJar data.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for CloudConvert
Provide connectivity to CloudConvert data through an SAP BusinessObjects universe.
-
How to import Jodoo Data into Apache Solr
Use the CData Software JDBC Driver for Jodoo in Data Import Handler and create an automated import of Jodoo data to Apache Solr Enterprise Search platform.
-
Integrating GitHub Copilot with Google Ads 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.
-
Create Informatica Mappings From/To an ODBC Data Source for WordPress
Create an ODBC connection to WordPress in Informatica and browse and transfer WordPress data.
-
DataBind PagerDuty Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide PagerDuty data to a chart.
-
Explore Geographical Relationships in Adobe Experience Manager Data with Power Map
Create data visualizations with Adobe Experience Manager data in Power Map.
-
Using the CData Software ODBC Driver for Stack Exchange in PyCharm
Connect to Stack Exchange as an ODBC data source in PyCharm using the CData Software ODBC Driver for Stack Exchange.
-
Use the CData Software ODBC Driver for Marketo in MicroStrategy Desktop
Connect to Marketo data in MicroStrategy Desktop using the CData Software ODBC Driver for Marketo.
-
Connect to Mode Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Mode and the SQL Gateway to access Mode data from Google Apps Script.
-
DataBind Oracle Eloqua Reporting Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Oracle Eloqua Reporting with the DevExpress Windows Forms and Web controls to provide Oracle Eloqua Reporting data to a chart.
-
Build Data Flows from SQL Server to Freshdesk through SSIS
Easily push SQL Server data to Freshdesk using the CData SSIS Tasks for Freshdesk.
-
Integrate with Smartsheet Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Smartsheet data to a JSON file on disk.
-
Use the CData Software ODBC Driver for LeadDesk in MicroStrategy
Connect to LeadDesk data in MicroStrategy Developer using the CData Software ODBC Driver for LeadDesk.
-
Automated Continuous Humanity Replication to SingleStore
Use CData Sync for automated, continuous, customizable Humanity replication to SingleStore.
-
Bind Live Splunk Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Splunk data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Query Live SuiteCRM 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 SuiteCRM data directly from the development environment.
-
Connect to and Visualize Live Basecamp Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Basecamp data.
-
Connect to Attio Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Attio and work with Attio data in your FileMaker applications.
-
Visualize Facebook Data in Sisense
Create an ElastiCube in Sisense app with access to Facebook data.
-
Visualize Live MailerLite Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live MailerLite data.
-
How to Connect to Apollo Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Apollo data. Leverage the pyodbc module for ODBC in Python.
-
Build Dashboards with Zoho Inventory Data in DBxtra
Create dynamic dashboards and perform analytics based on Zoho Inventory data in DBxtra.
-
Excel Spreadsheet Automation on Cohere Data with the QUERY Formula
Pull data from Cohere, automate spreadsheets, and more with the QUERY formula.
-
Connect to SurveyMonkey Data in DBArtisan
Use wizards in DBArtisan to configure SurveyMonkey data as a data source.
-
How to connect Amazon QuickSight to NetSuite SuiteAnalytics Data
Create a connection to NetSuite SuiteAnalytics data in CData Connect AI and insert NetSuite SuiteAnalytics data into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect to Copper Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Copper as an External Source in Dremio.
-
Trigger Pipedrive IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Pipedrive with standard wizards in Logic Apps.
-
Build ZohoExpense-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live ZohoExpense data.
-
Integrate Google's Vertex AI Agent with Live Bitbucket Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Bitbucket data within intelligent workflows.
-
Connecting Pipedream with Power BI XMLA 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 Power BI XMLA data in real time.
-
WordPress Reporting in OBIEE with the WordPress JDBC Driver
Deploy the WordPress JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Replicate Beeminder Data to Multiple Databases
Replicate Beeminder data to disparate databases with a point-and-click configuration.
-
Replicate Browserless Data in Heroku for Use in Salesforce Connect
Replicate Browserless data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Query Oracle Data in DataGrip
Create a Data Source for Oracle in DataGrip and use SQL to query live Oracle data.
-
LINQ to Notion Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Notion Data Provider.
-
Build Voice Agents in ElevenLabs with access to Live RSS Feeds
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live RSS feeds.
-
Connect to LDAP in SpagoBI
Create reports featuring live LDAP objects in SpagoBI Studio. Host LDAP reports on SpagoBI Server.
-
Getting Started with the CData Power BI Connector for Active Directory
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Active Directory.
-
Manage PhantomBuster Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for PhantomBuster.
-
Integrate BigCommerce with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate BigCommerce with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to BigCommerce data.
-
How to connect to EmailOctopus Data from IntelliJ
Integrate connectivity to EmailOctopus data with wizards in IntelliJ.