CData Software - Knowledge Base
Recent Articles
-
A PostgreSQL Interface for Pipeliner CRM Data (MySQL Remoting via JDBC)
Use the Remoting features of the Pipeliner CRM JDBC Driver to create a PostgreSQL entry-point for data access.
-
Manage SAP Concur Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SAP Concur.
-
Analyze Qualaroo Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Qualaroo in Microsoft R Open.
-
LINQ to Zoom 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 Zoom Data Provider.
-
Build Microsoft Entra ID-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Microsoft Entra ID Data from Zoho Analytics and import live Microsoft Entra ID.
-
How to Access Optimizely Data Using Entity Framework
This article shows how to access Optimizely using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automated Continuous OData Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable OData replication to Google Cloud SQL.
-
Enable the Airtable JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Airtable.
-
Create Dashboards and Visualize Live MongoDB Data in Geckoboard
Use CData Connect AI to connect to live MongoDB and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Build Gmail-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Gmail and build Gmail-connected web apps with Axios.
-
Build Oracle Financials Cloud-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Oracle Financials Cloud Data from Zoho Analytics and import live Oracle Financials Cloud.
-
Use ChatGPT to Talk to Your Google Spanner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Google Spanner for you.
-
How to connect to Google Calendar Data from IntelliJ
Integrate connectivity to Google Calendar with wizards in IntelliJ.
-
Connect to Teradata Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Teradata.
-
Automate WordPress Data Replication to SAP HANA
Use CData Sync to customize and automate WordPress replication to SAP HANA.
-
Integrate Blackbaud FE NXT Data in the Pentaho Report Designer
Publish reports based on Blackbaud FE NXT in the Pentaho BI tool.
-
Connect to Discourse Data in Jaspersoft Studio
Execute SQL to remote Discourse in Jaspersoft Studio.
-
Create a Data Access Object for Brex Data using JDBI
A brief overview of creating a SQL Object API for Brex in JDBI.
-
Use Agno to Talk to Your Basecamp 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 Basecamp for you.
-
Access Live Freshteam Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Freshteam in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
LINQ to Harvest 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 Harvest Data Provider.
-
How to Query Live Coda Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Coda data in natural language using Python.
-
Connecting GenSpark with Salesforce CRM Analytics Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Salesforce CRM Analytics without any replication or custom integration required.
-
Connect Browserless to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Browserless with IBM WebSphere for seamless data integration and connectivity.
-
Integrate ScrapingBee Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live ScrapingBee from Informatica Cloud.
-
Connect to Greenhouse Data in Claris FileMaker Pro
Use the CData ODBC Driver for Greenhouse in FileMaker Pro to connect to Greenhouse and work with Greenhouse in your FileMaker applications.
-
Back Up IBM Cloud Object Storage to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for IBM Cloud Object Storage. In this article, we will employ an SSIS workflow to populate a database with IBM Cloud Object Storage data.
-
Build Voice Agents in ElevenLabs with access to Live Google Ad Manager Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Google Ad Manager.
-
Build Twitter Ads Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Twitter Ads and build visualizations in Tableau Cloud.
-
Build a Singer.io Tap for Discord With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Discord data using
-
Use Databricks Agent Bricks to Talk to Your SAP SuccessFactors LMS Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your SAP SuccessFactors LMS for you.
-
Integrate Live Amazon Marketplace Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Amazon Marketplace from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Amazon Marketplace.
-
How to Easily Query Grafana Data in OpenOffice Base
Connect to Grafana data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to connect and process MySQL from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live MySQL.
-
Edit and Search External WordPress Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of WordPress to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create WordPress Data objects that you can access from apps and the dashboard.
-
Connecting Moonlit Workflow with Lakebase 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 Lakebase in real time.
-
Create Data Visualizations in Cognos BI with ZohoInvoice Data
Access ZohoInvoice as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrate with Adobe Experience Manager Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Adobe Experience Manager to a JSON file on disk.
-
Getting Started with the CData ADO.NET Provider for Yelp
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connect to SAP Ariba Procurement Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live SAP Ariba Procurement.
-
Edit and Search IBM Informix External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of IBM Informix to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create IBM Informix objects that you can access from apps and the dashboard.
-
Automate SAP HANA XS Advanced Data Replication to SAP HANA
Use CData Sync to customize and automate SAP HANA XS Advanced replication to SAP HANA.
-
Automated Continuous Act CRM Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Act CRM replication to Apache Kafka.
-
Build Automated Workflows with Live MarkLogic Data in Workato
Use CData Connect AI to connect to live MarkLogic and build automated workflows in Workato.
-
Automated Continuous Microsoft Entra ID Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Microsoft Entra ID replication to Google Cloud SQL.
-
Getting Started with the CData ADO.NET Provider for Mailjet
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Publish LinkedIn Ads-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live LinkedIn Ads.
-
Visualize Live Hugging Face Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Hugging Face using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to create Pinterest federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Pinterest in MySQL .
-
Natively Connect to Azure Data Catalog Data in PHP
The CData ODBC driver for Azure Data Catalog enables you to create PHP applications with connectivity to Azure Data Catalog. Leverage the native support for ODBC in PHP.
-
Visualize Live Microsoft Exchange Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Microsoft Exchange using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous PagerDuty Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable PagerDuty replication to PostgreSQL.
-
Automated Continuous CSV Replication to Snowflake
Use CData Sync for automated, continuous, customizable CSV replication to Snowflake.
-
Perform Batch Operations with SAP HANA Data in Apache NiFi
Connect to SAP HANA and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Automated Continuous Chargebee Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Chargebee replication to PostgreSQL.
-
Connect to PivotalTracker Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to Create Power BI Visual Reports with Real-Time Omnisend Data
Use CData Power BI Connectors to visualize Omnisend in Power BI.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live FreshBooks within intelligent workflows.
-
Import Real-Time Google Drive Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Google Drive in ColdFusion.
-
Creating SAP Fieldglass-Connected Applications in Unqork
You can use CData Connect AI to feed SAP Fieldglass to Unqork and build custom business apps.
-
Visualize Live Mistral AI Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Mistral AI using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to and Visualize Live Pipeliner CRM Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Pipeliner CRM.
-
Query Contentful Data as a MySQL Database in Node.js
Execute MySQL queries against Contentful from Node.js.
-
Deploy the ADO.NET Provider for Workday on an SSRS Report Server
Connect to Workday from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Automated Continuous Bannerbear Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Bannerbear replication to Google Cloud SQL.
-
Automate Act-On Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Act-On from PowerShell? This article demonstrates how to utilize the Act-On Cmdlets for tasks like connecting to Act-On, automating operations, downloading data, and more.
-
Publish Crystal Reports on Contentful Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Contentful.
-
How to Build an ETL App for Airtable Data in Python with CData Connect AI
Build ETL pipelines that read and write live Airtable in Python with petl and the CData Connect AI Python SDK.
-
How to publish and share BambooHR Data dashboards with Tableau Server
The CData ODBC driver for BambooHR enables you integrate BambooHR into Tableau dashboards.
-
How to use SQLAlchemy ORM to access SAP Netweaver Gateway Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SAP Netweaver Gateway.
-
Connecting Pipedream with Jira 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 Jira data in real time.
-
Connecting Moonlit Workflow with Workday 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 Workday in real time.
-
Use Biml to Build SSIS Tasks to Replicate Google Tasks Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Google Tasks to SQL Server.
-
Integrate with Amazon Athena Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Amazon Athena to a JSON file on disk.
-
Connect to Amazon Athena Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Amazon Athena.
-
Connect to Templated Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Templated and the SQL Gateway to access Templated from Google Apps Script.
-
Build a Singer.io Tap for Certinia With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Certinia data using
-
Connect to Real-Time Toggl Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Toggl in Power Apps.
-
Supabase Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Supabase facts in real time.
-
Publish Superchat-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Superchat.
-
Connect to Toggl Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Toggl in the Denodo Virtual DataPort Administrator.
-
Build Salesforce Pardot-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Salesforce Pardot and build Salesforce Pardot-connected web apps with Axios.
-
Integrating Codex CLI with Notion 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 CockroachDB Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for CockroachDB in the Denodo Virtual DataPort Administrator.
-
Import Real-Time NetSuite Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use NetSuite CRM & ERP in ColdFusion.
-
Automated Continuous Printful Replication to Databricks
Use CData Sync for automated, continuous, customizable Printful replication to Databricks.
-
How to publish and share Monday.com Data dashboards with Tableau Server
The CData ODBC driver for Monday.com enables you integrate Monday.com into Tableau dashboards.
-
Automate Epicor Kinetic Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Epicor Kinetic from PowerShell? This article demonstrates how to utilize the Epicor Kinetic Cmdlets for tasks like connecting to Epicor Kinetic, automating operations, downloading data, and more.
-
Create Apps from Zoho Inventory Data in Qlik Sense Cloud
Use CData Connect AI to connect to Zoho Inventory Data and build apps from live Zoho Inventory in Qlik Sense Cloud.
-
Load Square Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Square to a database.
-
Create Salesforce-Connected Business Apps in AppSheet
Connect to Salesforce Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Salesforce & Force.com.
-
Build Dashboards with Sendwithus Data in DBxtra
Create dynamic dashboards and perform analytics based on Sendwithus in DBxtra.
-
Integrate with live Sage Cloud Accounting Data in Jitterbit
Use CData Connect AI to connect to and integrate live Sage Business Cloud Accounting in Jitterbit.
-
Visualize SendInBlue Data in TIBCO Spotfire through ADO.NET
Integrate SendInBlue into dashboards in TIBCO Spotfire.
-
Integrating LangGraph with Oracle SCM Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Oracle SCM within automated workflows.
-
How to Work with OData Services in ETL Validator JDBC
Connect to OData from ETL Validator jobs using the CData Software JDBC Driver.
-
Use the CData Software ODBC Driver for CampaignMonitor in MicroStrategy
Connect to CampaignMonitor in MicroStrategy Developer using the CData Software ODBC Driver for CampaignMonitor.
-
Integrating Cursor CLI with RabbitMQ 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 Build an ETL App for ConstantContact Data in Python with CData
Create ETL applications and real-time data pipelines for ConstantContact in Python with petl.
-
Connect to Typeform from Asprova with CData Software ODBC Driver for Typeform
This article shows how to connect faster to Typeform data from Asprova.