CData Software - Knowledge Base
Recent Articles
-
How to Query ShipStation Data in MySQL Workbench
Execute MySQL queries against live ShipStation data from MySQL Workbench.
-
ETL Bitbucket in Oracle Data Integrator
This article shows how to transfer Bitbucket data into a data warehouse using Oracle Data Integrator.
-
Analyze MarkLogic Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of MarkLogic data and visualize MarkLogic data in SAP Analytics Cloud.
-
Connect to LinkedIn Ads in SpagoBI
Create reports featuring live LinkedIn Ads data in SpagoBI Studio. Host LinkedIn Ads reports on SpagoBI Server.
-
Build an OLAP Cube in SSAS from PayPal Data
Establish a connection to PayPal data data from SQL Server Analysis Services, and use the PayPal Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Egnyte Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Egnyte data in Airbyte.
-
Migrating data from Spotify to Snowflake using CData SSIS Components.
Easily push Spotify data to Snowflake using the CData SSIS Tasks for Spotify and Snowflake.
-
How to import Dynamics 365 Business Central Data into Apache Solr
Use the CData Software JDBC Driver for Dynamics 365 Business Central in Data Import Handler and create an automated import of Dynamics 365 Business Central data to Apache Solr Enterprise Search platform.
-
Use the CData Software ODBC Driver for Azure Data Lake Storage in MicroStrategy Desktop
Connect to Azure Data Lake Storage data in MicroStrategy Desktop using the CData Software ODBC Driver for Azure Data Lake Storage.
-
Use JayDeBeApi to access Google Cloud Storage Data in Python
Use standard Python scripting and the development environment of your choice to access live Google Cloud Storage data.
-
Getting Started with the CData ODBC Driver for Teamgate
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Teamgate.
-
Connecting Pipedream with Google Cloud Storage Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Google Cloud Storage data in real time.
-
Connect Quaderno to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Quaderno with IBM WebSphere for seamless data integration and connectivity.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Adobe Commerce
Provide connectivity to Adobe Commerce data through an SAP BusinessObjects universe.
-
Connect to and Query Vercel Data in QlikView over ODBC
Create data visualizations with Vercel data in QlikView.
-
Query, Visualize, and Share live LDAP Objects in Redash
Use CData Connect AI to connect to live LDAP objects in Redash for querying, visualizing, and sharing.
-
Access Reckon Accounts Hosted Data from MySQL in Amazon QuickSight
Connect to Reckon Accounts Hosted and build visualizations of Reckon Accounts Hosted data using a MySQL Connection in Amazon QuickSight.
-
Connect to Gmail Data in DBArtisan
Use wizards in DBArtisan to configure Gmail data as a data source.
-
Visualize Opsgenie Data in TIBCO Spotfire through ADO.NET
Integrate Opsgenie data into dashboards in TIBCO Spotfire.
-
How to Work with RabbitMQ Data in ETL Validator JDBC
Connect to RabbitMQ from ETL Validator jobs using the CData Software JDBC Driver.
-
How to connect PolyBase to Toggl
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Toggl data.
-
Creating NetSuite-Connected Applications in Unqork
You can use CData Connect AI to feed NetSuite data to Unqork and build custom business apps.
-
Extract, Transform, and Load GitHub Data in Informatica PowerCenter
Create a simple Workflow for GitHub data in Informatica PowerCenter.
-
How to create Visio diagrams from BigCommerce Data
Automatically update BigCommerce data with the changes you make to Visio master shapes.
-
Natively Connect to XML Data in PHP
The CData ODBC driver for XML enables you to create PHP applications with connectivity to XML data. Leverage the native support for ODBC in PHP.
-
How to connect to Timely Data in DBVisualizer
Integrate Timely data with visual data analysis tools and data connection wizards in DBVisualizer
-
How to Connect to Live Stripe Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Stripe data for you.
-
Design BIRT Reports on Power BI XMLA Data
Provide current Power BI XMLA data to your embedded analytics.
-
Creating SparkPost-Connected Applications in Unqork
You can use CData Connect AI to feed SparkPost data to Unqork and build custom business apps.
-
How to publish and share Power BI XMLA Data dashboards with Tableau Server
The CData ODBC driver for Power BI XMLA enables you integrate Power BI XMLA data into Tableau dashboards.
-
Access Live Supabase Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Supabase data into the statistical analysis tools available in SAS JMP. This article shows how to use Supabase data in the Graph Builder and Query Builder.
-
How to create an RPA flow for Zoho Recruit Data in UiPath Studio
Use the Zoho Recruit ODBC Driver to create workflows that access real-time Zoho Recruit data without any coding.
-
Connect to ZohoMarketingHub Data in RapidMiner
Integrate ZohoMarketingHub data with standard components and data source configuration wizards in RapidMiner Studio.
-
Import Real-Time Discourse Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Discourse data in ColdFusion.
-
Create Reports with PagerDuty Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date PagerDuty data.
-
Build an OLAP Cube in SSAS from Freshsales Data
Establish a connection to Freshsales data data from SQL Server Analysis Services, and use the Freshsales Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous Hubstaff Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Hubstaff replication to PostgreSQL.
-
Getting Started with the CData Python Connector for Oracle Financials Cloud
Learn to install and license the CData Python Connector and configure a connection to live Oracle Financials Cloud data.
-
Integrate Open WebUI with Live Act CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Act CRM data from within the chat interface.
-
Visualize Wrike Data in TIBCO Spotfire through ADO.NET
Integrate Wrike data into dashboards in TIBCO Spotfire.
-
Publish Crystal Reports on Smartsheet Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Smartsheet data.
-
How to Seamlessly Import Codat Data into IBM SPSS Modeler
Integrate Codat data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Automated Impala Data Replication to Teradata
Use CData Sync to Customize and automate Impala data replication to Teradata.
-
Automate HCL Domino Data Replication to SAP HANA
Use CData Sync to customize and automate HCL Domino data replication to SAP HANA.
-
Access Live Factorial Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Factorial data into the statistical analysis tools available in SAS JMP. This article shows how to use Factorial data in the Graph Builder and Query Builder.
-
Create SAP Ariba Procurement-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to SAP Ariba Procurement Data from OutSystems and build custom enterprise apps using live SAP Ariba Procurement data.
-
Build Agents in Relevance AI with Access to Live Bitbucket Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Bitbucket data within intelligent agent workflows.
-
Natively Connect to Zoho Inventory Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Zoho Inventory data. Leverage the native support for ODBC in PHP.
-
Create CockroachDB-Connected Applications in Appsmith
Connect to CockroachDB Data via CData Connect AI in Appsmith and create custom business applications with real-time access to CockroachDB data.
-
Use Claude to Talk to Your Typeform Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Typeform data for you.
-
Create Reports from LinkedIn Ads Data in Looker Studio
Use CData Connect AI to gain access to live LinkedIn Ads data and create custom reports in Looker Studio.
-
Publish MailerSend-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live MailerSend data.
-
Connect to Bitbucket Data in Ruby
Connect to Bitbucket data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Import Real-Time SAP HANA Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SAP HANA data in ColdFusion.
-
Connect to SAP Business One Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SAP Business One as an External Source in Dremio.
-
How to work with Email Data in Apache Spark using SQL
Access and process Email Data in Apache Spark using the CData Software JDBC Driver.
-
How to create Visio diagrams from Google Directory Data
Automatically update Google Directory data with the changes you make to Visio master shapes.
-
Connect to Workday Data in JRuby
Create a simple JRuby app with access to live Workday data.
-
Use JayDeBeApi to access Bugsnag Data in Python
Use standard Python scripting and the development environment of your choice to access live Bugsnag data.
-
Import and Visualize Instagram Data in Power View
Create data visualizations based on Instagram data in Excel.
-
Replicate Multiple SAP Concur Accounts via the CData Sync CLI
Replicate multiple SAP Concur accounts to one or many databases.
-
How to Access PabblySubscriptions Data Using Entity Framework
This article shows how to access PabblySubscriptions data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automated Continuous ClickUp Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable ClickUp replication to Amazon Redshift.
-
Integrate Cline with Live Notion Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Notion data from within your IDE.
-
Automated Continuous EnterpriseDB Replication to AlloyDB
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to AlloyDB.
-
Build MailerLite-Connected Apps in Choreo
Use CData Connect AI to connect to MailerLite Data from Choreo and build custom apps using live MailerLite data.
-
Integrating Claude Code with DB2 Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on DB2 data within assisted coding and automated development workflows.
-
Visualize Twilio Data in TIBCO Spotfire through ADO.NET
Integrate Twilio data into dashboards in TIBCO Spotfire.
-
Use the CData Software ODBC Driver for SharePoint Excel Services in SAS for Real-Time Reporting and Analytics
Connect to real-time SharePoint Excel Services data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SharePoint Excel Services.
-
Use the CData Software ODBC Driver for Supabase in SAS for Real-Time Reporting and Analytics
Connect to real-time Supabase data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Supabase.
-
Integrating OpenCode with Aha! 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.
-
How to connect and process Google Spanner data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Google Spanner data.
-
Natively Connect to Humanity Data in PHP
The CData ODBC driver for Humanity enables you to create PHP applications with connectivity to Humanity data. Leverage the native support for ODBC in PHP.
-
Create Jira Assets Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Jira Assets data access from reports, embedded analytics, and more.
-
Build Dashboards with Spark Data in DBxtra
Create dynamic dashboards and perform analytics based on Spark data in DBxtra.
-
Connect to Real-Time Oracle Eloqua Reporting Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Oracle Eloqua Reporting and Dataflow to import and use Oracle Eloqua Reporting data in Power Apps.
-
Getting Started with the CData Tableau Connector for PhantomBuster
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Connect to Paymo from a Connection Pool in WebLogic
Use the CData JDBC Driver for Paymo to connect to Paymo data from Web applications running on WebLogic.
-
DataBind Charts to Paddle Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Paddle data 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.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for OneNote
Provide connectivity to OneNote data through an SAP BusinessObjects universe.
-
Integrating Kiro with PayPal 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 OpenCode with Blackbaud FE NXT 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 Google Campaign Manager 360 Data in RapidMiner
Integrate Google Campaign Manager 360 data with standard components and data source configuration wizards in RapidMiner Studio.
-
Access Shopify Data from MySQL in Amazon QuickSight
Connect to Shopify and build visualizations of Shopify data using a MySQL Connection in Amazon QuickSight.
-
How to connect to Discord Data from Spring Boot
Connect to Discord in a Spring Boot Application using the CData API Driver for JDBC
-
Connect to Google Calendar Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Google Calendar data using standard SQL.
-
LINQ to Cosmos DB 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 Cosmos DB Data Provider.
-
How to integrate ZohoPeople with Apache Airflow
Access and process ZohoPeople data in Apache Airflow using the CData JDBC Driver.
-
Integrating Antigravity CLI with Notion data via CData CLI
Connect Notion data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to publish and share Salesforce Pardot Data dashboards with Tableau Server
The CData ODBC driver for Salesforce Pardot enables you integrate Salesforce Pardot data into Tableau dashboards.
-
Feed Act CRM Data into FineReport
How to set Act CRM data as a JDBC data source in FineReport.
-
How to Create Power BI Visual Reports with Real-Time Confluence Data
Use CData Power BI Connectors to visualize Confluence data in Power BI.
-
View Reports on Real-Time Dynamics 365 Data in Power BI Report Server
Use the CData ODBC Driver for Dynamics 365 to visualize Dynamics 365 data in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Connect to Live NetSuite SuiteAnalytics Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your NetSuite SuiteAnalytics data for you.
-
How to Work with Campaigner Data in AWS Glue Jobs Using JDBC
Connect to Campaigner from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Use Biml to Build SSIS Tasks to Replicate Reckon Accounts Hosted Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Reckon Accounts Hosted data to SQL Server.
-
Rapidly Develop Superchat-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 Superchat.
-
Connect to Pingdom Data in DBeaver
Use the CData ODBC Driver to connect to Pingdom data in DBeaver.
-
Use the CData Software JDBC Driver for ElevenLabs in MicroStrategy
Connect to ElevenLabs data in MicroStrategy Developer using the CData Software JDBC Driver for ElevenLabs.
-
Build a Singer.io Tap for AfterShip With the CData Python Connector
Learn how to easily build a Singer.io Tap for live AfterShip data using the CData Python Connector.