CData Software - Knowledge Base
Recent Articles
-
Connect to Missive Data in DBArtisan
Use wizards in DBArtisan to configure Missive data as a data source.
-
How to Work with Bitbucket Data in ETL Validator JDBC
Connect to Bitbucket from ETL Validator jobs using the CData Software JDBC Driver.
-
Visualize Sybase IQ Data in TIBCO Spotfire through OData
Integrate Sybase IQ data into dashboards in TIBCO Spotfire.
-
Create Greenhouse-Connected Applications in Appsmith
Connect to Greenhouse Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Greenhouse data.
-
Automated Continuous Reckon Replication to Oracle
Use CData Sync for automated, continuous, customizable Reckon replication to Oracle.
-
Connect to Microsoft Dataverse Data in RazorSQL
Connect to Microsoft Dataverse from wizards and query Microsoft Dataverse data from the GUI in the RazorSQL database management tool.
-
Replicate Slack Data to Multiple Databases
Replicate Slack data to disparate databases with a point-and-click configuration.
-
Automated Continuous Toggl Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Toggl replication to Google Cloud SQL.
-
Replicate Multiple Float Accounts via the CData Sync CLI
Replicate multiple Float accounts to one or many databases.
-
Access Excel Online Data from MySQL in Amazon QuickSight
Connect to Excel Online and build visualizations of Excel Online data using a MySQL Connection in Amazon QuickSight.
-
Build Apps with Live Presto Data Using the Low-Code Development Platform of Mendix
Connect Presto data with Mendix to build apps using the CData JDBC Driver for Presto.
-
Build Apps with Live AlloyDB Data Using the Low-Code Development Platform of Mendix
Connect AlloyDB data with Mendix to build apps using the CData JDBC Driver for AlloyDB.
-
Analyze Tally Data in Cognos Analytics
Use CData Connect AI to connect to Tally Data from Cognos Analytics and analyze live Tally data.
-
Access Live Airtable Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Airtable data through MCP integration.
-
Object-Relational Mapping (ORM) with HCL Domino 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 HCL Domino data into a Java-based ORM framework, Hibernate.
-
Build Vercel-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Vercel data and build web apps with connectivity to live Vercel data.
-
Back Up Onfleet data 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 Onfleet data data.
-
Access Live Klaviyo Data in AWS Lambda
Connect to live Klaviyo data in AWS Lambda using the CData JDBC Driver.
-
How to Work with Oracle Data in AWS Glue Jobs Using JDBC
Connect to Oracle from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Amazon DynamoDB Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Amazon DynamoDB and the Script function in FileMaker Pro to connect to Amazon DynamoDB and work with Amazon DynamoDB data in your FileMaker application.
-
Build Semantic Layer Views for Vault CRM Data in APOS Live Data Gateway
Use the CData Connector for Vault CRM in APOS Live Data Gateway to build Semantic Layer Views for Vault CRM data.
-
Connect to SparkPost Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for SparkPost data in Airbyte.
-
Integrate with Microsoft Entra ID Data in JReport Designer
Create charts and reports based on Microsoft Entra ID data in JReport Designer.
-
Automated Continuous GitHub Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable GitHub replication to Google Cloud SQL.
-
How to Connect to Live XML Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your XML data for you.
-
Integrate Planio Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Planio data from Informatica Cloud.
-
Integrating LangGraph with Discord Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Discord data within automated workflows.
-
Integrate with live Azure Data Lake Storage Data in Jitterbit
Use CData Connect AI to connect to and integrate live Azure Data Lake Storage data in Jitterbit.
-
Build Data Flows from SQL Server to Splunk through SSIS
Easily push SQL Server data to Splunk using the CData SSIS Tasks for Splunk.
-
Analyze GetResponse Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of GetResponse data and visualize GetResponse data in SAP Analytics Cloud.
-
Connecting Mastra with Amazon S3 Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Amazon S3 data, no replication required.
-
Integrate Google's Antigravity Agent with Live SAP Hybris C4C Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live SAP Hybris C4C data using the Model Context Protocol.
-
Connect to RSS Feeds in RazorSQL
Connect to RSS from wizards and query RSS feeds from the GUI in the RazorSQL database management tool.
-
Visualize Anaplan Data in Sisense
Create an ElastiCube in Sisense app with access to Anaplan data.
-
Connecting Pipedream with SuiteCRM Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on SuiteCRM data in real time.
-
Getting Started with the CData Tableau Connector for Yelp
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Query, Visualize, and Share live Google Contacts Data in Redash
Use CData Connect AI to connect to live Google Contacts data in Redash for querying, visualizing, and sharing.
-
Connect to Cosmos DB Data in Claris FileMaker Pro
Use the CData ODBC Driver for Cosmos DB in FileMaker Pro to connect to Cosmos DB and work with Cosmos DB data in your FileMaker applications.
-
Integrate Open WebUI with Live SendGrid Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live SendGrid data from within the chat interface.
-
Integrate Theia IDE with Live Google Directory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Google Directory data from within the development environment.
-
Use the CData Software ODBC Driver for Tanda in SAS for Real-Time Reporting and Analytics
Connect to real-time Tanda data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Tanda.
-
Automate Power BI XMLA Data Replication to Azure Synapse
Use CData Sync to customize and automate Power BI XMLA data replication to Azure Synapse.
-
Connect to Sugar CRM Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Sugar CRM data in the Denodo Virtual DataPort Administrator.
-
How to connect and process Trello data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Trello data.
-
Connecting GenSpark with Exact Online Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Exact Online data without any replication or custom integration required.
-
Use Biml to Build SSIS Tasks to Replicate Tally Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Tally data to SQL Server.
-
Object-Relational Mapping (ORM) with QuickBooks Time 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 QuickBooks Time data into a Java-based ORM framework, Hibernate.
-
Integrating Kiro with Ontraport 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.
-
Create Data Visualizations in Cognos BI with OpenWeatherMap Data
Access OpenWeatherMap data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build Pipelines with Live ServiceNow Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to ServiceNow from Google Cloud Data Fusion, enabling the integration of live ServiceNow data into the building and management of effective data pipelines.
-
Query Live Reckon Accounts Hosted 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 Reckon Accounts Hosted data through a conversational interface.
-
Access Live Zoom Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Zoom data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Create Reports with Short.io Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Short.io data.
-
Automated Continuous Optimizely Replication to MySQL
Use CData Sync for automated, continuous, customizable Optimizely replication to MySQL.
-
Integrating Antigravity CLI with Front data via CData CLI
Connect Front data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to Basecamp Data in Ruby
Connect to Basecamp data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Validate Auth0 Data with QuerySurge
Access and validate Auth0 data in QuerySurge using the CData JDBC Driver.
-
Getting Started with the CData ODBC Driver for Snapchat Ads
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Snapchat Ads.
-
Connect to HDFS Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with HDFS Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Publish Splunk-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Splunk data.
-
Back Up ServiceNow data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for ServiceNow. In this article, we will employ an SSIS workflow to populate a database with ServiceNow data data.
-
JSON Reporting in OBIEE with the JSON JDBC Driver
Deploy the JSON JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Replicate Multiple SendGrid Accounts
Replicate multiple SendGrid accounts to one or many databases.
-
Connect to Vault CRM Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Vault CRM and the SQL Gateway to access Vault CRM data from Google Apps Script.
-
Automated Continuous Front Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Front data replication to OneLake in Microsoft Fabric.
-
Query NetSuite Data in DataGrip
Create a Data Source for NetSuite in DataGrip and use SQL to query live NetSuite data.
-
Integrate Cursor with Live Impala Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Impala data from within the editor.
-
A PostgreSQL Interface for Float Data using the CData ODBC Driver
Use the SQL Gateway and Float ODBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze Jira Assets Data in Cognos Analytics
Use CData Connect AI to connect to Jira Assets Data from Cognos Analytics and analyze live Jira Assets data.
-
Integrating OpenCode with Rootly 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.
-
Integrate Live Google Spanner Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Google Spanner data from within the IDE.
-
Connect to CockroachDB 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 CockroachDB data.
-
Access Live Salesforce Data in TIBCO Data Virtualization
Use the Salesforce Tibco DV Adapter to create a Salesforce data data source in TIBCO Data Virtualization Studio and gain access to live Salesforce data from your TDV Server.
-
Connect to Outlook Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Outlook as an External Source in Dremio.
-
Choosing the Best Method to Connect SAP ByDesign to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SAP ByDesign data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Access FTP Data from MySQL in Amazon QuickSight
Connect to FTP and build visualizations of FTP data using a MySQL Connection in Amazon QuickSight.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Salesloft
Provide connectivity to Salesloft data through an SAP BusinessObjects universe.
-
Getting Started with the CData SSIS Components for Google Translate
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Google Translate.
-
Replicate Multiple HDFS Accounts via the CData Sync CLI
Replicate multiple HDFS accounts to one or many databases.
-
Use Dash to Build to Web Apps on Typeform Data
Create Python applications that use pandas and Dash to build Typeform-connected web apps.
-
Validate Tally Data with QuerySurge
Access and validate Tally data in QuerySurge using the CData JDBC Driver.
-
How to Connect Power BI XMLA 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 Power BI XMLA data in real time using natural language.
-
Connect to Xero Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Xero data in Airbyte.
-
Connect to Amazon Marketplace Data in RapidMiner
Integrate Amazon Marketplace data with standard components and data source configuration wizards in RapidMiner Studio.
-
Use Agno to Talk to Your Omnisend 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 Omnisend data for you.
-
Integrating Antigravity CLI with Float data via CData CLI
Connect Float data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Automated Continuous Pipeliner CRM Replication to SQL Server
Use CData Sync for automated, continuous, customizable Pipeliner CRM replication to SQL Server.
-
DataBind ZohoSubscriptions Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide ZohoSubscriptions data to a chart.
-
How to Work with Twilio Data in ETL Validator JDBC
Connect to Twilio from ETL Validator jobs using the CData Software JDBC Driver.
-
Analyze Jira Assets Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Jira Assets data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to ConvertKit Data from PowerBuilder via ADO.NET
This article demonstrates how to access ConvertKit data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to Easily Query Reply.io Data in OpenOffice Base
Connect to Reply.io data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Replicate Opsgenie Data in Heroku for Use in Salesforce Connect
Replicate Opsgenie data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Access Live Coda Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Coda data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to Connect to Live Oracle Sales 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 Sales data through natural language.
-
Integrating Kiro with Twilio 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.
-
Migrating data from Foursquare to Databricks using CData SSIS Components.
Easily push Foursquare data to Databricks using the CData SSIS Tasks for Foursquare and Databricks.
-
Access Apollo Data from MySQL in Amazon QuickSight
Connect to Apollo and build visualizations of Apollo data using a MySQL Connection in Amazon QuickSight.
-
Create Microsoft Dataverse-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Microsoft Dataverse Data from OutSystems and build custom enterprise apps using live Microsoft Dataverse data.
-
Connect to Monday.com Data in CloverDX (formerly CloverETL)
Transfer Monday.com data using the visual workflow in the CloverDX data integration tool.