CData Software - Knowledge Base
Recent Articles
-
Connect to Freshteam 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 Freshteam and work with Freshteam data in your FileMaker application.
-
Design BIRT Reports on Exact Online Data
Provide current Exact Online data to your embedded analytics.
-
Build ClickUp-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live ClickUp data without replication.
-
Integrate with Amazon S3 Data in JReport Designer
Create charts and reports based on Amazon S3 data in JReport Designer.
-
Use Agno to Talk to Your Figshare 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 Figshare data for you.
-
Integrating Gumloop with Dynamics CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Dynamics CRM data within automated workflows.
-
Integrating Outlook Data in Talend Cloud Data Management Platform
Connect Outlook Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Use the CData Software ODBC Driver for Stripe in MicroStrategy Web
Connect to Stripe data in MicroStrategy Web using the CData Software ODBC Driver for Stripe.
-
Choosing the Best Method to Connect Dotmailer to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Dotmailer data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Continuous Klaviyo Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Klaviyo replication to AlloyDB.
-
Natively Connect to Coinbase Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Coinbase data. Leverage the native support for ODBC in PHP.
-
Validate Short.io Data with QuerySurge
Access and validate Short.io data in QuerySurge using the CData JDBC Driver.
-
Replicate SAP ByDesign Data to Multiple Databases
Replicate SAP ByDesign data to disparate databases with a point-and-click configuration.
-
Prepare, Blend, and Analyze Perigon Data in Alteryx Designer (ODBC)
Build workflows to access live Perigon data for self-service data analytics.
-
LINQ to ZendeskSell 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 ZendeskSell Data Provider.
-
Create Apps from Azure Data Catalog Data in Qlik Sense Cloud
Use CData Connect AI to connect to Azure Data Catalog Data and build apps from live Azure Data Catalog data in Qlik Sense Cloud.
-
A PostgreSQL Interface for Insightly Data (MySQL Remoting via JDBC)
Use the Remoting features of the Insightly JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Elasticsearch-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Elasticsearch data and build web apps with connectivity to live Elasticsearch data.
-
Automated Continuous AdRoll Replication to Oracle
Use CData Sync for automated, continuous, customizable AdRoll replication to Oracle.
-
Model, Search, and Visualize Live Samanage Data in ThoughtSpot
Use CData Connect AI to connect to live Samanage data for modeling, searching, and visualizing.
-
Migrating data from Attio to Google BigQuery using CData SSIS Components.
Easily push Attio data to Google BigQuery using the CData SSIS Tasks for Attio and Google BigQuery.
-
Natively Connect to Deel Data in PHP
The CData ODBC driver for Deel enables you to create PHP applications with connectivity to Deel data. Leverage the native support for ODBC in PHP.
-
How to Easily Query Smartsheet Data in OpenOffice Base
Connect to Smartsheet data in OpenOffice Base using the CData ODBC Driver for Smartsheet and generate reports with live data insights.
-
How to import YouTube Analytics Data into Apache Solr
Use the CData Software JDBC Driver for YouTube Analytics in Data Import Handler and create an automated import of YouTube Analytics data to Apache Solr Enterprise Search platform.
-
How to Connect the Power BI Service to Amazon Athena: Complete Guide
Connect to the CData Software Power BI Connector for Amazon Athena from PowerBI.com to provide real-time Amazon Athena data across the organization.
-
Use Databricks Agent Bricks to Talk to Your Twitter Ads Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Twitter Ads data for you.
-
Access Live Spotify Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Spotify data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Access Live Office 365 Data in Coginiti Pro
Connect to and query live Office 365 data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Provide OData Services of IBM Informix Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for IBM Informix data by developing a WCF Service Application.
-
Connect to Gong Data in JRuby
Create a simple JRuby app with access to live Gong data.
-
Create YouTube Analytics Dataflows on PowerBI.com
Connect to the CData Power BI Connector for YouTube Analytics from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Visualize Outreach.io Data in Python with pandas
Use pandas and other modules to analyze and visualize live Outreach.io data in Python.
-
Connecting GenSpark with CouchDB Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to CouchDB data without any replication or custom integration required.
-
Analyze Workday Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Workday from Power Pivot. You will use the Table Import Wizard to load Workday data. You can visually build the import query or use any SQL supported by the driver.
-
Automated Continuous Demio Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Demio replication to Apache Kafka.
-
Connect to Moosend Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Moosend data in Airbyte.
-
Build Pipelines with Live AlloyDB Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to AlloyDB from Google Cloud Data Fusion, enabling the integration of live AlloyDB data into the building and management of effective data pipelines.
-
Use the CData ODBC Driver for Databricks in Microsoft Power Query
You can use the CData Databricks ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Databricks data into Microsoft Power Query.
-
How to Access Gong Data Using Entity Framework
This article shows how to access Gong data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to Connect Redshift 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 Redshift data in real time using natural language.
-
Connect to and Query Missive Data in QlikView over ODBC
Create data visualizations with Missive data in QlikView.
-
Create a Data Access Object for Databricks Data using JDBI
A brief overview of creating a SQL Object API for Databricks data in JDBI.
-
Build EnterpriseDB-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live EnterpriseDB data.
-
Integrate with Live Gong Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Gong from the MuleSoft Anypoint Platform to integrate live Gong data into custom reports and dashboards.
-
Use Dash to Build Web Apps on Apify Data via CData Connect AI
Build interactive Dash web apps on live Apify data using pandas and the CData Connect AI Python SDK.
-
Provide OData Services of SAP HANA Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SAP HANA data by developing a WCF Service Application.
-
Visualize Live NetSuite Data in the Power BI Service
Use CData Connect AI to connect to live NetSuite data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to connect to Facebook Data with Squirrel SQL client
Connect to Facebook data and execute queries in the Squirrel SQL Client.
-
Connect to Oracle HCM Cloud Data in NetBeans
Connect to Oracle HCM Cloud data in NetBeans with the data source configuration wizard.
-
View Reports on Real-Time CSV Data in Power BI Report Server
Use the CData ODBC Driver for CSV to visualize CSV data in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrating Codex with Microsoft Teams 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.
-
Build a PostgreSQL Interface for ShipStation Data using the CData JDBC Driver
Use the Remoting features of the ShipStation JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Cursor with Sendwithus 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.
-
Use Microsoft Copilot Studio to talk to your Stripe Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Stripe data for you.
-
Automated Continuous API Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable API replication to PostgreSQL.
-
Connect to Autopilot Data in JRuby
Create a simple JRuby app with access to live Autopilot data.
-
Integrate JobNimbus with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate JobNimbus with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to JobNimbus data.
-
Use the CData Software JDBC Driver for Guru in MicroStrategy
Connect to Guru data in MicroStrategy Developer using the CData Software JDBC Driver for Guru.
-
Create CockroachDB Dataflows on PowerBI.com
Connect to the CData Power BI Connector for CockroachDB from PowerBI.com to create Power BI Dataflows with real-time data.
-
Getting Started with the CData ADO.NET Provider for Codat
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Automated Continuous Access Replication to Databricks
Use CData Sync for automated, continuous, customizable Access replication to Databricks.
-
Getting Started with the CData Power BI Connector for Odoo
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Odoo.
-
Build an OLAP Cube in SSAS from Salesforce Marketing Data
Establish a connection to Salesforce Marketing data data from SQL Server Analysis Services, and use the Salesforce Marketing Data Provider to build OLAP cubes for use in analytics and reporting.
-
Query Live Oracle Service Cloud Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Oracle Service Cloud data through a conversational interface.
-
Create Reckon Accounts Hosted-Connected Nintex Workflows
Use CData Connect AI to connect to Reckon Accounts Hosted Data from Nintex Workflow Cloud and build custom workflows using live Reckon Accounts Hosted data.
-
Query EnterpriseDB Data as a SQL Server Database in Node.js
Execute SQL Server queries against EnterpriseDB data from Node.js.
-
How to use SQLAlchemy ORM to access Onfleet Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Onfleet data.
-
Integrating Cursor with Supabase 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.
-
Query Lakebase Data as a MySQL Database in Node.js
Execute MySQL queries against Lakebase data from Node.js.
-
Integrate Live ZohoPeople Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live ZohoPeople data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Integrate Dify with Live Reckon Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Reckon data.
-
Query Shopify Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Shopify entities in PHP by modeling them as objects.
-
Working with Campaigner Data in LINQPad
Execute LINQ queries to Campaigner data in LINQPad.
-
Build SAP Ariba Source-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for SAP Ariba Source Data and create custom apps in Mendix.
-
Connect to Tally Data in ACL Analytics
Connect to Tally data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Tally data.
-
Getting Started with the CData Tableau Connector for Paymo
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Guru
Provide connectivity to Guru data through an SAP BusinessObjects universe.
-
Access Live Snapchat Ads Data in Coginiti Pro
Connect to and query live Snapchat Ads data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Access Live Blackbaud FE NXT Data in TIBCO Data Virtualization
Use the Blackbaud FE NXT Tibco DV Adapter to create a Blackbaud FE NXT data data source in TIBCO Data Virtualization Studio and gain access to live Blackbaud FE NXT data from your TDV Server.
-
Integrate with Live WooCommerce Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to WooCommerce from the MuleSoft Anypoint Platform to integrate live WooCommerce data into custom reports and dashboards.
-
How to connect PolyBase to SAP SuccessFactors
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SAP SuccessFactors data.
-
Moving Data from Spotify to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Spotify data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
A PostgreSQL Interface for Bannerbear Data (MySQL Remoting via JDBC)
Use the Remoting features of the Bannerbear JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use JayDeBeApi to access BenchmarkEmail Data in Python
Use standard Python scripting and the development environment of your choice to access live BenchmarkEmail data.
-
Build AlloyDB-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live AlloyDB data without replication.
-
Use Manus AI to Talk to Your Snapchat Ads 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 Snapchat Ads data.
-
Create Power BI Reports on Real-Time Egnyte Data
Use the CData ODBC Driver for Egnyte to visualize Egnyte data in Power BI Desktop.
-
DataBind Charts to Google Cloud Storage Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Google Cloud Storage data 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.
-
Edit and Search External OneNote Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of OneNote data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create OneNote Data objects that you can access from apps and the dashboard.
-
Explore Geographical Relationships in HubDB Data with Power Map
Create data visualizations with HubDB data in Power Map.
-
Build Apify-Connected Apps in Choreo
Use CData Connect AI to connect to Apify Data from Choreo and build custom apps using live Apify data.
-
Connect Insightly to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Insightly with IBM WebSphere for seamless data integration and connectivity.
-
How to Build an ETL App for Webex Data in Python with CData
Create ETL applications and real-time data pipelines for Webex data in Python with petl.
-
Connect to Figshare Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Figshare data in the Denodo Virtual DataPort Administrator.
-
Integrating LangChain with FHIR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on FHIR data within automated workflows.
-
Connect to Apify Data in DBeaver
Use the CData ODBC Driver to connect to Apify data in DBeaver.
-
Integrate Devin with Live Klaviyo Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Klaviyo data.
-
How to Connect the Power BI Service to Exact Online: Complete Guide
Connect to the CData Software Power BI Connector for Exact Online from PowerBI.com to provide real-time Exact Online data across the organization.
-
Edit and Search External Sugar CRM Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Sugar CRM data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Sugar CRM Data objects that you can access from apps and the dashboard.
-
Automate Todoist Data Replication to Azure Data Lake
Use CData Sync to customize and automate Todoist data replication to Azure Data Lake.