CData Software - Knowledge Base
Recent Articles
-
Rapidly Develop Act-On-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 Act-On.
-
Create Data Visualizations in Cognos BI with Google Ads Data
Access Google Ads as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to integrate Presto with Apache Airflow
Access and process Presto in Apache Airflow using the CData JDBC Driver.
-
Create Power BI Reports on Real-Time Auth0 Data
Use the CData ODBC Driver for Auth0 to visualize Auth0 in Power BI Desktop.
-
Automate Email Data Replication to SAP HANA
Use CData Sync to customize and automate Email replication to SAP HANA.
-
How to connect and process Snapchat Ads from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Snapchat Ads.
-
Getting Started with the CData SSIS Components for Customer.io
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Customer.io.
-
Use Agno to Talk to Your Twilio Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Twilio for you.
-
Getting Started with the CData JDBC Driver for Salesloft
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Salesloft.
-
ETL Billsby in Oracle Data Integrator
This article shows how to transfer Billsby into a data warehouse using Oracle Data Integrator.
-
Getting Started with the CData Connect AI Python SDK for Kintone
Install the CData Connect AI Python SDK to read and write live Kintone with standard DB-API 2.0 Python code.
-
Integrating Basecamp Data in Talend Cloud Data Management Platform
Connect Basecamp Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Basecamp.
-
Automate Discord Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Discord from PowerShell? This article demonstrates how to utilize the Discord Cmdlets for tasks like connecting to Discord, automating operations, downloading data, and more.
-
Connect to Hacker News Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Hacker News to connect to Hacker News and execute queries in PowerBuilder.
-
How to Query Pinecone Data in MySQL Workbench
Execute MySQL queries against live Pinecone from MySQL Workbench.
-
DataBind Apify Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Apify to a chart.
-
Analyze HCL Domino Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of HCL Domino and visualize live HCL Domino in Infragistics Reveal.
-
Moving Data from PabblySubscriptions to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live PabblySubscriptions data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build Dashboards with Adobe Experience Manager Data in DBxtra
Create dynamic dashboards and perform analytics based on Adobe Experience Manager in DBxtra.
-
Bind Live Parquet Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Parquet data
-
Connect to Real-Time SparkPost Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use SparkPost in Power Apps.
-
Integrating Recurly Data in Talend Cloud Data Management Platform
Connect Recurly Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Work with ScrapingBee Data in FoxPro
Load ScrapingBee into a FoxPro database. This article includes full code and a walk-through of the process.
-
DataBind Amazon DynamoDB Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Amazon DynamoDB with the DevExpress Windows Forms and Web controls to provide Amazon DynamoDB to a chart.
-
Connect to SAS Data Sets Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Square Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Square through CData Connect AI using different applications and tools.
-
Automated Continuous Workday Replication to SingleStore
Use CData Sync for automated, continuous, customizable Workday replication to SingleStore.
-
Automate Box Data Replication to Azure Data Lake
Use CData Sync to customize and automate Box replication to Azure Data Lake.
-
Connect to LinkedIn Data in NetBeans
Connect to LinkedIn in NetBeans with the data source configuration wizard.
-
DataBind Controls to Sybase IQ Data in Delphi
DataBind to Sybase IQ in Delphi with standard data access components and controls.
-
Connect to REST Data as an External Source in Dremio
Use the CData JDBC Driver to connect to REST as an External Source in Dremio.
-
DataBind Charts to SAP HANA XS Advanced Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SAP HANA XS Advanced 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.
-
Work with Live MongoDB Data in Power Query
Use CData Connect AI to connect to MongoDB and work with live MongoDB in Microsoft Power Query.
-
Integrate with Auth0 Data in JReport Designer
Create charts and reports based on Auth0 in JReport Designer.
-
Create Salesforce Pardot-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Salesforce Pardot Data from OutSystems and build custom enterprise apps using live Salesforce Pardot.
-
Build Google Spanner-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Google Spanner.
-
Use Grok to Talk to Your Cvent 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 Cvent for you.
-
Enable the Bright Data JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Bright Data.
-
Build Automated Workflows with Live GitHub Data in Workato
Use CData Connect AI to connect to live GitHub and build automated workflows in Workato.
-
Integrate with live Greenhouse Data in Jitterbit
Use CData Connect AI to connect to and integrate live Greenhouse in Jitterbit.
-
How to Connect to Live Microsoft Teams 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 Microsoft Teams for you.
-
Enable the HubDB JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with HubDB.
-
Visualize Sybase Data in TIBCO Spotfire through OData
Integrate Sybase into dashboards in TIBCO Spotfire.
-
LINQ to Amazon S3 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 Amazon S3 Data Provider.
-
How to Query Live Kintone Data in Claude Desktop
Connect to and query live Kintone Data in Claude Desktop using CData MCP Server.
-
How to create Visio diagrams from IBM Informix Data
Automatically update IBM Informix with the changes you make to Visio master shapes.
-
Access Live Office 365 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 Microsoft Office 365 through MCP integration.
-
Replicate Splunk Data to Multiple Databases via the CData Sync CLI
Replicate Splunk to disparate databases with a single configuration.
-
Connect to SAP Business One Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SAP Business One to connect to SAP Business One and execute queries in PowerBuilder.
-
Work with Amazon S3 Data in FoxPro
Load Amazon S3 into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to integrate SAS Data Sets with Apache Airflow
Access and process SAS Data Sets in Apache Airflow using the CData JDBC Driver.
-
Work with Perigon Data in FoxPro
Load Perigon into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to work with AgileCRM Data in Apache Spark using SQL
Access and process AgileCRM Data in Apache Spark using the CData Software JDBC Driver.
-
Use the CData Software JDBC Driver for SAP HANA XS Advanced in MicroStrategy
Connect to SAP HANA XS Advanced in MicroStrategy Developer using the CData Software JDBC Driver for SAP HANA XS Advanced.
-
Back Up JSON to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for JSON. In this article, we will employ an SSIS workflow to populate a database with JSON data.
-
Build Snowflake-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Snowflake to explore live Snowflake Data in Claude Code to assist with building Snowflake-powered applications.
-
Automated Continuous ZohoSubscriptions Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable ZohoSubscriptions replication to PostgreSQL.
-
Integrate Redshift with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Redshift with External Services.
-
Access Live FTP Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate FTP Servers into the statistical analysis tools available in SAS JMP. This article shows how to use FTP Servers in the Graph Builder and Query Builder.
-
Enable the CouchDB JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Apache CouchDB.
-
Extend Google Sheets with Kintone Data
Make calls to Kintone from Google Apps Script via the API Server.
-
Migrating data from Beeminder to Snowflake using CData SSIS Components.
Easily push Beeminder to Snowflake using the CData SSIS Tasks for Beeminder and Snowflake.
-
Access Live ActiveCampaign Data in Excel 365 Online (Excel for the web)
Connect to ActiveCampaign from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Build Couchbase-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Couchbase and build web apps with connectivity to live Couchbase.
-
Build Zoho CRM-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Zoho CRM to explore live Zoho CRM Data in Claude Code to assist with building Zoho CRM-powered applications.
-
Connect to Gmail Data from PowerBuilder via JDBC
This article demonstrates how to access Gmail from PowerBuilder using the Gmail JDBC Driver.
-
Build an OLAP Cube in SSAS from PingOne Data
Establish a connection to PingOne data from SQL Server Analysis Services, and use the PingOne Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous Pipeliner CRM Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Pipeliner CRM replication to Amazon Redshift.
-
Query Reckon Accounts Hosted Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Reckon Accounts Hosted from Node.js.
-
Manage SAS xpt Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SAS xpt.
-
Configure the CData JDBC Driver for ZohoMarketingHub in a Connection Pool in Tomcat
Connect to ZohoMarketingHub from a connection pool in Tomcat.
-
How to connect to SpaceX Data from Spring Boot
Connect to SpaceX in a Spring Boot Application using the CData API Driver for JDBC
-
Create Dynamic Certinia Grids Using the Infragistics XamDataGrid
Learn how you can connect Certinia to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Odoo Data in ACL Analytics
Connect to Odoo ERP via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Odoo ERP.
-
DataBind Charts to Salesforce Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Salesforce & Force.com 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.
-
Integrate Goose with Live Greenplum Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Pivotal GreenPlum from within the local AI agent.
-
Access Live MailerLite Data in Coginiti Pro
Connect to and query live MailerLite from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use Manus AI to Talk to Your Zoho Projects Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Zoho Projects.
-
Extend Google Sheets with xBase Data
Make calls to xBase from Google Apps Script via the API Server.
-
Import Trello Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Trello Data and provide access to live Trello for custom reports in the Power BI Service.
-
Connect Opsgenie Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Opsgenie using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Access Live Okta Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Okta through MCP integration.
-
Analyze Basecamp Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Basecamp with the CData JDBC Driver for Basecamp.
-
Build FTP-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live FTP Servers.
-
Integrate Live Foursquare Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Foursquare to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Create Reports with CircleCI Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date CircleCI.
-
Automated Continuous AdRoll Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable AdRoll replication to Apache Cassandra.
-
Connect to Microsoft Dataverse Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Microsoft Dataverse (CDS).
-
Connect to OpenWeatherMap Data from a Connection Pool in Jetty
The OpenWeatherMap JDBC Driver supports connection pooling: This article shows how to connect faster to OpenWeatherMap from Web apps in Jetty.
-
How to Create Power BI Visual Reports with Real-Time Neo4J Data
Use CData Power BI Connectors to visualize Neo4J in Power BI.
-
Feed Blackbaud FE NXT Data into FineReport
How to set Blackbaud FE NXT as a JDBC data source in FineReport.
-
Publish Crystal Reports on Bright Data Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Bright Data.
-
Bidirectional Access to Tickspot Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Tickspot in Filemaker Pro for Mac or Windows.
-
Automated Continuous Elorus Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Elorus replication to Azure SQL Database.
-
Build Semantic Layer Views for Zoho Inventory Data in APOS Live Data Gateway
Use the CData Connector for Zoho Inventory in APOS Live Data Gateway to build Semantic Layer Views for Zoho Inventory.
-
How to connect Amazon QuickSight to NetSuite Data
Create a connection to NetSuite CRM & ERP in CData Connect AI and insert NetSuite CRM & ERP into Amazon QuickSight SPICE to build interactive dashboards.
-
Automated Continuous Perplexity Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Perplexity replication to Apache Cassandra.
-
Integrate Theia IDE with Live MariaDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Back Up SurveyMonkey to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SurveyMonkey. In this article, we will employ an SSIS workflow to populate a database with SurveyMonkey data.
-
Connect to Splunk Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Splunk using standard SQL.