CData Software - Knowledge Base
Recent Articles
-
How to Work with Phoenix Data in AWS Glue Jobs Using JDBC
Connect to Phoenix from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Use the CData Software ODBC Driver for Basecamp in MicroStrategy
Connect to Basecamp in MicroStrategy Developer using the CData Software ODBC Driver for Basecamp.
-
Feed RSS Feeds into FineReport
How to set RSS Feeds as a JDBC data source in FineReport.
-
Analyze Teamwork Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Teamwork in Microsoft R Open.
-
EmailOctopus Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on EmailOctopus facts in real time.
-
Working with Zoho CRM Data in LINQPad
Execute LINQ queries to Zoho CRM in LINQPad.
-
Create a Data Access Object for CSV Data using JDBI
A brief overview of creating a SQL Object API for CSV/TSV Files in JDBI.
-
Query HubSpot Data from Node.js
Use the OData endpoint of the CData API Server to connect to your HubSpot and perform CRUD operations on HubSpot from Node.js.
-
How to Work with xBase Data in AWS Glue Jobs Using JDBC
Connect to xBase from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create Highrise Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Highrise from PowerBI.com to create Power BI Dataflows with real-time data.
-
Create a Data Access Object for Kafka Data using JDBI
A brief overview of creating a SQL Object API for Apache Kafka in JDBI.
-
Prepare, Blend, and Analyze MailChimp Data in Alteryx Designer (Connect AI)
Build workflows to access live MailChimp for self-service data analytics.
-
How to connect to MongoDB Data from IntelliJ
Integrate connectivity to MongoDB with wizards in IntelliJ.
-
Getting Started with the CData Power BI Connector for Presto
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Presto.
-
Replicate SpaceX Data in Heroku for Use in Salesforce Connect
Replicate SpaceX to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Query Timely Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Timely from Node.js.
-
DataBind Controls to eBay Data in C++Builder
DataBind to eBay in C++Builder with standard components and controls.
-
How to Seamlessly Import Microsoft Planner Data into IBM SPSS Modeler
Integrate Microsoft Planner data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Visualize JotForm Data in Tableau
The CData ODBC driver for JotForm enables you integrate JotForm into Tableau dashboards.
-
Getting Started with the CData Excel Add-In for Amazon Marketplace
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Amazon Marketplace.
-
Integrating OpenCode Terminal with HBase 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.
-
Microsoft Teams Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Microsoft Teams through CData Connect AI using different applications and tools.
-
Integrating Cursor CLI with HubDB 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.
-
Access Everhour Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Everhour.
-
Connect to and Visualize Live Rootly Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Rootly.
-
Query SAP Ariba Procurement Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SAP Ariba Procurement from Node.js.
-
Integrating LangGraph with LinkedIn Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on LinkedIn within automated workflows.
-
Bridge Elorus Connectivity with Apache NiFi
Access and process Elorus in Apache NiFi using the CData JDBC Driver.
-
Connect Slack to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Slack with IBM WebSphere for seamless data integration and connectivity.
-
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.
-
DataBind Controls to Discord Data in Delphi
DataBind to Discord in Delphi with standard data access components and controls.
-
Viewing Intercom Data in RAD Studio Data Explorer
How to view Intercom in RAD Studio Data Explorer using the CData ODBC Driver for Intercom.
-
Connect to SAP Ariba Procurement Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SAP Ariba Procurement as an External Source in Dremio.
-
Automated Continuous Salesforce Replication to Oracle
Use CData Sync for automated, continuous, customizable Salesforce replication to Oracle.
-
Connect to Recurly Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Recurly and the SQL Gateway to access Recurly from Google Apps Script.
-
Automated Continuous Sage 300 Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Sage 300 replication to Azure SQL Database.
-
Automated Continuous GitLab Replication to Vertica
Use CData Sync for automated, continuous, customizable GitLab replication to Vertica.
-
Query Klipfolio Data in DataGrip
Create a Data Source for Klipfolio in DataGrip and use SQL to query live Klipfolio.
-
Build Redshift-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Redshift to explore live Redshift Data in Claude Code to assist with building Redshift-powered applications.
-
Connect to Real-Time Vault CRM Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Vault CRM and Dataflow to import and use Veeva Vault & Vault CRM in Power Apps.
-
Connect to Bullhorn CRM Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Bullhorn CRM from Filemaker Pro on Mac.
-
Create Twitter Ads-Connected Applications in Appsmith
Connect to Twitter Ads Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Twitter Ads.
-
How to create an RPA flow for Short.io Data in UiPath Studio
Use the Short.io ODBC Driver to create workflows that access real-time Short.io without any coding.
-
Connect to Google Calendar Data in DBArtisan
Use wizards in DBArtisan to configure Google Calendar as a data source.
-
Integrate Delighted with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Delighted with External Services.
-
How to Access Excel Data Using Entity Framework
This article shows how to access Microsoft Excel using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Getting Started with the CData Tableau Connector for Adobe Target
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Adobe Target.
-
Connect Gong to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Gong using the CData Python MCP Server.
-
Connect TaxJar to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live TaxJar using the CData Python MCP Server.
-
Getting Started with the CData SSIS Components for Spark
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Spark.
-
Create Dashboards and Visualize Live Shopify Data in Geckoboard
Use CData Connect AI to connect to live Shopify and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Back Up JobNimbus to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with JobNimbus data.
-
Connect to Live Slack Data in MicroStrategy through CData Connect AI
Create a live connection to Slack Data in CData Connect AI and connect to your Slack from MicroStrategy.
-
Building Dynamic Web Pages with FTP Data Using AngularJS
Create single-page applications with live connectivity to FTP using the CData API Server.
-
Create Data Visualizations in Cognos BI with Copper Data
Access Copper as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create Dashboards and Visualize Live Avalara AvaTax Data in Geckoboard
Use CData Connect AI to connect to live Avalara AvaTax and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Build Semantic Layer Views for Optimizely Data in APOS Live Data Gateway
Use the CData Connector for Optimizely in APOS Live Data Gateway to build Semantic Layer Views for Optimizely.
-
Build Raisers Edge NXT-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Raisers Edge NXT.
-
Automated Continuous SparkPost Replication to Snowflake
Use CData Sync for automated, continuous, customizable SparkPost replication to Snowflake.
-
Easily Integrate SAP Fieldglass Data in Lazarus Pascal IDE
Learn how to easily integrate live SAP Fieldglass in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrating Gumloop with Twilio Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Twilio within automated workflows.
-
Use the CData Software ODBC Driver for Twitter Ads in MicroStrategy Web
Connect to Twitter Ads in MicroStrategy Web using the CData Software ODBC Driver for Twitter Ads.
-
Replicate Multiple EmailOctopus Accounts
Replicate multiple EmailOctopus accounts to one or many databases.
-
Access Live Salesforce Marketing Data in AWS Lambda
Connect to live Salesforce Marketing Cloud in AWS Lambda using the CData JDBC Driver.
-
Create LinkedIn-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to LinkedIn Data from Klipfolio and build custom visualizations using live LinkedIn.
-
Integrate ClickTime Data in the Pentaho Report Designer
Publish reports based on ClickTime in the Pentaho BI tool.
-
Create Datadog Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Datadog data access from reports, embedded analytics, and more.
-
Query Greenhouse Data in ColdFusion
Write standard ColdFusion data access code to connect to Greenhouse.
-
Use the CData Software JDBC Driver for Cassandra in MicroStrategy Desktop
Connect to Apache Cassandra in MicroStrategy Desktop using the CData Software JDBC Driver for Cassandra.
-
Build Quickbase-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Quickbase Data and create custom apps in Mendix.
-
Process & Analyze Instantly Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Instantly Data.
-
Provide OData Services of SAP Ariba Procurement Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SAP Ariba Procurement by developing a WCF Service Application.
-
Bind Live Splunk Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Splunk 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 in your FileMaker applications.
-
Connect and Query Live Adobe Analytics Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Adobe Analytics into Databricks
-
Access Live HubDB Data in AWS Lambda (with IntelliJ IDEA)
Connect to live HubDB in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Easily Integrate Wave Financial Data in Lazarus Pascal IDE
Learn how to easily integrate live Wave Financial in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to load Brex data into Elasticsearch via Logstash
Introducing a simple method to load Brex data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Connect to Live Marketo Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Marketo for you.
-
Connecting Moonlit Workflow with Phoenix Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Apache Phoenix in real time.
-
Viewing DocuSign Data in RAD Studio Data Explorer
How to view DocuSign in RAD Studio Data Explorer using the CData ODBC Driver for DocuSign.
-
Bidirectional Access to PivotalTracker Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate PivotalTracker in Filemaker Pro for Mac or Windows.
-
How to Access Live Airtable Data in Visual Studio Code via Cline
Run CData MCP Server for Airtable on Windows Subsytem for Linux (WSL) and connect to live Airtable from the Cline extension in Visual Studio Code.
-
Import Real-Time PDFMonkey Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use PDFMonkey in ColdFusion.
-
How to work with Impala Data in Apache Spark using SQL
Access and process Impala Data in Apache Spark using the CData Software JDBC Driver.
-
Manage PhantomBuster Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for PhantomBuster.
-
How to connect to EmailOctopus Data from IntelliJ
Integrate connectivity to EmailOctopus with wizards in IntelliJ.
-
Work with Missive Data in FoxPro
Load Missive into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrating LangGraph with Databricks Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Databricks within automated workflows.
-
Automated Continuous Avaza Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Avaza replication to OneLake in Microsoft Fabric.
-
Getting Started with the CData Power BI Connector for Discord
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Publish ZendeskSell-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live ZendeskSell.
-
How to connect Amazon QuickSight to PostgreSQL Data
Create a connection to PostgreSQL in CData Connect AI and insert PostgreSQL into Amazon QuickSight SPICE to build interactive dashboards.
-
Getting Started with the CData Excel Add-In for Bugsnag
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Bugsnag.
-
Deploy the ADO.NET Provider for Deel on an SSRS Report Server
Connect to Deel 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.
-
Automated Continuous Couchbase Replication to MySQL
Use CData Sync for automated, continuous, customizable Couchbase replication to MySQL.
-
Integrating Codex CLI with Rebilly 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 a JDBC Data Source for Sendwithus
Create Sendwithus data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Couchbase Data in Claris FileMaker Pro
Use the CData ODBC Driver for Couchbase in FileMaker Pro to connect to Couchbase and work with Couchbase in your FileMaker applications.
-
Integrating Antigravity CLI with TigerGraph via CData CLI
Connect TigerGraph to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.