CData Software - Knowledge Base
Recent Articles
-
How to pipe PostgreSQL to CSV in PowerShell
Use standard PowerShell cmdlets to access PostgreSQL tables.
-
Connect to Amazon S3 as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Amazon S3.
-
Create Data Visualizations Based On Twitter in Mode
Use CData Connect AI to connect to Twitter from Mode and build visualizations using live
-
Automated Continuous Sybase IQ Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Sybase IQ replication to AlloyDB.
-
Access Google Directory as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Google Directory from your Oracle system.
-
Replicate Airtable from PowerShell
Write a quick PowerShell script to query Airtable. Use connectivity to the live data to replicate Airtable to SQL Server.
-
Connect OneNote to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Microsoft OneNote using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Seamlessly Import Greenhouse Data into IBM SPSS Modeler
Integrate Greenhouse data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Access Live Trello in Coginiti Pro
Connect to and query live Trello from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Import and Visualize IBM Cloud Object Storage in Power View
Create data visualizations based on IBM Cloud Object Storage in Excel.
-
Analyze Avalara AvaTax in Infragistics Reveal
Use the CData API Server to create an OData API on top of Avalara AvaTax and visualize live Avalara AvaTax in Infragistics Reveal.
-
Bidirectional Access to Google Ad Manager from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Google Ad Manager in Filemaker Pro for Mac or Windows.
-
A PostgreSQL Interface for JotForm (MySQL Remoting via JDBC)
Use the Remoting features of the JotForm JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Azure Analysis Services in Google Apps Script via Connect AI
Use CData Connect AI to access Azure Analysis Services in Google Apps Script.
-
Query MySQL in DataGrip
Create a Data Source for MySQL in DataGrip and use SQL to query live MySQL.
-
Access Live Databricks in Excel 365 Online (Excel for the web)
Connect to Databricks from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Splunk to Power BI dashboards. Simply drag and drop Splunk into data visuals on the Power BI canvas.
-
Analyze Active Directory in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Active Directory and visualize Active Directory in SAP Analytics Cloud.
-
Connect to Impala in ACL Analytics
Connect to Apache Impala via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Apache Impala.
-
Automated Continuous Reckon Accounts Hosted Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to Microsoft Access.
-
Migrating data from SendGrid to Google BigQuery using CData SSIS Components.
Easily push SendGrid to Google BigQuery using the CData SSIS Tasks for SendGrid and Google BigQuery.
-
Deploy the ADO.NET Provider for Epicor Kinetic on an SSRS Report Server
Connect to Epicor Kinetic 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.
-
Extract, Transform, and Load Azure Active Directory in Informatica PowerCenter
Create a simple Workflow for Azure Active Directory in Informatica PowerCenter.
-
Configure the CData JDBC Driver for SQL Server in a Connection Pool in Tomcat
Connect to Microsoft SQL Server from a connection pool in Tomcat.
-
Integrating Claude Code with Excel Online via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Microsoft Excel Online within assisted coding and automated development workflows.
-
Import Power BI XMLA into the Power BI Service for Visualizations
Use CData Connect AI to connect to Power BI XMLA and provide access to live Power BI XMLA for custom reports in the Power BI Service.
-
Query Oracle SCM using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Oracle SCM entities in PHP by modeling them as objects.
-
Easily Integrate Microsoft Exchange in Lazarus Pascal IDE
Learn how to easily integrate live Microsoft Exchange in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Publish Calendly-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Calendly.
-
Build Data Flows from ServiceNow to SQL Server using SSIS
Easily back up ServiceNow to SQL Server using the SSIS components for ServiceNow.
-
Visualize Drift in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Drift into TIBCO Spotfire.
-
Integrate Live ActiveCampaign into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to ActiveCampaign and integrate live ActiveCampaign into apps built in Microsoft Power Apps.
-
Access Live FHIR in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to FHIR from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to Oracle as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Oracle Database.
-
Use the CData Software ODBC Driver for Slack in SAS for Real-Time Reporting and Analytics
Connect to real-time Slack in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Slack.
-
Working with QuickBooks in LINQPad
Execute LINQ queries to QuickBooks Desktop in LINQPad.
-
Extend Google Sheets with Salesforce
Make calls to the API Server from Google Apps Script.
-
How to Access Live Azure Analysis Services in Power Automate Desktop via ODBC
The CData ODBC Driver for Azure Analysis Services enables you to integrate Azure Analysis Services into workflows built using Microsoft Power Automate Desktop.
-
Build Couchbase-Powered Applications in Claude Code with CData Code Assist MCP
-