CData Software - Knowledge Base
Recent Articles
-
Connect to Real-Time Salesforce CRM Analytics Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Salesforce CRM Analytics and Dataflow to import and use Salesforce CRM Analytics in Power Apps.
-
Publish Reports with Google Directory Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Google Directory.
-
Build Microsoft Dataverse Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Microsoft Dataverse (CDS) and build visualizations in Tableau.
-
Bridge Access Connectivity with Apache NiFi
Access and process Microsoft Access in Apache NiFi using the CData JDBC Driver.
-
How to Easily Query Freshteam Data in OpenOffice Base
Connect to Freshteam data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Extract, Transform, and Load SQL Server Data in Informatica PowerCenter
Create a simple Workflow for Microsoft SQL Server in Informatica PowerCenter.
-
DataBind Controls to ServiceDesk Plus Data in Delphi
DataBind to ServiceDesk Plus in Delphi with standard data access components and controls.
-
Analyze Monday.com Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Monday.com with the CData JDBC Driver for Monday.com.
-
Automate Flowlu Data Replication to SAP HANA
Use CData Sync to customize and automate Flowlu replication to SAP HANA.
-
DataBind Controls to SQL Analysis Services Data in C++Builder
DataBind to SQL Analysis Services in C++Builder with standard components and controls.
-
Getting Started with the CData SSIS Components for Gumroad
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Gumroad.
-
Automated Continuous AgileCRM Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable AgileCRM replication to Azure SQL Database.
-
Integrating Kiro CLI with Google Sheets 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 Real-Time Access to LinkedIn Ads in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to LinkedIn Ads in real time.
-
Analyze ZarMoney Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze ZarMoney with the CData JDBC Driver for ZarMoney.
-
Access Live Hugging Face Data in Coginiti Pro
Connect to and query live Hugging Face from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrate Live Confluence Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Atlassian Confluence and integrate live Atlassian Confluence into apps built in Microsoft Power Apps.
-
Connect to Microsoft OneDrive Data in Jaspersoft Studio
Execute SQL to remote Microsoft OneDrive in Jaspersoft Studio.
-
Connect to CockroachDB Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Using the CData Software ODBC Driver for Bugsnag in PyCharm
Connect to Bugsnag as an ODBC data source in PyCharm using the CData Software ODBC Driver for Bugsnag.
-
How to Query Live SAS xpt Data in Perplexity MacOS Desktop
Connect to and query live SAS xpt Data in Perplexity Desktop using CData MCP Server.
-
Replicate Snowflake Data from PowerShell
Write a quick PowerShell script to query Snowflake. Use connectivity to the live data to replicate Snowflake to SQL Server.
-
Getting Started with the CData SSIS Components for Simplesat
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Simplesat.
-
Automated Continuous CouchDB Replication to SingleStore
Use CData Sync for automated, continuous, customizable CouchDB replication to SingleStore.
-
Query CircleCI Data as a MySQL Database in Node.js
Execute MySQL queries against CircleCI from Node.js.
-
Integrate Bugsnag Data in Pentaho Data Integration
Build ETL pipelines based on Bugsnag in the Pentaho Data Integration tool.
-
Getting Started with the CData Power BI Connector for FreeAgent
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Automated Continuous Aweber Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Aweber replication to AlloyDB.
-
Connect to ChargeOver Data in DBeaver
Use the CData ODBC Driver to connect to ChargeOver in DBeaver.
-
Automated Continuous DB2 Replication to Vertica
Use CData Sync for automated, continuous, customizable DB2 replication to Vertica.
-
Excel Spreadsheet Automation on Reckon Accounts Hosted Data with the QUERY Formula
Pull data from Reckon Accounts Hosted, automate spreadsheets, and more with the QUERY formula.
-
Visualize Live Productboard Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Productboard using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automate Bugsnag Data Replication to Azure Synapse
Use CData Sync to customize and automate Bugsnag replication to Azure Synapse.
-
View Reports on Real-Time Zoho Creator Data in Power BI Report Server
Use the CData ODBC Driver for Zoho Creator to visualize Zoho Creator in Power BI Desktop and then publish them to Power BI Report Server.
-
Automated Continuous Chargebee Replication to MySQL
Use CData Sync for automated, continuous, customizable Chargebee replication to MySQL.
-
Connect Confluence to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Atlassian Confluence using the CData Python MCP Server.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Exact Online actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Automate Elorus Data Replication to Azure Synapse
Use CData Sync to customize and automate Elorus replication to Azure Synapse.
-
Create Google Cloud Storage Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Google Cloud Storage data access from reports, embedded analytics, and more.
-
Use Claude to Talk to Your CouchDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Apache CouchDB for you.
-
Automate Amazon Athena Data Replication to Azure Data Lake
Use CData Sync to customize and automate Amazon Athena replication to Azure Data Lake.
-
Use the CData Software ODBC Driver for Salesforce CRM Analytics in MicroStrategy Web
Connect to Salesforce CRM Analytics in MicroStrategy Web using the CData Software ODBC Driver for Salesforce CRM Analytics.
-
Use the CData ODBC Driver for Parallel in Microsoft Power Query
You can use the CData Parallel ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Parallel into Microsoft Power Query.
-
Publish Crystal Reports on Cvent Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Cvent.
-
Connecting GenSpark with MongoDB Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to MongoDB without any replication or custom integration required.
-
Publish SAP ByDesign-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SAP Business ByDesign.
-
Build a Simple VCL Application for Jodoo Data
How to build a simple VCL Application to view Jodoo in RAD Studio using the CData ODBC Driver for Jodoo.
-
Migrating data from Hive to Snowflake using CData SSIS Components.
Easily push Apache Hive to Snowflake using the CData SSIS Tasks for Hive and Snowflake.
-
Connect to BigCommerce Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for BigCommerce.
-
Create Informatica Mappings From/To an ODBC Data Source for Browserless
Create an ODBC connection to Browserless in Informatica and browse and transfer Browserless.
-
How to Seamlessly Import HelloSign Data into IBM SPSS Modeler
Integrate HelloSign data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Mailjet from a Connection Pool in WebLogic
Use the CData JDBC Driver for Mailjet to connect to Mailjet from Web applications running on WebLogic.
-
How to Connect Kintone 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 Kintone data in real time using natural language.
-
Use the CData Software ODBC Driver for PagerDuty in SAS for Real-Time Reporting and Analytics
Connect to real-time PagerDuty in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for PagerDuty.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Cohere
Provide connectivity to Cohere through an SAP BusinessObjects universe.
-
Working with Teamwork Data in LINQPad
Execute LINQ queries to Teamwork in LINQPad.
-
Integrating Kiro CLI with Short.io 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 Reports with Phoenix Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Apache Phoenix.
-
Automated Continuous Adobe Analytics Replication to Databricks
Use CData Sync for automated, continuous, customizable Adobe Analytics replication to Databricks.
-
How to Connect to & Open Wrike Data in Microsoft Excel
This article uses the CData ODBC driver for Wrike to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Replicate DB2 for i Data in Heroku for Use in Salesforce Connect
Replicate DB2 for i to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Create Google Directory-Connected Business Apps in AppSheet
Connect to Google Directory Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Google Directory.
-
Integrate LibreChat with Live Oracle Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Oracle Database from within the chat interface.
-
Automate CampaignMonitor Data Replication to Azure Synapse
Use CData Sync to customize and automate CampaignMonitor replication to Azure Synapse.
-
Stream Insightly Data into Apache Kafka Topics
Access and stream Insightly in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to SendGrid Data in Ruby
Connect to SendGrid in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Create SSAS Tabular Models from Act-On Data
How to build a SQL Server Analysis Service Tabular Model from Act-On using CData drivers.
-
Use the CData ODBC Driver for Microsoft Exchange in Microsoft Power Query
You can use the CData Microsoft Exchange ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Microsoft Exchange into Microsoft Power Query.
-
Import Oracle Sales Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Oracle Sales. In this article, you will use the OData format to import Oracle Sales into Microsoft Power Query.
-
Create SSAS Tabular Models from Drift Data
How to build a SQL Server Analysis Service Tabular Model from Drift using CData drivers.
-
Use the CData ODBC Driver for Flowlu from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Flowlu to connect to Flowlu from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Flowlu in Excel.
-
Getting Started with the CData ODBC Driver for Calendly
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Calendly.
-
Integrate with FTP Data in JReport Designer
Create charts and reports based on FTP Servers in JReport Designer.
-
Extract, Transform, and Load Hacker News Data in Informatica PowerCenter
Create a simple Workflow for Hacker News in Informatica PowerCenter.
-
Automated Continuous Exact Online Replication to Vertica
Use CData Sync for automated, continuous, customizable Exact Online replication to Vertica.
-
Create Data Visualizations Based On Reckon Accounts Hosted Data in Mode
Use CData Connect AI to connect to Reckon Accounts Hosted Data from Mode and build visualizations using live
-
Migrating data from Pushbullet to Databricks using CData SSIS Components.
Easily push Pushbullet to Databricks using the CData SSIS Tasks for Pushbullet and Databricks.
-
Automate Amazon S3 Data Replication to Azure Synapse
Use CData Sync to customize and automate Amazon S3 replication to Azure Synapse.
-
Access SAP Business Warehouse Data from MySQL in Amazon QuickSight
Connect to SAP Business Warehouse and build visualizations of SAP Business Warehouse using a MySQL Connection in Amazon QuickSight.
-
Using the CData Software ODBC Driver for Postmark in PyCharm
Connect to Postmark as an ODBC data source in PyCharm using the CData Software ODBC Driver for Postmark.
-
How to connect to Datadog Data in DBVisualizer
Integrate Datadog with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to SAP Business One in SpagoBI
Create reports featuring live SAP Business One in SpagoBI Studio. Host SAP Business One reports on SpagoBI Server.
-
Build Apps with Live AgileCRM Data Using the Low-Code Development Platform of Mendix
Connect AgileCRM with Mendix to build apps using the CData API Driver for JDBC.
-
Automated Continuous CData Connect AI Replication to Snowflake
Use CData Sync for automated, continuous, customizable CData Connect AI replication to Snowflake.
-
Build SFTP-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for SFTP to explore live SFTP Data in GitHub Copilot to assist with building SFTP-powered applications.
-
Visualize Salesforce Data 360 Data in Sisense
Create an ElastiCube in Sisense app with access to Salesforce Data 360.
-
Automated Continuous LionDesk Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable LionDesk replication to Azure SQL Database.
-
Query Live Active Directory Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Active Directory directly from the development environment.
-
Automated Continuous SurveyMonkey Replication to AlloyDB
Use CData Sync for automated, continuous, customizable SurveyMonkey replication to AlloyDB.
-
Getting Started with the CData ADO.NET Provider for ZeroBounce
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connect to ScrapingBee Data in Aqua Data Studio
Access ScrapingBee from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Query Live Microsoft Ads Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Microsoft Ads directly from the development environment.
-
Connect to Campaigner Data in DBArtisan
Use wizards in DBArtisan to configure Campaigner as a data source.
-
Automated Continuous Azure Synapse Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Azure Synapse replication to IBM DB2.
-
Use ChatGPT to Talk to Your SQL Server Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Microsoft SQL Server for you.
-
Connect OnePageCrm Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your OnePageCrm using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Configure the CData JDBC Driver for Microsoft Entra ID in a Connection Pool in Tomcat
Connect to Microsoft Entra ID from a connection pool in Tomcat.
-
Import Real-Time PhantomBuster Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use PhantomBuster in ColdFusion.
-
Integrating LlamaIndex with LinkedIn Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on LinkedIn Ads in real time.
-
How to Connect to & Open Vimeo Data in Microsoft Excel
This article uses the CData ODBC driver for Vimeo to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.