CData Software - Knowledge Base

Recent Articles

---

• «
• 1101
• 1102
• 1103
• 1104
• 1105
• 1106
• 1107
• 1108
• 1109
• 1110
• »

• Visualize Live Insightly Data in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Insightly.

• Replicate Multiple ZarMoney Accounts via the CData Sync CLI

  Replicate multiple ZarMoney accounts to one or many databases.

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

  Connect to Salesforce & Force.com in MicroStrategy Web using the CData Software JDBC Driver for Salesforce.

• Marketo Data Cloud Connectivity

  Explore a compilation of guides and tutorials demonstrating how to establish connections to Marketo through CData Connect AI using different applications and tools.

• Visualize Adobe Commerce Data in TIBCO Spotfire through OData

  Integrate Adobe Commerce into dashboards in TIBCO Spotfire.

• Consume Google Campaign Manager 360 OData Feeds in SAP Lumira

  Use the API Server to create data visualizations on Google Campaign Manager 360 feeds that reflect any changes in SAP Lumira.

• Integrating Codex CLI with Printful via CData CLI

  CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.

• How to Connect to & Open Dynamics CRM Data in Microsoft Excel

  This article uses the CData ODBC driver for Dynamics CRM to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

• Build Visualizations of Suadeo Data in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Suadeo in Birst.

• Visualize Live Office 365 Data of Power BI Report Builder in Power BI Service

  Use CData Power BI Connectors to connect to live Microsoft Office 365 using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

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

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

• Connect to Samanage Data in NetBeans

  Connect to Samanage in NetBeans with the data source configuration wizard.

• Load Impala Data to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Apache Impala to a database.

• How to create Visio diagrams from Amazon Athena Data

  Automatically update Amazon Athena with the changes you make to Visio master shapes.

• How to Query Live Snapchat Ads Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live Snapchat Ads data in natural language using Python.

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for Everhour

  Provide connectivity to Everhour through an SAP BusinessObjects universe.

• Automated Continuous HDFS Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable HDFS replication to Google Cloud SQL.

• How to Query Live Google Contacts Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live Google Contacts data in natural language using Python.

• Back Up Accelo to SQL Server through SSIS

  Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Accelo data.

• How to publish and share Bright Data Data dashboards with Tableau Server

  The CData ODBC driver for Bright Data enables you integrate Bright Data into Tableau dashboards.

• Build Printify-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Printify.

• Build Automated Workflows with Live SAP Fieldglass Data in Workato

  Use CData Connect AI to connect to live SAP Fieldglass and build automated workflows in Workato.

• Integrating Codex CLI with ChartMogul via CData CLI

  CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.

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

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

• Connect to EnterpriseDB from Excel & GoogleSheets!

  Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from EnterpriseDB, and over 250 other data sources, right inside your Excel and Google spreadsheets!

• Use the CData ODBC Driver for Salesforce in Microsoft Power Query

  You can use the CData Salesforce ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Salesforce & Force.com into Microsoft Power Query.

• LINQ to OData Services

  LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the OData Data Provider.

• DataBind Charts to Impala Data

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Apache Impala 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.

• Deploy the ADO.NET Provider for ZendeskSell on an SSRS Report Server

  Connect to ZendeskSell 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.

• Automated Continuous Google Calendar Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable Google Calendar replication to Google Cloud SQL.

• Building Dynamic Web Pages with Splunk Data Using AngularJS

  Create single-page applications with live connectivity to Splunk using the CData API Server.

• Create a Data Access Object for Twitter Ads Data using JDBI

  A brief overview of creating a SQL Object API for Twitter Ads in JDBI.

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

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

• Build AI Agents with Facebook Data in IBM watsonx Orchestrate using CData Connect AI

  Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Facebook through CData Connect AI.

• Publish Crystal Reports on Adobe Experience Manager Data

  Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Adobe Experience Manager.

• Create Marketo-Connected Business Apps in AppSheet

  Connect to Marketo Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Marketo.

• Access Live Odoo Data in Excel (Desktop) via Connect AI

  Use CData Connect AI to gain access to live Odoo ERP from your Excel spreadsheets.

• Use the CData API Server to Access Quickbase Data in Microsoft PowerPivot

  Use the CData API Server to connect to live Quickbase in the Power Pivot business intelligence tool.

• How to connect to Figshare Data from IntelliJ

  Integrate connectivity to Figshare with wizards in IntelliJ.

• Object-Relational Mapping (ORM) with Pingdom Data Entities in Java

  Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Pingdom into a Java-based ORM framework, Hibernate.

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

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

• Build an OLAP Cube in SSAS from ZohoExpense Data

  Establish a connection to ZohoExpense data from SQL Server Analysis Services, and use the ZohoExpense Data Provider to build OLAP cubes for use in analytics and reporting.

• Access Live Reckon Accounts Hosted Data in Tableau with CData API Server

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

• Build Semantic Layer Views for Hive Data in APOS Live Data Gateway

  Use the CData Connector for Hive in APOS Live Data Gateway to build Semantic Layer Views for Apache Hive.

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

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

• Import Kintone Data Using Azure Data Factory

  Use CData Connect AI to connect to Kintone Data from Azure Data Factory and import live Kintone.

• How to Seamlessly Import Gong Data into IBM SPSS Modeler

  Integrate Gong data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.

• Automated Continuous Facebook Ads Replication to Apache Cassandra

  Use CData Sync for automated, continuous, customizable Facebook Ads replication to Apache Cassandra.

• Excel Spreadsheet Automation on PostgreSQL Data with the QUERY Formula

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

• Build Dynamics 365 Visualizations in Tableau Cloud

  Use CData Connect AI to connect to live Microsoft Dynamics 365 and build visualizations in Tableau Cloud.

• Use the CData ODBC Driver for Amazon Athena from SharePoint Excel Services

  This article demonstrates how to use the CData ODBC Driver for Amazon Athena to connect to Amazon Athena from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Amazon Athena in Excel.

• Connect to Invoiced Data from PowerBuilder via ODBC

  This article demonstrates how to use the CData ODBC Driver for Invoiced to connect to Invoiced and execute queries in PowerBuilder.

• Integrate Webex with JetBrains RubyMine using CData JDBC Drivers

  Learn how to integrate Webex with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Webex.

• Connect to Oracle HCM Cloud Data through External Services in Salesforce

  Use CData Connect AI to securely connect Salesforce External Services with Oracle HCM Cloud Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.

• How to Query Live Rebilly Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live Rebilly data in natural language using Python.

• Create Reports with Webex Data in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Webex.

• Build a PostgreSQL Interface for Drift Data using the CData JDBC Driver

  Use the Remoting features of the Drift JDBC Driver to create a PostgreSQL entry-point for data access.

• Bridge Google Search Connectivity with Apache NiFi

  Access and process Google Search in Apache NiFi using the CData JDBC Driver.

• Visualize Live Facebook Data in the Power BI Service

  Use CData Connect AI to connect to live Facebook and create custom reports in the Power BI Service through the On-Premises Gateway.

• Access Live MarkLogic Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

  Connect to MarkLogic from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

• Connect to JotForm Data in DBeaver

  Use the CData ODBC Driver to connect to JotForm in DBeaver.

• Prepare, Blend, and Analyze BambooHR Data in Alteryx Designer (Connect AI)

  Build workflows to access live BambooHR for self-service data analytics.

• Build Dashboards with Oracle SCM Data in Dundas BI

  Create dynamic dashboards and perform analytics based on Oracle SCM in Dundas BI.

• Connect and Query Live Xero Data in Databricks with CData Connect AI

  Use CData Connect AI to integrate live Xero Accounting into Databricks

• Design BIRT Reports on ZohoDesk Data

  Provide current ZohoDesk to your embedded analytics.

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

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

• Access Workday Data from MySQL in Amazon QuickSight

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

• How to import HCL Domino Data into Apache Solr

  Use the CData Software JDBC Driver for HCL Domino in Data Import Handler and create an automated import of HCL Domino to Apache Solr Enterprise Search platform.

• How to Query Live Zoho CRM Data in Perplexity MacOS Desktop

  Connect to and query live Zoho CRM Data in Perplexity Desktop using CData MCP Server.

• Build Automated Workflows with Live FTP Data in Workato

  Use CData Connect AI to connect to live FTP Servers and build automated workflows in Workato.

• Bridge Grafana Connectivity with Apache NiFi

  Access and process Grafana in Apache NiFi using the CData JDBC Driver.

• Manage ZohoDesk Data in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for ZohoDesk.

• Create Power BI Reports on Real-Time Snapchat Ads Data

  Use the CData ODBC Driver for Snapchat Ads to visualize Snapchat Ads in Power BI Desktop.

• Build Dashboards with Workable Data in DBxtra

  Create dynamic dashboards and perform analytics based on Workable in DBxtra.

• Access Live Shippo Data in Coginiti Pro

  Connect to and query live Shippo from the GUI in the Coginiti Pro: SQL Analytics Tool.

• Query eBay Analytics Data from Node.js

  Use the OData endpoint of the CData API Server to connect to your eBay Analytics and perform CRUD operations on eBay Analytics from Node.js.

• Query MailerLite Data through ODBC in Node.js

  Use node-odbc to execute SQL queries against MailerLite from Node.js.

• Automate Tasks in Power Automate Using the CData API Server

  Automate Adobe Commerce actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.

• Deploy the ADO.NET Provider for MYOB AccountRight on an SSRS Report Server

  Connect to MYOB AccountRight 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.

• Connect to Amazon DynamoDB Data in NetBeans

  Connect to Amazon DynamoDB in NetBeans with the data source configuration wizard.

• Excel Spreadsheet Automation on Freshteam Data with the QUERY Formula

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

• How to Query Bugsnag Data in MySQL Workbench

  Execute MySQL queries against live Bugsnag from MySQL Workbench.

• Import Salesforce Marketing Data Using Azure Data Factory

  Use CData Connect AI to connect to Salesforce Marketing Data from Azure Data Factory and import live Salesforce Marketing Cloud.

• Create Power BI Reports on Real-Time Highrise Data

  Use the CData ODBC Driver for Highrise to visualize Highrise CRM in Power BI Desktop.

• Object-Relational Mapping (ORM) with Mode Data Entities in Java

  Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Mode into a Java-based ORM framework, Hibernate.

• Use the CData Software ODBC Driver for MailerLite in MicroStrategy Desktop

  Connect to MailerLite in MicroStrategy Desktop using the CData Software ODBC Driver for MailerLite.

• Getting Started with the CData Tableau Connector for Wrike

  Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.

• How to connect Amazon QuickSight to Phoenix Data

  Create a connection to Apache Phoenix in CData Connect AI and insert Apache Phoenix into Amazon QuickSight SPICE to build interactive dashboards.

• Connect to Vertica Data from Crystal Reports

  Use CData Connect AI to connect to and report on live Vertica from Crystal Reports.

• Build Airtable-Connected Apps in Mendix

  Use CData Connect AI to create an OData feed for Airtable Data and create custom apps in Mendix.

• Analyze SuiteCRM Data in R via JDBC

  Use standard R functions and the development environment of your choice to analyze SuiteCRM with the CData JDBC Driver for SuiteCRM.

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

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

• A PostgreSQL Interface for Sugar CRM Data using the CData ODBC Driver

  Use the SQL Gateway and Sugar CRM ODBC Driver to create a PostgreSQL entry-point for data access.

• Visualize Zoho Inventory Data in TIBCO Spotfire through ODBC

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

• Connect to Attio Data in DBeaver

  Use the CData ODBC Driver to connect to Attio in DBeaver.

• Process & Analyze Figshare Data in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live Figshare Data.

• Write a Simple Go Application to work with Hugging Face Data on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Hugging Face.

• Integrating OpenCode Terminal with Suadeo Data via CData CLI

  CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.

• Connect Azure Data Lake Storage to AI Assistants With the CData Python MCP Server

  Learn how to give AI assistants like Claude direct access to live Azure Data Lake Storage using the CData Python MCP Server.

• Natively Connect to SAP SuccessFactors LMS Data in PHP

  The CData ODBC driver for SAP SuccessFactors LMS enables you to create PHP applications with connectivity to SAP SuccessFactors LMS. Leverage the native support for ODBC in PHP.

• «
• 1101
• 1102
• 1103
• 1104
• 1105
• 1106
• 1107
• 1108
• 1109
• 1110
• »