CData Software - Knowledge Base
Recent Articles
-
How to Access Live PabblySubscriptions Data in Power Automate Desktop via ODBC
The CData ODBC Driver for PabblySubscriptions enables you to integrate PabblySubscriptions into workflows built using Microsoft Power Automate Desktop.
-
Build Odoo-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Odoo ERP.
-
Build ShipStation-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for ShipStation to explore live ShipStation Data in GitHub Copilot to assist with building ShipStation-powered applications.
-
Use the CData Software ODBC Driver for Spotify in MicroStrategy
Connect to Spotify in MicroStrategy Developer using the CData Software ODBC Driver for Spotify.
-
Automated Continuous SingleStore Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable SingleStore replication to Google BigQuery.
-
How to connect to SparkPost Data with Squirrel SQL client
Connect to SparkPost and execute queries in the Squirrel SQL Client.
-
Trigger EnterpriseDB IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for EnterpriseDB with standard wizards in Logic Apps.
-
Create Informatica Mappings From/To an ODBC Data Source for Beeminder
Create an ODBC connection to Beeminder in Informatica and browse and transfer Beeminder.
-
Analyze Eventbrite Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Eventbrite and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Build Dashboards with Salesforce Data 360 Data in Dundas BI
Create dynamic dashboards and perform analytics based on Salesforce Data 360 in Dundas BI.
-
LINQ to Exact Online 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 Exact Online Data Provider.
-
Create Reports with Okta Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Okta.
-
Build a PostgreSQL Interface for Avalara AvaTax Data using the CData JDBC Driver
Use the Remoting features of the Avalara AvaTax JDBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Sage 200 Data in TIBCO Spotfire through ADO.NET
Integrate Sage 200 into dashboards in TIBCO Spotfire.
-
Create Reports from Google Drive Data in Looker Studio
Use CData Connect AI to gain access to live Google Drive and create custom reports in Looker Studio.
-
Getting Started with the CData SSIS Components for Factorial
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Factorial.
-
Process & Analyze Stripe Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Stripe Data.
-
Build Charts with Coinbase Data in Clear Analytics
Create dynamic charts and perform analytics based on Coinbase in Clear Analytics.
-
Connect to and Visualize Live Outreach.io Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Outreach.io.
-
Import Real-Time Zoho Inventory Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Zoho Inventory in ColdFusion.
-
Bidirectional Access to Everhour Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Everhour in Filemaker Pro for Mac or Windows.
-
Analyze Figshare Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Figshare from Power Pivot. You will use the Table Import Wizard to load Figshare. You can visually build the import query or use any SQL supported by the driver.
-
Getting Started with the CData Python Connector for Spotify
Learn to install and license the CData Python Connector
-
Create Data Visualizations in Cognos BI with Cvent Data
Access Cvent as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Visualize Microsoft Teams Data in Python with pandas
Use pandas and other modules to analyze and visualize live Microsoft Teams in Python.
-
Visualize REST Data in Tableau
The CData ODBC driver for REST enables you integrate REST into Tableau dashboards.
-
Connect to Gmail Data in Google Apps Script via Connect AI
Use CData Connect AI to access Gmail in Google Apps Script.
-
Bidirectional Access to HelloSign Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate HelloSign in Filemaker Pro for Mac or Windows.
-
Build Apps with Live Apache Spark SQL in Adalo using CData Connect AI
Use CData Connect AI to integrate live Apache Spark SQL into the Adalo platform and build custom mobile and web applications with real-time Apache Spark SQL.
-
Automate Hubstaff Data Replication to Azure Data Lake
Use CData Sync to customize and automate Hubstaff replication to Azure Data Lake.
-
FHIR Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to FHIR through CData Connect AI using different applications and tools.
-
Getting Started with the CData Tableau Connector for PivotalTracker
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Write a Simple Go Application to work with Exa Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Exa.
-
How to create Visio diagrams from Zoho CRM Data
Automatically update Zoho CRM with the changes you make to Visio master shapes.
-
Integrate Live Aha! Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Aha! to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Integrating OpenCode Terminal with Epicor Kinetic 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.
-
Validate Square Data with QuerySurge
Access and validate Square in QuerySurge using the CData JDBC Driver.
-
Model, Search, and Visualize Live Adobe Commerce Data in ThoughtSpot
Use CData Connect AI to connect to live Adobe Commerce for modeling, searching, and visualizing.
-
Automated Continuous Salesloft Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Salesloft replication to AlloyDB.
-
Validate Brex Data with QuerySurge
Access and validate Brex in QuerySurge using the CData JDBC Driver.
-
Build Salesforce Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Salesforce & Force.com and build visualizations in Tableau.
-
Automated Continuous MessageBird Replication to Snowflake
Use CData Sync for automated, continuous, customizable MessageBird replication to Snowflake.
-
Migrating data from QuickBooks Online to Google BigQuery using CData SSIS Components.
Easily push QuickBooks Online to Google BigQuery using the CData SSIS Tasks for QuickBooks Online and Google BigQuery.
-
Import Dotmailer Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Dotmailer. In this article, you will use the OData format to import Dotmailer into Microsoft Power Query.
-
Analyze CouchDB Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Apache CouchDB with the CData JDBC Driver for CouchDB.
-
Build a Singer.io Tap for Dynamics CRM With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Dynamics CRM data using
-
Explore Geographical Relationships in Amazon Marketplace Data with Power Map
Create data visualizations with Amazon Marketplace in Power Map.
-
Automated Continuous Azure Synapse Replication to Oracle
Use CData Sync for automated, continuous, customizable Azure Synapse replication to Oracle.
-
Connect to Sybase Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Sybase and the Script function in FileMaker Pro to connect to Sybase and work with Sybase in your FileMaker application.
-
Moving Data from SAP Business One to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live SAP Business One data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to Freshdesk Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Freshdesk.
-
Build Semantic Layer Views for Outreach.io Data in APOS Live Data Gateway
Use the CData Connector for Outreach.io in APOS Live Data Gateway to build Semantic Layer Views for Outreach.io.
-
Connect to Real-Time ActiveCampaign Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for ActiveCampaign and Dataflow to import and use ActiveCampaign in Power Apps.
-
LinkedIn Reporting in OBIEE with the LinkedIn JDBC Driver
Deploy the LinkedIn JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to and Query ZohoExpense Data in QlikView over ODBC
Create data visualizations with ZohoExpense in QlikView.
-
Connect to Zoho Projects Data from AWS Glue
Use CData Connect AI to gain access to live Zoho Projects from your AWS Glue jobs.
-
Build AI Agents with HBase 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 Apache HBase through CData Connect AI.
-
Integrate Adobe Target with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Adobe Target with External Services.
-
How to connect to ClickUp Data from IntelliJ
Integrate connectivity to ClickUp with wizards in IntelliJ.
-
Visualize OpenWeatherMap 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 OpenWeatherMap into TIBCO Spotfire.
-
Access Live Zoho Creator Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Zoho Creator in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to use SQLAlchemy ORM to access Gong Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Gong.
-
Connecting Pipedream with Cvent 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 Cvent data in real time.
-
How to create Visio diagrams from Teradata Data
Automatically update Teradata with the changes you make to Visio master shapes.
-
Connecting Agentforce with SharePoint 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 Microsoft SharePoint for you.
-
Connect to Aircall from Asprova with CData Software ODBC Driver for Aircall
This article shows how to connect faster to Aircall data from Asprova.
-
Connecting GenSpark with Vault CRM Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Veeva Vault & Vault CRM without any replication or custom integration required.
-
Feed Coda Data into FineReport
How to set Coda as a JDBC data source in FineReport.
-
Build an OLAP Cube in SSAS from SAS Data Sets Data
Establish a connection to SAS Data Sets data from SQL Server Analysis Services, and use the SAS Data Sets Data Provider to build OLAP cubes for use in analytics and reporting.
-
Build SAP Netweaver Gateway-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SAP Netweaver Gateway and build web apps with connectivity to live SAP Netweaver Gateway.
-
Connect to Neo4J Data in CloverDX (formerly CloverETL)
Transfer Neo4J using the visual workflow in the CloverDX data integration tool.
-
Getting Started with the CData JDBC Driver for RSS
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for RSS.
-
Getting Started with the CData Python Connector for Databricks
Learn to install and license the CData Python Connector
-
Connect Aircall Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Aircall using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Publish Reports with SharePoint Excel Services Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SharePoint Excel Services.
-
Access Live eBay Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live eBay through MCP integration.
-
Publish Salesforce Marketing-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Salesforce Marketing Cloud.
-
Consume Strava OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Strava feeds that reflect any changes in SAP Lumira.
-
Back Up BigCommerce to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for BigCommerce. In this article, we will employ an SSIS workflow to populate a database with BigCommerce data.
-
Migrating data from SAP ByDesign to Databricks using CData SSIS Components.
Easily push SAP Business ByDesign to Databricks using the CData SSIS Tasks for SAP ByDesign and Databricks.
-
Integrate Salesforce with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Salesforce with External Services.
-
Automated Continuous Reckon Accounts Hosted Replication to Oracle
Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to Oracle.
-
Automated Continuous GitLab Replication to MySQL
Use CData Sync for automated, continuous, customizable GitLab replication to MySQL.
-
Connect Printify to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Printify with IBM WebSphere for seamless data integration and connectivity.
-
Replicate Multiple Marketo Accounts via the CData Sync CLI
Replicate multiple Marketo accounts to one or many databases.
-
Create Power BI Reports on Real-Time Sentry Data
Use the CData ODBC Driver for Sentry to visualize Sentry in Power BI Desktop.
-
How to Query Live Sage 200 Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Sage 200 data in natural language using Python.
-
Visualize SAP Hybris C4C Data in TIBCO Spotfire through OData
Integrate SAP Hybris C4C into dashboards in TIBCO Spotfire.
-
Integrating GitHub Copilot CLI with Vimeo 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.
-
How to Access Live NetSuite Data in Power Automate Desktop via ODBC
The CData ODBC Driver for NetSuite enables you to integrate NetSuite CRM & ERP into workflows built using Microsoft Power Automate Desktop.
-
Build Square-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Square.
-
Connecting Agentforce with Microsoft Entra ID 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 Microsoft Entra ID for you.
-
Connect to Delighted Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Delighted and work with Delighted in your FileMaker application.
-
Natively Connect to BigQuery Data in PHP
The CData ODBC driver for BigQuery enables you to create PHP applications with connectivity to Google BigQuery. Leverage the native support for ODBC in PHP.
-
Replicate ShipStation Data to Multiple Databases via the CData Sync CLI
Replicate ShipStation to disparate databases with a single configuration.
-
Use the CData ODBC Driver for Snapchat Ads from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Snapchat Ads to connect to Snapchat Ads from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Snapchat Ads in Excel.
-
Connect BigCommerce Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your BigCommerce using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build Greenplum-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Greenplum to explore live Greenplum Data in GitHub Copilot to assist with building Greenplum-powered applications.
-
Create MySQL-Connected Nintex Workflows
Use CData Connect AI to connect to MySQL Data from Nintex Workflow Cloud and build custom workflows using live MySQL.
-
Connect to Spark Data in RapidMiner
Integrate Apache Spark SQL with standard components and data source configuration wizards in RapidMiner Studio.