CData Software - Knowledge Base
Recent Articles
-
Process & Analyze Zoho CRM Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Zoho CRM Data.
-
Natively Connect to Retently Data in PHP
The CData ODBC driver for Retently enables you to create PHP applications with connectivity to Retently data. Leverage the native support for ODBC in PHP.
-
Connect to Tavily Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Tavily data in the Denodo Virtual DataPort Administrator.
-
Connect to SFTP Data in DBArtisan
Use wizards in DBArtisan to configure SFTP data as a data source.
-
Access Live Amazon DynamoDB Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Amazon DynamoDB data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Publish Crystal Reports on Google Ads Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Google Ads data.
-
Integrate with Live Phoenix Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Phoenix from the MuleSoft Anypoint Platform to integrate live Phoenix data into custom reports and dashboards.
-
Migrating data from Scrapfly to Databricks using CData SSIS Components.
Easily push Scrapfly data to Databricks using the CData SSIS Tasks for Scrapfly and Databricks.
-
How to create Vimeo federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Vimeo data in MySQL .
-
Connect to Suadeo Data in Jaspersoft Studio
Execute SQL to remote Suadeo data in Jaspersoft Studio.
-
Analyze Cvent Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Cvent data and visualize Cvent data in SAP Analytics Cloud.
-
How to Visualize Nethunt Data in Python with pandas
Use pandas and other modules to analyze and visualize live Nethunt data in Python.
-
Integrate Trae with Live SAP Fieldglass Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live SAP Fieldglass data from within the AI-powered IDE.
-
Create WordPress-Connected Dashboards in Grafana
Connect to WordPress Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to WordPress data.
-
Use Databricks Agent Bricks to Talk to Your Sage Cloud Accounting Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Sage Cloud Accounting data for you.
-
Automated Continuous Google Sheets Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Google Sheets replication to Google BigQuery.
-
Analyze BigCommerce Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of BigCommerce data and visualize live BigCommerce data in Infragistics Reveal.
-
Query Grafana Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Grafana data from Node.js.
-
How to connect to Email Data from IntelliJ
Integrate connectivity to Email data with wizards in IntelliJ.
-
Import NetSuite Data Using Azure Data Factory
Use CData Connect AI to connect to NetSuite Data from Azure Data Factory and import live NetSuite data.
-
Use the CData Software ODBC Driver for Oracle Financials Cloud in MicroStrategy Web
Connect to Oracle Financials Cloud data in MicroStrategy Web using the CData Software ODBC Driver for Oracle Financials Cloud.
-
Query Wrike Data in ColdFusion
Write standard ColdFusion data access code to connect to Wrike data.
-
Use the CData Software ODBC Driver for ActiveCampaign in SAS for Real-Time Reporting and Analytics
Connect to real-time ActiveCampaign data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ActiveCampaign.
-
Automated Continuous Kafka Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Kafka replication to Amazon S3.
-
Connect to QuickBooks Data in DBArtisan
Use wizards in DBArtisan to configure QuickBooks data as a data source.
-
Mailjet Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Mailjet data through CData Connect AI using different applications and tools.
-
Manage Dynamics 365 Business Central Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Dynamics 365 Business Central.
-
Getting Started with the CData Excel Add-In for Figshare
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Figshare.
-
Migrating data from Auth0 to Databricks using CData SSIS Components.
Easily push Auth0 data to Databricks using the CData SSIS Tasks for Auth0 and Databricks.
-
Model Workday Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Workday, enabling the direct import of real-time Workday data.
-
Visualize Sage Intacct Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Sage Intacct data.
-
How to import HubSpot Data into Apache Solr
Use the CData Software JDBC Driver for HubSpot in Data Import Handler and create an automated import of HubSpot data to Apache Solr Enterprise Search platform.
-
Query Omnisend Data in ColdFusion
Write standard ColdFusion data access code to connect to Omnisend data.
-
Build BigQuery-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live BigQuery data.
-
Connect to FreeAgent Data in RapidMiner
Integrate FreeAgent data with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous Short.io Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Short.io replication to Google BigQuery.
-
Provide OData Services of Snowflake Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Snowflake data by developing a WCF Service Application.
-
A PostgreSQL Interface for Google Calendar Data using the CData ODBC Driver
Use the SQL Gateway and Google Calendar ODBC Driver to create a PostgreSQL entry-point for data access.
-
Model, Search, and Visualize Live Toggl Data in ThoughtSpot
Use CData Connect AI to connect to live Toggl data for modeling, searching, and visualizing.
-
Query Live SageHR 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 SageHR data directly from the development environment.
-
How to connect Amazon QuickSight to SAP Ariba Source Data
Create a connection to SAP Ariba Source data in CData Connect AI and insert SAP Ariba Source data into Amazon QuickSight SPICE to build interactive dashboards.
-
Natively Connect to ZohoSubscriptions Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to ZohoSubscriptions data. Leverage the native support for ODBC in PHP.
-
Create Zoho Projects Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Zoho Projects from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrate Live Snowflake Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Snowflake data to Blue Prism using the CData ODBC Driver for Snowflake to create automated workflows for repetitive business tasks.
-
Use CData Connect AI to Access Presto Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Presto data in the Power Pivot business intelligence tool.
-
Build JSON-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to JSON services and build web apps with connectivity to live JSON services.
-
Automate Google Ads Data Replication to SAP HANA
Use CData Sync to customize and automate Google Ads data replication to SAP HANA.
-
Build Salesforce CRM Analytics-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Salesforce CRM Analytics data without replication.
-
Access Google Translate Data from MySQL in Amazon QuickSight
Connect to Google Translate and build visualizations of Google Translate data using a MySQL Connection in Amazon QuickSight.
-
Replicate Multiple Salesloft Accounts via the CData Sync CLI
Replicate multiple Salesloft accounts to one or many databases.
-
How to Easily Query Elorus Data in OpenOffice Base
Connect to Elorus data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Choosing the Best Method to Connect Workday to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Workday data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Create Data Visualizations in Cognos BI with ZohoExpense Data
Access ZohoExpense data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Access OnePageCrm Data Using Entity Framework
This article shows how to access OnePageCrm data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Create Reports from Perplexity Data in Looker Studio
Use CData Connect AI to gain access to live Perplexity data and create custom reports in Looker Studio.
-
Access Live OneNote Data in Excel 365 Online (Excel for the web)
Connect to OneNote data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Automate Microsoft Entra ID Data Replication to Azure Synapse
Use CData Sync to customize and automate Microsoft Entra ID data replication to Azure Synapse.
-
Create SSAS Tabular Models from Xero Data
How to build a SQL Server Analysis Service Tabular Model from Xero data using CData drivers.
-
Build Timely-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Timely data.
-
Automate Aha! Data Replication to SAP HANA
Use CData Sync to customize and automate Aha! data replication to SAP HANA.
-
Easily Integrate Azure DevOps Data in Lazarus Pascal IDE
Learn how to easily integrate live Azure DevOps data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Access Live SageHR Data in Excel 365 Online (Excel for the web)
Connect to SageHR data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to Connect to Live Oracle Sales Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Oracle Sales data without replication.
-
Create Dashboards and Visualize Live Cassandra Data in Geckoboard
Use CData Connect AI to connect to live Cassandra data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Create SSAS Tabular Models from Intercom Data
How to build a SQL Server Analysis Service Tabular Model from Intercom data using CData drivers.
-
Getting Started with the CData Tableau Connector for Neo4J
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Neo4J.
-
Build Data Flows from SQL Server to BigCommerce through SSIS
Easily push SQL Server data to BigCommerce using the CData SSIS Tasks for BigCommerce.
-
Connect to Notion Data in CloverDX (formerly CloverETL)
Transfer Notion data using the visual workflow in the CloverDX data integration tool.
-
Import Real-Time Suadeo Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Suadeo data in ColdFusion.
-
Automated Continuous Highrise Replication to Oracle
Use CData Sync for automated, continuous, customizable Highrise replication to Oracle.
-
Access Live Google Forms Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Google Forms data into the statistical analysis tools available in SAS JMP. This article shows how to use Google Forms data in the Graph Builder and Query Builder.
-
How to import LinkedIn Ads Data into Apache Solr
Use the CData Software JDBC Driver for LinkedIn Ads in Data Import Handler and create an automated import of LinkedIn Ads data to Apache Solr Enterprise Search platform.
-
Automated Continuous Tavily Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Tavily replication to PostgreSQL.
-
Extract, Transform, and Load Zoho Recruit Data in Informatica PowerCenter
Create a simple Workflow for Zoho Recruit data in Informatica PowerCenter.
-
Use the CData Software JDBC Driver for ADP in MicroStrategy Web
Connect to ADP data in MicroStrategy Web using the CData Software JDBC Driver for ADP.
-
Getting Started with the CData Excel Add-In for Vault CRM
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Vault CRM.
-
Integrating Boomi Agentstudio with Office 365 Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Office 365 data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Integrate with Hacker News Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Hacker News data to a JSON file on disk.
-
Feed QuickBooks Online Data into FineReport
How to set QuickBooks Online data as a JDBC data source in FineReport.
-
Integrate Live Neo4J Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Neo4J data and integrate live Neo4J data into apps built in Microsoft Power Apps.
-
Query, Visualize, and Share live MailChimp Data in Redash
Use CData Connect AI to connect to live MailChimp data in Redash for querying, visualizing, and sharing.
-
Automated Continuous JSON Replication to Oracle
Use CData Sync for automated, continuous, customizable JSON replication to Oracle.
-
Using the CData Software ODBC Driver for ClickUp in PyCharm
Connect to ClickUp as an ODBC data source in PyCharm using the CData Software ODBC Driver for ClickUp.
-
Connect to BigQuery Data from PowerBuilder via ADO.NET
This article demonstrates how to access BigQuery data from Appeon PowerBuilder using the CData ADO.NET Provider for BigQuery.
-
Connect to AlloyDB Data from a Connection Pool in JBoss
Integrate AlloyDB data into Java servlets: Use the Management Console in JBoss to install the AlloyDB JDBC Driver.
-
Connect to Intercom Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Intercom as an External Source in Dremio.
-
Integrate Open WebUI with Live SageHR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live SageHR data from within the chat interface.
-
Validate Intercom Data with QuerySurge
Access and validate Intercom data in QuerySurge using the CData JDBC Driver.
-
Connect to Suadeo Data in NetBeans
Connect to Suadeo data in NetBeans with the data source configuration wizard.
-
Automate QuickBooks Data Replication to Azure Data Lake
Use CData Sync to customize and automate QuickBooks data replication to Azure Data Lake.
-
Automated Continuous Act CRM Replication to Snowflake
Use CData Sync for automated, continuous, customizable Act CRM replication to Snowflake.
-
How to Connect DBeaver to Coinbase via a JDBC Driver
Manage Coinbase data with visual tools in DBeaver like the query browser.
-
Connect to Postmark Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Postmark data in the Denodo Virtual DataPort Administrator.
-
Use the CData Software JDBC Driver for FormSite in MicroStrategy
Connect to FormSite data in MicroStrategy Developer using the CData Software JDBC Driver for FormSite.
-
Getting Started with the CData Power BI Connector for xBase
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for xBase.
-
Connect to Adobe Target Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Adobe Target data.
-
Access Live SendGrid 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 SendGrid data through MCP integration.
-
Access Live CSV Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to CSV data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Getting Started with the CData Tableau Connector for Access
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Access.
-
Connect to RSS Feeds in DBeaver
Use the CData ODBC Driver to connect to RSS feeds in DBeaver.