CData Software - Knowledge Base
Recent Articles
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SpaceX
Provide connectivity to SpaceX through an SAP BusinessObjects universe.
-
Publish Crystal Reports on Unbounce Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Unbounce.
-
Extract, Transform, and Load Wave Financial Data in Informatica PowerCenter
Create a simple Workflow for Wave Financial in Informatica PowerCenter.
-
Analyze Google Cloud Storage Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Google Cloud Storage and visualize live Google Cloud Storage in Infragistics Reveal.
-
View Reports on Real-Time BigCommerce Data in Power BI Report Server
Use the CData ODBC Driver for BigCommerce to visualize BigCommerce in Power BI Desktop and then publish them to Power BI Report Server.
-
Getting Started with the CData ODBC Driver for Printify
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Printify.
-
How to create SAP HANA federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SAP HANA in MySQL .
-
Connect to Zoho Creator Data in HULFT Integrate
Connect to Zoho Creator as a JDBC data source in HULFT Integrate
-
Connect to HBase Data in RapidMiner
Integrate Apache HBase with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Connect to & Open Instantly Data in Microsoft Excel
This article uses the CData ODBC driver for Instantly to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Visualize HelloSign Data in Tableau
The CData ODBC driver for HelloSign enables you integrate HelloSign into Tableau dashboards.
-
How to create an RPA flow for Clari Data in UiPath Studio
Use the Clari ODBC Driver to create workflows that access real-time Clari without any coding.
-
Getting Started with the CData ODBC Driver for Google Directory
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Google Directory.
-
Viewing Confluence Data in RAD Studio Data Explorer
How to view Atlassian Confluence in RAD Studio Data Explorer using the CData ODBC Driver for Confluence.
-
How to Connect MYOB AccountRight Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live MYOB AccountRight data in real time using natural language.
-
Use Dash to Build to Web Apps on CapsuleCRM Data
Create Python applications that use pandas and Dash to build CapsuleCRM-connected web apps.
-
Access Live Amazon S3 Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Amazon S3 into the statistical analysis tools available in SAS JMP. This article shows how to use Amazon S3 in the Graph Builder and Query Builder.
-
How to Build an ETL App for Google Cloud Storage Data in Python with CData Connect AI
Build ETL pipelines that read and write live Google Cloud Storage in Python with petl and the CData Connect AI Python SDK.
-
Create Dynamics NAV Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Dynamics NAV data access from reports, embedded analytics, and more.
-
Integrating Cursor CLI with Apify 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.
-
Connect Egnyte Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Egnyte using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Aweber Data in Ruby
Connect to Aweber in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
DataBind Auth0 Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Auth0 to a chart.
-
Build Zoho Projects-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Zoho Projects to explore live Zoho Projects Data in Gemini Code Assist to assist with building Zoho Projects-powered applications.
-
Build SAP Concur-Connected Apps in Choreo
Use CData Connect AI to connect to SAP Concur Data from Choreo and build custom apps using live SAP Concur.
-
How to Easily Query ActiveCampaign Data in OpenOffice Base
Connect to ActiveCampaign data in OpenOffice Base using the CData ODBC Driver for ActiveCampaign and generate reports with live data insights.
-
Use the CData ODBC Driver for Datadog from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Datadog to connect to Datadog from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Datadog in Excel.
-
Creating WordPress-Connected Applications in Unqork
You can use CData Connect AI to feed WordPress to Unqork and build custom business apps.
-
Connect to Pipeline CRM Data in JRuby
Create a simple JRuby app with access to live Pipeline CRM.
-
Connect to and Visualize Live Mode Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Mode.
-
Connect to Sage 200 in SpagoBI
Create reports featuring live Sage 200 in SpagoBI Studio. Host Sage 200 reports on SpagoBI Server.
-
Access Shippo Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Shippo from your Oracle system.
-
Access Live EmailOctopus Data in AWS Lambda
Connect to live EmailOctopus in AWS Lambda using the CData JDBC Driver.
-
Analyze Amazon Athena Data in Looker
Use CData Connect AI to connect to Amazon Athena Data from Looker and build custom apps using live Amazon Athena.
-
Automate ClickTime Data Replication to Couchbase
Use CData Sync to Customize and automate ClickTime replication to Couchbase.
-
Create Dynamic Dynamics NAV Grids Using the Infragistics XamDataGrid
Learn how you can connect Dynamics NAV to Infragistics XamDataGrid to build dynamic grids.
-
Visualize Cloudant 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 IBM Cloudant into TIBCO Spotfire.
-
Build a Simple VCL Application for Reply.io Data
How to build a simple VCL Application to view Reply.io in RAD Studio using the CData ODBC Driver for Reply.io.
-
Connect to Raisers Edge NXT Data in JRuby
Create a simple JRuby app with access to live Raisers Edge NXT.
-
Create Data Visualizations Based On Google Campaign Manager 360 Data in Mode
Use CData Connect AI to connect to Google Campaign Manager 360 Data from Mode and build visualizations using live
-
How to Connect DBeaver to Twilio via a JDBC Driver
Manage Twilio with visual tools in DBeaver like the query browser.
-
Use Biml to Build SSIS Tasks to Replicate DocuSign Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate DocuSign to SQL Server.
-
Import Excel Online Data Using Azure Data Factory
Use CData Connect AI to connect to Excel Online Data from Azure Data Factory and import live Microsoft Excel Online.
-
Configure the CData JDBC Driver for SuiteCRM in a Connection Pool in Tomcat
Connect to SuiteCRM from a connection pool in Tomcat.
-
Create Reports with Coinbase Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Coinbase.
-
Automated Keap Data Replication to Teradata
Use CData Sync to Customize and automate Keap replication to Teradata.
-
Integrating Gumloop with eBay Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on eBay within automated workflows.
-
Configure the CData JDBC Driver for Exa in a Connection Pool in Tomcat
Connect to Exa from a connection pool in Tomcat.
-
Connect to Salesforce CRM Analytics Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Salesforce CRM Analytics using standard SQL.
-
Create Informatica Mappings From/To an ODBC Data Source for Printify
Create an ODBC connection to Printify in Informatica and browse and transfer Printify.
-
Integrate Sugar CRM Data in the Pentaho Report Designer
Publish reports based on Sugar CRM in the Pentaho BI tool.
-
Integrate Vertica Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Vertica and integrate live Vertica into your Power Automate tasks.
-
Connect to Optimizely Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Optimizely to connect to Optimizely and execute queries in PowerBuilder.
-
Getting Started with the CData JDBC Driver for Productboard
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Productboard.
-
Migrating data from Pipedrive to Databricks using CData SSIS Components.
Easily push Pipedrive to Databricks using the CData SSIS Tasks for Pipedrive and Databricks.
-
ETL Snowflake in Oracle Data Integrator
This article shows how to transfer Snowflake into a data warehouse using Oracle Data Integrator.
-
Create Informatica Mappings From/To an ODBC Data Source for Bitly
Create an ODBC connection to Bitly in Informatica and browse and transfer Bitly.
-
Build Charts with Salesloft Data in Clear Analytics
Create dynamic charts and perform analytics based on Salesloft in Clear Analytics.
-
Work with Eventbrite Data in FoxPro
Load Eventbrite into a FoxPro database. This article includes full code and a walk-through of the process.
-
Visualize FormSite Data in Sisense
Create an ElastiCube in Sisense app with access to FormSite.
-
Access Live OData Services in Coginiti Pro
Connect to and query live OData from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrate Live BigCommerce Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live BigCommerce to Blue Prism using the CData ODBC Driver for BigCommerce to create automated workflows for repetitive business tasks.
-
Integrate with CouchDB Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Apache CouchDB to a JSON file on disk.
-
Integrating Claude Code with YouTube Analytics Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on YouTube Analytics within assisted coding and automated development workflows.
-
How to Query Live Tavily Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Tavily data in natural language using Python.
-
Connect to SparkPost Data from PowerBuilder via JDBC
This article demonstrates how to access SparkPost from PowerBuilder using the SparkPost JDBC Driver.
-
Connect to Close Data from a Connection Pool in JBoss
Integrate Close into Java servlets: Use the Management Console in JBoss to install the Close JDBC Driver.
-
Build Data Flows from SAP Netweaver Gateway to SQL Server using SSIS
Easily back up SAP Netweaver Gateway to SQL Server using the SSIS components for SAP Netweaver Gateway.
-
Use Grok to Talk to Your OData Services via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your OData for you.
-
How to work with Factorial Data in Apache Spark using SQL
Access and process Factorial Data in Apache Spark using the CData Software JDBC Driver.
-
Use Grok to Talk to Your SAP Fieldglass Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your SAP Fieldglass for you.
-
Integrating Cursor CLI with SAP Hybris C4C 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.
-
Connect to Dynamics 365 Data from Crystal Reports
Use CData Connect AI to connect to and report on live Microsoft Dynamics 365 from Crystal Reports.
-
Integrate with MYOB AccountRight Data in JReport Designer
Create charts and reports based on MYOB AccountRight in JReport Designer.
-
Getting Started with the CData ODBC Driver for Salesforce Data 360
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Salesforce Data 360.
-
Automated Continuous VWO Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable VWO replication to Apache Kafka.
-
Connect Airtable Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Airtable using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build AI/ML Models with Live Avalara AvaTax Data using Dataiku
Connect Avalara AvaTax Data with Dataiku using the CData JDBC Driver for Avalara AvaTax.
-
Query Live Oracle SCM Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Oracle SCM directly from the development environment.
-
Automated Continuous PolarTeamPro Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable PolarTeamPro replication to delimited files (CSV/TSV).
-
Integrating Cursor CLI with MailerLite 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.
-
ActiveCampaign Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on ActiveCampaign facts in real time.
-
Automated Continuous Azure DevOps Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Azure DevOps replication to AlloyDB.
-
Use Dash to Build to Web Apps on Outreach.io Data
Create Python applications that use pandas and Dash to build Outreach.io-connected web apps.
-
Use the CData API Server to Access Microsoft Planner Data in Microsoft PowerPivot
Use the CData API Server to connect to live Microsoft Planner in the Power Pivot business intelligence tool.
-
How to Access Notion Data Using Entity Framework
This article shows how to access Notion using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect Snapchat Ads Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Snapchat Ads using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Access Aircall Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Aircall from your Oracle system.
-
How to connect to GitHub Data in DBVisualizer
Integrate GitHub with visual data analysis tools and data connection wizards in DBVisualizer
-
How to Access Freshteam Data Using Entity Framework
This article shows how to access Freshteam using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Create Reports with Yelp Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Yelp.
-
Replicate Ontraport Data to Multiple Databases
Replicate Ontraport to disparate databases with a point-and-click configuration.
-
Connect to Sugar CRM Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Sugar CRM in Airbyte.
-
Integrate Real-Time Access to Sage 200 in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Sage 200 in real time.
-
Automated Continuous Mailgun Replication to Oracle
Use CData Sync for automated, continuous, customizable Mailgun replication to Oracle.
-
Configure the CData JDBC Driver for Cloudant in a Connection Pool in Tomcat
Connect to IBM Cloudant from a connection pool in Tomcat.
-
Connecting Agentforce with PostgreSQL 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 PostgreSQL for you.
-
Connect to PabblySubscriptions Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for PabblySubscriptions to connect to PabblySubscriptions and execute queries in PowerBuilder.
-
Getting Started with the CData ADO.NET Provider for Google Contacts
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Google Contacts.
-
Connect Confluence to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Confluence with IBM WebSphere for seamless data integration and connectivity.