CData Software - Knowledge Base
Recent Articles
-
Access Google Sheets as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Google Sheets from your Oracle system.
-
Building Dynamic Web Pages with SAP Fieldglass Using AngularJS
Create single-page applications with live connectivity to SAP Fieldglass using the CData API Server.
-
Connect to SAP Business One in the Denodo Platform
Use CData driver technologies to create a virtual data source for SAP Business One in the Denodo Virtual DataPort Administrator.
-
Build Access-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Microsoft Access and build web apps with connectivity to live Microsoft Access.
-
Build an OLAP Cube in SSAS from Google Analytics
Establish a connection to Google Analytics data from SQL Server Analysis Services, and use the Google Analytics Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create Cloudant-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Cloudant from OutSystems and build custom enterprise apps using live IBM Cloudant.
-
How to Connect to SuiteCRM in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SuiteCRM. Leverage the pyodbc module for ODBC in Python.
-
How to Create Power BI Visual Reports with Real-Time IBM Informix
Use CData Power BI Connectors to visualize IBM Informix in Power BI.
-
Build Charts with Google Data Catalog in Clear Analytics
Create dynamic charts and perform analytics based on Google Data Catalog in Clear Analytics.
-
Connect to Azure Active Directory in RapidMiner
Integrate Azure Active Directory with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Neo4J in CloverDX (formerly CloverETL)
Transfer Neo4J using the visual workflow in the CloverDX data integration tool.
-
How to Access NetSuite Using Entity Framework
This article shows how to access NetSuite CRM & ERP using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Deploy the ADO.NET Provider for Redis on an SSRS Report Server
Connect to Redis 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.
-
Integrating LangChain with Workday via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Workday within automated workflows.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Oracle Sales to Power BI dashboards. Simply drag and drop Oracle Sales into data visuals on the Power BI canvas.
-
Connect and Visualize Live CockroachDB Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live CockroachDB into the Databricks platform and create visualization dashboards with real-time CockroachDB.
-
Provide OData Services of Zendesk from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Zendesk by developing a WCF Service Application.
-
Extend Google Sheets with Google Calendar
Make calls to the API Server from Google Apps Script.
-
Automate Active Directory Replication to Couchbase
Use CData Sync to Customize and automate Active Directory replication to Couchbase.
-
Visualize Tableau CRM Analytics in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Tableau CRM Analytics into TIBCO Spotfire.
-
Connect to Avalara AvaTax from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Avalara AvaTax, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to connect to Printful in DBVisualizer
Integrate Printful with visual data analysis tools and data connection wizards in DBVisualizer
-
A PostgreSQL Interface for Square (MySQL Remoting via JDBC)
Use the Remoting features of the Square JDBC Driver to create a PostgreSQL entry-point for data access.
-
Load Monday.com to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Monday.com to a database.
-
Replicate xBase in Heroku for Use in Salesforce Connect
Replicate xBase to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Analyze Adobe Commerce in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Adobe Commerce and visualize live Adobe Commerce in Infragistics Reveal.
-
Extend Google Sheets with Impala
Make calls to the API Server from Google Apps Script.
-
How to Connect to & Open SurveyMonkey in Microsoft Excel
This article uses the CData ODBC driver for SurveyMonkey to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Analyze Google Ads in Cognos Analytics
Use CData Connect AI to connect to Google Ads from Cognos Analytics and analyze live Google Ads.
-
Create Informatica Mappings From/To an ODBC Data Source for Klaviyo
Create an ODBC connection to Klaviyo in Informatica and browse and transfer Klaviyo.
-
How to Work with Drift in AWS Glue Jobs Using JDBC
Connect to Drift from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Easily Integrate SQL Server in Lazarus Pascal IDE
Learn how to easily integrate live Microsoft SQL Server in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Query Live Lakebase Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Lakebase data in natural language using Python.
-
Analyze HubDB in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze HubDB in Microsoft R Open.
-
Extract, Transform, and Load Amazon Marketplace in Informatica PowerCenter
Create a simple Workflow for Amazon Marketplace in Informatica PowerCenter.
-
Connect to SQL Analysis Services from a Connection Pool in WebLogic
Use the CData JDBC Driver for SQL Analysis Services to connect to SQL Analysis Services from Web applications running on WebLogic.
-
Create Google Ads-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Google Ads from Klipfolio and build custom visualizations using live Google Ads.
-
Import Real-Time Freshdesk via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Freshdesk in ColdFusion.
-
Use the CData Software ODBC Driver for Email in MicroStrategy
Connect to Email in MicroStrategy Developer using the CData Software ODBC Driver for Email.
-
How to Connect DBeaver to OneNote via a JDBC Driver
Manage Microsoft OneNote with visual tools in DBeaver like the query browser.
-
Using the CData Software ODBC Driver for LinkedIn Ads in PyCharm
Connect to LinkedIn Ads as an ODBC data source in PyCharm using the CData Software ODBC Driver for LinkedIn Ads.
-
Connect to SAS Data Sets in the Denodo Platform
Use CData driver technologies to create a virtual data source for SAS Data Sets in the Denodo Virtual DataPort Administrator.
-
Visualize Microsoft Dataverse in Tableau
The CData ODBC driver for Microsoft Dataverse enables you integrate Microsoft Dataverse (CDS) into Tableau dashboards.
-
Replicate LinkedIn Ads in Heroku for Use in Salesforce Connect
Replicate LinkedIn Ads to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Create Datasets from Zoho Projects in Domo Workbench and Build Visualizations of Zoho Projects in Domo
Use the CData Software ODBC Driver for Zoho Projects to create datasets from Zoho Projects in Domo Workbench and then build visualizations in the Domo service.
-
Build MVC Applications with Connectivity to DocuSign
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access DocuSign from an ASP.NET MVC application.
-
Automated Continuous Google Analytics Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Google Analytics replication to PostgreSQL.
-
Write a Simple Go Application to work with SurveyMonkey on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SurveyMonkey.
-
Validate Zoho Inventory with QuerySurge
Access and validate Zoho Inventory in QuerySurge using the CData JDBC Driver.
-
Connect to MongoDB in JRuby
Create a simple JRuby app with access to live MongoDB.
-
Build Automated Workflows with Live Redshift in Workato
Use CData Connect AI to connect to live Amazon Redshift and build automated workflows in Workato.
-
Use CData Connect AI to Access BigCommerce in Microsoft Power Pivot
Use CData Connect AI to connect to live BigCommerce in the Power Pivot business intelligence tool.
-
Procore Reporting in OBIEE with the Procore JDBC Driver
Deploy the Procore JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Configure the CData JDBC Driver for Phoenix in a Connection Pool in Tomcat
Connect to Apache Phoenix from a connection pool in Tomcat.
-
Creating Sugar CRM-Connected Applications in Unqork
You can use CData Connect AI to feed Sugar CRM to Unqork and build custom business apps.
-
Access Live Zoho Inventory in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Zoho Inventory from your Excel spreadsheets.
-
Import Real-Time Teradata via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Teradata in ColdFusion.
-
Natively Connect to WooCommerce in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to WooCommerce. Leverage the native support for ODBC in PHP.
-
Connect to MariaDB in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for MariaDB in Airbyte.
-
Use the CData ODBC Driver for Slack in Microsoft Power Query
You can use the CData Slack ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Slack into Microsoft Power Query.
-
How to Easily Query Printful in OpenOffice Base
-