CData Software - Knowledge Base
Recent Articles
-
Design BIRT Reports on SAP Business One Data
Provide current SAP Business One data to your embedded analytics.
-
Replicate Multiple Slack Accounts
Replicate multiple Slack accounts to one or many databases.
-
Load eBay Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load eBay data to a database.
-
Connect to Oracle Service Cloud Data in JRuby
Create a simple JRuby app with access to live Oracle Service Cloud data.
-
Easily Integrate Productboard Data in Lazarus Pascal IDE
Learn how to easily integrate live Productboard data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Use the CData Software JDBC Driver for SendInBlue in MicroStrategy Web
Connect to SendInBlue data in MicroStrategy Web using the CData Software JDBC Driver for SendInBlue.
-
Visualize Live Monday.com Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Monday.com data.
-
Replicate Multiple Google Analytics Accounts
Replicate multiple Google Analytics accounts to one or many databases.
-
Automated Continuous Acumatica Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Acumatica replication to Azure SQL Database.
-
Access Live MongoDB Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate MongoDB data into the statistical analysis tools available in SAS JMP. This article shows how to use MongoDB data in the Graph Builder and Query Builder.
-
Import Real-Time Shopify Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Shopify data in ColdFusion.
-
Prepare, Blend, and Analyze Greenhouse Data in Alteryx Designer (ODBC)
Build workflows to access live Greenhouse data for self-service data analytics.
-
Query BenchmarkEmail Data in ColdFusion
Write standard ColdFusion data access code to connect to BenchmarkEmail data.
-
How to connect Amazon QuickSight to GraphQL Data
Create a connection to GraphQL data in CData Connect AI and insert GraphQL data into Amazon QuickSight SPICE to build interactive dashboards.
-
Publish Nuclia-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Nuclia data.
-
Build Dashboards with JotForm Data in DBxtra
Create dynamic dashboards and perform analytics based on JotForm data in DBxtra.
-
Visualize Slack 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 Slack data into TIBCO Spotfire.
-
Working with Optimizely Data in LINQPad
Execute LINQ queries to Optimizely data in LINQPad.
-
Getting Started with the CData Connect AI Python SDK for Bright Data
Install the CData Connect AI Python SDK to read live Bright Data data with standard DB-API 2.0 Python code.
-
Create Power BI Reports on Real-Time Opsgenie Data
Use the CData ODBC Driver for Opsgenie to visualize Opsgenie data in Power BI Desktop.
-
Automate SAP Fieldglass Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SAP Fieldglass data from PowerShell? This article demonstrates how to utilize the SAP Fieldglass Cmdlets for tasks like connecting to SAP Fieldglass data, automating operations, downloading data, and more.
-
Create Microsoft Ads-Connected Business Apps in AppSheet
Connect to Microsoft Ads Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Microsoft Ads data.
-
Use the CData ODBC Driver for Bannerbear from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Bannerbear to connect to Bannerbear data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Bannerbear data in Excel.
-
Use Azure AI Foundry to Talk to Your Freshteam Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Freshteam data for you.
-
Connect to MailerLite from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from MailerLite data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Automated Continuous Placid Replication to MySQL
Use CData Sync for automated, continuous, customizable Placid replication to MySQL.
-
Integrating Gumloop with Google Sheets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Google Sheets data within automated workflows.
-
Create Splunk Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Splunk data access from reports, embedded analytics, and more.
-
Connect to Reply.io Data in RazorSQL
Connect to Reply.io from wizards and query Reply.io data from the GUI in the RazorSQL database management tool.
-
Automated Continuous Zoho Projects Replication to SQL Server
Use CData Sync for automated, continuous, customizable Zoho Projects replication to SQL Server.
-
How to Connect to Couchbase Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Couchbase data. Leverage the pyodbc module for ODBC in Python.
-
Integrate with Paylocity Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Paylocity data to a JSON file on disk.
-
How to Build an ETL App for Elorus Data in Python with CData
Create ETL applications and real-time data pipelines for Elorus data in Python with petl.
-
How to Seamlessly Import Beeminder Data into IBM SPSS Modeler
Integrate Beeminder data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to integrate Metabase with SparkPost Data
Use CData Connect AI to connect to live SparkPost data and create an interactive dashboard in Metabase from SparkPost data.
-
Access Cvent Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Cvent data from your Oracle system.
-
Use Manus AI to Talk to Your Highrise 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 Highrise data.
-
How to connect to iContact Data in DBVisualizer
Integrate iContact data with visual data analysis tools and data connection wizards in DBVisualizer
-
Configure the CData JDBC Driver for Bannerbear in a Connection Pool in Tomcat
Connect to Bannerbear data from a connection pool in Tomcat.
-
Automate MarkLogic Data Replication to SAP HANA
Use CData Sync to customize and automate MarkLogic data replication to SAP HANA.
-
Trigger Freshdesk IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Freshdesk with standard wizards in Logic Apps.
-
Use Biml to Build SSIS Tasks to Replicate Freshservice Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Freshservice data to SQL Server.
-
DataBind Controls to Google Forms Data in Delphi
DataBind to Google Forms data in Delphi with standard data access components and controls.
-
Replicate Salesforce CRM Analytics Data to Multiple Databases via the CData Sync CLI
Replicate Salesforce CRM Analytics data to disparate databases with a single configuration.
-
Connect to CircleCI 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 CircleCI and work with CircleCI data in your FileMaker application.
-
Getting Started with the CData Connect AI Python SDK for SparkPost
Install the CData Connect AI Python SDK to read live SparkPost data with standard DB-API 2.0 Python code.
-
Connect to Sage 200 from Asprova with CData Software ODBC Driver for Sage 200
This article shows how to connect faster to Sage 200 data from Asprova.
-
Connect to PingOne Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live PingOne data from Filemaker Pro on Mac.
-
Create Informatica Mappings From/To an ODBC Data Source for Exa
Create an ODBC connection to Exa in Informatica and browse and transfer Exa data.
-
Query ZohoPeople Data through ODBC in Node.js
Use node-odbc to execute SQL queries against ZohoPeople data from Node.js.
-
Seamlessly Bring Google Calendar Data into Retool Using CData Connect AI
Integrate Google Calendar data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Automated Continuous SendPulse Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable SendPulse replication to Azure SQL Database.
-
Create Blackbaud FE NXT Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Blackbaud FE NXT data access from reports, embedded analytics, and more.
-
Integrate Dynamics CRM with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Dynamics CRM with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Dynamics CRM data.
-
Integrate Cursor with Live Zoho Creator Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Zoho Creator data from within the editor.
-
How to integrate Redis with Apache Airflow
Access and process Redis data in Apache Airflow using the CData JDBC Driver.
-
Access Monday.com Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Monday.com data.
-
Connect to MySQL Data in Aqua Data Studio
Access MySQL data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build Data Flows from SQL Server to Email through SSIS
Easily push SQL Server data to Email using the CData SSIS Tasks for Email.
-
Use the CData Software ODBC Driver for Timely in MicroStrategy Web
Connect to Timely data in MicroStrategy Web using the CData Software ODBC Driver for Timely.
-
Connect to Wrike in SpagoBI
Create reports featuring live Wrike data in SpagoBI Studio. Host Wrike reports on SpagoBI Server.
-
Create Data Visualizations in Cognos BI with SurveyMonkey Data
Access SurveyMonkey data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Sage 300 Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Sage 300 as an External Source in Dremio.
-
Automate Sage Intacct Data Replication to Couchbase
Use CData Sync to Customize and automate Sage Intacct data replication to Couchbase.
-
Connect to and Visualize Live PostgreSQL Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live PostgreSQL data.
-
Automated Continuous Azure Data Catalog Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Azure Data Catalog replication to IBM DB2.
-
Integrate Devin with Live Zoho Books 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 Zoho Books data.
-
Creating Anaplan-Connected Applications in Unqork
You can use CData Connect AI to feed Anaplan data to Unqork and build custom business apps.
-
Automated Continuous LeadDesk Replication to Amazon S3
Use CData Sync for automated, continuous, customizable LeadDesk replication to Amazon S3.
-
Automated Bitly Data Replication to Teradata
Use CData Sync to Customize and automate Bitly data replication to Teradata.
-
Automate Pinecone Data Replication to SAP HANA
Use CData Sync to customize and automate Pinecone data replication to SAP HANA.
-
Integrating LangGraph with Authorize.Net Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Authorize.Net data within automated workflows.
-
Use JayDeBeApi to access Foursquare Data in Python
Use standard Python scripting and the development environment of your choice to access live Foursquare data.
-
Analyze Landbot Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Landbot data with the CData JDBC Driver for Landbot.
-
Integrating Cursor with Discord 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 Attio Replication to SQLite
Use CData Sync for automated, continuous, customizable Attio replication to SQLite.
-
Integrate Rebilly with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Rebilly with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Rebilly data.
-
Build Data Flows from Parquet to SQL Server using SSIS
Easily back up Parquet data to SQL Server using the SSIS components for Parquet.
-
How to Connect Flowise AI Agents to Live Teradata Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Teradata data without replication.
-
How to connect and process Tickspot data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Tickspot data.
-
Analyze SingleStore Data in Looker
Use CData Connect AI to connect to SingleStore Data from Looker and build custom apps using live SingleStore data.
-
Design BIRT Reports on Insightly Data
Provide current Insightly data to your embedded analytics.
-
Query Live Mailjet 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 Mailjet data through a conversational interface.
-
Query Epicor Kinetic Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Epicor Kinetic entities in PHP by modeling them as objects.
-
Connecting GenSpark with Impala Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Impala data without any replication or custom integration required.
-
Connect to Microsoft Exchange Data in Jaspersoft Studio
Execute SQL to remote Microsoft Exchange data in Jaspersoft Studio.
-
Build Dashboards with Freshsales Data in DBxtra
Create dynamic dashboards and perform analytics based on Freshsales data in DBxtra.
-
Integrate Instagram Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Instagram data and integrate live Instagram data into your Power Automate tasks.
-
Access Live Tally Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Tally data from your Google Sheets.
-
Automated Continuous Kafka Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Kafka data replication to OneLake in Microsoft Fabric.
-
Migrating data from Attio to Snowflake using CData SSIS Components.
Easily push Attio data to Snowflake using the CData SSIS Tasks for Attio and Snowflake.
-
Integrate Cassandra Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Cassandra data and integrate live Cassandra data into your Power Automate tasks.
-
Migrating data from Google Spanner to Google BigQuery using CData SSIS Components.
Easily push Google Spanner data to Google BigQuery using the CData SSIS Tasks for Google Spanner and Google BigQuery.
-
Connect to Sage 200 Data in ACL Analytics
Connect to Sage 200 data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Sage 200 data.
-
Bill an Invoice with the CData Excel Add-In for QuickBooks
The CData Excel Add-In for QuickBooks makes it easy to transfer data in and out of QuickBooks Desktop and QuickBooks Online. In this article, you will create an Invoice spreadsheet that can be sent to customers. Customers can then insert the Invoice data as Bills to their company files or their company on QuickBooks Online.
-
Connect to Apify Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Apify data.
-
Connect to SpaceX Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SpaceX data using standard SQL.
-
Natively Connect to LinkedIn Ads Data in PHP
The CData ODBC driver for LinkedIn Ads enables you to create PHP applications with connectivity to LinkedIn Ads data. Leverage the native support for ODBC in PHP.
-
Connect to Google Analytics Data from a Connection Pool in JBoss
Integrate Google Analytics data into Java servlets: Use the Management Console in JBoss to install the Google Analytics JDBC Driver.
-
Visualize Live Sage Cloud Accounting Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Sage Cloud Accounting data into custom reports in Power BI.