CData Software - Knowledge Base
Recent Articles
-
Connect to Acumatica Data in Ruby
Connect to Acumatica ERP in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Use Dash to Build to Web Apps on Wistia Data
Create Python applications that use pandas and Dash to build Wistia-connected web apps.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Freshteam
Provide connectivity to Freshteam through an SAP BusinessObjects universe.
-
Use Azure AI Foundry to Talk to Your BambooHR 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 BambooHR for you.
-
Create Dynamic Oracle Service Cloud Grids Using the Infragistics XamDataGrid
Learn how you can connect Oracle Service Cloud to Infragistics XamDataGrid to build dynamic grids.
-
Query CapsuleCRM Data through ODBC in Node.js
Use node-odbc to execute SQL queries against CapsuleCRM from Node.js.
-
Automate Twitter Ads Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Twitter Ads from PowerShell? This article demonstrates how to utilize the Twitter Ads Cmdlets for tasks like connecting to Twitter Ads, automating operations, downloading data, and more.
-
Connect to Procore Data in Ruby
Connect to Procore in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Google Sheets Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Google Sheets and build visualizations in Tableau Cloud.
-
Automated Continuous ClickUp Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable ClickUp replication to Apache Kafka.
-
Access Live HBase Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Apache HBase from your Google Sheets.
-
Excel Spreadsheet Automation on Google Analytics Data with the QUERY Formula
Pull data from Google Analytics, automate spreadsheets, and more with the QUERY formula.
-
Import Real-Time SAP Business Warehouse Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SAP Business Warehouse in ColdFusion.
-
Connect to Jodoo in SpagoBI
Create reports featuring live Jodoo in SpagoBI Studio. Host Jodoo reports on SpagoBI Server.
-
How to Connect the Power BI Service to Sage 200: Complete Guide
Connect to the CData Software Power BI Connector for Sage 200 from PowerBI.com to provide real-time Sage 200 across the organization.
-
Automated Continuous Twilio Replication to Vertica
Use CData Sync for automated, continuous, customizable Twilio replication to Vertica.
-
Build Visualizations of Google Analytics Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Google Analytics in Birst.
-
Explore Geographical Relationships in Cloudant Data with Power Map
Create data visualizations with IBM Cloudant in Power Map.
-
Connect to Wrike Data from PowerBuilder via ADO.NET
This article demonstrates how to access Wrike from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Analyze Bullhorn CRM Data in Cognos Analytics
Use CData Connect AI to connect to Bullhorn CRM Data from Cognos Analytics and analyze live Bullhorn CRM.
-
Bidirectional Access to QuickBooks Online Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate QuickBooks Online in Filemaker Pro for Mac or Windows.
-
Visualize SharePoint Excel Services Data in TIBCO Spotfire through ADO.NET
Integrate SharePoint Excel Services into dashboards in TIBCO Spotfire.
-
Automated Continuous Bullhorn CRM Replication to SingleStore
Use CData Sync for automated, continuous, customizable Bullhorn CRM replication to SingleStore.
-
Integrate Dropbox with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Dropbox with External Services.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for AfterShip
Provide connectivity to AfterShip through an SAP BusinessObjects universe.
-
Integrating LinkedIn Data in Talend Cloud Data Management Platform
Connect LinkedIn Data with Talend Cloud Data Management Platform using the CData JDBC Driver for LinkedIn.
-
Natively Connect to Shortcut Data in PHP
The CData ODBC driver for Shortcut enables you to create PHP applications with connectivity to Shortcut. Leverage the native support for ODBC in PHP.
-
Connect to Facebook Ads Data in RapidMiner
Integrate Facebook Ads with standard components and data source configuration wizards in RapidMiner Studio.
-
Build Charts with Typeform Data in Clear Analytics
Create dynamic charts and perform analytics based on Typeform in Clear Analytics.
-
Integrate Live Float Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Float to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Analyze Sugar CRM Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Sugar CRM in Microsoft R Open.
-
How to connect to Delighted Data in DBVisualizer
Integrate Delighted with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect Zoho Projects to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Zoho Projects using the CData Python MCP Server.
-
Edit and Search Oracle SCM External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Oracle SCM to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Oracle SCM objects that you can access from apps and the dashboard.
-
Query LionDesk Data through ODBC in Node.js
Use node-odbc to execute SQL queries against LionDesk from Node.js.
-
How to Visualize Procore Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Procore in Python.
-
Automated Continuous Parquet Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Parquet replication to Azure SQL Database.
-
How to connect to eBay Analytics Data from IntelliJ
Integrate connectivity to eBay Analytics with wizards in IntelliJ.
-
Connect to SAP Netweaver Gateway Data in DBeaver
Use the CData ODBC Driver to connect to SAP Netweaver Gateway in DBeaver.
-
Use the CData Software ODBC Driver for Opsgenie in MicroStrategy Desktop
Connect to Opsgenie in MicroStrategy Desktop using the CData Software ODBC Driver for Opsgenie.
-
Connect to MailChimp Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for MailChimp Data and connect to MailChimp in Akorbi Digital RunMyProcess.
-
Access Live SendGrid Data in TIBCO Data Virtualization
Use the SendGrid Tibco DV Adapter to create a SendGrid data source in TIBCO Data Virtualization Studio and gain access to live SendGrid from your TDV Server.
-
Import Real-Time Google Spanner Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Google Spanner in ColdFusion.
-
Connect to Mode Data in CloverDX (formerly CloverETL)
Transfer Mode using the visual workflow in the CloverDX data integration tool.
-
Publish Aha!-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Aha!.
-
Create Insightly Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Insightly data access from reports, embedded analytics, and more.
-
ETL Drift in Oracle Data Integrator
This article shows how to transfer Drift into a data warehouse using Oracle Data Integrator.
-
How to Connect to Certinia Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Certinia. Leverage the pyodbc module for ODBC in Python.
-
How to publish and share Google Drive Data dashboards with Tableau Server
The CData ODBC driver for Google Drive enables you integrate Google Drive into Tableau dashboards.
-
Integrate Snowflake with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Snowflake with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Snowflake.
-
Query Azure Data Lake Storage Data in ColdFusion
Write standard ColdFusion data access code to connect to Azure Data Lake Storage.
-
Import and Visualize Zendesk Data in Power View
Create data visualizations based on Zendesk in Excel.
-
Connect to Billsby Data in Jaspersoft Studio
Execute SQL to remote Billsby in Jaspersoft Studio.
-
Connect to Datadog Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Datadog and work with Datadog in your FileMaker applications.
-
Enable the SAP Business One JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SAP Business One.
-
Rapidly Develop Google Tasks-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 Google Tasks.
-
Import Facebook Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Facebook. In this article, you will use the OData format to import Facebook into Microsoft Power Query.
-
Access SAP Data from MySQL in Amazon QuickSight
Connect to SAP and build visualizations of SAP ERP/NetWeaver using a MySQL Connection in Amazon QuickSight.
-
Connect to Vault CRM Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Vault CRM Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Integrating LangGraph with MarkLogic Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on MarkLogic within automated workflows.
-
Create SSAS Tabular Models from Google Spanner Data
How to build a SQL Server Analysis Service Tabular Model from Google Spanner using CData drivers.
-
Build BambooHR Visualizations in Tableau Cloud
Use CData Connect AI to connect to live BambooHR and build visualizations in Tableau Cloud.
-
Connecting Agentforce with SingleStore 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 SingleStore for you.
-
Build Phoenix Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Apache Phoenix and build visualizations in Tableau Cloud.
-
Integrate LibreChat with Live MarkLogic Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live MarkLogic from within the chat interface.
-
Getting Started with the CData ADO.NET Provider for Coda
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Load Pushbullet Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Pushbullet to a database.
-
Integrate Dotmailer Data in Pentaho Data Integration
Build ETL pipelines based on Dotmailer in the Pentaho Data Integration tool.
-
Build AI/ML Models with Live Oracle Financials Cloud Data using Dataiku
Connect Oracle Financials Cloud Data with Dataiku using the CData JDBC Driver for Oracle Financials Cloud.
-
Integrating Cursor CLI with GitLab 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.
-
Integrate Cursor with Live EnterpriseDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live EnterpriseDB from within the editor.
-
Build IBM Cloud Object Storage-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to IBM Cloud Object Storage Data from Zoho Analytics and import live IBM Cloud Object Storage.
-
Connect to Supabase Data in HULFT Integrate
Connect to Supabase as a JDBC data source in HULFT Integrate
-
Create OneNote Dataflows on PowerBI.com
Connect to the CData Power BI Connector for OneNote from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Connect to Live Twitter Ads Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Twitter Ads securely in real time.
-
Import Spark Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Spark Data and provide access to live Apache Spark SQL for custom reports in the Power BI Service.
-
Connect to Excel Online Data in RazorSQL
Connect to Excel Online from wizards and query Microsoft Excel Online from the GUI in the RazorSQL database management tool.
-
Getting Started with the CData ADO.NET Provider for Stripe
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Stripe.
-
DataBind Charts to eBay Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to eBay 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.
-
Automated Continuous Testmonitor Replication to SingleStore
Use CData Sync for automated, continuous, customizable Testmonitor replication to SingleStore.
-
Create Cassandra-Connected Nintex Workflows
Use CData Connect AI to connect to Cassandra Data from Nintex Workflow Cloud and build custom workflows using live Apache Cassandra.
-
How to work with Nethunt Data in Apache Spark using SQL
Access and process Nethunt Data in Apache Spark using the CData Software JDBC Driver.
-
Easily Integrate SAP HANA Data in Lazarus Pascal IDE
Learn how to easily integrate live SAP HANA in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Google Drive Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Google Drive in Airbyte.
-
ETL Jira in Oracle Data Integrator
This article shows how to transfer Atlassian Jira into a data warehouse using Oracle Data Integrator.
-
Integrating GitHub Copilot CLI with Twilio 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 to Calendly Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Calendly.
-
Create Reports with Suadeo Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Suadeo.
-
Connect to Azure Data Lake Storage Data in RapidMiner
Integrate Azure Data Lake Storage with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Query Live HubSpot Data in Perplexity MacOS Desktop
Connect to and query live HubSpot Data in Perplexity Desktop using CData MCP Server.
-
Use the CData Software JDBC Driver for FHIR in MicroStrategy Web
Connect to FHIR in MicroStrategy Web using the CData Software JDBC Driver for FHIR.
-
Model Google Analytics Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Google Analytics, enabling the direct import of real-time Google Analytics.
-
Bind Live Cosmos DB Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Cosmos DB data
-
How to use SQLAlchemy ORM to access eBay Analytics Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of eBay Analytics.
-
Connect to Google Spanner Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Google Spanner Data and connect to Google Spanner in Akorbi Digital RunMyProcess.
-
Integrating GitHub Copilot CLI with ConstantContact 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.
-
Use Manus AI to Talk to Your Sage Intacct Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Sage Intacct.
-
Use the CData Software JDBC Driver for Factorial in MicroStrategy Web
Connect to Factorial in MicroStrategy Web using the CData Software JDBC Driver for Factorial.
-
Publish RabbitMQ-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live RabbitMQ.
-
Query Aweber Data in DataGrip
Create a Data Source for Aweber in DataGrip and use SQL to query live Aweber.