CData Software - Knowledge Base
Recent Articles
-
How to Design Couchbase Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Couchbase from mobile and tablet Power Apps.
-
Connect to Greenplum Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Automate Mode Data Replication to Azure Data Lake
Use CData Sync to customize and automate Mode replication to Azure Data Lake.
-
Build Semantic Layer Views for Email Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Email.
-
Getting Started with the CData ADO.NET Provider for ZohoDesk
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Integrate Xero with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Xero with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Xero Accounting.
-
Write a Simple Go Application to work with Microsoft Entra ID Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Microsoft Entra ID.
-
Analyze Live Twilio Data in SAS Viya
Use CData Connect AI to connect to Twilio from SAS Viya and deploy self-service analytics using live Twilio.
-
Integrate Live CouchDB Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Apache CouchDB and integrate live Apache CouchDB into apps built in Microsoft Power Apps.
-
How to Work with Apify Data in AWS Glue Jobs Using JDBC
Connect to Apify from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrating Landbot Data in Talend Cloud Data Management Platform
Connect Landbot Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Create Power BI Reports on Real-Time Box Data
Use the CData ODBC Driver for Box to visualize Box in Power BI Desktop.
-
Migrating data from Teradata to Snowflake using CData SSIS Components.
Easily push Teradata to Snowflake using the CData SSIS Tasks for Teradata and Snowflake.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Facebook
Provide connectivity to Facebook through an SAP BusinessObjects universe.
-
Integrate Live MYOB AccountRight Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
How to Visualize Wrike Data in Python with pandas
Use pandas and other modules to analyze and visualize live Wrike in Python.
-
Create EmailOctopus Dataflows on PowerBI.com
Connect to the CData Power BI Connector for EmailOctopus from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to integrate Gong with Apache Airflow
Access and process Gong in Apache Airflow using the CData JDBC Driver.
-
Visualize Mocean 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 Mocean into TIBCO Spotfire.
-
Integrate Live MYOB AccountRight Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live MYOB AccountRight to Blue Prism using the CData ODBC Driver for MYOB AccountRight to create automated workflows for repetitive business tasks.
-
Use the CData Software JDBC Driver for Harvest in MicroStrategy
Connect to Harvest in MicroStrategy Developer using the CData Software JDBC Driver for Harvest.
-
View Reports on Real-Time Figshare Data in Power BI Report Server
Use the CData ODBC Driver for Figshare to visualize Figshare in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrating GitHub Copilot CLI with Workable 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 SQL Analysis Services to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SQL Analysis Services with IBM WebSphere for seamless data integration and connectivity.
-
Use the CData Software ODBC Driver for LionDesk in MicroStrategy Desktop
Connect to LionDesk in MicroStrategy Desktop using the CData Software ODBC Driver for LionDesk.
-
Replicate Multiple MariaDB Accounts
Replicate multiple MariaDB accounts to one or many databases.
-
How to connect Amazon QuickSight to SAP BusinessObjects BI Data
Create a connection to SAP BusinessObjects BI in CData Connect AI and insert SAP BusinessObjects BI into Amazon QuickSight SPICE to build interactive dashboards.
-
Use the CData Software JDBC Driver for Onfleet in MicroStrategy Desktop
Connect to Onfleet in MicroStrategy Desktop using the CData Software JDBC Driver for Onfleet.
-
Automated Continuous SAP Ariba Procurement Replication to SQLite
Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to SQLite.
-
Connect to Parquet Data from PowerBuilder via JDBC
This article demonstrates how to access Apache Parquet from PowerBuilder using the Parquet JDBC Driver.
-
Choosing the Best Method to Connect BenchmarkEmail to SQL Server: 5 Options Explained
Discover multiple ways to connect and use BenchmarkEmail from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build Voice Agents in ElevenLabs with access to Live Salesforce CRM Analytics Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Salesforce CRM Analytics.
-
Prepare, Blend, and Analyze Smartsheet Data in Alteryx Designer (ODBC)
Build workflows to access live Smartsheet for self-service data analytics.
-
Connect Xero to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Xero with IBM WebSphere for seamless data integration and connectivity.
-
Query ChargeOver Data in ColdFusion
Write standard ColdFusion data access code to connect to ChargeOver.
-
Working with Toggl Data in LINQPad
Execute LINQ queries to Toggl in LINQPad.
-
Create SSAS Tabular Models from Attio Data
How to build a SQL Server Analysis Service Tabular Model from Attio using CData drivers.
-
How to Access Live AfterShip Data in Power Automate Desktop via ODBC
The CData ODBC Driver for AfterShip enables you to integrate AfterShip into workflows built using Microsoft Power Automate Desktop.
-
Import and Visualize Databricks Data in Power View
Create data visualizations based on Databricks in Excel.
-
Automate Apify Data Replication to SAP HANA
Use CData Sync to customize and automate Apify replication to SAP HANA.
-
How to connect to Parallel Data from IntelliJ
Integrate connectivity to Parallel with wizards in IntelliJ.
-
How to work with JDBC-ODBC Bridge Data in Apache Spark using SQL
Access and process JDBC-ODBC Bridge Data in Apache Spark using the CData Software JDBC Driver.
-
How to connect and process SAP SuccessFactors from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live SAP SuccessFactors.
-
Access Live Short.io Data in Coginiti Pro
Connect to and query live Short.io from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to use SQLAlchemy ORM to access Clockify Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Clockify.
-
Query SurveyMonkey Data as a SQL Server Database in Node.js
Execute SQL Server queries against SurveyMonkey from Node.js.
-
Build AI/ML Models with Live Azure DevOps Data using Dataiku
Connect Azure DevOps Data with Dataiku using the CData JDBC Driver for Azure DevOps.
-
Create Telegram Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Telegram data access from reports, embedded analytics, and more.
-
Provide OData Services of Planio Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Planio by developing a WCF Service Application.
-
Migrating data from SAP to Databricks using CData SSIS Components.
Easily push SAP ERP/NetWeaver to Databricks using the CData SSIS Tasks for SAP and Databricks.
-
Connect to Ontraport from a Connection Pool in WebLogic
Use the CData JDBC Driver for Ontraport to connect to Ontraport from Web applications running on WebLogic.
-
Use the CData Software ODBC Driver for Ontraport in MicroStrategy Desktop
Connect to Ontraport in MicroStrategy Desktop using the CData Software ODBC Driver for Ontraport.
-
Connect to Oracle HCM Cloud Data in JRuby
Create a simple JRuby app with access to live Oracle HCM Cloud.
-
How to publish and share Stripe Data dashboards with Tableau Server
The CData ODBC driver for Stripe enables you integrate Stripe into Tableau dashboards.
-
Back Up Microsoft Entra ID to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Microsoft Entra ID. In this article, we will employ an SSIS workflow to populate a database with Microsoft Entra ID data.
-
Integrating Kiro CLI with Oracle Financials Cloud 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 Live Nuclia Data in Coginiti Pro
Connect to and query live Nuclia from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Operational Reporting on SurveyMonkey Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SurveyMonkey.
-
How to Work with ServiceNow Data in ETL Validator JDBC
Connect to ServiceNow from ETL Validator jobs using the CData Software JDBC Driver.
-
Use Dash to Build to Web Apps on Harvest Data
Create Python applications that use pandas and Dash to build Harvest-connected web apps.
-
Connect to PostgreSQL Data as an External Source in Dremio
Use the CData JDBC Driver to connect to PostgreSQL as an External Source in Dremio.
-
Use JayDeBeApi to access FHIR Data in Python
Use standard Python scripting and the development environment of your choice to access live FHIR.
-
Integrating Pipedrive Data in Talend Cloud Data Management Platform
Connect Pipedrive Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Pipedrive.
-
How to Connect FreshBooks 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 FreshBooks data in real time using natural language.
-
Visualize MySQL Data in Tableau
The CData ODBC driver for MySQL enables you integrate MySQL into Tableau dashboards.
-
Integrating GitHub Copilot CLI with Microsoft Excel Online 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 Insightly Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Insightly as an External Source in Dremio.
-
Build Data Flows from SQL Server to Access through SSIS
Easily push SQL Server data to Access using the CData SSIS Tasks for Access.
-
LINQ to SendPulse 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 SendPulse Data Provider.
-
Natively Connect to iContact Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to iContact. Leverage the native support for ODBC in PHP.
-
Build Charts with LinkedIn Ads Data in Clear Analytics
Create dynamic charts and perform analytics based on LinkedIn Ads in Clear Analytics.
-
Visualize Live OData Services of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live OData using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build AI/ML Models with Live Dropbox Data using Dataiku
Connect Dropbox Data with Dataiku using the CData JDBC Driver for Dropbox.
-
How to import Jira Data into Apache Solr
Use the CData Software JDBC Driver for Jira in Data Import Handler and create an automated import of Atlassian Jira to Apache Solr Enterprise Search platform.
-
Connect and Visualize Live FreshBooks Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live FreshBooks into the Databricks platform and create visualization dashboards with real-time FreshBooks.
-
Import and Visualize ConvertKit Data in Power View
Create data visualizations based on ConvertKit in Excel.
-
Automated Continuous MailerLite Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable MailerLite replication to Azure SQL Database.
-
How to Connect DBeaver to Flowlu via a JDBC Driver
Manage Flowlu with visual tools in DBeaver like the query browser.
-
Integrate Live Suadeo Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Suadeo to Blue Prism using the CData ODBC Driver for Suadeo to create automated workflows for repetitive business tasks.
-
Getting Started with the CData ADO.NET Provider for DB2
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for DB2.
-
How to Build an ETL App for Dynamics 365 Data in Python with CData Connect AI
Build ETL pipelines that read and write live Microsoft Dynamics 365 in Python with petl and the CData Connect AI Python SDK.
-
Connect to QuickBooks Online Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for QuickBooks Online in Airbyte.
-
Moving Data from ZarMoney to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live ZarMoney data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Query Wrike Data as a MySQL Database in Node.js
Execute MySQL queries against Wrike from Node.js.
-
Automated Continuous Adobe Target Replication to Snowflake
Use CData Sync for automated, continuous, customizable Adobe Target replication to Snowflake.
-
Connect to Gmail Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Gmail from Filemaker Pro on Mac.
-
Connect to Planio Data in NetBeans
Connect to Planio in NetBeans with the data source configuration wizard.
-
Write a Simple Go Application to work with Stack Exchange Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Stack Exchange.
-
Easily Integrate PostgreSQL Data in Lazarus Pascal IDE
Learn how to easily integrate live PostgreSQL in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Getting Started with the CData ODBC Driver for LDAP
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for LDAP.
-
Connect to Stripe Data in RapidMiner
Integrate Stripe with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to and Query ActiveCampaign Data in QlikView over ODBC
Create data visualizations with ActiveCampaign in QlikView.
-
Integrating Kiro CLI with Moosend 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.
-
Analyze Excel Online Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Microsoft Excel Online and visualize live Microsoft Excel Online in Infragistics Reveal.
-
How to connect to Stripe Data from IntelliJ
Integrate connectivity to Stripe with wizards in IntelliJ.
-
How to connect to BigCommerce Data from IntelliJ
Integrate connectivity to BigCommerce with wizards in IntelliJ.
-
Integrate TaxJar with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate TaxJar with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to TaxJar.
-
Prepare, Blend, and Analyze Act-On Data in Alteryx Designer (Connect AI)
Build workflows to access live Act-On for self-service data analytics.
-
Connect to Highrise Data in JRuby
Create a simple JRuby app with access to live Highrise CRM.
-
Access Vimeo Data from MySQL in Amazon QuickSight
Connect to Vimeo and build visualizations of Vimeo using a MySQL Connection in Amazon QuickSight.