CData Software - Knowledge Base

Recent Articles

---

• «
• 366
• 367
• 368
• 369
• 370
• 371
• 372
• 373
• 374
• 375
• »

• Query Cloudant in ColdFusion

  Write standard ColdFusion data access code to connect to IBM Cloudant.

• Use the CData Software JDBC Driver for Excel in MicroStrategy Web

  Connect to Microsoft Excel in MicroStrategy Web using the CData Software JDBC Driver for Excel.

• Bidirectional Access to SAS Data Sets from FileMaker Pro

  Use the MySQL Remoting feature of the JDBC driver to integrate SAS Data Sets in Filemaker Pro for Mac or Windows.

• Build Zoho Inventory-Connected Dashboards Using Zoho Analytics

  Use CData Connect AI to connect to Zoho Inventory from Zoho Analytics and import live Zoho Inventory.

• Natively Connect to Google Campaign Manager 360 in PHP via ODBC (Linux)

  Create PHP applications on Linux/UNIX machines with connectivity to Google Campaign Manager 360. Leverage the native support for ODBC in PHP.

• Automated Continuous Calendly Replication to AlloyDB

  Use CData Sync for automated, continuous, customizable Calendly replication to AlloyDB.

• View Reports on Real-Time Square in Power BI Report Server

  Use the CData ODBC Driver for Square to visualize Square in Power BI Desktop and then publish them to Power BI Report Server.

• Automated Continuous Sugar CRM Replication to Amazon Redshift

  Use CData Sync for automated, continuous, customizable Sugar CRM replication to Amazon Redshift.

• How to Connect Flowise AI Agents to Live MongoDB 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.

• Analyze Facebook Ads with Power Pivot

  This article walks you through the process of using the CData ODBC Driver for Facebook Ads from Power Pivot. You will use the Table Import Wizard to load Facebook Ads. You can visually build the import query or use any SQL supported by the driver.

• How to use SQLAlchemy ORM to access Snapchat Ads in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Snapchat Ads.

• Create Dashboards and Visualize Live IBM Informix in Geckoboard

  Use CData Connect AI to connect to live IBM Informix and create dashboards for real-time monitoring and visualization in Geckoboard.

• Access Live Spark in Emergent via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Apache Spark SQL through MCP integration.

• How to connect to Azure Data Catalog with Squirrel SQL client

  Connect to Azure Data Catalog and execute queries in the Squirrel SQL Client.

• Connect to Spark from Asprova with CData Software ODBC Driver for Spark

  This article shows how to connect faster to Spark data from Asprova.

• Access Klaviyo from MySQL in Amazon QuickSight

  Connect to Klaviyo and build visualizations of Klaviyo using a MySQL Connection in Amazon QuickSight.

• Import Marketo into Microsoft Power Query

  The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Marketo. In this article, you will use the OData format to import Marketo into Microsoft Power Query.

• Automate IBM Cloud Object Storage Tasks in Power Automate Using CData API Server

  With CData API Server, easily create OData endpoints for live IBM Cloud Object Storage and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.

• Extend Google Sheets with Azure Analysis Services

  Make calls to the API Server from Google Apps Script.

• DataBind Charts to Parquet

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Apache Parquet from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.

• How to Visualize eBay Data in Python with pandas

  Use pandas and other modules to analyze and visualize live eBay in Python.

• Excel Spreadsheet Automation on Jira with the QUERY Formula

  Pull data, automate spreadsheets, and more with the QUERY formula.

• Connect to Google Directory in NetBeans

  Connect to Google Directory in NetBeans with the data source configuration wizard.

• Automate SuiteCRM Integration Tasks from PowerShell

  Are you in search of a quick and easy way to access SuiteCRM from PowerShell? This article demonstrates how to utilize the SuiteCRM Cmdlets for tasks like connecting to SuiteCRM, automating operations, downloading data, and more.

• How to pipe Jira to CSV in PowerShell

  Use standard PowerShell cmdlets to access Jira tables.

• Automated Continuous Paylocity Replication to MongoDB

  Use CData Sync for automated, continuous, customizable Paylocity replication to MongoDB.

• Build a Simple VCL Application for Sugar CRM

  How to build a simple VCL Application to view Sugar CRM in RAD Studio using the CData ODBC Driver for Sugar CRM.

• Analyze QuickBooks Online with Power Pivot

  This article walks you through the process of using the CData ODBC Driver for QuickBooks Online from Power Pivot. You will use the Table Import Wizard to load QuickBooks Online. You can visually build the import query or use any SQL supported by the driver.

• Automated Continuous Oracle Sales Replication to AlloyDB

  Use CData Sync for automated, continuous, customizable Oracle Sales replication to AlloyDB.

• Manage Oracle Service Cloud in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for Oracle Service Cloud.

• Bind Live Zoho Books Data in Wijmo FlexGrid with CData API Server

  With CData API Server, easily create OData endpoints for live Zoho Books data

• Automate Printful Integration Tasks from PowerShell

  Are you in search of a quick and easy way to access Printful from PowerShell? This article demonstrates how to utilize the Printful Cmdlets for tasks like connecting to Printful, automating operations, downloading data, and more.

• Access Live SAP Business One Data in Tableau with CData API Server

  With CData API Server, easily create OData endpoints for live SAP Business One data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.

• Build Asana Visualizations in Tableau Desktop

  Use CData Connect AI to connect to live Asana and build visualizations in Tableau.

• Replicate Multiple Parquet Accounts via the CData Sync CLI

  Replicate multiple Parquet accounts to one or many databases.

• PowerShell Scripting to Replicate DocuSign to MySQL

  Write a simple PowerShell script to replicate DocuSign to a MySQL database.

• Connect to Unbounce from a Connection Pool in JBoss

  Integrate Unbounce into Java servlets: Use the Management Console in JBoss to install the Unbounce JDBC Driver.

• Integrate with Facebook using Apache Camel2

  Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Facebook to a JSON file on disk.

• Automated Continuous SAP Concur Replication to MySQL

  Use CData Sync for automated, continuous, customizable SAP Concur replication to MySQL.

• Edit and Search Greenplum External Objects in Salesforce Connect (API Server)

  Use the API Server to securely provide OData feeds of Pivotal GreenPlum to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Greenplum objects that you can access from apps and the dashboard.

• Connect to Hive in Google Apps Script via SQL Gateway

  Use the ODBC Driver for Hive and the SQL Gateway to access Apache Hive from Google Apps Script.

• Connect to Zoho CRM from HeidiSQL

  Use CData Connect AI to connect to and query live Zoho CRM from HeidiSQL.

• How to connect and process Google Analytics from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Google Analytics.

• Connect to Tableau CRM Analytics in Aqua Data Studio

  Access Tableau CRM Analytics from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• Import Real-Time Databricks via ODBC in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Databricks in ColdFusion.

• Visualize Act CRM in TIBCO Spotfire through ODBC

  The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Act CRM into TIBCO Spotfire.

• How to Connect to Live OData Services 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 OData for you.

• Automated Continuous PayPal Replication to Local Delimited Files

  Use CData Sync for automated, continuous, customizable PayPal replication to delimited files (CSV/TSV).

• Connect to Bing Ads in Google Apps Script via Connect AI

  Use CData Connect AI to access Bing Ads in Google Apps Script.

• Access RSS Feeds as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access RSS Feeds from your Oracle system.

• Integrate Cline with Live Databricks Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Databricks from within your IDE.

• Create Informatica Mappings From/To a JDBC Data Source for ConstantContact

  Create ConstantContact data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

• Visualize Couchbase in TIBCO Spotfire through ODBC

  The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Couchbase into TIBCO Spotfire.

• Connect to AlloyDB in DBeaver

  Use the CData ODBC Driver to connect to Google AlloyDB in DBeaver.

• Connect to PostgreSQL in Ruby

  Connect to PostgreSQL in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• Access Live Azure DevOps in Excel (Desktop) via Connect AI

  Use CData Connect AI to gain access to live Azure DevOps from your Excel spreadsheets.

• Build Semantic Layer Views for SAP BusinessObjects BI in APOS Live Data Gateway

  Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for SAP BusinessObjects BI.

• Choosing the Best Method to Connect Instagram to SQL Server: 5 Options Explained

  Discover multiple ways to connect and use Instagram from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.

• ServiceNow Reporting in OBIEE with the ServiceNow JDBC Driver

  Deploy the ServiceNow JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• Analyze SAS xpt with Power Pivot

  This article walks you through the process of using the CData ODBC Driver for SAS xpt from Power Pivot. You will use the Table Import Wizard to load SAS XPORT. You can visually build the import query or use any SQL supported by the driver.

• Operational Reporting on Office 365 from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Microsoft Office 365.

• Add TaxJar to Informatica Enterprise Data Catalog

  Use the CData Software JDBC Driver for TaxJar with the Informatica Enterprise Data Catalog to classify and organize data.

• Build Apps with Live HDFS Using the Low-Code Development Platform of Mendix

• «
• 366
• 367
• 368
• 369
• 370
• 371
• 372
• 373
• 374
• 375
• »