CData Software - Knowledge Base
Recent Articles
-
DataBind Controls to Adobe Commerce Data in Delphi
DataBind to Adobe Commerce data in Delphi with standard data access components and controls.
-
Create Informatica Mappings From/To a JDBC Data Source for Excel
Create Excel data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Zoom 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 Zoom and work with Zoom data in your FileMaker application.
-
Build MVC Applications with Connectivity to Coinbase Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Coinbase from an ASP.NET MVC application.
-
Dynamics 365 Business Central Reporting in OBIEE with the Dynamics 365 Business Central JDBC Driver
Deploy the Dynamics 365 Business Central JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Connect to Highrise Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Highrise data. Leverage the pyodbc module for ODBC in Python.
-
How to connect to Raisers Edge NXT Data with Squirrel SQL client
Connect to Raisers Edge NXT data and execute queries in the Squirrel SQL Client.
-
Query Samanage Data in DataGrip
Create a Data Source for Samanage in DataGrip and use SQL to query live Samanage data.
-
Connect to Google Ads from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Google Ads data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Integrate Live LinkedIn Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to LinkedIn from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live LinkedIn data.
-
Connect to AgileCRM Data from a Connection Pool in JBoss
Integrate AgileCRM data into Java servlets: Use the Management Console in JBoss to install the AgileCRM JDBC Driver.
-
Integrate Zuora Data in Pentaho Data Integration
Build ETL pipelines based on Zuora data in the Pentaho Data Integration tool.
-
Build ZohoDesk-Connected Apps in Choreo
Use CData Connect AI to connect to ZohoDesk Data from Choreo and build custom apps using live ZohoDesk data.
-
Automated Continuous NASA Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable NASA replication to Azure SQL Database.
-
How to connect to ServiceDesk Plus Data in DBVisualizer
Integrate ServiceDesk Plus data with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous ADP Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable ADP replication to delimited files (CSV/TSV).
-
Visualize Live DB2 Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live DB2 data into custom reports in Power BI.
-
Build Cloudant Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Cloudant data and build visualizations in Tableau.
-
Integrate Google's Vertex AI Agent with Live LDAP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live LDAP objects within intelligent workflows.
-
Automate HBase Integration Tasks from PowerShell
Are you in search of a quick and easy way to access HBase data from PowerShell? This article demonstrates how to utilize the HBase Cmdlets for tasks like connecting to HBase data, automating operations, downloading data, and more.
-
Use the CData Software JDBC Driver for Odoo in MicroStrategy Desktop
Connect to Odoo data in MicroStrategy Desktop using the CData Software JDBC Driver for Odoo.
-
Import Real-Time Redis Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Redis data in ColdFusion.
-
Query Live Oracle Eloqua 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 Oracle Eloqua data directly from the development environment.
-
Automate Power BI XMLA Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Power BI XMLA data from PowerShell? This article demonstrates how to utilize the Power BI XMLA Cmdlets for tasks like connecting to Power BI XMLA data, automating operations, downloading data, and more.
-
Connect to and Query Paymo Data in QlikView over ODBC
Create data visualizations with Paymo data in QlikView.
-
Import Zoho Books Data Using Azure Data Factory
Use CData Connect AI to connect to Zoho Books Data from Azure Data Factory and import live Zoho Books data.
-
Connect to and Query Apollo Data in QlikView over ODBC
Create data visualizations with Apollo data in QlikView.
-
Publish Vimeo-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Vimeo data.
-
Replicate Multiple SharePoint Accounts
Replicate multiple SharePoint accounts to one or many databases.
-
Integrate with Azure DevOps Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Azure DevOps data in SnapLogic.
-
How to Query Live Printful Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Printful data data in natural language using Python.
-
Build Charts with Google Ads Data in Clear Analytics
Create dynamic charts and perform analytics based on Google Ads data in Clear Analytics.
-
How to Query WooCommerce Data in MySQL Workbench
Execute MySQL queries against live WooCommerce data from MySQL Workbench.
-
Automated Continuous Marketo Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Marketo replication to IBM DB2.
-
Replicate Square Data in Heroku for Use in Salesforce Connect
Replicate Square data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Use the CData Software ODBC Driver for GitHub in MicroStrategy
Connect to GitHub data in MicroStrategy Developer using the CData Software ODBC Driver for GitHub.
-
Object-Relational Mapping (ORM) with QuickBooks Online 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 Online data into a Java-based ORM framework, Hibernate.
-
Connect to Neo4J Data in RazorSQL
Connect to Neo4J from wizards and query Neo4J data from the GUI in the RazorSQL database management tool.
-
Connect to Gong Data in HULFT Integrate
Connect to Gong as a JDBC data source in HULFT Integrate
-
Automated Continuous Attio Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Attio replication to delimited files (CSV/TSV).
-
Connect to Real-Time Aha! Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Aha! data in Power Apps.
-
Connect to SAS xpt Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for SAS xpt data in the Denodo Virtual DataPort Administrator.
-
How to Connect Salesforce CRM Analytics 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 Salesforce CRM Analytics data in real time using natural language.
-
How to Build an ETL App for Phoenix Data in Python with CData Connect AI
Extract and transform live Phoenix data in Python with petl and the CData Connect AI Python SDK.
-
How to connect and process Customer.io data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Customer.io data.
-
Create Dynamic Mailgun Grids Using the Infragistics XamDataGrid
Learn how you can connect Mailgun to Infragistics XamDataGrid to build dynamic grids.
-
Connect to and Visualize Live Google Contacts Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Google Contacts data.
-
Integrate Google's Antigravity Agent with Live Avalara AvaTax Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Avalara AvaTax data using the Model Context Protocol.
-
Getting Started with the CData Power BI Connector for ChartMogul
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Access Live SuiteCRM Data in AWS Lambda (with IntelliJ IDEA)
Connect to live SuiteCRM data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build Basecamp-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 Basecamp data without replication.
-
Visualize Acumatica Data in Tableau
The CData ODBC driver for Acumatica enables you integrate Acumatica data into Tableau dashboards.
-
How to Visualize IBM Cloud Object Storage Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live IBM Cloud Object Storage data in Python.
-
How to Easily Query CampaignMonitor Data in OpenOffice Base
Connect to CampaignMonitor data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Integrate with Microsoft Planner Data in JReport Designer
Create charts and reports based on Microsoft Planner data in JReport Designer.
-
Bind Live FHIR Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live FHIR data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Prepare, Blend, and Analyze Freshdesk Data in Alteryx Designer (Connect AI)
Build workflows to access live Freshdesk data for self-service data analytics.
-
Connect to Attio 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 Attio data.
-
Work with Live Anaplan Data in Power Query
Use CData Connect AI to connect to Anaplan data and work with live Anaplan data in Microsoft Power Query.
-
Access Live Jodoo Data in Coginiti Pro
Connect to and query live Jodoo data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrate Cline with Live AgileCRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live AgileCRM data from within your IDE.
-
Model BambooHR Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and BambooHR, enabling the direct import of real-time BambooHR data.
-
Build Insightly-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Insightly data and build web apps with connectivity to live Insightly data.
-
How to Visualize GetResponse Data in Python with pandas
Use pandas and other modules to analyze and visualize live GetResponse data in Python.
-
Connect to AlloyDB Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for AlloyDB data in Airbyte.
-
Publish Crystal Reports on Guru Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Guru data.
-
How to connect to Exa Data from IntelliJ
Integrate connectivity to Exa data with wizards in IntelliJ.
-
Analyze CircleCI Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze CircleCI data in Microsoft R Open.
-
Query Microsoft Teams Data as a SQL Server Database in Node.js
Execute SQL Server queries against Microsoft Teams data from Node.js.
-
Build Apps with Live ClickTime Data Using the Low-Code Development Platform of Mendix
Connect ClickTime data with Mendix to build apps using the CData API Driver for JDBC.
-
Manage Flowlu Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Flowlu.
-
How to Work with Everhour Data in AWS Glue Jobs Using JDBC
Connect to Everhour from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to connect to Snapchat Ads Data in DBVisualizer
Integrate Snapchat Ads data with visual data analysis tools and data connection wizards in DBVisualizer
-
Build AI Agents with Greenhouse Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Greenhouse data through CData Connect AI.
-
Connect and Query Live Elasticsearch Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Elasticsearch data into Databricks and enable direct, live querying and analysis without replication.
-
Automated Continuous Zoho Projects Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Zoho Projects replication to Amazon Redshift.
-
How to work with Instagram Data in Apache Spark using SQL
Access and process Instagram Data in Apache Spark using the CData Software JDBC Driver.
-
Seamlessly Bring IBM Cloud Object Storage Data into Retool Using CData Connect AI
Integrate IBM Cloud Object Storage data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Build Webex-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Webex data and build web apps with connectivity to live Webex data.
-
Integrate Trae with Live Bitly Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Bitly data from within the AI-powered IDE.
-
Establish a Live Connection with Dynamics NAV Data using Tableau Bridge
The CData ODBC Driver for Dynamics NAV enables you to integrate live Dynamics NAV data into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Freshdesk Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Freshdesk and the Script function in FileMaker Pro to connect to Freshdesk and work with Freshdesk data in your FileMaker application.
-
Create SSAS Tabular Models from Coinbase Data
How to build a SQL Server Analysis Service Tabular Model from Coinbase data using CData drivers.
-
Build Semantic Layer Views for Notion Data in APOS Live Data Gateway
Use the CData Connector for Notion in APOS Live Data Gateway to build Semantic Layer Views for Notion data.
-
Integrate Nuclia Data in the Pentaho Report Designer
Publish reports based on Nuclia data in the Pentaho BI tool.
-
Replicate Sage Cloud Accounting Data from PowerShell
Write a quick PowerShell script to query Sage Cloud Accounting data. Use connectivity to the live data to replicate Sage Cloud Accounting data to SQL Server.
-
Build Data Flows from SQL Server to Marketo through SSIS
Easily push SQL Server data to Marketo using the CData SSIS Tasks for Marketo.
-
Bridge ZohoMarketingHub Connectivity with Apache NiFi
Access and process ZohoMarketingHub data in Apache NiFi using the CData JDBC Driver.
-
Connect to Microsoft Ads Data from Crystal Reports
Use CData Connect AI to connect to and report on live Microsoft Ads data from Crystal Reports.
-
How to import EnterpriseDB Data into Apache Solr
Use the CData Software JDBC Driver for EnterpriseDB in Data Import Handler and create an automated import of EnterpriseDB data to Apache Solr Enterprise Search platform.
-
Connect to Oracle Sales 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 Oracle Sales data.
-
Connect to Missive Data from PowerBuilder via ADO.NET
This article demonstrates how to access Missive data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Search External Campaigner Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Campaigner data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Campaigner Data objects that you can access from apps and the dashboard.
-
Integrate Dify with Live Azure Data Catalog Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Azure Data Catalog data.
-
Connect to Toggl Data from a Connection Pool in JBoss
Integrate Toggl data into Java servlets: Use the Management Console in JBoss to install the Toggl JDBC Driver.
-
Connect to Salesloft Data in DBArtisan
Use wizards in DBArtisan to configure Salesloft data as a data source.
-
How to integrate Metabase with Odoo Data
Use CData Connect AI to connect to live Odoo data and create an interactive dashboard in Metabase from Odoo data.
-
Automated Continuous Billsby Replication to Oracle
Use CData Sync for automated, continuous, customizable Billsby replication to Oracle.
-
Use the CData Software ODBC Driver for Salesforce Data 360 in MicroStrategy
Connect to Salesforce Data 360 data in MicroStrategy Developer using the CData Software ODBC Driver for Salesforce Data 360.
-
Build Data Flows from Supabase to SQL Server using SSIS
Easily back up Supabase data to SQL Server using the SSIS components for Supabase.