CData Software - Knowledge Base
Recent Articles
-
LINQ to Access 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 Access Data Provider.
-
Use Manus AI to Talk to Your SAP HANA 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 SAP HANA.
-
Access Live QuickBooks Time 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 QuickBooks Time through MCP integration.
-
Integrate Todoist Data in the Pentaho Report Designer
Publish reports based on Todoist in the Pentaho BI tool.
-
Integrating GitHub Copilot CLI with Adobe Commerce 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 Planio Data from IntelliJ
Integrate connectivity to Planio with wizards in IntelliJ.
-
Create SSAS Tabular Models from Clio Data
How to build a SQL Server Analysis Service Tabular Model from Clio using CData drivers.
-
Connect to Tally Data in CloverDX (formerly CloverETL)
Transfer Tally ERP using the visual workflow in the CloverDX data integration tool.
-
Integrating GitHub Copilot CLI with Zoho Projects 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.
-
Publish Neo4J-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Neo4J.
-
Connect to Reckon Accounts Hosted Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Reckon Accounts Hosted.
-
Integrate Live Zoho Creator Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Zoho Creator from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Zoho Creator.
-
Provide OData Services of Sugar CRM Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Sugar CRM by developing a WCF Service Application.
-
Automated Continuous ZohoInvoice Replication to SQLite
Use CData Sync for automated, continuous, customizable ZohoInvoice replication to SQLite.
-
Viewing Templated Data in RAD Studio Data Explorer
How to view Templated in RAD Studio Data Explorer using the CData ODBC Driver for Templated.
-
Analyze Databricks Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Databricks in Microsoft R Open.
-
Automated Continuous MySQL Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable MySQL replication to Google BigQuery.
-
Access Live Adobe Commerce 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 Adobe Commerce through MCP integration.
-
Connect to Discourse Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Automated Continuous Omnisend Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Omnisend replication to Amazon S3.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Amazon Redshift within intelligent workflows.
-
Create Power BI Reports on Real-Time Okta Data
Use the CData ODBC Driver for Okta to visualize Okta in Power BI Desktop.
-
Rapidly Develop Azure Analysis Services-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 Azure Analysis Services.
-
Connect Front to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Front with IBM WebSphere for seamless data integration and connectivity.
-
Automated Continuous Eventbrite Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Eventbrite replication to Amazon Redshift.
-
Automated Continuous Mailgun Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Mailgun replication to Google BigQuery.
-
How to work with Retently Data in Apache Spark using SQL
Access and process Retently Data in Apache Spark using the CData Software JDBC Driver.
-
Build Dashboards with Authorize.Net Data in DBxtra
Create dynamic dashboards and perform analytics based on Authorize.Net in DBxtra.
-
How to Visualize Couchbase Data in Python with pandas
Use pandas and other modules to analyze and visualize live Couchbase in Python.
-
How to connect to YouTube Analytics Data from Spring Boot
Connect to YouTube Analytics in a Spring Boot Application using the CData JDBC Driver for YouTube Analytics
-
Replicate LionDesk Data from PowerShell
Write a quick PowerShell script to query LionDesk. Use connectivity to the live data to replicate LionDesk to SQL Server.
-
Integrating GitHub Copilot CLI with Google Directory 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.
-
DataBind Charts to BigQuery Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Google BigQuery 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.
-
Migrating data from Workable to Snowflake using CData SSIS Components.
Easily push Workable to Snowflake using the CData SSIS Tasks for Workable and Snowflake.
-
Analyze PostgreSQL Data in Cognos Analytics
Use CData Connect AI to connect to PostgreSQL Data from Cognos Analytics and analyze live PostgreSQL.
-
Create Dynamic Adobe Experience Manager Grids Using the Infragistics XamDataGrid
Learn how you can connect Adobe Experience Manager to Infragistics XamDataGrid to build dynamic grids.
-
How to integrate Nethunt with Apache Airflow
Access and process Nethunt in Apache Airflow using the CData JDBC Driver.
-
Connect to CouchDB Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for CouchDB and the SQL Gateway to access Apache CouchDB from Google Apps Script.
-
Access SAP BusinessObjects BI Data from MySQL in PHP
Connect to SAP BusinessObjects BI through the standard MySQL libraries in PHP.
-
How to work with Office 365 Data in Apache Spark using SQL
Access and process Office 365 Data in Apache Spark using the CData Software JDBC Driver.
-
Create Power BI Reports on Real-Time SuiteCRM Data
Use the CData ODBC Driver for SuiteCRM to visualize SuiteCRM in Power BI Desktop.
-
Stream ConvertAPI Data into Apache Kafka Topics
Access and stream ConvertAPI in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Datadog Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect and Query Live Presto Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Presto into Databricks
-
Sugar CRM Reporting in OBIEE with the Sugar CRM JDBC Driver
Deploy the Sugar CRM JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrate SAP Business Warehouse with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SAP Business Warehouse with External Services.
-
Automated Continuous AdRoll Replication to IBM DB2
Use CData Sync for automated, continuous, customizable AdRoll replication to IBM DB2.
-
Integrating Azure Analysis Services Data in Talend Cloud Data Management Platform
Connect Azure Analysis Services Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Azure Analysis Services.
-
Query Slack Data as a SQL Server Database in Node.js
Execute SQL Server queries against Slack from Node.js.
-
Viewing PostgreSQL Data in RAD Studio Data Explorer
How to view PostgreSQL in RAD Studio Data Explorer using the CData ODBC Driver for PostgreSQL.
-
Replicate Microsoft Ads Data in Heroku for Use in Salesforce Connect
Replicate Microsoft Ads to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Add Moosend Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Moosend with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect and Visualize Live Oracle HCM Cloud Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Oracle HCM Cloud into the Databricks platform and create visualization dashboards with real-time Oracle HCM Cloud.
-
How to Work with Testmonitor Data in ETL Validator JDBC
Connect to Testmonitor from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Insightly Data in Jaspersoft Studio
Execute SQL to remote Insightly in Jaspersoft Studio.
-
Build Apps with Live Vimeo Data Using the Low-Code Development Platform of Mendix
Connect Vimeo with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to Live HCL Domino Data in PostGresSQL Interface through CData Connect AI
Create a live connection to HCL Domino in CData Connect AI and connect to your HCL Domino from PostgreSQL.
-
How to connect and process Apache Kafka from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Apache Kafka.
-
Integrating Claude Code CLI with Clio 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 publish and share SAP Concur Data dashboards with Tableau Server
The CData ODBC driver for SAP Concur enables you integrate SAP Concur into Tableau dashboards.
-
Natively Connect to Bitbucket Data in PHP
The CData ODBC driver for Bitbucket enables you to create PHP applications with connectivity to Bitbucket. Leverage the native support for ODBC in PHP.
-
Use the CData ODBC Driver for Amazon DynamoDB in Microsoft Power Query
You can use the CData Amazon DynamoDB ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Amazon DynamoDB into Microsoft Power Query.
-
Automate Scrapfly Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Scrapfly from PowerShell? This article demonstrates how to utilize the Scrapfly Cmdlets for tasks like connecting to Scrapfly, automating operations, downloading data, and more.
-
Replicate CouchDB Data in Heroku for Use in Salesforce Connect
Replicate Apache CouchDB to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Use the CData SSIS Components to Insert New or Update Existing Active Directory Records from SQL Server
Easily push SQL Server data to Active Directory using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Active Directory or update existing records with data from a SQL Server database.
-
Working with Placid Data in LINQPad
Execute LINQ queries to Placid in LINQPad.
-
Connect to Amazon Athena Data from a Connection Pool in JBoss
Integrate Amazon Athena into Java servlets: Use the Management Console in JBoss to install the Amazon Athena JDBC Driver.
-
Replicate Multiple Omnisend Accounts
Replicate multiple Omnisend accounts to one or many databases.
-
Configure the CData JDBC Driver for Auth0 in a Connection Pool in Tomcat
Connect to Auth0 from a connection pool in Tomcat.
-
How to work with Opsgenie Data in Apache Spark using SQL
Access and process Opsgenie Data in Apache Spark using the CData Software JDBC Driver.
-
Build Adobe Commerce-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Adobe Commerce.
-
How to Connect DBeaver to SAP Business One via a JDBC Driver
Manage SAP Business One with visual tools in DBeaver like the query browser.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Oracle HCM Cloud
Provide connectivity to Oracle HCM Cloud through an SAP BusinessObjects universe.
-
Getting Started with the CData Connect AI Python SDK for Oracle Financials Cloud
Install the CData Connect AI Python SDK to read and write live Oracle Financials Cloud with standard DB-API 2.0 Python code.
-
Build Data Flows from Cloudflare to SQL Server using SSIS
Easily back up Cloudflare to SQL Server using the SSIS components for Cloudflare.
-
How to Visualize Google Directory Data in Python with pandas
Use pandas and other modules to analyze and visualize live Google Directory in Python.
-
Automated Continuous Clockify Replication to SQLite
Use CData Sync for automated, continuous, customizable Clockify replication to SQLite.
-
Create a Data Access Object for ZarMoney Data using JDBI
A brief overview of creating a SQL Object API for ZarMoney in JDBI.
-
Use JayDeBeApi to access Marketo Data in Python
Use standard Python scripting and the development environment of your choice to access live Marketo.
-
Replicate LionDesk Data to Multiple Databases
Replicate LionDesk to disparate databases with a point-and-click configuration.
-
Connecting Agentforce with Outreach.io 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 Outreach.io for you.
-
Access Live Neo4J Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Neo4J from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Replicate Typeform Data to Multiple Databases via the CData Sync CLI
Replicate Typeform to disparate databases with a single configuration.
-
How to create an RPA flow for Exact Online Data in UiPath Studio
Use the Exact Online ODBC Driver to create workflows that access real-time Exact Online without any coding.
-
Integrate Theia IDE with Live Microsoft Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Connect to Datadog Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Datadog and the SQL Gateway to access Datadog from Google Apps Script.
-
Create Informatica Mappings From/To a JDBC Data Source for HelloSign
Create HelloSign data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Visualize Vercel 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 Vercel into TIBCO Spotfire.
-
Connect to PhantomBuster Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time PhantomBuster using standard SQL.
-
Visualize Live Instagram Data in the Power BI Service
Use CData Connect AI to connect to live Instagram and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to connect to BigCommerce Data from Spring Boot
Connect to BigCommerce in a Spring Boot Application using the CData JDBC Driver for BigCommerce
-
Connect to Google Sheets Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Google Sheets and the Script function in FileMaker Pro to connect to Google Sheets and work with Google Sheets in your FileMaker application.
-
Natively Connect to ElevenLabs Data in PHP
The CData ODBC driver for ElevenLabs enables you to create PHP applications with connectivity to ElevenLabs. Leverage the native support for ODBC in PHP.
-
Working with Hubstaff Data in LINQPad
Execute LINQ queries to Hubstaff in LINQPad.
-
Connect to CircleCI in SpagoBI
Create reports featuring live CircleCI in SpagoBI Studio. Host CircleCI reports on SpagoBI Server.
-
LINQ to Google Contacts 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 Google Contacts Data Provider.
-
Connect to Sendwithus Data in CloverDX (formerly CloverETL)
Transfer Sendwithus using the visual workflow in the CloverDX data integration tool.
-
Create a Data Access Object for PabblySubscriptions Data using JDBI
A brief overview of creating a SQL Object API for PabblySubscriptions in JDBI.
-
Configure the CData JDBC Driver for Eventbrite in a Connection Pool in Tomcat
Connect to Eventbrite from a connection pool in Tomcat.
-
View Reports on Real-Time NetSuite Data in Power BI Report Server
Use the CData ODBC Driver for NetSuite to visualize NetSuite CRM & ERP in Power BI Desktop and then publish them to Power BI Report Server.