CData Software - Knowledge Base
Recent Articles
-
Create Azure DevOps Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Azure DevOps from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build Sage Intacct-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Sage Intacct data and build web apps with connectivity to live Sage Intacct data.
-
Connect to Live Dynamics 365 Business Central Data in MicroStrategy through CData Connect AI
Create a live connection to Dynamics 365 Business Central Data in CData Connect AI and connect to your Dynamics 365 Business Central data from MicroStrategy.
-
Build a PostgreSQL Interface for Twitter Ads Data using the CData JDBC Driver
Use the Remoting features of the Twitter Ads JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Data Flows from Tally to SQL Server using SSIS
Easily back up Tally data to SQL Server using the SSIS components for Tally.
-
Build AI Agents with WooCommerce Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live WooCommerce data through CData Connect AI.
-
Build Semantic Layer Views for Twitter Ads Data in APOS Live Data Gateway
Use the CData Connector for Twitter Ads in APOS Live Data Gateway to build Semantic Layer Views for Twitter Ads data.
-
Integrate HubSpot Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live HubSpot data from Informatica Cloud.
-
Automated Continuous Jumpseller Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Jumpseller replication to delimited files (CSV/TSV).
-
Integrating Codex with Facebook 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 Zoho Books Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Zoho Books data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Work with Google Search Results in FoxPro
Load Google Search results into a FoxPro database. This article includes full code and a walk-through of the process.
-
Query Live Sage 200 Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Sage 200 data directly from the development environment.
-
Publish Google Analytics-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Google Analytics data.
-
Automate Dotmailer Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Dotmailer data from PowerShell? This article demonstrates how to utilize the Dotmailer Cmdlets for tasks like connecting to Dotmailer data, automating operations, downloading data, and more.
-
Connect to and Query Databricks Data in QlikView over ODBC
Create data visualizations with Databricks data in QlikView.
-
Create Reports with Everhour Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Everhour data.
-
Provide OData Services of SharePoint Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SharePoint data by developing a WCF Service Application.
-
Build a Simple VCL Application for Perplexity Data
How to build a simple VCL Application to view Perplexity data in RAD Studio using the CData ODBC Driver for Perplexity.
-
Access Live Clockify Data in AWS Lambda
Connect to live Clockify data in AWS Lambda using the CData JDBC Driver.
-
Access Tavily Data from MySQL in Amazon QuickSight
Connect to Tavily and build visualizations of Tavily data using a MySQL Connection in Amazon QuickSight.
-
Integrate Adobe Commerce Data in Pentaho Data Integration
Build ETL pipelines based on Adobe Commerce data in the Pentaho Data Integration tool.
-
Easily Integrate Tanda Data in Lazarus Pascal IDE
Learn how to easily integrate live Tanda data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build Dashboards with Oracle Eloqua Reporting Data in DBxtra
Create dynamic dashboards and perform analytics based on Oracle Eloqua Reporting data in DBxtra.
-
LINQ to Instantly 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 Instantly Data Provider.
-
Create Reports from BigQuery Data in Looker Studio
Use CData Connect AI to gain access to live BigQuery data and create custom reports in Looker Studio.
-
Integrate Open WebUI with Live Yelp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Yelp data from within the chat interface.
-
Write a Simple Go Application to work with LDAP Objects on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to LDAP objects.
-
Build AI Agents with Vertica Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Vertica data through CData Connect AI.
-
Integrating Cursor with Vault CRM 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.
-
Creating Twitter Ads-Connected Applications in Unqork
You can use CData Connect AI to feed Twitter Ads data to Unqork and build custom business apps.
-
Replicate Multiple Vercel Accounts
Replicate multiple Vercel accounts to one or many databases.
-
DataBind Instagram Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Instagram with the DevExpress Windows Forms and Web controls to provide Instagram data to a chart.
-
Automate SAP Business One Data Replication to Azure Data Lake
Use CData Sync to customize and automate SAP Business One data replication to Azure Data Lake.
-
How to Use a Microsoft Access Database to Update Google Directory Data in Real Time
Update Google Directory data by creating a linked table in Microsoft Access with the CData Google Directory ODBC Driver.
-
How to Connect to Live Oracle HCM Cloud Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Oracle HCM Cloud data through natural language.
-
How to Connect DBeaver to SAP HANA XS Advanced via a JDBC Driver
Manage SAP HANA XS Advanced data with visual tools in DBeaver like the query browser.
-
Query Oracle Eloqua Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Oracle Eloqua entities in PHP by modeling them as objects.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Microsoft Ads
Provide connectivity to Microsoft Ads data through an SAP BusinessObjects universe.
-
Use Agno to Talk to Your ADP 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 ADP data for you.
-
Visualize Perigon Data in Tableau
The CData ODBC driver for Perigon enables you integrate Perigon data into Tableau dashboards.
-
Create Datasets from Azure Table in Domo Workbench and Build Visualizations of Azure Table Data in Domo
Use the CData Software ODBC Driver for Azure Table to create datasets from Azure Table data in Domo Workbench and then build visualizations in the Domo service.
-
Access Live SageHR Data in AWS Lambda
Connect to live SageHR data in AWS Lambda using the CData JDBC Driver.
-
Connect to Recurly Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Recurly and work with Recurly data in your FileMaker application.
-
How to publish and share Gorgias Data dashboards with Tableau Server
The CData ODBC driver for Gorgias enables you integrate Gorgias data into Tableau dashboards.
-
Connect to ConvertKit Data as an External Source in Dremio
Use the CData JDBC Driver to connect to ConvertKit as an External Source in Dremio.
-
Automated Continuous Mailgun Replication to SQLite
Use CData Sync for automated, continuous, customizable Mailgun replication to SQLite.
-
Automated Continuous Sendwithus Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Sendwithus replication to delimited files (CSV/TSV).
-
Use Agno to Talk to Your SharePoint 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 SharePoint data for you.
-
Integrate Open WebUI with Live ServiceNow Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live ServiceNow data from within the chat interface.
-
Connect to Clockify Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Clockify data in the Denodo Virtual DataPort Administrator.
-
Connect to Bright Data Data in CloverDX (formerly CloverETL)
Transfer Bright Data data using the visual workflow in the CloverDX data integration tool.
-
How to Work with ClickTime Data in AWS Glue Jobs Using JDBC
Connect to ClickTime from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Access ZarMoney Data from MySQL in Amazon QuickSight
Connect to ZarMoney and build visualizations of ZarMoney data using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous Avaza Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Avaza replication to Google BigQuery.
-
A PostgreSQL Interface for Parquet Data (MySQL Remoting via JDBC)
Use the Remoting features of the Parquet JDBC Driver to create a PostgreSQL entry-point for data access.
-
Add Raisers Edge NXT Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Raisers Edge NXT with the Informatica Enterprise Data Catalog to classify and organize data.
-
Build an OLAP Cube in SSAS from Jodoo Data
Establish a connection to Jodoo data data from SQL Server Analysis Services, and use the Jodoo Data Provider to build OLAP cubes for use in analytics and reporting.
-
Validate Datadog Data with QuerySurge
Access and validate Datadog data in QuerySurge using the CData JDBC Driver.
-
How to connect to Dynamics NAV Data from Spring Boot
Connect to Dynamics NAV in a Spring Boot Application using the CData JDBC Driver for Dynamics NAV
-
Publish Reports with SpaceX Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SpaceX data.
-
View Reports on Real-Time SQL Server Data in Power BI Report Server
Use the CData ODBC Driver for SQL Server to visualize SQL Server data in Power BI Desktop and then publish them to Power BI Report Server.
-
Create Datasets from Shortcut in Domo Workbench and Build Visualizations of Shortcut Data in Domo
Use the CData Software ODBC Driver for Shortcut to create datasets from Shortcut data in Domo Workbench and then build visualizations in the Domo service.
-
Use JayDeBeApi to access Google Drive Data in Python
Use standard Python scripting and the development environment of your choice to access live Google Drive data.
-
Provide OData Services of Placid Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Placid data by developing a WCF Service Application.
-
Access Live Redis Data in TIBCO Data Virtualization
Use the Redis Tibco DV Adapter to create a Redis data data source in TIBCO Data Virtualization Studio and gain access to live Redis data from your TDV Server.
-
Configure the CData JDBC Driver for Exact Online in a Connection Pool in Tomcat
Connect to Exact Online data from a connection pool in Tomcat.
-
Build AI Agents with Azure Data Catalog Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Azure Data Catalog data through CData Connect AI.
-
Write a Simple Go Application to work with Browserless Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Browserless data.
-
Connect to Klipfolio Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Klipfolio data in Airbyte.
-
Connect Workable to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Workable with IBM WebSphere for seamless data integration and connectivity.
-
Create Datasets from Parquet in Domo Workbench and Build Visualizations of Parquet Data in Domo
Use the CData Software ODBC Driver for Parquet to create datasets from Parquet data in Domo Workbench and then build visualizations in the Domo service.
-
Write a Simple Go Application to work with Sage Intacct Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Sage Intacct data.
-
Object-Relational Mapping (ORM) with Float Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Float data into a Java-based ORM framework, Hibernate.
-
How to Connect to Live Google Sheets Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Google Sheets data through natural language.
-
Migrating data from NetSuite to Databricks using CData SSIS Components.
Easily push NetSuite data to Databricks using the CData SSIS Tasks for NetSuite and Databricks.
-
Build Apps with Live SurveyMonkey Data Using the Low-Code Development Platform of Mendix
Connect SurveyMonkey data with Mendix to build apps using the CData JDBC Driver for SurveyMonkey.
-
How to Build an ETL App for Amazon S3 Data in Python with CData
Create ETL applications and real-time data pipelines for Amazon S3 data in Python with petl.
-
Build AI/ML Models with Live Oracle SCM Data using Dataiku
Connect Oracle SCM Data with Dataiku using the CData JDBC Driver for Oracle SCM.
-
Design BIRT Reports on Anaplan Data
Provide current Anaplan data to your embedded analytics.
-
A PostgreSQL Interface for Amazon DynamoDB Data using the CData ODBC Driver
Use the SQL Gateway and Amazon DynamoDB ODBC Driver to create a PostgreSQL entry-point for data access.
-
Migrating data from RSS to Snowflake using CData SSIS Components.
Easily push RSS feeds to Snowflake using the CData SSIS Tasks for RSS and Snowflake.
-
Visualize Live Workday Data in the Power BI Service
Use CData Connect AI to connect to live Workday data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Bind Live Google Contacts Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Google Contacts data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Connect to iContact Data from Crystal Reports
Use CData Connect AI to connect to and report on live iContact data from Crystal Reports.
-
How to create iContact federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for iContact data in MySQL .
-
Import Certinia Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Certinia Data and provide access to live Certinia data for custom reports in the Power BI Service.
-
Import Real-Time Highrise Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Highrise data in ColdFusion.
-
Automated Continuous Jira Assets Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Jira Assets replication to Azure SQL Database.
-
Integrating LangGraph with GraphQL Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on GraphQL data within automated workflows.
-
Replicate Instantly Data in Heroku for Use in Salesforce Connect
Replicate Instantly data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build Agents in Relevance AI with Access to Live Wave Financial Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Wave Financial data within intelligent agent workflows.
-
Back Up Cvent data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Cvent. In this article, we will employ an SSIS workflow to populate a database with Cvent data data.
-
Getting Started with the CData Tableau Connector for Customer.io
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Create Informatica Mappings From/To an ODBC Data Source for SQL Server
Create an ODBC connection to SQL Server in Informatica and browse and transfer SQL Server data.
-
Getting Started with the CData Python Connector for REST
Learn to install and license the CData Python Connector and configure a connection to live REST data.
-
Create Facebook Ads-Connected Applications in Appsmith
Connect to Facebook Ads Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Facebook Ads data.
-
How to Access Live Onfleet Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Onfleet enables you to integrate Onfleet data into workflows built using Microsoft Power Automate Desktop.
-
Use the CData ODBC Driver for Parquet in Microsoft Power Query
You can use the CData Parquet ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Parquet data into Microsoft Power Query.
-
Automated Continuous Intercom Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Intercom replication to Amazon Redshift.