CData Software - Knowledge Base
Recent Articles
-
Integrating LangGraph with Jira Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Jira data within automated workflows.
-
Use the CData Software ODBC Driver for FreeAgent in SAS for Real-Time Reporting and Analytics
Connect to real-time FreeAgent data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for FreeAgent.
-
Migrating data from LinkedIn to Google BigQuery using CData SSIS Components.
Easily push LinkedIn data to Google BigQuery using the CData SSIS Tasks for LinkedIn and Google BigQuery.
-
Publish Reports with Stack Exchange Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Stack Exchange data.
-
Work with Paddle Data in FoxPro
Load Paddle data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Use JayDeBeApi to access XML Data in Python
Use standard Python scripting and the development environment of your choice to access live XML data.
-
Create Zoho Creator Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Zoho Creator from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build Semantic Layer Views for MariaDB Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for MariaDB data.
-
Use the CData ODBC Driver for Mode from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Mode to connect to Mode data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Mode data in Excel.
-
Import Microsoft Dataverse Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Microsoft Dataverse Data and provide access to live Microsoft Dataverse data for custom reports in the Power BI Service.
-
View Reports on Real-Time Spotify Data in Power BI Report Server
Use the CData ODBC Driver for Spotify to visualize Spotify data in Power BI Desktop and then publish them to Power BI Report Server.
-
Connecting Pipedream with XML 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 XML data in real time.
-
Replicate Multiple AdRoll Accounts via the CData Sync CLI
Replicate multiple AdRoll accounts to one or many databases.
-
Connect to Paylocity Data in NetBeans
Connect to Paylocity data in NetBeans with the data source configuration wizard.
-
Integrate HubDB Data in Pentaho Data Integration
Build ETL pipelines based on HubDB data in the Pentaho Data Integration tool.
-
Access Live SAS xpt Data in Excel 365 Online (Excel for the web)
Connect to SAS xpt data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Use the CData Software ODBC Driver for JobNimbus in SAS for Real-Time Reporting and Analytics
Connect to real-time JobNimbus data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for JobNimbus.
-
Object-Relational Mapping (ORM) with Oracle HCM Cloud 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 Oracle HCM Cloud data into a Java-based ORM framework, Hibernate.
-
Operational Reporting on Google Search Results from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Google Search results.
-
Connect to Microsoft Exchange Data from PowerBuilder via ADO.NET
This article demonstrates how to access Microsoft Exchange data from Appeon PowerBuilder using the CData ADO.NET Provider for Microsoft Exchange.
-
Process & Analyze Bugsnag Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Bugsnag Data.
-
Getting Started with the CData SSIS Components for Productboard
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Productboard.
-
Automated Continuous Moosend Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Moosend replication to Apache Cassandra.
-
Automated Continuous MailerLite Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable MailerLite data replication to OneLake in Microsoft Fabric.
-
Query, Visualize, and Share live Klipfolio Data in Redash
Use CData Connect AI to connect to live Klipfolio data in Redash for querying, visualizing, and sharing.
-
Analyze Zendesk Data in Looker
Use CData Connect AI to connect to Zendesk Data from Looker and build custom apps using live Zendesk data.
-
Access Live SAS Data Sets Data in Coginiti Pro
Connect to and query live SAS Data Sets data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Connect to & Open FreshBooks Data in Microsoft Excel
This article uses the CData ODBC driver for FreshBooks to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create Reports from Hive Data in Looker Studio
Use CData Connect AI to gain access to live Hive data and create custom reports in Looker Studio.
-
Integrate Trello Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Trello data from Informatica Cloud.
-
Connect to and Visualize Live SFTP Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live SFTP data.
-
How to Access Live OpenWeatherMap Data in Power Automate Desktop via ODBC
The CData ODBC Driver for OpenWeatherMap enables you to integrate OpenWeatherMap data into workflows built using Microsoft Power Automate Desktop.
-
A PostgreSQL Interface for Salesforce Pardot Data using the CData ODBC Driver
Use the SQL Gateway and Salesforce Pardot ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Twilio Replication to Oracle
Use CData Sync for automated, continuous, customizable Twilio replication to Oracle.
-
Connect xBase Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your xBase data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Migrating data from Salesforce to Google BigQuery using CData SSIS Components.
Easily push Salesforce data to Google BigQuery using the CData SSIS Tasks for Salesforce and Google BigQuery.
-
Integrate with Beeminder Data in JReport Designer
Create charts and reports based on Beeminder data in JReport Designer.
-
Automate Google Spanner Data Replication to SAP HANA
Use CData Sync to customize and automate Google Spanner data replication to SAP HANA.
-
Integrate LinkedIn Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to LinkedIn data and integrate live LinkedIn data into your Power Automate tasks.
-
Bidirectional Access to Reckon Accounts Hosted Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Reckon Accounts Hosted data in Filemaker Pro for Mac or Windows.
-
Access Live JSON Services in Excel 365 Online (Excel for the web)
Connect to JSON services from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Create Informatica Mappings From/To a JDBC Data Source for FHIR
Create FHIR data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Stack Exchange Data in RapidMiner
Integrate Stack Exchange data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Phoenix 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 Phoenix data.
-
How to create an RPA flow for Wistia Data in UiPath Studio
Use the Wistia ODBC Driver to create workflows that access real-time Wistia data without any coding.
-
Create Power BI Reports on Real-Time Avalara AvaTax Data
Use the CData ODBC Driver for Avalara AvaTax to visualize Avalara AvaTax data in Power BI Desktop.
-
Create Datasets from Moosend in Domo Workbench and Build Visualizations of Moosend Data in Domo
Use the CData Software ODBC Driver for Moosend to create datasets from Moosend data in Domo Workbench and then build visualizations in the Domo service.
-
Build Apps with Live Oracle Sales Data Using the Low-Code Development Platform of Mendix
Connect Oracle Sales data with Mendix to build apps using the CData JDBC Driver for Oracle Sales.
-
Build Automated Workflows with Live Blackbaud FE NXT Data in Workato
Use CData Connect AI to connect to live Blackbaud FE NXT data and build automated workflows in Workato.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Unbounce
Provide connectivity to Unbounce data through an SAP BusinessObjects universe.
-
Integrate QuickBooks Online with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate QuickBooks Online with External Services.
-
Integrate GraphQL Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live GraphQL data from Informatica Cloud.
-
Connect to Sage 300 Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Sage 300.
-
Create Informatica Mappings From/To an ODBC Data Source for Pinecone
Create an ODBC connection to Pinecone in Informatica and browse and transfer Pinecone data.
-
Connect to FTP in SpagoBI
Create reports featuring live FTP data in SpagoBI Studio. Host FTP reports on SpagoBI Server.
-
Use Dash to Build Web Apps on Salesforce Pardot Data via CData Connect AI
Build interactive Dash web apps on live Salesforce Pardot data using pandas and the CData Connect AI Python SDK.
-
Integrate with Discourse Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Discourse data to a JSON file on disk.
-
Create Dynamic Planio Grids Using the Infragistics XamDataGrid
Learn how you can connect Planio to Infragistics XamDataGrid to build dynamic grids.
-
Connect to SAP SuccessFactors LMS Data in ACL Analytics
Connect to SAP SuccessFactors LMS data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to SAP SuccessFactors LMS data.
-
Integrate Google Ads Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Google Ads data and integrate live Google Ads data into your Power Automate tasks.
-
Slack Reporting in OBIEE with the Slack JDBC Driver
Deploy the Slack JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous HCL Domino Replication to Amazon S3
Use CData Sync for automated, continuous, customizable HCL Domino replication to Amazon S3.
-
How to Connect the Power BI Service to LightSpeedRetail: Complete Guide
Connect to the CData Software Power BI Connector for LightSpeedRetail from PowerBI.com to provide real-time LightSpeedRetail data across the organization.
-
Publish Crystal Reports on Access Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Access data.
-
Getting Started with the CData Excel Add-In for HBase
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for HBase.
-
Integrate JotForm Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live JotForm data from Informatica Cloud.
-
Integrate Google Ad Manager with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Google Ad Manager with External Services.
-
Integrate Live REST Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live REST data to Blue Prism using the CData ODBC Driver for REST to create automated workflows for repetitive business tasks.
-
Integrating LlamaIndex with Freshservice Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Freshservice data in real time.
-
Enable the Tanda JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Tanda data.
-
Build MVC Applications with Connectivity to Raisers Edge NXT Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Raisers Edge NXT from an ASP.NET MVC application.
-
How to connect Amazon QuickSight to MongoDB Data
Create a connection to MongoDB data in CData Connect AI and insert MongoDB data into Amazon QuickSight SPICE to build interactive dashboards.
-
Build Voice Agents in ElevenLabs with access to Live HBase Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live HBase data.
-
Use the CData Software JDBC Driver for REST in MicroStrategy Desktop
Connect to REST data in MicroStrategy Desktop using the CData Software JDBC Driver for REST.
-
Replicate Multiple DocuSign Accounts via the CData Sync CLI
Replicate multiple DocuSign accounts to one or many databases.
-
Connect to MailerSend Data from a Connection Pool in Jetty
The MailerSend JDBC Driver supports connection pooling: This article shows how to connect faster to MailerSend data from Web apps in Jetty.
-
Connect to ZohoPeople Data in DBeaver
Use the CData ODBC Driver to connect to ZohoPeople data in DBeaver.
-
Use the CData Software JDBC Driver for Oracle HCM Cloud in MicroStrategy Desktop
Connect to Oracle HCM Cloud data in MicroStrategy Desktop using the CData Software JDBC Driver for Oracle HCM Cloud.
-
Create Informatica Mappings From/To a JDBC Data Source for OnePageCrm
Create OnePageCrm data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Visualize Live Sage 200 Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Sage 200 data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Square Data in ACL Analytics
Connect to Square data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Square data.
-
Integrate Live BambooHR Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to BambooHR data and integrate live BambooHR data into apps built in Microsoft Power Apps.
-
Query Bright Data Data in ColdFusion
Write standard ColdFusion data access code to connect to Bright Data data.
-
Use CData Connect AI to Access Notion Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Notion data in the Power Pivot business intelligence tool.
-
Explore Geographical Relationships in LaunchDarkly Data with Power Map
Create data visualizations with LaunchDarkly data in Power Map.
-
Integrate Trae with Live Avalara AvaTax Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Avalara AvaTax data from within the AI-powered IDE.
-
Automate Demio Data Replication to Azure Synapse
Use CData Sync to customize and automate Demio data replication to Azure Synapse.
-
Automated Continuous HDFS Replication to Databricks
Use CData Sync for automated, continuous, customizable HDFS replication to Databricks.
-
Integrating Codex with JotForm 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 PDFMonkey Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date PDFMonkey data.
-
Use the CData Software JDBC Driver for ShipEngine in MicroStrategy Desktop
Connect to ShipEngine data in MicroStrategy Desktop using the CData Software JDBC Driver for ShipEngine.
-
Automated Continuous ElevenLabs Replication to Amazon S3
Use CData Sync for automated, continuous, customizable ElevenLabs replication to Amazon S3.
-
Connect to Recurly Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Recurly data using standard SQL.
-
Automated Continuous Microsoft Ads Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Microsoft Ads replication to delimited files (CSV/TSV).
-
Create SSAS Tabular Models from SAS xpt Data
How to build a SQL Server Analysis Service Tabular Model from SAS xpt data using CData drivers.
-
Build a Simple VCL Application for Deel Data
How to build a simple VCL Application to view Deel data in RAD Studio using the CData ODBC Driver for Deel.
-
Integrating Boomi Agentstudio with EnterpriseDB Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to EnterpriseDB data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect to Campaigner Data in CloverDX (formerly CloverETL)
Transfer Campaigner data using the visual workflow in the CloverDX data integration tool.
-
Automated Continuous SpaceX Replication to AlloyDB
Use CData Sync for automated, continuous, customizable SpaceX replication to AlloyDB.
-
Build Teamgate-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Teamgate data.