CData Software - Knowledge Base
Recent Articles
-
How to Connect the Power BI Service to Hubstaff: Complete Guide
Connect to the CData Software Power BI Connector for Hubstaff from PowerBI.com to provide real-time Hubstaff across the organization.
-
Connect to Real-Time Beeminder Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Beeminder in Power Apps.
-
Use the CData Software ODBC Driver for Teamgate in SAS for Real-Time Reporting and Analytics
Connect to real-time Teamgate in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Teamgate.
-
Integrating Antigravity CLI with Exact Online via CData CLI
Connect Exact Online to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to integrate XML with Apache Airflow
Access and process XML Files in Apache Airflow using the CData JDBC Driver.
-
Import Real-Time Dynamics CRM Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Microsoft Dynamics CRM in ColdFusion.
-
How to Create Power BI Visual Reports with Real-Time ClickTime Data
Use CData Power BI Connectors to visualize ClickTime in Power BI.
-
Access Live Elorus Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Elorus into the statistical analysis tools available in SAS JMP. This article shows how to use Elorus in the Graph Builder and Query Builder.
-
Connect to Productboard Data from a Connection Pool in JBoss
Integrate Productboard into Java servlets: Use the Management Console in JBoss to install the Productboard JDBC Driver.
-
Integrate Real-Time Access to RSS in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to RSS Feeds in real time.
-
ETL Microsoft Entra ID in Oracle Data Integrator
This article shows how to transfer Microsoft Entra ID into a data warehouse using Oracle Data Integrator.
-
Integrate Live Samanage Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Samanage to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect and Visualize Live Cvent Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Cvent into the Databricks platform and create visualization dashboards with real-time Cvent.
-
Feed Freshsales Data into FineReport
How to set Freshsales as a JDBC data source in FineReport.
-
Automated Continuous SAP Ariba Source Replication to Amazon S3
Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to Amazon S3.
-
Use the CData Software ODBC Driver for Neo4J in MicroStrategy
Connect to Neo4J in MicroStrategy Developer using the CData Software ODBC Driver for Neo4J.
-
How to connect SharePoint with Oracle Data through external lists
Provide Oracle Database to SharePoint users as an external list.
-
Visualize Live Placid Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Placid.
-
Work with Cvent Data in FoxPro
Load Cvent into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build ShipEngine-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to ShipEngine and build web apps with connectivity to live ShipEngine.
-
Use Microsoft Copilot Studio to talk to your Cassandra Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Apache Cassandra for you.
-
Create Informatica Mappings From/To a JDBC Data Source for Mocean
Create Mocean data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to use SQLAlchemy ORM to access Google Contacts Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Google Contacts.
-
Access Live Quickbase Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Quickbase from your Excel spreadsheets.
-
Write a Simple Go Application to work with Eventbrite Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Eventbrite.
-
Design BIRT Reports on Shortcut Data
Provide current Shortcut to your embedded analytics.
-
Operational Reporting on Toggl Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Toggl.
-
Create Webflow Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Webflow from PowerBI.com to create Power BI Dataflows with real-time data.
-
Query, Visualize, and Share live Redis Data in Redash
Use CData Connect AI to connect to live Redis in Redash for querying, visualizing, and sharing.
-
Working with Greenhouse Data in LINQPad
Execute LINQ queries to Greenhouse in LINQPad.
-
Choosing the Best Method to Connect Kintone to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Kintone from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrate Live Elasticsearch Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Elasticsearch and integrate live Elasticsearch into apps built in Microsoft Power Apps.
-
Connect to Float Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Float in the Denodo Virtual DataPort Administrator.
-
Integrate Cvent Data in Pentaho Data Integration
Build ETL pipelines based on Cvent in the Pentaho Data Integration tool.
-
Automate Microsoft Teams Data Replication to Couchbase
Use CData Sync to Customize and automate Microsoft Teams replication to Couchbase.
-
Query PostgreSQL Data as a MySQL Database in Node.js
Execute MySQL queries against PostgreSQL from Node.js.
-
Use the CData Software ODBC Driver for Cvent in MicroStrategy Web
Connect to Cvent in MicroStrategy Web using the CData Software ODBC Driver for Cvent.
-
Create Quickbase-Connected Business Apps in AppSheet
Connect to Quickbase Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Quickbase.
-
Use the CData ODBC Driver for Exact Online from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Exact Online to connect to Exact Online from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Exact Online in Excel.
-
Use the CData API Server to Access MailChimp Data in Microsoft PowerPivot
Use the CData API Server to connect to live MailChimp in the Power Pivot business intelligence tool.
-
Use Agno to Talk to Your Monday.com 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 Monday.com for you.
-
Connect to Aweber Data in DBArtisan
Use wizards in DBArtisan to configure Aweber as a data source.
-
Create Apps from SAP SuccessFactors Data in Qlik Sense Cloud
Use CData Connect AI to connect to SAP SuccessFactors Data and build apps from live SAP SuccessFactors in Qlik Sense Cloud.
-
Access Live Sage Cloud Accounting Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Sage Business Cloud Accounting through MCP integration.
-
Stream Browserless Data into Apache Kafka Topics
Access and stream Browserless in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Access Postmark Data from MySQL in PHP
Connect to Postmark through the standard MySQL libraries in PHP.
-
A PostgreSQL Interface for Google Search Results using the CData ODBC Driver
Use the SQL Gateway and Google Search ODBC Driver to create a PostgreSQL entry-point for data access.
-
Create Power BI Reports on Real-Time Klaviyo Data
Use the CData ODBC Driver for Klaviyo to visualize Klaviyo in Power BI Desktop.
-
Connect to Splunk Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Splunk in Airbyte.
-
Manage Confluence Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Confluence.
-
Build Apps with Live ADP Data Using the Low-Code Development Platform of Mendix
Connect ADP with Mendix to build apps using the CData JDBC Driver for ADP.
-
Connect to YouTube Analytics Data in Aqua Data Studio
Access YouTube Analytics from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build Microsoft Planner-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Microsoft Planner.
-
Migrating data from Delighted to Databricks using CData SSIS Components.
Easily push Delighted to Databricks using the CData SSIS Tasks for Delighted and Databricks.
-
Create HelloSign Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time HelloSign data access from reports, embedded analytics, and more.
-
Build IBM Informix-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for IBM Informix to explore live IBM Informix Data in Cursor to assist with building IBM Informix-powered applications.
-
Analyze Contentful Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Contentful with the CData JDBC Driver for Contentful.
-
Use the CData Software ODBC Driver for Pinecone in SAS for Real-Time Reporting and Analytics
Connect to real-time Pinecone in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Pinecone.
-
Automated Continuous RSS Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable RSS replication to Google BigQuery.
-
Publish Bullhorn CRM-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Bullhorn CRM.
-
How to Build an ETL App for Hive Data in Python with CData Connect AI
Build ETL pipelines that read and write live Apache Hive in Python with petl and the CData Connect AI Python SDK.
-
Integrate with live Jira Data in Jitterbit
Use CData Connect AI to connect to and integrate live Atlassian Jira in Jitterbit.
-
Automate OData Services Replication to Couchbase
Use CData Sync to Customize and automate OData replication to Couchbase.
-
How to create Visio diagrams from Snowflake Data
Automatically update Snowflake with the changes you make to Visio master shapes.
-
Build MVC Applications with Connectivity to Presto Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Presto from an ASP.NET MVC application.
-
Integrate with Attio Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Attio to a JSON file on disk.
-
DataBind Controls to LaunchDarkly Data in Delphi
DataBind to LaunchDarkly in Delphi with standard data access components and controls.
-
Natively Connect to ServiceDesk Plus Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to ServiceDesk Plus. Leverage the native support for ODBC in PHP.
-
Connect to Zoom Data from Crystal Reports
Use CData Connect AI to connect to and report on live Zoom from Crystal Reports.
-
Integrate FreshBooks Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to FreshBooks and integrate live FreshBooks into your Power Automate tasks.
-
How to use SQLAlchemy ORM to access Google Campaign Manager 360 Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Google Campaign Manager 360.
-
Connect to Contentful Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Contentful in the Denodo Virtual DataPort Administrator.
-
Access Egnyte Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Egnyte from your Oracle system.
-
Migrating data from Presto to Snowflake using CData SSIS Components.
Easily push Presto to Snowflake using the CData SSIS Tasks for Presto and Snowflake.
-
Build Apps with Live Okta Data Using the Low-Code Development Platform of Mendix
Connect Okta with Mendix to build apps using the CData JDBC Driver for Okta.
-
Automated Continuous Quickbase Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Quickbase replication to Apache Cassandra.
-
Connect to and Visualize Live GitHub Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live GitHub.
-
Create Dynamic ClickTime Grids Using the Infragistics XamDataGrid
Learn how you can connect ClickTime to Infragistics XamDataGrid to build dynamic grids.
-
Bidirectional Access to SingleStore Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate SingleStore in Filemaker Pro for Mac or Windows.
-
DataBind Controls to CloudConvert Data in Delphi
DataBind to CloudConvert in Delphi with standard data access components and controls.
-
Getting Started with the CData Power BI Connector for Mistral AI
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Create SAP Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SAP data access from reports, embedded analytics, and more.
-
Automate Egnyte Data Replication to Azure Synapse
Use CData Sync to customize and automate Egnyte replication to Azure Synapse.
-
Create Data Visualizations in Cognos BI with Google Analytics Data
Access Google Analytics as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Automated Continuous Pipeline CRM Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Pipeline CRM replication to Apache Kafka.
-
Automate Authorize.Net Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Authorize.Net and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
How to Access Webex Data Using Entity Framework
This article shows how to access Webex using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Use the CData Software JDBC Driver for Zoho Books in MicroStrategy Desktop
Connect to Zoho Books in MicroStrategy Desktop using the CData Software JDBC Driver for Zoho Books.
-
Create Reports from Google Directory Data in Looker Studio
Use CData Connect AI to gain access to live Google Directory and create custom reports in Looker Studio.
-
Campaigner Reporting in OBIEE with the Campaigner JDBC Driver
Deploy the Campaigner JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Power BI XMLA Data in Jaspersoft Studio
Execute SQL to remote Power BI XMLA in Jaspersoft Studio.
-
Work with Live Salesforce Data in Power Query
Use CData Connect AI to connect to Salesforce & Force.com and work with live Salesforce & Force.com in Microsoft Power Query.
-
Automate Insightly Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Insightly from PowerShell? This article demonstrates how to utilize the Insightly Cmdlets for tasks like connecting to Insightly, automating operations, downloading data, and more.
-
Natively Connect to Bitbucket Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Bitbucket. Leverage the native support for ODBC in PHP.
-
Query Live Lakebase 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 Lakebase directly from the development environment.
-
Connect and Visualize Live Amazon S3 Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Amazon S3 into the Databricks platform and create visualization dashboards with real-time Amazon S3.
-
Integrate Live Mixpanel Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Mixpanel to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Automated Continuous Zoho Inventory Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Zoho Inventory replication to Apache Cassandra.
-
Access Live Basecamp Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Basecamp data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Connect to Live Sage 200 Data in MicroStrategy through CData Connect AI
Create a live connection to Sage 200 Data in CData Connect AI and connect to your Sage 200 from MicroStrategy.