CData Software - Knowledge Base
Recent Articles
-
Connect to Real-Time Stripe Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Stripe and Dataflow to import and use Stripe data in Power Apps.
-
Build Sage 300-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Sage 300 data and build web apps with connectivity to live Sage 300 data.
-
Connect to Klipfolio Data from a Connection Pool in JBoss
Integrate Klipfolio data into Java servlets: Use the Management Console in JBoss to install the Klipfolio JDBC Driver.
-
Manage Customer.io Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Customer.io.
-
Build AI/ML Models with Live Sage 200 Data using Dataiku
Connect Sage 200 Data with Dataiku using the CData JDBC Driver for Sage 200.
-
Access Chargebee Data from MySQL in PHP
Connect to Chargebee through the standard MySQL libraries in PHP.
-
Integrate LibreChat with Live ZohoExpense Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live ZohoExpense data from within the chat interface.
-
Replicate Presto Data to Multiple Databases
Replicate Presto data to disparate databases with a point-and-click configuration.
-
Create Reports with Clari Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Clari data.
-
How to Connect MongoDB 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 MongoDB data in real time using natural language.
-
Connect to Sybase Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Sybase data in the Denodo Virtual DataPort Administrator.
-
Build Bugsnag-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Bugsnag data and build web apps with connectivity to live Bugsnag data.
-
Build ZohoInvoice-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for ZohoInvoice Data and create custom apps in Mendix.
-
Model, Search, and Visualize Live Outreach.io Data in ThoughtSpot
Use CData Connect AI to connect to live Outreach.io data for modeling, searching, and visualizing.
-
Access Live SAS xpt Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to SAS xpt data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to Oracle Service Cloud from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Oracle Service Cloud data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Create a Data Access Object for Sendwithus Data using JDBI
A brief overview of creating a SQL Object API for Sendwithus data in JDBI.
-
Automated Continuous Oracle Sales Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Oracle Sales replication to Azure SQL Database.
-
Connect to Moosend Data from HeidiSQL
Use CData Connect AI to connect to and query live Moosend data from HeidiSQL.
-
Connect to Clockify Data from PowerBuilder via ADO.NET
This article demonstrates how to access Clockify data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Access Live Mailgun Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Mailgun data through MCP integration.
-
How to import Gumroad Data into Apache Solr
Use the CData Software JDBC Driver for Gumroad in Data Import Handler and create an automated import of Gumroad data to Apache Solr Enterprise Search platform.
-
Build Apps with Live EnterpriseDB data in Adalo using CData Connect AI
Use CData Connect AI to integrate live EnterpriseDB data into the Adalo platform and build custom mobile and web applications with real-time EnterpriseDB data.
-
Connect to and Visualize Live Blackbaud FE NXT Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Blackbaud FE NXT data.
-
Link SparkPost with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SparkPost data in Filemaker Pro for Mac or Windows.
-
Extract, Transform, and Load Dropbox Data in Informatica PowerCenter
Create a simple Workflow for Dropbox data in Informatica PowerCenter.
-
Create SSAS Tabular Models from Spark Data
How to build a SQL Server Analysis Service Tabular Model from Spark data using CData drivers.
-
Design BIRT Reports on Zendesk Data
Provide current Zendesk data to your embedded analytics.
-
Create Dynamic PDFMonkey Grids Using the Infragistics XamDataGrid
Learn how you can connect PDFMonkey to Infragistics XamDataGrid to build dynamic grids.
-
Connect to ClickUp Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for ClickUp to connect to ClickUp data and execute queries in PowerBuilder.
-
Create a Data Access Object for Marketo Data using JDBI
A brief overview of creating a SQL Object API for Marketo data in JDBI.
-
Enable the Sentry JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Sentry data.
-
Use Databricks Agent Bricks to Talk to Your Google Search Results via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Google Search results for you.
-
Use Grok to Talk to Your Dynamics 365 Business Central 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 Dynamics 365 Business Central data for you.
-
Connect eBay Analytics to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect eBay Analytics with IBM WebSphere for seamless data integration and connectivity.
-
Analyze MySQL Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze MySQL data with the CData JDBC Driver for MySQL.
-
How to Easily Query Dynamics 365 Business Central Data in OpenOffice Base
Connect to Dynamics 365 Business Central data in OpenOffice Base using the CData ODBC Driver for Dynamics 365 Business Central and generate reports with live data insights.
-
Connect and Visualize Live Google Ads Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Google Ads data into the Databricks platform and create visualization dashboards with real-time Google Ads data.
-
Create Data Visualizations in Cognos BI with Exa Data
Access Exa data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Prepare, Blend, and Analyze Figshare Data in Alteryx Designer (Connect AI)
Build workflows to access live Figshare data for self-service data analytics.
-
Automated Continuous Oracle SCM Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Oracle SCM replication to Google Cloud SQL.
-
Integrate CircleCI Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live CircleCI data from Informatica Cloud.
-
Create Informatica Mappings From/To a JDBC Data Source for Elasticsearch
Create Elasticsearch data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Create NetSuite SuiteAnalytics-Connected Business Apps in AppSheet
Connect to NetSuite SuiteAnalytics Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to NetSuite SuiteAnalytics data.
-
Process & Analyze ZohoSubscriptions Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live ZohoSubscriptions Data.
-
Create Sendwithus-Connected Applications in Appsmith
Connect to Sendwithus Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Sendwithus data.
-
Explore Geographical Relationships in MYOB AccountRight Data with Power Map
Create data visualizations with MYOB AccountRight data in Power Map.
-
Integrating Cursor with Snowflake 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 to LDAP Objects with Squirrel SQL client
Connect to LDAP objects and execute queries in the Squirrel SQL Client.
-
Use Databricks Agent Bricks to Talk to Your Certinia Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Certinia data for you.
-
DataBind Controls to VWO Data in C++Builder
DataBind to VWO data in C++Builder with standard components and controls.
-
How to Build an ETL App for Discourse Data in Python with CData
Create ETL applications and real-time data pipelines for Discourse data in Python with petl.
-
Add Demio Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Demio with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate Cosmos DB Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Cosmos DB data from Informatica Cloud.
-
Automated Continuous Vimeo Replication to SQLite
Use CData Sync for automated, continuous, customizable Vimeo replication to SQLite.
-
LINQ to Microsoft Exchange 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 Microsoft Exchange Data Provider.
-
Seamlessly Bring CockroachDB Data into Retool Using CData Connect AI
Integrate CockroachDB data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to connect and process Slack data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Slack data.
-
Create Informatica Mappings From/To an ODBC Data Source for LDAP
Create an ODBC connection to LDAP in Informatica and browse and transfer LDAP objects.
-
Integrate Testmonitor Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Testmonitor data from Informatica Cloud.
-
Connect to Sage 200 Data from HeidiSQL
Use CData Connect AI to connect to and query live Sage 200 data from HeidiSQL.
-
How to Seamlessly Import MailerLite Data into IBM SPSS Modeler
Integrate MailerLite data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Add Twilio Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Twilio with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Contentful Data in HULFT Integrate
Connect to Contentful as a JDBC data source in HULFT Integrate
-
Visualize Klipfolio Data in Sisense
Create an ElastiCube in Sisense app with access to Klipfolio data.
-
Connect to Retently Data from a Connection Pool in Jetty
The Retently JDBC Driver supports connection pooling: This article shows how to connect faster to Retently data from Web apps in Jetty.
-
Create Informatica Mappings From/To a JDBC Data Source for AlloyDB
Create AlloyDB data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Work with SAS Data Sets Data in ETL Validator JDBC
Connect to SAS Data Sets from ETL Validator jobs using the CData Software JDBC Driver.
-
Build Kafka-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Kafka data.
-
Connect to and Visualize Live SAS Data Sets Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live SAS Data Sets data.
-
Access Live eBay Analytics Data in AWS Lambda
Connect to live eBay Analytics data in AWS Lambda using the CData JDBC Driver.
-
Getting Started with the CData Excel Add-In for Trello
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Trello.
-
Connect to EmailOctopus Data from PowerBuilder via JDBC
This article demonstrates how to access EmailOctopus data from PowerBuilder using the EmailOctopus JDBC Driver.
-
Import Printify Data Using Azure Data Factory
Use CData Connect AI to connect to Printify Data from Azure Data Factory and import live Printify data.
-
Connect to Demio Data in DBArtisan
Use wizards in DBArtisan to configure Demio data as a data source.
-
Getting Started with the CData SSIS Components for ZohoInvoice
Complete guide to installing, licensing, and connecting with the CData SSIS Components for ZohoInvoice.
-
Connect to Lakebase Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Lakebase.
-
How to connect to Todoist Data from IntelliJ
Integrate connectivity to Todoist data with wizards in IntelliJ.
-
Connect to PagerDuty Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to PagerDuty and work with PagerDuty data in your FileMaker applications.
-
Automated Continuous Webflow Replication to Snowflake
Use CData Sync for automated, continuous, customizable Webflow replication to Snowflake.
-
Connecting Moonlit Workflow with MYOB AccountRight 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 MYOB AccountRight data in real time.
-
Automated Continuous RabbitMQ Replication to Snowflake
Use CData Sync for automated, continuous, customizable RabbitMQ replication to Snowflake.
-
Create Apps from GetResponse Data in Qlik Sense Cloud
Use CData Connect AI to connect to GetResponse Data and build apps from live GetResponse data in Qlik Sense Cloud.
-
Use the CData Software JDBC Driver for Toggl in MicroStrategy
Connect to Toggl data in MicroStrategy Developer using the CData Software JDBC Driver for Toggl.
-
Create Harvest Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Harvest data access from reports, embedded analytics, and more.
-
Connect to Reply.io Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Reply.io and work with Reply.io data in your FileMaker applications.
-
Create Datasets from Zoho Inventory in Domo Workbench and Build Visualizations of Zoho Inventory Data in Domo
Use the CData Software ODBC Driver for Zoho Inventory to create datasets from Zoho Inventory data in Domo Workbench and then build visualizations in the Domo service.
-
Create a Data Access Object for MongoDB Data using JDBI
A brief overview of creating a SQL Object API for MongoDB data in JDBI.
-
Automated Continuous DB2 for i Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable DB2 for i replication to Azure SQL Database.
-
Automated Continuous EnterpriseDB Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to Amazon Redshift.
-
How to connect to SAP SuccessFactors Data from Spring Boot
Connect to SAP SuccessFactors in a Spring Boot Application using the CData JDBC Driver for SAP SuccessFactors
-
How to connect SharePoint with Microsoft Entra ID Data through external lists
Provide Microsoft Entra ID data to SharePoint users as an external list.
-
Getting Started with the CData JDBC Driver for Front
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Front.
-
How to connect Amazon QuickSight to Bitbucket Data
Create a connection to Bitbucket data in CData Connect AI and insert Bitbucket data into Amazon QuickSight SPICE to build interactive dashboards.
-
How to Access Microsoft Planner Data Using Entity Framework
This article shows how to access Microsoft Planner data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrating Boomi Agentstudio with Avalara AvaTax Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Avalara AvaTax data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Analyze WooCommerce Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze WooCommerce data in Microsoft R Open.
-
Prepare, Blend, and Analyze Jira Assets Data in Alteryx Designer (Connect AI)
Build workflows to access live Jira Assets data for self-service data analytics.
-
Seamlessly Bring eBay Analytics Data into Retool Using CData Connect AI
Integrate eBay Analytics data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Getting Started with the CData Tableau Connector for Salesforce Data 360
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Salesforce Data 360.