CData Software - Knowledge Base
Recent Articles
-
Use the CData ODBC Driver for Google Cloud Storage from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Google Cloud Storage to connect to Google Cloud Storage from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Google Cloud Storage in Excel.
-
Visualize Coda Data in Tableau
The CData ODBC driver for Coda enables you integrate Coda into Tableau dashboards.
-
Publish Crystal Reports on Shopify Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Shopify.
-
Use CData Connect AI to Access Neo4J Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Neo4J in the Power Pivot business intelligence tool.
-
How to Query Sage 200 Data in MySQL Workbench
Execute MySQL queries against live Sage 200 from MySQL Workbench.
-
Access Egnyte Data from MySQL in PHP
Connect to Egnyte through the standard MySQL libraries in PHP.
-
Integrating Claude Code with Sybase Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Sybase within assisted coding and automated development workflows.
-
Create Power BI Reports on Real-Time Active Directory Data
Use the CData ODBC Driver for Active Directory to visualize Active Directory in Power BI Desktop.
-
Migrating data from ZeroBounce to Google BigQuery using CData SSIS Components.
Easily push ZeroBounce to Google BigQuery using the CData SSIS Tasks for ZeroBounce and Google BigQuery.
-
Connect Customer.io to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Customer.io with IBM WebSphere for seamless data integration and connectivity.
-
Query Dynamics CRM Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Dynamics CRM entities in PHP by modeling them as objects.
-
Integrating Dataiku with SAP Hybris C4C Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live SAP Hybris C4C.
-
Using the CData Software ODBC Driver for Microsoft Entra ID in PyCharm
Connect to Microsoft Entra ID as an ODBC data source in PyCharm using the CData Software ODBC Driver for Microsoft Entra ID.
-
Integrate HCL Domino Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to HCL Domino and integrate live HCL Domino into your Power Automate tasks.
-
Migrating data from Mistral AI to Snowflake using CData SSIS Components.
Easily push Mistral AI to Snowflake using the CData SSIS Tasks for Mistral AI and Snowflake.
-
Automated Continuous Paylocity Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Paylocity replication to PostgreSQL.
-
LINQ to Teamgate Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Teamgate Data Provider.
-
Automated Continuous LinkedIn Ads Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable LinkedIn Ads replication to Amazon Redshift.
-
Publish Gong-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Gong.
-
Connect to YouTube Analytics Data in DBArtisan
Use wizards in DBArtisan to configure YouTube Analytics as a data source.
-
Rapidly Develop PDFMonkey-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by PDFMonkey.
-
Visualize Insightly Data in Sisense
Create an ElastiCube in Sisense app with access to Insightly.
-
Bidirectional Access to Clari Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Clari in Filemaker Pro for Mac or Windows.
-
Analyze Guru Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Guru with the CData JDBC Driver for Guru.
-
Replicate Datadog Data in Heroku for Use in Salesforce Connect
Replicate Datadog to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrate Salesloft with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Salesloft with External Services.
-
Create Informatica Mappings From/To an ODBC Data Source for HubSpot
Create an ODBC connection to HubSpot in Informatica and browse and transfer HubSpot.
-
Build Microsoft Teams Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Microsoft Teams and build visualizations in Tableau Cloud.
-
How to Query Reckon Accounts Hosted Data in MySQL Workbench
Execute MySQL queries against live Reckon Accounts Hosted from MySQL Workbench.
-
Build Avro-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Avro Data and create custom apps in Bubble.
-
How to Query Live Paymo Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Paymo data in natural language using Python.
-
DataBind Monday.com Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Monday.com with the DevExpress Windows Forms and Web controls to provide Monday.com to a chart.
-
Connect and Visualize Live Dynamics 365 Business Central Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Dynamics 365 Business Central into the Databricks platform and create visualization dashboards with real-time Dynamics 365 Business Central.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Pipedrive
Provide connectivity to Pipedrive through an SAP BusinessObjects universe.
-
Moving Data from Sendwithus to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Sendwithus data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to CouchDB Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Apache CouchDB from Filemaker Pro on Mac.
-
Automated Microsoft OneLake Data Replication to Teradata
Use CData Sync to Customize and automate Microsoft OneLake replication to Teradata.
-
Build Twitter Ads-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Twitter Ads to explore live Twitter Ads Data in Cursor to assist with building Twitter Ads-powered applications.
-
Getting Started with the CData ADO.NET Provider for Hubstaff
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Getting Started with the CData Tableau Connector for Google Cloud Storage
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Google Cloud Storage.
-
Getting Started with the CData ADO.NET Provider for Elorus
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Creating Gmail-Connected Applications in Unqork
You can use CData Connect AI to feed Gmail to Unqork and build custom business apps.
-
Integrate Dynamics NAV Data in the Pentaho Report Designer
Publish reports based on Microsoft Dynamics NAV in the Pentaho BI tool.
-
Automate Azure Analysis Services Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Azure Analysis Services and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Moving Data from Excel to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Excel data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to Work with DocuSign Data in ETL Validator JDBC
Connect to DocuSign from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Printify Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Printify and work with Printify in your FileMaker applications.
-
Integrating CircleCI Data in Talend Cloud Data Management Platform
Connect CircleCI Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Connect to Hubstaff Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Hubstaff and the SQL Gateway to access Hubstaff from Google Apps Script.
-
Connect to Live Presto Data in MicroStrategy through CData Connect AI
Create a live connection to Presto Data in CData Connect AI and connect to your Presto from MicroStrategy.
-
Visualize Lakebase Data in Sisense
Create an ElastiCube in Sisense app with access to Lakebase.
-
Back Up SAP SuccessFactors LMS to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SAP SuccessFactors LMS. In this article, we will employ an SSIS workflow to populate a database with SAP SuccessFactors LMS data.
-
Viewing Humanity Data in RAD Studio Data Explorer
How to view Humanity in RAD Studio Data Explorer using the CData ODBC Driver for Humanity.
-
Connect to SAP Ariba Source 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 SAP Ariba Source.
-
Create Apps from Apollo Data in Qlik Sense Cloud
Use CData Connect AI to connect to Apollo Data and build apps from live Apollo in Qlik Sense Cloud.
-
Use Grok to Talk to Your IBM Cloud Object Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your IBM Cloud Object Storage for you.
-
How to Query Live Neo4J Data in Perplexity MacOS Desktop
Connect to and query live Neo4J Data in Perplexity Desktop using CData MCP Server.
-
Analyze Google Search Results in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Google Search and visualize live Google Search in Infragistics Reveal.
-
Connect to OneNote Data in Ruby
Connect to Microsoft OneNote in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous SendGrid Replication to IBM DB2
Use CData Sync for automated, continuous, customizable SendGrid replication to IBM DB2.
-
Connect Aha! to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Aha! with IBM WebSphere for seamless data integration and connectivity.
-
Create ActiveCampaign Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time ActiveCampaign data access from reports, embedded analytics, and more.
-
Create Dynamic Auth0 Grids Using the Infragistics XamDataGrid
Learn how you can connect Auth0 to Infragistics XamDataGrid to build dynamic grids.
-
Integrate Cline with Live eBay Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live eBay from within your IDE.
-
Migrating data from Greenhouse to Databricks using CData SSIS Components.
Easily push Greenhouse to Databricks using the CData SSIS Tasks for Greenhouse and Databricks.
-
Automate Nethunt Data Replication to Azure Data Lake
Use CData Sync to customize and automate Nethunt replication to Azure Data Lake.
-
How to Connect to Adobe Commerce Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Adobe Commerce. Leverage the pyodbc module for ODBC in Python.
-
Explore Geographical Relationships in SQL Server Data with Power Map
Create data visualizations with Microsoft SQL Server in Power Map.
-
Use Biml to Build SSIS Tasks to Replicate Wistia Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Wistia to SQL Server.
-
Connect to Moosend Data from PowerBuilder via JDBC
This article demonstrates how to access Moosend from PowerBuilder using the Moosend JDBC Driver.
-
Creating QuickBooks Online-Connected Applications in Unqork
You can use CData Connect AI to feed QuickBooks Online to Unqork and build custom business apps.
-
Add Google Search Results to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Google Search with the Informatica Enterprise Data Catalog to classify and organize data.
-
Build Apps with Live QuickBooks Online in Adalo using CData Connect AI
Use CData Connect AI to integrate live QuickBooks Online into the Adalo platform and build custom mobile and web applications with real-time QuickBooks Online.
-
Integrate BambooHR with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate BambooHR with External Services.
-
Automated Continuous Optimizely Replication to Vertica
Use CData Sync for automated, continuous, customizable Optimizely replication to Vertica.
-
Automated Continuous Freshservice Replication to MongoDB
Use CData Sync for automated, continuous, customizable Freshservice replication to MongoDB.
-
Automated Continuous NetSuite SuiteAnalytics Replication to SingleStore
Use CData Sync for automated, continuous, customizable NetSuite SuiteAnalytics replication to SingleStore.
-
DataBind Controls to Demio Data in C++Builder
DataBind to Demio in C++Builder with standard components and controls.
-
Moving Data from JobNimbus to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live JobNimbus data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Getting Started with the CData ADO.NET Provider for MailerLite
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live IBM DB2 within intelligent workflows.
-
Create Parquet Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Parquet data access from reports, embedded analytics, and more.
-
Integrate Live Discord Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Discord to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Bridge Google Directory Connectivity with Apache NiFi
Access and process Google Directory in Apache NiFi using the CData JDBC Driver.
-
Viewing Zoho Inventory Data in RAD Studio Data Explorer
How to view Zoho Inventory in RAD Studio Data Explorer using the CData ODBC Driver for Zoho Inventory.
-
Use Databricks Agent Bricks to Talk to Your Epicor Kinetic Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Epicor Kinetic for you.
-
Automate Jira Assets Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Jira Assets from PowerShell? This article demonstrates how to utilize the Jira Assets Cmdlets for tasks like connecting to Jira Assets, automating operations, downloading data, and more.
-
Connect to eBay Analytics Data in JRuby
Create a simple JRuby app with access to live eBay Analytics.
-
How to Create Power BI Visual Reports with Real-Time Bright Data Data
Use CData Power BI Connectors to visualize Bright Data in Power BI.
-
Feed Access Data into FineReport
How to set Microsoft Access as a JDBC data source in FineReport.
-
Natively Connect to Workable Data in PHP
The CData ODBC driver for Workable enables you to create PHP applications with connectivity to Workable. Leverage the native support for ODBC in PHP.
-
Replicate Multiple AlloyDB Accounts
Replicate multiple AlloyDB accounts to one or many databases.
-
Query SAP ByDesign Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume SAP ByDesign entities in PHP by modeling them as objects.
-
Explore Geographical Relationships in Bullhorn CRM Data with Power Map
Create data visualizations with Bullhorn CRM in Power Map.
-
DataBind Controls to Dynamics 365 Data in C++Builder
DataBind to Microsoft Dynamics 365 in C++Builder with standard components and controls.
-
Create ServiceNow-Connected Business Apps in AppSheet
Connect to ServiceNow Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to ServiceNow.
-
Integrate Goose with Live Adobe Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Adobe Analytics from within the local AI agent.
-
Work with Outlook Data in FoxPro
Load Outlook into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to use SQLAlchemy ORM to access Toggl Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Toggl.
-
Connect to eBay Analytics Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for eBay Analytics to connect to eBay Analytics and execute queries in PowerBuilder.