CData Software - Knowledge Base
Recent Articles
-
Access Oracle HCM Cloud as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Oracle HCM Cloud from your Oracle system.
-
Bidirectional Access to Drift from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Drift in Filemaker Pro for Mac or Windows.
-
Automate Adobe Target Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Adobe Target from PowerShell? This article demonstrates how to utilize the Adobe Target Cmdlets for tasks like connecting to Adobe Target, automating operations, downloading data, and more.
-
Connect to Google Contacts from Crystal Reports
Use CData Connect AI to connect to and report on live Google Contacts from Crystal Reports.
-
Connect to Cloudant in CloverDX (formerly CloverETL)
Transfer IBM Cloudant using the visual workflow in the CloverDX data integration tool.
-
How to pipe Box to CSV in PowerShell
Use standard PowerShell cmdlets to access Box tables.
-
Automated Continuous Google Sheets Replication to Databricks
Use CData Sync for automated, continuous, customizable Google Sheets replication to Databricks.
-
Prepare, Blend, and Analyze Jira Assets in Alteryx Designer (ODBC)
Build workflows to access live Jira Assets for self-service data analytics.
-
Connect to Outreach.io from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Outreach.io to connect to Outreach.io and execute queries in PowerBuilder.
-
Query Acumatica as a MySQL Database in Node.js
Execute MySQL queries against Acumatica ERP from Node.js.
-
How to pipe SAP Fieldglass to CSV in PowerShell
Use standard PowerShell cmdlets to access SAP Fieldglass tables.
-
Automated Continuous QuickBooks Replication to MySQL
Use CData Sync for automated, continuous, customizable QuickBooks replication to MySQL.
-
Connect to Redis from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Redis to connect to Redis and execute queries in PowerBuilder.
-
Connect to Exact Online in ACL Analytics
Connect to Exact Online via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Exact Online.
-
Automated Continuous Exact Online Replication to SQLite
Use CData Sync for automated, continuous, customizable Exact Online replication to SQLite.
-
Build Shopify-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Shopify from Zoho Analytics and import live Shopify.
-
Connect to Google Cloud Storage in JRuby
Create a simple JRuby app with access to live Google Cloud Storage.
-
Automated Continuous Teradata Replication to SingleStore
Use CData Sync for automated, continuous, customizable Teradata replication to SingleStore.
-
Natively Connect to JSON Services in PHP
The CData ODBC driver for JSON enables you to create PHP applications with connectivity to JSON. Leverage the native support for ODBC in PHP.
-
How to Query BambooHR in MySQL Workbench
Execute MySQL queries against live BambooHR from MySQL Workbench.
-
How to Access Live Act-On in Power Automate Desktop via ODBC
The CData ODBC Driver for Act-On enables you to integrate Act-On into workflows built using Microsoft Power Automate Desktop.
-
Bidirectional Access to Quickbase from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Quickbase in Filemaker Pro for Mac or Windows.
-
Use the CData Software ODBC Driver for Google Calendar in MicroStrategy Desktop
Connect to Google Calendar in MicroStrategy Desktop using the CData Software ODBC Driver for Google Calendar.
-
Create Informatica Mappings From/To a JDBC Data Source for Bing Ads
Create Bing Ads data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Model, Search, and Visualize Live Google Ads in ThoughtSpot
Use CData Connect AI to connect to live Google Ads for modeling, searching, and visualizing.
-
Visualize Live Pinterest of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Pinterest using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to use SQLAlchemy ORM to access Smartsheet in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Smartsheet.
-
Connect to Zuora in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Zuora in Airbyte.
-
How to Connect to & Open BigQuery in Microsoft Excel
This article uses the CData ODBC driver for BigQuery to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrate Avalara AvaTax into Power Automate Desktop using CData Connect
CData Connect for Avalara AvaTax enables you to integrate Avalara AvaTax into workflows built using Microsoft Power Automate Desktop.
-
Build Dashboards with xBase in Dundas BI
Create dynamic dashboards and perform analytics based on xBase in Dundas BI.
-
Automated Continuous Oracle Eloqua Replication to Snowflake
Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to Snowflake.
-
Replicate HBase from PowerShell
Write a quick PowerShell script to query Apache HBase. Use connectivity to the live data to replicate Apache HBase to SQL Server.
-
Automated Continuous ServiceNow Replication to SQLite
Use CData Sync for automated, continuous, customizable ServiceNow replication to SQLite.
-
Getting Started with the CData Excel Add-In for Google Cloud Storage
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Google Cloud Storage.
-
Migrating data from ConstantContact to Snowflake using CData SSIS Components.
Easily push ConstantContact to Snowflake using the CData SSIS Tasks for ConstantContact and Snowflake.
-
Connect to TaxJar from a Connection Pool in JBoss
Integrate TaxJar into Java servlets: Use the Management Console in JBoss to install the TaxJar JDBC Driver.
-
Automate WordPress Replication to Azure Data Lake
Use CData Sync to customize and automate WordPress replication to Azure Data Lake.
-
Visualize Facebook Ads in TIBCO Spotfire through OData
Integrate Facebook Ads into dashboards in TIBCO Spotfire.
-
How to connect to Blackbaud FE NXT from Spring Boot
Connect to Blackbaud FE NXT in a Spring Boot Application using CData JDBC Blackbaud FE NXT Driver
-
Create Sage Intacct-Connected Dashboards in Grafana
Connect to Sage Intacct via CData Connect AI in Grafana and create custom business dashboards with real-time access to Sage Intacct.
-
Use ChatGPT to Talk to Your Office 365 via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Microsoft Office 365 for you.
-
Automated Continuous Unbounce Replication to Snowflake
Use CData Sync for automated, continuous, customizable Unbounce replication to Snowflake.
-
Build a PostgreSQL Interface for REST using the CData JDBC Driver
Use the Remoting features of the REST JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build SQL Server-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Microsoft SQL Server and build SQL Server-connected web apps with Axios.
-
Create LinkedIn-Connected Dashboards in Grafana
Connect to LinkedIn via CData Connect AI in Grafana and create custom business dashboards with real-time access to LinkedIn.
-
Rapidly Develop Microsoft Teams-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.
-
How to connect PolyBase to Sugar CRM
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Sugar CRM.
-
Connect to MariaDB in the Denodo Platform
Use CData driver technologies to create a virtual data source for MariaDB in the Denodo Virtual DataPort Administrator.
-
Trigger BigQuery IFTTT Flows in Azure App Service
This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.
-
Build MailChimp Visualizations in Tableau Cloud
Use CData Connect AI to connect to live MailChimp and build visualizations in Tableau Cloud.
-
Feed ClickUp into FineReport
How to set ClickUp as a JDBC data source in FineReport.
-
Automate Basecamp Replication to Azure Data Lake
Use CData Sync to customize and automate Basecamp replication to Azure Data Lake.
-
Integrating LDAP Objects in Talend Cloud Data Management Platform
-