CData Software - Knowledge Base
Recent Articles
-
How to Build an ETL App for Cloudant Data in Python with CData Connect AI
Build ETL pipelines that read and write live IBM Cloudant in Python with petl and the CData Connect AI Python SDK.
-
Access Live Sybase IQ Data in TIBCO Data Virtualization
Use the Sybase IQ Tibco DV Adapter to create a Sybase IQ data source in TIBCO Data Virtualization Studio and gain access to live Sybase IQ from your TDV Server.
-
Build Data Flows from SQL Server to Cloudant through SSIS
Easily push SQL Server data to Cloudant using the CData SSIS Tasks for Cloudant.
-
Use the CData Software ODBC Driver for Samanage in MicroStrategy
Connect to Samanage in MicroStrategy Developer using the CData Software ODBC Driver for Samanage.
-
Build AI/ML Models with Live Codat Data using Dataiku
Connect Codat Data with Dataiku using the CData API Driver for JDBC.
-
Integrate LibreChat with Live Microsoft Teams Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Microsoft Teams from within the chat interface.
-
Visualize Live Drip Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Drip.
-
Explore Geographical Relationships in Demio Data with Power Map
Create data visualizations with Demio in Power Map.
-
Connect to Delighted Data in Ruby
Connect to Delighted in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrate Theia IDE with Live Cloudant Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Automated Continuous Quaderno Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Quaderno replication to Azure SQL Database.
-
Build Apps with Live Sybase in Adalo using CData Connect AI
Use CData Connect AI to integrate live Sybase into the Adalo platform and build custom mobile and web applications with real-time Sybase.
-
Excel Spreadsheet Automation on EmailOctopus Data with the QUERY Formula
Pull data from EmailOctopus, automate spreadsheets, and more with the QUERY formula.
-
How to Easily Query BigQuery Data in OpenOffice Base
Connect to BigQuery data in OpenOffice Base using the CData ODBC Driver for BigQuery and generate reports with live data insights.
-
Build Dashboards with MYOB AccountRight Data in DBxtra
Create dynamic dashboards and perform analytics based on MYOB AccountRight in DBxtra.
-
Provide OData Services of Gumroad Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Gumroad by developing a WCF Service Application.
-
Connect to Oracle SCM Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Oracle SCM and the Script function in FileMaker Pro to connect to Oracle SCM and work with Oracle SCM in your FileMaker application.
-
Bridge Sugar CRM Connectivity with Apache NiFi
Access and process Sugar CRM in Apache NiFi using the CData JDBC Driver.
-
How to publish and share Hugging Face Data dashboards with Tableau Server
The CData ODBC driver for Hugging Face enables you integrate Hugging Face into Tableau dashboards.
-
Automated Continuous Zoho CRM Replication to Snowflake
Use CData Sync for automated, continuous, customizable Zoho CRM replication to Snowflake.
-
Create SSAS Tabular Models from SparkPost Data
How to build a SQL Server Analysis Service Tabular Model from SparkPost using CData drivers.
-
Getting Started with the CData JDBC Driver for BenchmarkEmail
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for BenchmarkEmail.
-
Use the CData Software ODBC Driver for SAP Business One in MicroStrategy Web
Connect to SAP Business One in MicroStrategy Web using the CData Software ODBC Driver for SAP Business One.
-
Use Agno to Talk to Your Vault CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Veeva Vault & Vault CRM for you.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Copper
Provide connectivity to Copper through an SAP BusinessObjects universe.
-
Establish a Live Connection with Intercom Data using Tableau Bridge
The CData ODBC Driver for Intercom enables you to integrate live Intercom into Tableau Cloud dashboards using the Tableau Bridge.
-
Automated Continuous Printify Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Printify replication to Google Cloud SQL.
-
Integrate with Instagram Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Instagram to a JSON file on disk.
-
Getting Started with the CData Excel Add-In for PolarTeamPro
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for PolarTeamPro.
-
Connect to Optimizely Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Optimizely as an External Source in Dremio.
-
Connect to LinkedIn Ads Data in Jaspersoft Studio
Execute SQL to remote LinkedIn Ads in Jaspersoft Studio.
-
Publish Crystal Reports on Coda Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Coda.
-
Build QuickBooks Online-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live QuickBooks Online and build QuickBooks Online-connected web apps with Axios.
-
Integrate Theia IDE with Live Quickbase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Visualize Snapchat Ads Data in TIBCO Spotfire through OData
Integrate Snapchat Ads into dashboards in TIBCO Spotfire.
-
Build Apps with Live Cloudflare Data Using the Low-Code Development Platform of Mendix
Connect Cloudflare with Mendix to build apps using the CData API Driver for JDBC.
-
How to use SQLAlchemy ORM to access Sugar CRM Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Sugar CRM.
-
Use the CData Software JDBC Driver for LDAP in MicroStrategy
Connect to LDAP in MicroStrategy Developer using the CData Software JDBC Driver for LDAP.
-
Prepare, Blend, and Analyze Nuclia Data in Alteryx Designer (ODBC)
Build workflows to access live Nuclia for self-service data analytics.
-
Explore Geographical Relationships in Facebook Data with Power Map
Create data visualizations with Facebook in Power Map.
-
Create Reports with Mixpanel Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Mixpanel.
-
Create Data Visualizations in Cognos BI with Raisers Edge NXT Data
Access Raisers Edge NXT as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create Informatica Mappings From/To a JDBC Data Source for SAP Ariba Procurement
Create SAP Ariba Procurement data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build Google Contacts-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Google Contacts Data from Zoho Analytics and import live Google Contacts.
-
Prepare, Blend, and Analyze Google Sheets Data in Alteryx Designer (Connect AI)
Build workflows to access live Google Sheets for self-service data analytics.
-
Connect to LaunchDarkly Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for LaunchDarkly.
-
Automated Continuous DocuSign Replication to SQL Server
Use CData Sync for automated, continuous, customizable DocuSign replication to SQL Server.
-
Build a Singer.io Tap for Demio With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Demio data using
-
Access Live Asana Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Asana from your Excel spreadsheets.
-
How to use SQLAlchemy ORM to access Planio Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Planio.
-
Build Semantic Layer Views for Dynamics 365 Business Central Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Dynamics 365 Business Central.
-
Visualize Recurly Data in Tableau
The CData ODBC driver for Recurly enables you integrate Recurly into Tableau dashboards.
-
How to work with Odoo Data in Apache Spark using SQL
Access and process Odoo Data in Apache Spark using the CData Software JDBC Driver.
-
LINQ to Apollo 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 Apollo Data Provider.
-
How to Query Live QuickBooks Data in Perplexity MacOS Desktop
Connect to and query live QuickBooks Data in Perplexity Desktop using CData MCP Server.
-
How to Work with Nethunt Data in AWS Glue Jobs Using JDBC
Connect to Nethunt from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate with Exa Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Exa to a JSON file on disk.
-
Use the CData ODBC Driver for Amazon S3 from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Amazon S3 to connect to Amazon S3 from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Amazon S3 in Excel.
-
Validate SQL Server Data with QuerySurge
Access and validate Microsoft SQL Server in QuerySurge using the CData JDBC Driver.
-
How to Access SendInBlue Data Using Entity Framework
This article shows how to access SendInBlue using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to publish and share Demio Data dashboards with Tableau Server
The CData ODBC driver for Demio enables you integrate Demio into Tableau dashboards.
-
Object-Relational Mapping (ORM) with SAP Fieldglass Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to SAP Fieldglass into a Java-based ORM framework, Hibernate.
-
Replicate Multiple Reckon Accounts via the CData Sync CLI
Replicate multiple Reckon accounts to one or many databases.
-
Use ChatGPT to Talk to Your Azure DevOps Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Azure DevOps for you.
-
Integrating Kiro CLI with BambooHR 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.
-
Integrating Kiro CLI with Amazon DynamoDB 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.
-
Use the CData Software JDBC Driver for Square in MicroStrategy Desktop
Connect to Square in MicroStrategy Desktop using the CData Software JDBC Driver for Square.
-
Getting Started with the CData Tableau Connector for Helpscout
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
How to connect to Smartsheet Data from IntelliJ
Integrate connectivity to Smartsheet with wizards in IntelliJ.
-
Create Impala-Connected Dashboards in Grafana
Connect to Impala Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Apache Impala.
-
Establish a Live Connection with Deel Data using Tableau Bridge
The CData ODBC Driver for Deel enables you to integrate live Deel into Tableau Cloud dashboards using the Tableau Bridge.
-
Automated Eventbrite Data Replication to Teradata
Use CData Sync to Customize and automate Eventbrite replication to Teradata.
-
How to connect to Splunk Data from Spring Boot
Connect to Splunk in a Spring Boot Application using the CData JDBC Driver for Splunk
-
Automated Continuous Pipeliner CRM Replication to Vertica
Use CData Sync for automated, continuous, customizable Pipeliner CRM replication to Vertica.
-
Connect to Authorize.Net Data in CloverDX (formerly CloverETL)
Transfer Authorize.Net using the visual workflow in the CloverDX data integration tool.
-
Visualize Google Ad Manager Data in Tableau
The CData ODBC driver for Google Ad Manager enables you integrate Google Ad Manager into Tableau dashboards.
-
Seamlessly Bring CouchDB Data into Retool Using CData Connect AI
Integrate CouchDB data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connect SpaceX to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live SpaceX using the CData Python MCP Server.
-
Integrating Kiro CLI with Gumroad 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.
-
Excel Spreadsheet Automation on Typeform Data with the QUERY Formula
Pull data from Typeform, automate spreadsheets, and more with the QUERY formula.
-
Automate Act-On Data Replication to SAP HANA
Use CData Sync to customize and automate Act-On replication to SAP HANA.
-
Model SAP HANA Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SAP HANA, enabling the direct import of real-time SAP HANA.
-
Visualize Zoho Inventory Data in TIBCO Spotfire through OData
Integrate Zoho Inventory into dashboards in TIBCO Spotfire.
-
How to Connect to Live Sage Intacct Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Sage Intacct securely in real time.
-
Connect to WordPress Data from Crystal Reports
Use CData Connect AI to connect to and report on live WordPress from Crystal Reports.
-
Integrate LibreChat with Live Vault CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Veeva Vault & Vault CRM from within the chat interface.
-
Deploy the ADO.NET Provider for LinkedIn on an SSRS Report Server
Connect to LinkedIn from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Replicate Salesloft Data to Multiple Databases
Replicate Salesloft to disparate databases with a point-and-click configuration.
-
Use the CData Software JDBC Driver for Amplitude in MicroStrategy Desktop
Connect to Amplitude in MicroStrategy Desktop using the CData Software JDBC Driver for Amplitude.
-
Automated Continuous Jira Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Jira replication to delimited files (CSV/TSV).
-
Design BIRT Reports on Factorial Data
Provide current Factorial to your embedded analytics.
-
Use Agno to Talk to Your MongoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your MongoDB for you.
-
Integrate Open WebUI with Live Salesforce Marketing Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Salesforce Marketing Cloud from within the chat interface.
-
Bidirectional Access to Grafana Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Grafana in Filemaker Pro for Mac or Windows.
-
Connect to Azure Data Catalog Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Azure Data Catalog and the SQL Gateway to access Azure Data Catalog from Google Apps Script.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Zendesk using the Model Context Protocol.
-
Integrate Cursor with Live BigQuery Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Google BigQuery from within the editor.
-
Create Informatica Mappings From/To a JDBC Data Source for Clio
Create Clio data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automated Continuous Planio Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Planio replication to Google Cloud SQL.
-
Analyze Rootly Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Rootly with the CData JDBC Driver for Rootly.