CData Software - Knowledge Base
Recent Articles
-
Connect to Everhour Data in DBArtisan
Use wizards in DBArtisan to configure Everhour as a data source.
-
Create Dynamic Aweber Grids Using the Infragistics XamDataGrid
Learn how you can connect Aweber to Infragistics XamDataGrid to build dynamic grids.
-
How to integrate Metabase with Jira Assets Data
Use CData Connect AI to connect to live Jira Assets and create an interactive dashboard in Metabase from Jira Assets.
-
Automated Continuous Google Ad Manager Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Google Ad Manager replication to delimited files (CSV/TSV).
-
Getting Started with the CData Power BI Connector for Calendly
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Access Live Trello Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Trello from your Excel spreadsheets.
-
How to Create Power BI Visual Reports with Real-Time Delighted Data
Use CData Power BI Connectors to visualize Delighted in Power BI.
-
Use the CData ODBC Driver for Intercom from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Intercom to connect to Intercom from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Intercom in Excel.
-
Build MarkLogic-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for MarkLogic Data and create custom apps in Mendix.
-
Create Informatica Mappings From/To a JDBC Data Source for Humanity
Create Humanity data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrating LangChain with Azure DevOps Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Azure DevOps within automated workflows.
-
Replicate Teamwork Data from PowerShell
Write a quick PowerShell script to query Teamwork. Use connectivity to the live data to replicate Teamwork to SQL Server.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Google Campaign Manager 360 to Power BI dashboards. Simply drag and drop Google Campaign Manager 360 into data visuals on the Power BI canvas.
-
Build Salesforce CRM Analytics-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Salesforce CRM Analytics and build Salesforce CRM Analytics-connected web apps with Axios.
-
Connect to ChartMogul Data in JRuby
Create a simple JRuby app with access to live ChartMogul.
-
Integrate with Lakebase Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Lakebase to a JSON file on disk.
-
Prepare, Blend, and Analyze Printify Data in Alteryx Designer (ODBC)
Build workflows to access live Printify for self-service data analytics.
-
Validate Campaigner Data with QuerySurge
Access and validate Campaigner in QuerySurge using the CData JDBC Driver.
-
Create Data Visualizations in Cognos BI with Square Data
Access Square as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect Foursquare to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Foursquare using the CData Python MCP Server.
-
Connect to Drip Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Drip.
-
Connect to Campaigner Data in Jaspersoft Studio
Execute SQL to remote Campaigner in Jaspersoft Studio.
-
Visualize Live Act CRM Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Act CRM.
-
How to Access SurveyMonkey Data Using Entity Framework
This article shows how to access SurveyMonkey using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Visualize Live Amazon Athena Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Amazon Athena using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create Data Visualizations Based On LinkedIn Data in Mode
Use CData Connect AI to connect to LinkedIn Data from Mode and build visualizations using live
-
Integrate Open WebUI with Live SAS xpt Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live SAS XPORT from within the chat interface.
-
Publish Greenhouse-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Greenhouse.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Zoho Projects within intelligent workflows.
-
How to connect to Pingdom Data from IntelliJ
Integrate connectivity to Pingdom with wizards in IntelliJ.
-
Use Azure AI Foundry to Talk to Your SAP Concur 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 SAP Concur for you.
-
How to Visualize HubSpot Data in Python with pandas
Use pandas and other modules to analyze and visualize live HubSpot in Python.
-
How to work with Monday.com Data in Apache Spark using SQL
Access and process Monday.com Data in Apache Spark using the CData Software JDBC Driver.
-
Integrating LangGraph with Square Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Square within automated workflows.
-
Connect to Amplitude Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Amplitude and work with Amplitude in your FileMaker applications.
-
Write a Simple Go Application to work with Google Search Results on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Google Search.
-
Use Biml to Build SSIS Tasks to Replicate WordPress Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate WordPress to SQL Server.
-
Integrate with live Zoho CRM Data in Jitterbit
Use CData Connect AI to connect to and integrate live Zoho CRM in Jitterbit.
-
Build CapsuleCRM-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to CapsuleCRM and build web apps with connectivity to live CapsuleCRM.
-
Integrate Figshare with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Figshare with External Services.
-
Create Workday-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Workday Data from OutSystems and build custom enterprise apps using live Workday.
-
Connect to BigCommerce Data as an External Source in Dremio
Use the CData JDBC Driver to connect to BigCommerce as an External Source in Dremio.
-
Use Azure AI Foundry to Talk to Your LinkedIn Ads 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 LinkedIn Ads for you.
-
Automated Continuous Smartsheet Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Smartsheet replication to Amazon S3.
-
Integrating Kiro CLI with Adobe Target 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.
-
Query Active Directory Data in ColdFusion
Write standard ColdFusion data access code to connect to Active Directory.
-
Create Apps from Azure Analysis Services Data in Qlik Sense Cloud
Use CData Connect AI to connect to Azure Analysis Services Data and build apps from live Azure Analysis Services in Qlik Sense Cloud.
-
Access Live Gmail Data in Coginiti Pro
Connect to and query live Gmail from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Access Paddle Data from MySQL in Amazon QuickSight
Connect to Paddle and build visualizations of Paddle using a MySQL Connection in Amazon QuickSight.
-
Connect to Dynamics 365 Business Central Data from HeidiSQL
Use CData Connect AI to connect to and query live Dynamics 365 Business Central from HeidiSQL.
-
Connect to Accelo Data from a Connection Pool in JBoss
Integrate Accelo into Java servlets: Use the Management Console in JBoss to install the Accelo JDBC Driver.
-
Import Real-Time Tavily Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Tavily in ColdFusion.
-
Visualize Bright Data 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 Bright Data into TIBCO Spotfire.
-
DataBind Controls to Shopify Data in C++Builder
DataBind to Shopify in C++Builder with standard components and controls.
-
Choosing the Best Method to Connect SAP Ariba Source to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SAP Ariba Source from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Continuous Wistia Replication to Oracle
Use CData Sync for automated, continuous, customizable Wistia replication to Oracle.
-
Connect to SingleStore Data in NetBeans
Connect to SingleStore in NetBeans with the data source configuration wizard.
-
Build Pipelines with Live Active Directory Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Active Directory from Google Cloud Data Fusion, enabling the integration of live Active Directory into the building and management of effective data pipelines.
-
Create SingleStore Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SingleStore from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build SingleStore-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SingleStore and build web apps with connectivity to live SingleStore.
-
Analyze Authorize.Net Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Authorize.Net in Microsoft R Open.
-
Access SAP HANA Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SAP HANA from HeidiSQL.
-
Access Live Active Directory 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 Active Directory through MCP integration.
-
Connect to Live SAS xpt Data in PostGresSQL Interface through CData Connect AI
Create a live connection to SAS xpt in CData Connect AI and connect to your SAS XPORT from PostgreSQL.
-
Manage CircleCI Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for CircleCI.
-
Connect to Samanage from Asprova with CData Software ODBC Driver for Samanage
This article shows how to connect faster to Samanage data from Asprova.
-
Build a Simple VCL Application for Amazon S3 Data
How to build a simple VCL Application to view Amazon S3 in RAD Studio using the CData ODBC Driver for Amazon S3.
-
Visualize PolarTeamPro Data in Sisense
Create an ElastiCube in Sisense app with access to PolarTeamPro.
-
Automated Continuous MySQL Replication to SQL Server
Use CData Sync for automated, continuous, customizable MySQL replication to SQL Server.
-
View Reports on Real-Time Sugar CRM Data in Power BI Report Server
Use the CData ODBC Driver for Sugar CRM to visualize Sugar CRM in Power BI Desktop and then publish them to Power BI Report Server.
-
Visualize MYOB AccountRight Data in TIBCO Spotfire through ADO.NET
Integrate MYOB AccountRight into dashboards in TIBCO Spotfire.
-
How to connect to Postmark Data in DBVisualizer
Integrate Postmark with visual data analysis tools and data connection wizards in DBVisualizer
-
Use Agno to Talk to Your Google Cloud Storage 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 Google Cloud Storage for you.
-
Connect to Rebilly Data in RazorSQL
Connect to Rebilly from wizards and query Rebilly from the GUI in the RazorSQL database management tool.
-
How to Work with Workday Data in AWS Glue Jobs Using JDBC
Connect to Workday from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Access Live Parallel Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Parallel enables you to integrate Parallel into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous ConvertKit Replication to Databricks
Use CData Sync for automated, continuous, customizable ConvertKit replication to Databricks.
-
Build Charts with Webflow Data in Clear Analytics
Create dynamic charts and perform analytics based on Webflow in Clear Analytics.
-
Connect Adobe Experience Manager to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Adobe Experience Manager with IBM WebSphere for seamless data integration and connectivity.
-
How to work with Wistia Data in Apache Spark using SQL
Access and process Wistia Data in Apache Spark using the CData Software JDBC Driver.
-
Manage Oracle Financials Cloud Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Oracle Financials Cloud.
-
Import Raisers Edge NXT Data Using Azure Data Factory
Use CData Connect AI to connect to Raisers Edge NXT Data from Azure Data Factory and import live Raisers Edge NXT.
-
Choosing the Best Method to Connect QuickBooks to SQL Server: 5 Options Explained
Discover multiple ways to connect and use QuickBooks Desktop from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to IBM Informix Data in Jaspersoft Studio
Execute SQL to remote IBM Informix in Jaspersoft Studio.
-
Publish Superchat-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Superchat.
-
View Reports on Real-Time ZohoExpense Data in Power BI Report Server
Use the CData ODBC Driver for ZohoExpense to visualize ZohoExpense in Power BI Desktop and then publish them to Power BI Report Server.
-
Connecting Moonlit Workflow with OneNote Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Microsoft OneNote in real time.
-
Automated Continuous Oracle HCM Cloud Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Oracle HCM Cloud replication to Google Cloud SQL.
-
Use Databricks Agent Bricks to Talk to Your Oracle SCM Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Oracle SCM for you.
-
Automated Continuous TaxJar Replication to IBM DB2
Use CData Sync for automated, continuous, customizable TaxJar replication to IBM DB2.
-
Build an OLAP Cube in SSAS from Azure Table Data
Establish a connection to Azure Table Storage data from SQL Server Analysis Services, and use the Azure Table Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate Salesforce Data in Pentaho Data Integration
Build ETL pipelines based on Salesforce & Force.com in the Pentaho Data Integration tool.
-
Connect to HCL Domino Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Automated Continuous Cloudflare Replication to Oracle
Use CData Sync for automated, continuous, customizable Cloudflare replication to Oracle.
-
How to Build an ETL App for Azure Data Catalog Data in Python with CData
Create ETL applications and real-time data pipelines for Azure Data Catalog in Python with petl.
-
Build Dashboards with LeadDesk Data in Dundas BI
Create dynamic dashboards and perform analytics based on LeadDesk in Dundas BI.
-
Dynamics CRM Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Microsoft Dynamics CRM through CData Connect AI using different applications and tools.
-
A PostgreSQL Interface for Aweber Data using the CData ODBC Driver
Use the SQL Gateway and Aweber ODBC Driver to create a PostgreSQL entry-point for data access.
-
Build a PostgreSQL Interface for AfterShip Data using the CData JDBC Driver
Use the Remoting features of the AfterShip JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to ZohoDesk in SpagoBI
Create reports featuring live ZohoDesk in SpagoBI Studio. Host ZohoDesk reports on SpagoBI Server.