CData Software - Knowledge Base
Recent Articles
-
Connect to Hive in HULFT Integrate
Connect to Hive as a JDBC data source in HULFT Integrate
-
Access Harvest from MySQL in Amazon QuickSight
Connect to Harvest and build visualizations of Harvest using a MySQL Connection in Amazon QuickSight.
-
Connect to Live SAP Ariba Procurement in PostGresSQL Interface through CData Connect AI
Create a live connection to SAP Ariba Procurement in CData Connect AI and connect to your SAP Ariba Procurement from PostgreSQL.
-
How to connect to Oracle with Squirrel SQL client
Connect to Oracle Database and execute queries in the Squirrel SQL Client.
-
Prepare, Blend, and Analyze Reckon Accounts Hosted in Alteryx Designer (Connect AI)
Build workflows to access live Reckon Accounts Hosted for self-service data analytics.
-
Build a Simple VCL Application for Smartsheet
How to build a simple VCL Application to view Smartsheet in RAD Studio using the CData ODBC Driver for Smartsheet.
-
Manage Avro in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Avro.
-
Automate Hive Replication to Azure Synapse
Use CData Sync to customize and automate Apache Hive replication to Azure Synapse.
-
Connect to SAP BusinessObjects BI in DBArtisan
Use wizards in DBArtisan to configure SAP BusinessObjects BI as a data source.
-
Connect to Bing Ads as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Bing Ads.
-
Access Live MailChimp in Coginiti Pro
Connect to and query live MailChimp from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to and Query Instagram in QlikView over ODBC
Create data visualizations with Instagram in QlikView.
-
Access Live Google Ads in AWS Lambda (with IntelliJ IDEA)
Connect to live Google Ads in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Visualize Live FHIR in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live FHIR into custom reports in Power BI.
-
Create Power BI Reports on Real-Time Procore
Use the CData ODBC Driver for Procore to visualize Procore in Power BI Desktop.
-
Manage Microsoft Exchange in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Microsoft Exchange.
-
Connect to Confluence in SpagoBI
Create reports featuring live Atlassian Confluence in SpagoBI Studio. Host Confluence reports on SpagoBI Server.
-
How to Work with Facebook in ETL Validator JDBC
Connect to Facebook from ETL Validator jobs using the CData Software JDBC Driver.
-
Build Data Flows from SingleStore to SQL Server using SSIS
Easily back up SingleStore to SQL Server using the SSIS components for SingleStore.
-
Analyze SAP Netweaver Gateway in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SAP Netweaver Gateway in Microsoft R Open.
-
How to Access Dynamics 365 Business Central Using Entity Framework
This article shows how to access Dynamics 365 Business Central using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to Query Live Google Cloud Storage in Perplexity MacOS Desktop
Connect to and query live Google Cloud Storage in Perplexity Desktop using CData Code Assist MCP.
-
Integrating Claude Code with Oracle via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Oracle Database within assisted coding and automated development workflows.
-
Automated Continuous Dynamics 365 Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Dynamics 365 replication to Apache Cassandra.
-
Automated Continuous Typeform Replication to Snowflake
Use CData Sync for automated, continuous, customizable Typeform replication to Snowflake.
-
Replicate Greenplum from PowerShell
Write a quick PowerShell script to query Pivotal GreenPlum. Use connectivity to the live data to replicate Pivotal GreenPlum to SQL Server.
-
Use Dash to Build to Web Apps on Google Contacts
Create Python applications that use pandas and Dash to build Google Contacts-connected web apps.
-
How to Connect to Live Cloudant from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your IBM Cloudant for you.
-
Use the CData API Server to Access Google Search Results in Microsoft PowerPivot
Use the CData API Server to connect to live Google Search in the Power Pivot business intelligence tool.
-
How to create Zoom federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Zoom in MySQL .
-
Getting Started with the CData JDBC Driver for SAP SuccessFactors
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SAP SuccessFactors.
-
Build a Singer.io Tap for EnterpriseDB With the CData Python Connector
Learn how to easily build a Singer.io Tap for live EnterpriseDB data using
-
Connect to Cvent from a Connection Pool in JBoss
Integrate Cvent into Java servlets: Use the Management Console in JBoss to install the Cvent JDBC Driver.
-
Connect to Zendesk from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Zendesk using standard SQL.
-
Connect to Drift in JRuby
Create a simple JRuby app with access to live Drift.
-
Integrate PostgreSQL with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate PostgreSQL with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to PostgreSQL.
-
Creating Kintone-Connected Applications in Unqork
You can use CData Connect AI to feed Kintone to Unqork and build custom business apps.
-
A PostgreSQL Interface for ADP using the CData ODBC Driver
Use the SQL Gateway and ADP ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect Flowise AI Agents to Live Microsoft Dataverse via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live data without replication.
-
How to create Google Spanner federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Google Spanner in MySQL .
-
Access Live Act-On in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Act-On from your Google Sheets.
-
A PostgreSQL Interface for Exact Online using the CData ODBC Driver
Use the SQL Gateway and Exact Online ODBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze Salesforce Marketing in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Salesforce Marketing Cloud in Microsoft R Open.
-
Build Semantic Layer Views for Act-On in APOS Live Data Gateway
Use the CData Connector for Act-On in APOS Live Data Gateway to build Semantic Layer Views for Act-On.
-
Analyze Azure DevOps in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Azure DevOps in Microsoft R Open.
-
Query Smartsheet in ColdFusion
Write standard ColdFusion data access code to connect to Smartsheet.
-
Edit and Search Confluence External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Atlassian Confluence to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Confluence objects that you can access from apps and the dashboard.
-
Choosing the Best Method to Connect JotForm to SQL Server: 5 Options Explained
Discover multiple ways to connect and use JotForm from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrate Real-Time Access to Google Directory in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Google Directory in real time.
-
Use ChatGPT to Talk to Your ShipStation via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your ShipStation for you.
-
Integrating Google Drive in Talend Cloud Data Management Platform
-