CData Software - Knowledge Base
Recent Articles
-
Deploy the ADO.NET Provider for Microsoft Exchange on an SSRS Report Server
Connect to Microsoft Exchange from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Connect to Avalara AvaTax in DBArtisan
Use wizards in DBArtisan to configure Avalara AvaTax as a data source.
-
How to use SQLAlchemy ORM to access Authorize.Net in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Authorize.Net.
-
Access Live SAP ByDesign in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live SAP Business ByDesign from your Excel spreadsheets.
-
Replicate Dynamics NAV in Heroku for Use in Salesforce Connect
Replicate Microsoft Dynamics NAV to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Facebook from PowerBuilder via ADO.NET
This article demonstrates how to access Facebook from Appeon PowerBuilder using the CData ADO.NET Provider for Facebook.
-
Using the CData Software ODBC Driver for Google Contacts in PyCharm
Connect to Google Contacts as an ODBC data source in PyCharm using the CData Software ODBC Driver for Google Contacts.
-
Build Apps with Live Amazon S3 in Adalo using CData Connect AI
Use CData Connect AI to integrate live Amazon S3 into the Adalo platform and build custom mobile and web applications with real-time Amazon S3.
-
Build Semantic Layer Views for Shopify in APOS Live Data Gateway
Use the CData Connector for Shopify in APOS Live Data Gateway to build Semantic Layer Views for Shopify.
-
Configure the CData JDBC Driver for Facebook in a Connection Pool in Tomcat
Connect to Facebook from a connection pool in Tomcat.
-
Import Real-Time SendGrid via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SendGrid in ColdFusion.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live MongoDB within intelligent workflows.
-
Creating OData-Connected Applications in Unqork
You can use CData Connect AI to feed OData to Unqork and build custom business apps.
-
Automate SAP Concur Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live SAP Concur and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Use the CData Software JDBC Driver for Dynamics CRM in MicroStrategy Desktop
Connect to Microsoft Dynamics CRM in MicroStrategy Desktop using the CData Software JDBC Driver for Dynamics CRM.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Azure DevOps
Provide connectivity to Azure DevOps through an SAP BusinessObjects universe.
-
How to Connect to Live MongoDB 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 MongoDB through natural language.
-
Integrate Zoho Creator in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Zoho Creator from Informatica Cloud.
-
Access Live Invoiced in Coginiti Pro
Connect to and query live Invoiced from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Validate Azure Data Catalog with QuerySurge
Access and validate Azure Data Catalog in QuerySurge using the CData JDBC Driver.
-
Build Adobe Analytics-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Adobe Analytics.
-
Add Google Directory to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Google Directory with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Connect to Live SendGrid from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your SendGrid for you.
-
Build Pipelines with Live Acumatica in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Acumatica from Google Cloud Data Fusion, enabling the integration of live Acumatica ERP into the building and management of effective data pipelines.
-
Connect to Google Sheets from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Google Sheets using standard SQL.
-
Excel Spreadsheet Automation on Zoho Creator with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Query, Visualize, and Share live MariaDB in Redash
Use CData Connect AI to connect to live MariaDB in Redash for querying, visualizing, and sharing.
-
Integrate with Live SAP BusinessObjects BI in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to SAP BusinessObjects BI from the MuleSoft Anypoint Platform to integrate live SAP BusinessObjects BI into custom reports and dashboards.
-
How to Connect to Live Microsoft Teams from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Microsoft Teams for you.
-
Access Live Gmail in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Gmail from your Google Sheets.
-
Perform Batch Operations with Jira Service Management in Apache NiFi
Connect to Atlassian Jira Service Management and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Connect to FHIR from a Connection Pool in JBoss
Integrate FHIR into Java servlets: Use the Management Console in JBoss to install the FHIR JDBC Driver.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Apache Hive using the Model Context Protocol.
-
Build MVC Applications with Connectivity to Aha
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Aha from an ASP.NET MVC application.
-
Publish Crystal Reports on Oracle SCM
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Oracle SCM.
-
How to Access Adobe Target Using Entity Framework
This article shows how to access Adobe Target using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Easily Integrate MailChimp in Lazarus Pascal IDE
Learn how to easily integrate live MailChimp in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Access Live SAP HANA in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SAP HANA into the statistical analysis tools available in SAS JMP. This article shows how to use SAP HANA in the Graph Builder and Query Builder.
-
Build Azure Analysis Services-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Azure Analysis Services from Zoho Analytics and import live Azure Analysis Services.
-
How to create Visio diagrams from SAP SuccessFactors
Automatically update SAP SuccessFactors with the changes you make to Visio master shapes.
-
Analyze Highrise in R via JDBC
Use standard R functions and the development environment of your choice to analyze Highrise CRM with the CData JDBC Driver for Highrise.
-
Query OData Services using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume OData entities in PHP by modeling them as objects.
-
Integrate LinkedIn Ads in Pentaho Data Integration
Build ETL pipelines based on LinkedIn Ads in the Pentaho Data Integration tool.
-
Build Gmail-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Gmail.
-
Create Informatica Mappings From/To an ODBC Data Source for Monday.com
Create an ODBC connection to Monday.com in Informatica and browse and transfer Monday.com.
-
Model Shopify Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Shopify, enabling the direct import of real-time Shopify.
-
Build Email-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Email and build web apps with connectivity to live Email.
-
Connect to and Query Sage 200 in QlikView over ODBC
Create data visualizations with Sage 200 in QlikView.
-
Validate Twilio with QuerySurge
Access and validate Twilio in QuerySurge using the CData JDBC Driver.
-
How to Connect to Live Shopify from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Shopify for you.
-
Build Vault CRM-Connected Apps in Choreo
Use CData Connect AI to connect to Vault CRM from Choreo and build custom apps using live Veeva Vault & Vault CRM.
-
Access Live Reckon in Coginiti Pro
Connect to and query live Reckon from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Rapidly Develop ServiceNow-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
Create a Data Access Object for Snapchat Ads using JDBI
A brief overview of creating a SQL Object API for Snapchat Ads in JDBI.
-
Access Live CockroachDB in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live CockroachDB from your Excel spreadsheets.
-
Automated Continuous Drift Replication to Snowflake
Use CData Sync for automated, continuous, customizable Drift replication to Snowflake.
-
How to Access Sybase IQ Using Entity Framework
This article shows how to access Sybase IQ using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Sage Intacct as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Sage Intacct.
-
How to Work with Jira Service Management in ETL Validator JDBC
Connect to Jira Service Management from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Hive in Google Apps Script via Connect AI
Use CData Connect AI to access Apache Hive in Google Apps Script.
-
How to connect PolyBase to WordPress
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live WordPress.
-
Write a Simple Go Application to work with SAP HANA XS Advanced on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SAP HANA XS Advanced.
-
Connect to SendGrid in Ruby
Connect to SendGrid in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Publish WordPress-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live WordPress.
-
Replicate Multiple Amazon S3 Accounts via the CData Sync CLI
Replicate multiple Amazon S3 accounts to one or many databases.
-
Publish Reports with Redshift in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Amazon Redshift.
-
Import Sugar CRM into the Power BI Service for Visualizations
Use CData Connect AI to connect to Sugar CRM and provide access to live Sugar CRM for custom reports in the Power BI Service.
-
Consume RSS OData Feeds in SAP Lumira
Use the API Server to create data visualizations on RSS feeds that reflect any changes in SAP Lumira.
-
Connect SQL Server to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Microsoft SQL Server using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
View Reports on Real-Time Databricks in Power BI Report Server
Use the CData ODBC Driver for Databricks to visualize Databricks in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Connect to Live Freshdesk Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Freshdesk securely in real time.
-
Write a Simple Go Application to work with ClickUp on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to ClickUp.
-
Create Data Visualizations Based On MySQL in Mode
Use CData Connect AI to connect to MySQL from Mode and build visualizations using live
-
Use Azure AI Foundry to Talk to Your Google Spanner via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Google Spanner for you.
-
Connect to DocuSign from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for DocuSign to connect to DocuSign and execute queries in PowerBuilder.
-
Use the CData Software JDBC Driver for Square in MicroStrategy Desktop
Connect to Square in MicroStrategy Desktop using the CData Software JDBC Driver for Square.
-
Use the CData Software JDBC Driver for Avalara AvaTax in MicroStrategy
Connect to Avalara AvaTax in MicroStrategy Developer using the CData Software JDBC Driver for Avalara AvaTax.
-
How to Visualize Phoenix Data in Python with pandas
Use pandas and other modules to analyze and visualize live Apache Phoenix in Python.
-
Connect to Tally from a Connection Pool in Jetty
The Tally JDBC Driver supports connection pooling: This article shows how to connect faster to Tally ERP from Web apps in Jetty.
-
Use the CData ODBC Driver for SurveyMonkey in Microsoft Power Query
You can use the CData SurveyMonkey ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SurveyMonkey into Microsoft Power Query.
-
Connect to Presto in Google Apps Script via Connect AI
Use CData Connect AI to access Presto in Google Apps Script.
-
A Comparison of Database Drivers for MySQL
A performance comparison of the CData JDBC & ODBC Drivers for MySQL and the native MySQL Connector/J & Connector/ODBC (updated May 2020)
-
Create Dynamic ClickUp Grids Using the Infragistics XamDataGrid
Learn how you can connect ClickUp to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Dynamics NAV in RazorSQL
Connect to Dynamics NAV from wizards and query Microsoft Dynamics NAV from the GUI in the RazorSQL database management tool.
-
Query IBM Informix as a SQL Server Database in Node.js
Execute SQL Server queries against IBM Informix from Node.js.
-
Prepare, Blend, and Analyze ConstantContact in Alteryx Designer (ODBC)
Build workflows to access live ConstantContact for self-service data analytics.
-
Build Pipelines with Live Adobe Analytics in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Adobe Analytics from Google Cloud Data Fusion, enabling the integration of live Adobe Analytics into the building and management of effective data pipelines.
-
Create Reports from Google Search Results in Looker Studio
Use CData Connect AI to gain access to live Google Search and create custom reports in Looker Studio.
-
Integrate with live Bullhorn CRM in Jitterbit
Use CData Connect AI to connect to and integrate live Bullhorn CRM in Jitterbit.
-
Automated Continuous Basecamp Replication to SingleStore
Use CData Sync for automated, continuous, customizable Basecamp replication to SingleStore.
-
Integrate Live Shopify into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Shopify from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Shopify.
-
Build WordPress-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to WordPress and build web apps with connectivity to live WordPress.
-
Use JayDeBeApi to access SAP Fieldglass in Python
Use standard Python scripting and the development environment of your choice to access live SAP Fieldglass.
-
How to Connect to Live Spark from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Apache Spark SQL for you.
-
Build Raisers Edge NXT Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Raisers Edge NXT and build visualizations in Tableau.
-
Connect to IBM Cloud Object Storage in RapidMiner
Integrate IBM Cloud Object Storage with standard components and data source configuration wizards in RapidMiner Studio.
-
How to connect and process Box from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Box.
-
Connect to BigCommerce as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live BigCommerce.
-
Use Dash to Build to Web Apps on Greenplum
Create Python applications that use pandas and Dash to build Greenplum-connected web apps.
-
Edit and Search JSON External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of JSON to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create JSON objects that you can access from apps and the dashboard.