CData Software - Knowledge Base
Recent Articles
-
Connect to Mistral AI Data in Jaspersoft Studio
Execute SQL to remote Mistral AI in Jaspersoft Studio.
-
Create Apps from SAS Data Sets Data in Qlik Sense Cloud
Use CData Connect AI to connect to SAS Data Sets Data and build apps from live SAS Data Sets in Qlik Sense Cloud.
-
How to Connect to Live PostgreSQL Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your PostgreSQL for you.
-
Getting Started with the CData Python Connector for Oracle Financials Cloud
Learn to install and license the CData Python Connector
-
Migrating data from Amazon S3 to Snowflake using CData SSIS Components.
Easily push Amazon S3 to Snowflake using the CData SSIS Tasks for Amazon S3 and Snowflake.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Lakebase actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Google Drive actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Automated Continuous Keap Replication to SQL Server
Use CData Sync for automated, continuous, customizable Keap replication to SQL Server.
-
DataBind Charts to Float Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Float 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.
-
Build Data Flows from Sage Cloud Accounting to SQL Server using SSIS
Easily back up Sage Business Cloud Accounting to SQL Server using the SSIS components for Sage Cloud Accounting.
-
Create Data Visualizations Based On Email Data in Mode
Use CData Connect AI to connect to Email Data from Mode and build visualizations using live
-
How to Use a Microsoft Access Database to Update Azure Table Data in Real Time
Update Azure Table data by creating a linked table in Microsoft Access with the CData Azure Table ODBC Driver.
-
Create SAP Ariba Procurement-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to SAP Ariba Procurement Data from OutSystems and build custom enterprise apps using live SAP Ariba Procurement.
-
Working with Kintone Data in LINQPad
Execute LINQ queries to Kintone in LINQPad.
-
Create CockroachDB-Connected Applications in Appsmith
Connect to CockroachDB Data via CData Connect AI in Appsmith and create custom business applications with real-time access to CockroachDB.
-
Getting Started with the CData Tableau Connector for FTP
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for FTP.
-
Integrating Codex CLI with FTP Servers 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 Controls to GitHub Data in Delphi
DataBind to GitHub in Delphi with standard data access components and controls.
-
Create Reports from LinkedIn Ads Data in Looker Studio
Use CData Connect AI to gain access to live LinkedIn Ads and create custom reports in Looker Studio.
-
How to Work with Zoho Inventory Data in ETL Validator JDBC
Connect to Zoho Inventory from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous PivotalTracker Replication to SingleStore
Use CData Sync for automated, continuous, customizable PivotalTracker replication to SingleStore.
-
Access Live Freshsales Data in AWS Lambda
Connect to live Freshsales in AWS Lambda using the CData JDBC Driver.
-
Add Eventbrite Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Eventbrite with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrating LangChain with Amazon Marketplace Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Amazon Marketplace within automated workflows.
-
Bidirectional Access to Landbot Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Landbot in Filemaker Pro for Mac or Windows.
-
Integrate Live Microsoft Planner Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Microsoft Planner and integrate live Microsoft Planner into apps built in Microsoft Power Apps.
-
Build LDAP-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live LDAP.
-
Use Grok to Talk to Your Microsoft Exchange Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Microsoft Exchange for you.
-
Integrating GitHub Copilot CLI with Figshare 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.
-
Import Google Ad Manager Data Using Azure Data Factory
Use CData Connect AI to connect to Google Ad Manager Data from Azure Data Factory and import live Google Ad Manager.
-
How to Import Data from PostgreSQL into Google Sheets
Import PostgreSQL into a Google spreadsheet that is automatically refreshed.
-
Use JayDeBeApi to access Bugsnag Data in Python
Use standard Python scripting and the development environment of your choice to access live Bugsnag.
-
Easily Integrate Perplexity Data in Lazarus Pascal IDE
Learn how to easily integrate live Perplexity in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Replicate Multiple SAP Concur Accounts via the CData Sync CLI
Replicate multiple SAP Concur accounts to one or many databases.
-
Integrating Salesloft Data in Talend Cloud Data Management Platform
Connect Salesloft Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Salesloft.
-
Replicate VWO Data from PowerShell
Write a quick PowerShell script to query VWO. Use connectivity to the live data to replicate VWO to SQL Server.
-
EnterpriseDB Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on EnterpriseDB facts in real time.
-
Build Amazon S3-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Amazon S3.
-
Automated Continuous Microsoft Entra ID Replication to MySQL
Use CData Sync for automated, continuous, customizable Microsoft Entra ID replication to MySQL.
-
Getting Started with the CData Tableau Connector for SAP
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for SAP.
-
Analyze Chargebee Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Chargebee from Power Pivot. You will use the Table Import Wizard to load Chargebee. You can visually build the import query or use any SQL supported by the driver.
-
Getting Started with the CData Excel Add-In for Drip
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Drip.
-
Build Office 365-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Office 365 Data and create custom apps in Mendix.
-
Visualize Raisers Edge NXT 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 Raisers Edge NXT into TIBCO Spotfire.
-
Connect to Amazon Athena from a Connection Pool in WebLogic
Use the CData JDBC Driver for Amazon Athena to connect to Amazon Athena from Web applications running on WebLogic.
-
Automated Continuous Bugsnag Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Bugsnag replication to Azure SQL Database.
-
Write a Simple Go Application to work with Harvest Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Harvest.
-
Access Sage Intacct Data from MySQL in Amazon QuickSight
Connect to Sage Intacct and build visualizations of Sage Intacct using a MySQL Connection in Amazon QuickSight.
-
Integrating GitHub Copilot CLI with Apache Phoenix 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.
-
Access MessageBird Data from MySQL in PHP
Connect to MessageBird through the standard MySQL libraries in PHP.
-
Load Rootly Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Rootly to a database.
-
Use the CData Software ODBC Driver for Recurly in MicroStrategy
Connect to Recurly in MicroStrategy Developer using the CData Software ODBC Driver for Recurly.
-
Integrating Kiro CLI with PayPal 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 ZohoSubscriptions Replication to Amazon S3
Use CData Sync for automated, continuous, customizable ZohoSubscriptions replication to Amazon S3.
-
Analyze BigQuery Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for BigQuery from Power Pivot. You will use the Table Import Wizard to load Google BigQuery. You can visually build the import query or use any SQL supported by the driver.
-
How to Query Live MarkLogic Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live MarkLogic data in natural language using Python.
-
DataBind Controls to REST Data in C++Builder
DataBind to REST in C++Builder with standard components and controls.
-
Edit and Search Google Ad Manager External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Google Ad Manager to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Google Ad Manager objects that you can access from apps and the dashboard.
-
Automated Continuous Codat Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Codat replication to PostgreSQL.
-
Access Tanda Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Tanda from HeidiSQL.
-
Connect to Odoo Data in Aqua Data Studio
Access Odoo ERP from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Process & Analyze Exact Online Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Exact Online Data.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Lakebase
Provide connectivity to Lakebase through an SAP BusinessObjects universe.
-
Connect to Dynamics 365 Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Microsoft Dynamics 365 in Airbyte.
-
How to Work with Eventbrite Data in AWS Glue Jobs Using JDBC
Connect to Eventbrite from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Google Sheets
Provide connectivity to Google Sheets through an SAP BusinessObjects universe.
-
Access Live HBase Data in Coginiti Pro
Connect to and query live Apache HBase from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Hugging Face Data in RazorSQL
Connect to Hugging Face from wizards and query Hugging Face from the GUI in the RazorSQL database management tool.
-
Connect to Hive Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Hive and the Script function in FileMaker Pro to connect to Hive and work with Apache Hive in your FileMaker application.
-
Visualize QuickBooks Time Data in TIBCO Spotfire through OData
Integrate QuickBooks Time into dashboards in TIBCO Spotfire.
-
LINQ to Cosmos DB 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 Cosmos DB Data Provider.
-
Automated Continuous Oracle Service Cloud Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to AlloyDB.
-
Visualize Live Customer.io Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Customer.io using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating GitHub Copilot CLI with Freshdesk 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 Live NetSuite SuiteAnalytics Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your NetSuite SuiteAnalytics for you.
-
Build Semantic Layer Views for GraphQL Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for GraphQL.
-
Connect Helpscout Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Helpscout using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Publish Crystal Reports on Strava Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Strava.
-
Natively Connect to Recurly Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Recurly. Leverage the native support for ODBC in PHP.
-
Connect to Real-Time PivotalTracker Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use PivotalTracker in Power Apps.
-
How to publish and share Insightly Data dashboards with Tableau Server
The CData ODBC driver for Insightly enables you integrate Insightly into Tableau dashboards.
-
Getting Started with the CData SSIS Components for Vimeo
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Vimeo.
-
Connect to Jumpseller Data in RazorSQL
Connect to Jumpseller from wizards and query Jumpseller from the GUI in the RazorSQL database management tool.
-
Use the CData Software JDBC Driver for Delighted in MicroStrategy
Connect to Delighted in MicroStrategy Developer using the CData Software JDBC Driver for Delighted.
-
Connect to Wrike Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Wrike.
-
Integrating Kiro CLI with Salesforce 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 Facebook Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Facebook and visualize Facebook in SAP Analytics Cloud.
-
Automated Continuous Paylocity Replication to SQLite
Use CData Sync for automated, continuous, customizable Paylocity replication to SQLite.
-
Visualize Jira Data in Sisense
Create an ElastiCube in Sisense app with access to Atlassian Jira.
-
Integrating Claude Code CLI with Asana 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.
-
Access Apify Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Apify from your Oracle system.
-
Automated Continuous Reckon Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Reckon replication to AlloyDB.
-
Connect to SAP Business One Data in Ruby
Connect to SAP Business One in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Pipeliner CRM Data in CloverDX (formerly CloverETL)
Transfer Pipeliner CRM using the visual workflow in the CloverDX data integration tool.
-
Work with Square Data in FoxPro
Load Square into a FoxPro database. This article includes full code and a walk-through of the process.
-
View Reports on Real-Time Pinecone Data in Power BI Report Server
Use the CData ODBC Driver for Pinecone to visualize Pinecone in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrate Goose with Live OData Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live OData from within the local AI agent.
-
Connect to CircleCI Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for CircleCI in the Denodo Virtual DataPort Administrator.
-
Build XML-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live XML Files.
-
Integrate MariaDB with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate MariaDB with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to MariaDB.