CData Software - Knowledge Base
Recent Articles
-
Qualaroo Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Qualaroo facts in real time.
-
How to Easily Query Zoho CRM Data in OpenOffice Base
Connect to Zoho CRM data in OpenOffice Base using the CData ODBC Driver for Zoho CRM and generate reports with live data insights.
-
Connect to ZohoMarketingHub Data in DBeaver
Use the CData ODBC Driver to connect to ZohoMarketingHub in DBeaver.
-
Access Sybase Data from MySQL in PHP
Connect to Sybase through the standard MySQL libraries in PHP.
-
Publish Crystal Reports on Close Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Close.
-
Write a Simple Go Application to work with Google Analytics Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Google Analytics.
-
Connect to GitHub Data in Google Apps Script via Connect AI
Use CData Connect AI to access GitHub in Google Apps Script.
-
Build a Singer.io Tap for Gorgias With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Gorgias data using
-
Operational Reporting on Salesforce Data 360 Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Salesforce Data 360.
-
Use the CData Software JDBC Driver for LDAP in MicroStrategy Web
Connect to LDAP in MicroStrategy Web using the CData Software JDBC Driver for LDAP.
-
Visualize Live Blackbaud FE NXT Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Blackbaud FE NXT.
-
Add SAP Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SAP with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous Exact Online Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Exact Online replication to Apache Kafka.
-
Use Dash to Build to Web Apps on HBase Data
Create Python applications that use pandas and Dash to build HBase-connected web apps.
-
Build a Simple VCL Application for Rootly Data
How to build a simple VCL Application to view Rootly in RAD Studio using the CData ODBC Driver for Rootly.
-
Connect to Dynamics CRM Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Process & Analyze Sybase IQ Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Sybase IQ Data.
-
Build AI Agents with Google Search 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 Google Search through CData Connect AI.
-
Build Acumatica Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Acumatica ERP and build visualizations in Tableau.
-
Consume Google Search OData Feeds in PowerBuilder
This article demonstrates how to consume Google Search as OData feeds from PowerBuilder using the API Server.
-
Import Real-Time SAP Fieldglass Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SAP Fieldglass in ColdFusion.
-
Building Dynamic Web Pages with QuickBooks Data Using AngularJS
Create single-page applications with live connectivity to QuickBooks using the CData API Server.
-
Import Real-Time Azure Analysis Services Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Azure Analysis Services in ColdFusion.
-
How to work with Amplitude Data in Apache Spark using SQL
Access and process Amplitude Data in Apache Spark using the CData Software JDBC Driver.
-
Create Data Visualizations in Cognos BI with PivotalTracker Data
Access PivotalTracker as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Query LinkedIn Data in DataGrip
Create a Data Source for LinkedIn in DataGrip and use SQL to query live LinkedIn.
-
Model Marketo Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Marketo, enabling the direct import of real-time Marketo.
-
How to Connect to Live BambooHR Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live BambooHR without replication.
-
Replicate Epicor Kinetic Data to Multiple Databases
Replicate Epicor Kinetic to disparate databases with a point-and-click configuration.
-
Provide OData Services of Postmark Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Postmark by developing a WCF Service Application.
-
Automated Continuous Sage Intacct Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Sage Intacct replication to Azure SQL Database.
-
Build SAS Data Sets Visualizations in Tableau Cloud
Use CData Connect AI to connect to live SAS Data Sets and build visualizations in Tableau Cloud.
-
Visualize Live OneNote Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Microsoft OneNote.
-
Use the CData ODBC Driver for xBase in Microsoft Power Query
You can use the CData xBase ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import xBase into Microsoft Power Query.
-
Automate IBM Cloud Object Storage Data Replication to SAP HANA
Use CData Sync to customize and automate IBM Cloud Object Storage replication to SAP HANA.
-
Back Up Everhour to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Everhour data.
-
How to Connect Bullhorn CRM 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 Bullhorn CRM data in real time using natural language.
-
Integrate Open WebUI with Live Google Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Google Ads from within the chat interface.
-
Visualize Confluence 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 Atlassian Confluence into TIBCO Spotfire.
-
Connect to Gong Data in Jaspersoft Studio
Execute SQL to remote Gong in Jaspersoft Studio.
-
Connect to QuickBooks Time Data from a Connection Pool in Jetty
The QuickBooks Time JDBC Driver supports connection pooling: This article shows how to connect faster to QuickBooks Time from Web apps in Jetty.
-
Use the CData ODBC Driver for Sybase in Microsoft Power Query
You can use the CData Sybase ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Sybase into Microsoft Power Query.
-
Connect to HBase Data from PowerBuilder via ADO.NET
This article demonstrates how to access Apache HBase from Appeon PowerBuilder using the CData ADO.NET Provider for HBase.
-
Create Dynamic Outlook Grids Using the Infragistics XamDataGrid
Learn how you can connect Outlook to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Placid Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Placid in the Denodo Virtual DataPort Administrator.
-
Connect to Cosmos DB Data from a Connection Pool in Jetty
The Cosmos DB JDBC Driver supports connection pooling: This article shows how to connect faster to Azure Cosmos DB from Web apps in Jetty.
-
Build a Simple VCL Application for Factorial Data
How to build a simple VCL Application to view Factorial in RAD Studio using the CData ODBC Driver for Factorial.
-
Publish Reports with ZendeskSell Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ZendeskSell.
-
Moving Data from SharePoint Excel Services to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live SharePoint Excel Services data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to Connect to & Open MySQL Data in Microsoft Excel
This article uses the CData ODBC driver for MySQL to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrate Goose with Live Instagram Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Instagram from within the local AI agent.
-
How to Connect to Live Azure Data Lake Storage Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Azure Data Lake Storage through natural language.
-
Automated Continuous Greenplum Replication to Snowflake
Use CData Sync for automated, continuous, customizable Greenplum replication to Snowflake.
-
Connect to Reckon Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Reckon using standard SQL.
-
Establish a Live Connection with Azure DevOps Data using Tableau Bridge
The CData ODBC Driver for Azure DevOps enables you to integrate live Azure DevOps into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Connect to & Open Cassandra Data in Microsoft Excel
This article uses the CData ODBC driver for Cassandra to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrating Gumloop with FHIR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on FHIR within automated workflows.
-
Build GitHub-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to GitHub Data from Zoho Analytics and import live GitHub.
-
Automated Continuous ZohoPeople Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable ZohoPeople replication to Google Cloud SQL.
-
Build Data Flows from Microsoft Dataverse to SQL Server using SSIS
Easily back up Microsoft Dataverse (CDS) to SQL Server using the SSIS components for Microsoft Dataverse.
-
Automated Continuous Pipeliner CRM Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Pipeliner CRM replication to Apache Kafka.
-
Create Salesforce CRM Analytics-Connected Business Apps in AppSheet
Connect to Salesforce CRM Analytics Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Salesforce CRM Analytics.
-
Visualize Live Mixpanel Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Mixpanel using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automate BenchmarkEmail Data Replication to Couchbase
Use CData Sync to Customize and automate BenchmarkEmail replication to Couchbase.
-
Connect SharePoint Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Microsoft SharePoint using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automated Continuous Oracle HCM Cloud Replication to SQL Server
Use CData Sync for automated, continuous, customizable Oracle HCM Cloud replication to SQL Server.
-
PagerDuty Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on PagerDuty facts in real time.
-
Connect to eBay Data in Jaspersoft Studio
Execute SQL to remote eBay in Jaspersoft Studio.
-
Load Greenplum Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Pivotal GreenPlum to a database.
-
DataBind Facebook Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Facebook with the DevExpress Windows Forms and Web controls to provide Facebook to a chart.
-
Integrate Live Google Ads Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Migrating data from Pipeline CRM to Snowflake using CData SSIS Components.
Easily push Pipeline CRM to Snowflake using the CData SSIS Tasks for Pipeline CRM and Snowflake.
-
Connect to SAP Ariba Source Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SAP Ariba Source using standard SQL.
-
How to Connect the Power BI Service to LinkedIn: Complete Guide
Connect to the CData Software Power BI Connector for LinkedIn from PowerBI.com to provide real-time LinkedIn across the organization.
-
Integrate with live Act-On Data in Jitterbit
Use CData Connect AI to connect to and integrate live Act-On in Jitterbit.
-
Connect to Certinia Data in DBeaver
Use the CData ODBC Driver to connect to Certinia in DBeaver.
-
Access ZohoInvoice Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access ZohoInvoice from your Oracle system.
-
Integrate with Okta Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Okta in SnapLogic.
-
DataBind Controls to MariaDB Data in Delphi
DataBind to MariaDB in Delphi with standard data access components and controls.
-
Prepare, Blend, and Analyze SingleStore Data in Alteryx Designer (ODBC)
Build workflows to access live SingleStore for self-service data analytics.
-
Replicate MailerLite Data to Multiple Databases
Replicate MailerLite to disparate databases with a point-and-click configuration.
-
How to Connect to & Open Attio Data in Microsoft Excel
This article uses the CData ODBC driver for Attio to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Access Live Unbounce Data in AWS Lambda
Connect to live Unbounce in AWS Lambda using the CData JDBC Driver.
-
Create Apps from MYOB AccountRight Data in Qlik Sense Cloud
Use CData Connect AI to connect to MYOB AccountRight Data and build apps from live MYOB AccountRight in Qlik Sense Cloud.
-
Create Data Visualizations in Cognos BI with Dynamics 365 Data
Access Microsoft Dynamics 365 as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create Reports with Workday Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Workday.
-
Import Azure Data Lake Storage Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Azure Data Lake Storage Data and provide access to live Azure Data Lake Storage for custom reports in the Power BI Service.
-
Getting Started with the CData JDBC Driver for Wave Financial
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Wave Financial.
-
Query LaunchDarkly Data in ColdFusion
Write standard ColdFusion data access code to connect to LaunchDarkly.
-
Add DB2 Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for DB2 with the Informatica Enterprise Data Catalog to classify and organize data.
-
Create Freshservice-Connected Dashboards in Grafana
Connect to Freshservice Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Freshservice.
-
Connect to PDFMonkey Data as an External Source in Dremio
Use the CData JDBC Driver to connect to PDFMonkey as an External Source in Dremio.
-
Automated Continuous ZohoSubscriptions Replication to SingleStore
Use CData Sync for automated, continuous, customizable ZohoSubscriptions replication to SingleStore.
-
Automated Continuous GraphQL Replication to SQLite
Use CData Sync for automated, continuous, customizable GraphQL replication to SQLite.
-
How to Access Confluence Data Using Entity Framework
This article shows how to access Atlassian Confluence using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Act-On from Asprova with CData Software ODBC Driver for Act-On
This article shows how to connect faster to Act-On data from Asprova.
-
Create Power BI Reports on Real-Time Basecamp Data
Use the CData ODBC Driver for Basecamp to visualize Basecamp in Power BI Desktop.
-
Use the CData Software ODBC Driver for Reckon in MicroStrategy Web
Connect to Reckon in MicroStrategy Web using the CData Software ODBC Driver for Reckon.
-
Connect to Salesforce Data in DBArtisan
Use wizards in DBArtisan to configure Salesforce & Force.com as a data source.
-
Connect Odoo to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Odoo with IBM WebSphere for seamless data integration and connectivity.