CData Software - Knowledge Base
Recent Articles
-
Import Greenhouse Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Greenhouse Data and provide access to live Greenhouse for custom reports in the Power BI Service.
-
Connect to Planio Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Planio and work with Planio in your FileMaker applications.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Instagram actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Automated Continuous Timely Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Timely replication to delimited files (CSV/TSV).
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for MySQL
Provide connectivity to MySQL through an SAP BusinessObjects universe.
-
How to connect Amazon QuickSight to Sage 200 Data
Create a connection to Sage 200 in CData Connect AI and insert Sage 200 into Amazon QuickSight SPICE to build interactive dashboards.
-
Build Apps with Live Amazon S3 Data Using the Low-Code Development Platform of Mendix
Connect Amazon S3 with Mendix to build apps using the CData JDBC Driver for Amazon S3.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Salesforce
Provide connectivity to Salesforce & Force.com through an SAP BusinessObjects universe.
-
Build BambooHR-Connected Apps in Choreo
Use CData Connect AI to connect to BambooHR Data from Choreo and build custom apps using live BambooHR.
-
Enable the Google Calendar JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Google Calendar.
-
Replicate Multiple Adobe Analytics Accounts
Replicate multiple Adobe Analytics accounts to one or many databases.
-
Prepare, Blend, and Analyze IBM Informix Data in Alteryx Designer (Connect AI)
Build workflows to access live IBM Informix for self-service data analytics.
-
Automated Continuous Twilio Replication to SingleStore
Use CData Sync for automated, continuous, customizable Twilio replication to SingleStore.
-
Automated Continuous Jodoo Replication to SingleStore
Use CData Sync for automated, continuous, customizable Jodoo replication to SingleStore.
-
Create Apps from Presto Data in Qlik Sense Cloud
Use CData Connect AI to connect to Presto Data and build apps from live Presto in Qlik Sense Cloud.
-
Use the CData ODBC Driver for Airtable from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Airtable to connect to Airtable from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Airtable in Excel.
-
How to publish and share Customer.io Data dashboards with Tableau Server
The CData ODBC driver for Customer.io enables you integrate Customer.io into Tableau dashboards.
-
How to Connect to Live HubSpot Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live HubSpot without replication.
-
Working with YouTube Analytics Data in LINQPad
Execute LINQ queries to YouTube Analytics in LINQPad.
-
Automated Continuous Pingdom Replication to Oracle
Use CData Sync for automated, continuous, customizable Pingdom replication to Oracle.
-
Visualize SAP ByDesign Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to SAP Business ByDesign.
-
Getting Started with the CData Tableau Connector for Google Spanner
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Google Spanner.
-
Connect to Box Data in Jaspersoft Studio
Execute SQL to remote Box in Jaspersoft Studio.
-
Getting Started with the CData Tableau Connector for ZohoDesk
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Connect to and Query Oracle Financials Cloud Data in QlikView over ODBC
Create data visualizations with Oracle Financials Cloud in QlikView.
-
Bridge AlloyDB Connectivity with Apache NiFi
Access and process Google AlloyDB in Apache NiFi using the CData JDBC Driver.
-
Migrating data from FHIR to Google BigQuery using CData SSIS Components.
Easily push FHIR to Google BigQuery using the CData SSIS Tasks for FHIR and Google BigQuery.
-
Connect to Live Neo4J Data in MicroStrategy through CData Connect AI
Create a live connection to Neo4J Data in CData Connect AI and connect to your Neo4J from MicroStrategy.
-
Analyze Google Analytics Data in Cognos Analytics
Use CData Connect AI to connect to Google Analytics Data from Cognos Analytics and analyze live Google Analytics.
-
Oracle Sales Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Oracle Sales through CData Connect AI using different applications and tools.
-
Access Live CampaignMonitor Data in AWS Lambda (with IntelliJ IDEA)
Connect to live CampaignMonitor in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Query Live Telegram Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Telegram data in natural language using Python.
-
Natively Connect to Smartsheet Data in PHP
The CData ODBC driver for Smartsheet enables you to create PHP applications with connectivity to Smartsheet. Leverage the native support for ODBC in PHP.
-
How to Query Amazon S3 Data in MySQL Workbench
Execute MySQL queries against live Amazon S3 from MySQL Workbench.
-
Automated Continuous Jira Replication to MongoDB
Use CData Sync for automated, continuous, customizable Jira replication to MongoDB.
-
Add eBay Analytics Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for eBay Analytics with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Excel Online Data from a Connection Pool in JBoss
Integrate Microsoft Excel Online into Java servlets: Use the Management Console in JBoss to install the Excel Online JDBC Driver.
-
How to create an RPA flow for GitHub Data in UiPath Studio
Use the GitHub ODBC Driver to create workflows that access real-time GitHub without any coding.
-
How to Connect to Webflow Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Webflow. Leverage the pyodbc module for ODBC in Python.
-
How to Visualize Postmark Data in Python with pandas
Use pandas and other modules to analyze and visualize live Postmark in Python.
-
Getting Started with the CData ADO.NET Provider for Hacker News
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Integrating LangGraph with Redis Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Redis within automated workflows.
-
Create SSAS Tabular Models from Sage Cloud Accounting Data
How to build a SQL Server Analysis Service Tabular Model from Sage Business Cloud Accounting using CData drivers.
-
How to use SQLAlchemy ORM to access Amazon DynamoDB Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Amazon DynamoDB.
-
Connect to Bannerbear from Asprova with CData Software ODBC Driver for Bannerbear
This article shows how to connect faster to Bannerbear data from Asprova.
-
Getting Started with the CData ODBC Driver for Brex
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Brex.
-
Work with GitHub Data in FoxPro
Load GitHub into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SAP Business Warehouse
Provide connectivity to SAP Business Warehouse through an SAP BusinessObjects universe.
-
Visualize Sybase Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Sybase.
-
Getting Started with the CData Tableau Connector for QuickBooks
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for QuickBooks.
-
Build an OLAP Cube in SSAS from Bright Data Data
Establish a connection to Bright Data data from SQL Server Analysis Services, and use the Bright Data Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Epicor Kinetic within intelligent workflows.
-
Connect to Salesforce Data in JRuby
Create a simple JRuby app with access to live Salesforce & Force.com.
-
Connect to MessageBird from a Connection Pool in WebLogic
Use the CData JDBC Driver for MessageBird to connect to MessageBird from Web applications running on WebLogic.
-
Automated Continuous BigCommerce Replication to Oracle
Use CData Sync for automated, continuous, customizable BigCommerce replication to Oracle.
-
Create SSAS Tabular Models from Cohere Data
How to build a SQL Server Analysis Service Tabular Model from Cohere using CData drivers.
-
Visualize Printify 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 Printify into TIBCO Spotfire.
-
Automate Tasks in Power Automate Using the CData API Server
Automate MySQL actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
DataBind Humanity Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Humanity to a chart.
-
Automated Continuous Discord Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Discord replication to OneLake in Microsoft Fabric.
-
Use Azure AI Foundry to Talk to Your Box Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Box for you.
-
Publish Bugsnag-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Bugsnag.
-
Integrating Claude Code CLI with TigerGraph 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.
-
Build AI/ML Models with Live MailerSend Data using Dataiku
Connect MailerSend Data with Dataiku using the CData API Driver for JDBC.
-
Connecting Mastra with Sybase Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Sybase, no replication required.
-
Getting Started with the CData Power BI Connector for EnterpriseDB
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for EnterpriseDB.
-
DataBind Landbot Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Landbot to a chart.
-
Integrating Redshift Data in Talend Cloud Data Management Platform
Connect Redshift Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Redshift.
-
Integrating GitHub Copilot CLI with REST 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.
-
Manage MySQL Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for MySQL.
-
Design BIRT Reports on Outreach.io Data
Provide current Outreach.io to your embedded analytics.
-
Automate CSV Integration Tasks from PowerShell
Are you in search of a quick and easy way to access CSV/TSV Files from PowerShell? This article demonstrates how to utilize the CSV Cmdlets for tasks like connecting to CSV/TSV Files, automating operations, downloading data, and more.
-
How to connect to eBay Data from IntelliJ
Integrate connectivity to eBay with wizards in IntelliJ.
-
How to publish and share Okta Data dashboards with Tableau Server
The CData ODBC driver for Okta enables you integrate Okta into Tableau dashboards.
-
Access Oracle Eloqua Reporting Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Oracle Eloqua Reporting from your Oracle system.
-
Work with Figshare Data in FoxPro
Load Figshare into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate ZohoExpense Data in Pentaho Data Integration
Build ETL pipelines based on ZohoExpense in the Pentaho Data Integration tool.
-
How to connect to Wistia Data in DBVisualizer
Integrate Wistia with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous IBM Informix Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable IBM Informix replication to Google BigQuery.
-
Automate EnterpriseDB Integration Tasks from PowerShell
Are you in search of a quick and easy way to access EnterpriseDB from PowerShell? This article demonstrates how to utilize the EnterpriseDB Cmdlets for tasks like connecting to EnterpriseDB, automating operations, downloading data, and more.
-
Load NetSuite Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load NetSuite CRM & ERP to a database.
-
Import and Visualize Microsoft Ads Data in Power View
Create data visualizations based on Microsoft Ads in Excel.
-
Query Shopify Data as a SQL Server Database in Node.js
Execute SQL Server queries against Shopify from Node.js.
-
Natively Connect to Hubstaff Data in PHP
The CData ODBC driver for Hubstaff enables you to create PHP applications with connectivity to Hubstaff. Leverage the native support for ODBC in PHP.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Presto
Provide connectivity to Presto through an SAP BusinessObjects universe.
-
How to create an RPA flow for LinkedIn Ads Data in UiPath Studio
Use the LinkedIn Ads ODBC Driver to create workflows that access real-time LinkedIn Ads without any coding.
-
How to connect and process Bullhorn CRM from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Bullhorn CRM.
-
Create a Data Access Object for ActiveCampaign Data using JDBI
A brief overview of creating a SQL Object API for ActiveCampaign in JDBI.
-
Publish WooCommerce-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live WooCommerce.
-
Getting Started with the CData ODBC Driver for SAP SuccessFactors
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SAP SuccessFactors.
-
How to Seamlessly Import LinkedIn Data into IBM SPSS Modeler
Integrate LinkedIn data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Highrise CRM using the Model Context Protocol.
-
Access Beeminder Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Beeminder from your Oracle system.
-
Build Microsoft Entra ID Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Microsoft Entra ID and build visualizations in Tableau.
-
Work with DocuSign Data in FoxPro
Load DocuSign into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build AI/ML Models with Live LDAP Data using Dataiku
Connect LDAP Data with Dataiku using the CData JDBC Driver for LDAP.
-
Use the CData Software JDBC Driver for Oracle HCM Cloud in MicroStrategy
Connect to Oracle HCM Cloud in MicroStrategy Developer using the CData Software JDBC Driver for Oracle HCM Cloud.
-
Prepare, Blend, and Analyze EmailOctopus Data in Alteryx Designer (ODBC)
Build workflows to access live EmailOctopus for self-service data analytics.
-
Bind Live BigQuery Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live BigQuery data
-
Integrate with Parquet Data in JReport Designer
Create charts and reports based on Apache Parquet in JReport Designer.