CData Software - Knowledge Base
Recent Articles
-
How to Access Greenhouse Data Using Entity Framework
This article shows how to access Greenhouse using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrating Antigravity CLI with Drip via CData CLI
Connect Drip to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrate with SAP HANA Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SAP HANA to a JSON file on disk.
-
Create Datasets from SAP Ariba Source in Domo Workbench and Build Visualizations of SAP Ariba Source Data in Domo
Use the CData Software ODBC Driver for SAP Ariba Source to create datasets from SAP Ariba Source in Domo Workbench and then build visualizations in the Domo service.
-
Automate Spark Data Replication to Couchbase
Use CData Sync to Customize and automate Apache Spark SQL replication to Couchbase.
-
Use the CData ODBC Driver for Sybase IQ from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Sybase IQ to connect to Sybase IQ from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Sybase IQ in Excel.
-
Access QuickBooks Time Data from MySQL in Amazon QuickSight
Connect to QuickBooks Time and build visualizations of QuickBooks Time using a MySQL Connection in Amazon QuickSight.
-
Connect to Amazon Athena Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Amazon Athena as an External Source in Dremio.
-
Connect to Guru Data in CloverDX (formerly CloverETL)
Transfer Guru using the visual workflow in the CloverDX data integration tool.
-
DataBind Controls to AdRoll Data in C++Builder
DataBind to AdRoll in C++Builder with standard components and controls.
-
Query Spotify Data as a MySQL Database in Node.js
Execute MySQL queries against Spotify from Node.js.
-
How to integrate Metabase with Google Campaign Manager 360 Data
Use CData Connect AI to connect to live Google Campaign Manager 360 and create an interactive dashboard in Metabase from Google Campaign Manager 360.
-
Access Live Trello Data in TIBCO Data Virtualization
Use the Trello Tibco DV Adapter to create a Trello data source in TIBCO Data Virtualization Studio and gain access to live Trello from your TDV Server.
-
Replicate Multiple FreeAgent Accounts via the CData Sync CLI
Replicate multiple FreeAgent accounts to one or many databases.
-
Integrate with Egnyte Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Egnyte to a JSON file on disk.
-
Connect to JSON Services from Crystal Reports
Use CData Connect AI to connect to and report on live JSON from Crystal Reports.
-
How to create Amazon Athena federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Amazon Athena in MySQL .
-
Build an OLAP Cube in SSAS from Snowflake Data
Establish a connection to Snowflake data from SQL Server Analysis Services, and use the Snowflake Data Provider to build OLAP cubes for use in analytics and reporting.
-
Use the CData ODBC Driver for Aircall in Microsoft Power Query
You can use the CData Aircall ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Aircall into Microsoft Power Query.
-
Build Pipelines with Live SAS xpt Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to SAS xpt from Google Cloud Data Fusion, enabling the integration of live SAS XPORT into the building and management of effective data pipelines.
-
Deploy the ADO.NET Provider for Sugar CRM on an SSRS Report Server
Connect to Sugar CRM 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.
-
Configure the CData JDBC Driver for SendGrid in a Connection Pool in Tomcat
Connect to SendGrid from a connection pool in Tomcat.
-
Automate SuiteCRM Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SuiteCRM from PowerShell? This article demonstrates how to utilize the SuiteCRM Cmdlets for tasks like connecting to SuiteCRM, automating operations, downloading data, and more.
-
Working with Printful Data in LINQPad
Execute LINQ queries to Printful in LINQPad.
-
How to Query Live Smartsheet Data in Perplexity MacOS Desktop
Connect to and query live Smartsheet Data in Perplexity Desktop using CData MCP Server.
-
Automated Continuous Sybase Replication to MongoDB
Use CData Sync for automated, continuous, customizable Sybase replication to MongoDB.
-
How to integrate Metabase with Salesforce Pardot Data
Use CData Connect AI to connect to live Salesforce Pardot and create an interactive dashboard in Metabase from Salesforce Pardot.
-
Publish Mode-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Mode.
-
Connect to Pingdom Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Pingdom and the SQL Gateway to access Pingdom from Google Apps Script.
-
Import Bullhorn CRM Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Bullhorn CRM. In this article, you will use the OData format to import Bullhorn CRM into Microsoft Power Query.
-
Integrating Antigravity CLI with Twilio via CData CLI
Connect Twilio to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to Easily Query Todoist Data in OpenOffice Base
Connect to Todoist data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Connect to Bullhorn CRM Data in Google Apps Script via Connect AI
Use CData Connect AI to access Bullhorn CRM in Google Apps Script.
-
Back Up Stack Exchange to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Stack Exchange data.
-
How to Connect the Power BI Service to Postmark: Complete Guide
Connect to the CData Software Power BI Connector for Postmark from PowerBI.com to provide real-time Postmark across the organization.
-
LINQ to Aweber 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 Aweber Data Provider.
-
How to connect to Greenplum Data in DBVisualizer
Integrate Pivotal GreenPlum with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Gumroad Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Gumroad and work with Gumroad in your FileMaker applications.
-
Moving Data from Customer.io to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Customer.io data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to connect to Microsoft OneDrive Data with Squirrel SQL client
Connect to Microsoft OneDrive and execute queries in the Squirrel SQL Client.
-
Write a Simple Go Application to work with Printify Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Printify.
-
How to use SQLAlchemy ORM to access Bullhorn CRM Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Bullhorn CRM.
-
How to Easily Query Jira Data in OpenOffice Base
Connect to Jira data in OpenOffice Base using the CData ODBC Driver for Jira and generate reports with live data insights.
-
Create Microsoft Exchange-Connected Dashboards in Grafana
Connect to Microsoft Exchange Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Microsoft Exchange.
-
How to connect to Zoho Creator Data from IntelliJ
Integrate connectivity to Zoho Creator with wizards in IntelliJ.
-
Build SuiteCRM-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for SuiteCRM to explore live SuiteCRM Data in Gemini Code Assist to assist with building SuiteCRM-powered applications.
-
Build Dashboards with MariaDB Data in DBxtra
Create dynamic dashboards and perform analytics based on MariaDB in DBxtra.
-
Connect to IBM Informix Data in DBeaver
Use the CData ODBC Driver to connect to IBM Informix in DBeaver.
-
Connect to Amplitude from a Connection Pool in WebLogic
Use the CData JDBC Driver for Amplitude to connect to Amplitude from Web applications running on WebLogic.
-
Connect Microsoft Teams Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Microsoft Teams using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Connect to Live SAP SuccessFactors LMS 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 SAP SuccessFactors LMS through natural language.
-
Connect to and Query Campaigner Data in QlikView over ODBC
Create data visualizations with Campaigner in QlikView.
-
Automated Procore Data Replication to Teradata
Use CData Sync to Customize and automate Procore replication to Teradata.
-
Connect to Wrike Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Wrike in the Denodo Virtual DataPort Administrator.
-
A PostgreSQL Interface for Stripe Data using the CData ODBC Driver
Use the SQL Gateway and Stripe ODBC Driver to create a PostgreSQL entry-point for data access.
-
Feed Instagram Data into FineReport
How to set Instagram as a JDBC data source in FineReport.
-
How to Create Power BI Visual Reports with Real-Time Google Translate Data
Use CData Power BI Connectors to visualize Google Translate in Power BI.
-
Integrate with Live Zoho Projects Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Zoho Projects from the MuleSoft Anypoint Platform to integrate live Zoho Projects into custom reports and dashboards.
-
Connect to MySQL Data as an External Source in Dremio
Use the CData JDBC Driver to connect to MySQL as an External Source in Dremio.
-
Automated Continuous WordPress Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable WordPress replication to Amazon Redshift.
-
DataBind Charts to Drift Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Drift 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.
-
Integrating LangGraph with Office 365 Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Microsoft Office 365 within automated workflows.
-
Seamlessly Bring SurveyMonkey Data into Retool Using CData Connect AI
Integrate SurveyMonkey data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connect to SingleStore Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live SingleStore from Filemaker Pro on Mac.
-
Use JayDeBeApi to access FTP Data in Python
Use standard Python scripting and the development environment of your choice to access live FTP Servers.
-
How to connect to Bannerbear Data from Spring Boot
Connect to Bannerbear in a Spring Boot Application using the CData API Driver for JDBC
-
How to connect PolyBase to Copper
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Copper.
-
Build MVC Applications with Connectivity to Deel Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Deel from an ASP.NET MVC application.
-
Integrating Claude Code CLI with Egnyte 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.
-
Visualize Live Printify Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Printify.
-
Connect to Dynamics 365 Business Central Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Dynamics 365 Business Central Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Use Agno to Talk to Your SAP Ariba Source 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 SAP Ariba Source for you.
-
Build a Simple VCL Application for Anaplan Data
How to build a simple VCL Application to view Anaplan in RAD Studio using the CData ODBC Driver for Anaplan.
-
Use the CData Software JDBC Driver for Trello in MicroStrategy Desktop
Connect to Trello in MicroStrategy Desktop using the CData Software JDBC Driver for Trello.
-
Automated Continuous Klipfolio Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Klipfolio replication to Azure SQL Database.
-
Integrating Kiro CLI with Rebilly 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.
-
Automated Continuous Phoenix Replication to MongoDB
Use CData Sync for automated, continuous, customizable Phoenix replication to MongoDB.
-
How to Work with SAP SuccessFactors Data in AWS Glue Jobs Using JDBC
Connect to SAP SuccessFactors from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous Cosmos DB Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Cosmos DB replication to Amazon Redshift.
-
Getting Started with the CData JDBC Driver for VWO
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for VWO.
-
Integrate Open WebUI with Live Greenplum Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Pivotal GreenPlum from within the chat interface.
-
Integrate DB2 Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live IBM DB2 from Informatica Cloud.
-
Automated Continuous Grafana Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Grafana replication to delimited files (CSV/TSV).
-
Model WooCommerce Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and WooCommerce, enabling the direct import of real-time WooCommerce.
-
Build Dashboards with Flowlu Data in Dundas BI
Create dynamic dashboards and perform analytics based on Flowlu in Dundas BI.
-
Create Informatica Mappings From/To an ODBC Data Source for PivotalTracker
Create an ODBC connection to PivotalTracker in Informatica and browse and transfer PivotalTracker.
-
Perform Batch Operations with Microsoft Entra ID Data in Apache NiFi
Connect to Microsoft Entra ID and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Use the CData Software JDBC Driver for Landbot in MicroStrategy
Connect to Landbot in MicroStrategy Developer using the CData Software JDBC Driver for Landbot.
-
Add ScrapingBee Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for ScrapingBee with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate Open WebUI with Live Smartsheet Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Smartsheet from within the chat interface.
-
A PostgreSQL Interface for Authorize.Net Data using the CData ODBC Driver
Use the SQL Gateway and Authorize.Net ODBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze Sybase Data in Looker
Use CData Connect AI to connect to Sybase Data from Looker and build custom apps using live Sybase.
-
Use Manus AI to Talk to Your Apollo 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 Apollo.
-
Choosing the Best Method to Connect Reckon Accounts Hosted to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Reckon Accounts Hosted from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Create Marketo-Connected Nintex Workflows
Use CData Connect AI to connect to Marketo Data from Nintex Workflow Cloud and build custom workflows using live Marketo.
-
Visualize Live Zendesk Data in the Power BI Service
Use CData Connect AI to connect to live Zendesk and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Getting Started with the CData Power BI Connector for Zuora
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Zuora.
-
Build Email-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Email to explore live Email Data in Claude Code to assist with building Email-powered applications.
-
Connect to Microsoft Exchange from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Microsoft Exchange, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to Amazon Athena Data in CloverDX (formerly CloverETL)
Transfer Amazon Athena using the visual workflow in the CloverDX data integration tool.