CData Software - Knowledge Base

Recent Articles

---

• «
• 1091
• 1092
• 1093
• 1094
• 1095
• 1096
• 1097
• 1098
• 1099
• 1100
• »

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

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

• Configure the CData JDBC Driver for Amazon Athena in a Connection Pool in Tomcat

  Connect to Amazon Athena from a connection pool in Tomcat.

• DataBind Controls to Teamwork Data in Delphi

  DataBind to Teamwork in Delphi with standard data access components and controls.

• Visualize Live BambooHR Data in the Power BI Service

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

• Automated Continuous Power BI XMLA Replication to Oracle

  Use CData Sync for automated, continuous, customizable Power BI XMLA replication to Oracle.

• Query Scrapfly Data through ODBC in Node.js

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

• How to integrate Recurly with Apache Airflow

  Access and process Recurly in Apache Airflow using the CData JDBC Driver.

• How to connect to CircleCI Data with Squirrel SQL client

  Connect to CircleCI and execute queries in the Squirrel SQL Client.

• Visualize JobNimbus 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 JobNimbus into TIBCO Spotfire.

• Validate Missive Data with QuerySurge

  Access and validate Missive in QuerySurge using the CData JDBC Driver.

• Getting Started with the CData JDBC Driver for Pinterest

  Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Pinterest.

• Create Informatica Mappings From/To an ODBC Data Source for Oracle Sales

  Create an ODBC connection to Oracle Sales in Informatica and browse and transfer Oracle Sales.

• How to create Excel Online federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for Microsoft Excel Online in MySQL .

• Create Ontraport Dataflows on PowerBI.com

  Connect to the CData Power BI Connector for Ontraport from PowerBI.com to create Power BI Dataflows with real-time data.

• Migrating data from Float to Snowflake using CData SSIS Components.

  Easily push Float to Snowflake using the CData SSIS Tasks for Float and Snowflake.

• Integrate Cline with Live Shopify Data via CData Connect AI

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

• Connect to Pinecone Data from PowerBuilder via JDBC

  This article demonstrates how to access Pinecone from PowerBuilder using the Pinecone JDBC Driver.

• Create a Data Access Object for JDBC-ODBC Bridge Data using JDBI

  A brief overview of creating a SQL Object API for JDBC-ODBC Bridge in JDBI.

• Bidirectional Access to Typeform Data from FileMaker Pro

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

• Automate Amazon Marketplace Data Replication to SAP HANA

  Use CData Sync to customize and automate Amazon Marketplace replication to SAP HANA.

• Integrate with BenchmarkEmail Data using Apache Camel2

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

• Connect to QuickBooks Time Data in Google Apps Script via Connect AI

  Use CData Connect AI to access QuickBooks Time in Google Apps Script.

• Build MVC Applications with Connectivity to Dotmailer Data

  This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Dotmailer from an ASP.NET MVC application.

• Working with IBM Cloud Object Storage Data in LINQPad

  Execute LINQ queries to IBM Cloud Object Storage in LINQPad.

• Connect to and Visualize Live JotForm Data in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live JotForm.

• Integrate Real-Time Access to Azure DevOps in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Azure DevOps in real time.

• Excel Spreadsheet Automation on Workable Data with the QUERY Formula

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

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

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

• Build an OLAP Cube in SSAS from Salesloft Data

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

• Enable the Pingdom JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with Pingdom.

• Import and Visualize MariaDB Data in Power View

  Create data visualizations based on MariaDB in Excel.

• Connect to Pipedrive from Excel & GoogleSheets!

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

• Connect to Splunk Data as an External Source in Dremio

  Use the CData JDBC Driver to connect to Splunk as an External Source in Dremio.

• Import and Visualize Front Data in Power View

  Create data visualizations based on Front in Excel.

• Migrating data from SAS xpt to Snowflake using CData SSIS Components.

  Easily push SAS XPORT to Snowflake using the CData SSIS Tasks for SAS xpt and Snowflake.

• Use Biml to Build SSIS Tasks to Replicate ShipStation Data to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate ShipStation to SQL Server.

• Visualize ScrapingBee Data in TIBCO Spotfire through ADO.NET

  Integrate ScrapingBee into dashboards in TIBCO Spotfire.

• How to update QuickBooks Online from Excel

  This article explains how to transfer data from Excel to QuickBooks Online using the Excel Add-In for QuickBooks Online.

• Automate Attio Data Replication to Couchbase

  Use CData Sync to Customize and automate Attio replication to Couchbase.

• Easily Integrate Instantly Data in Lazarus Pascal IDE

  Learn how to easily integrate live Instantly in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.

• Access Live Elasticsearch Data in Coginiti Pro

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

• Integrate Snowflake Data into Automated Tasks with Power Automate

  Use CData Connect AI to connect to Snowflake and integrate live Snowflake into your Power Automate tasks.

• Connect to AfterShip Data in Aqua Data Studio

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

• A PostgreSQL Interface for Azure Data Lake Storage Data using the CData ODBC Driver

  Use the SQL Gateway and Azure Data Lake Storage ODBC Driver to create a PostgreSQL entry-point for data access.

• Import Smartsheet Data into Microsoft Power Query

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

• Automated Continuous Google Search Results Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable Google Search replication to OneLake in Microsoft Fabric.

• Prepare, Blend, and Analyze Mouseflow Data in Alteryx Designer (ODBC)

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

• Connecting Moonlit Workflow with Salesforce Marketing Data via CData Connect AI MCP Server

  Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Salesforce Marketing Cloud in real time.

• Publish HDFS-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Apache HDFS.

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

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

• Replicate Ontraport Data in Heroku for Use in Salesforce Connect

  Replicate Ontraport to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Use the CData Software ODBC Driver for Todoist in MicroStrategy Web

  Connect to Todoist in MicroStrategy Web using the CData Software ODBC Driver for Todoist.

• Integrating LangChain with SAP Ariba Source Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on SAP Ariba Source within automated workflows.

• Design BIRT Reports on Zoho Books Data

  Provide current Zoho Books to your embedded analytics.

• Use CData Connect AI to Access Stripe Data in Microsoft Power Pivot

  Use CData Connect AI to connect to live Stripe in the Power Pivot business intelligence tool.

• Visualize Live HCL Domino Data in Power BI (via CData Connect AI)

  Use the CData Power BI Connector and CData Connect AI to integrate live HCL Domino into custom reports in Power BI.

• Getting Started with the CData SSIS Components for Hugging Face

  Complete guide to installing, licensing, and connecting with the CData SSIS Components for Hugging Face.

• Replicate Multiple NetSuite SuiteAnalytics Accounts

  Replicate multiple NetSuite SuiteAnalytics accounts to one or many databases.

• Easily Integrate Act CRM Data in Lazarus Pascal IDE

  Learn how to easily integrate live Act CRM in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.

• How to Work with Todoist Data in AWS Glue Jobs Using JDBC

  Connect to Todoist from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• Object-Relational Mapping (ORM) with Microsoft Planner 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 Microsoft Planner into a Java-based ORM framework, Hibernate.

• Automated Continuous LDAP Replication to AlloyDB

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

• Migrating data from Discourse to Google BigQuery using CData SSIS Components.

  Easily push Discourse to Google BigQuery using the CData SSIS Tasks for Discourse and Google BigQuery.

• Explore Geographical Relationships in Freshsales Data with Power Map

  Create data visualizations with Freshsales in Power Map.

• Connect to Customer.io Data in HULFT Integrate

  Connect to Customer.io as a JDBC data source in HULFT Integrate

• Build Dashboards with Salesforce Data 360 Data in DBxtra

  Create dynamic dashboards and perform analytics based on Salesforce Data 360 in DBxtra.

• Automate TaxJar Data Replication to SAP HANA

  Use CData Sync to customize and automate TaxJar replication to SAP HANA.

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

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

• Integrating Claude Code CLI with GraphQL 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.

• Create Kintone-Connected Business Apps in AppSheet

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

• Use JayDeBeApi to access Teamwork Data in Python

  Use standard Python scripting and the development environment of your choice to access live Teamwork.

• Use Dash to Build Web Apps on AlloyDB Data via CData Connect AI

  Build interactive Dash web apps on live Google AlloyDB using pandas and the CData Connect AI Python SDK.

• Build Oracle Service Cloud-Powered Applications in Claude Code with CData MCP Server

  Use the CData MCP Server for Oracle Service Cloud to explore live Oracle Service Cloud Data in Claude Code to assist with building Oracle Service Cloud-powered applications.

• How to connect to PabblySubscriptions Data in DBVisualizer

  Integrate PabblySubscriptions with visual data analysis tools and data connection wizards in DBVisualizer

• How to integrate Metabase with Avalara AvaTax Data

  Use CData Connect AI to connect to live Avalara AvaTax and create an interactive dashboard in Metabase from Avalara AvaTax.

• DataBind Controls to Google Drive Data in Delphi

  DataBind to Google Drive in Delphi with standard data access components and controls.

• Query Shopify Data in DataGrip

  Create a Data Source for Shopify in DataGrip and use SQL to query live Shopify.

• Getting Started with the CData Connect AI Python SDK for Neo4J

  Install the CData Connect AI Python SDK to read and write live Neo4J with standard DB-API 2.0 Python code.

• Automated Continuous Avro Replication to Apache Kafka

  Use CData Sync for automated, continuous, customizable Avro replication to Apache Kafka.

• Getting Started with the CData Power BI Connector for Toggl

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

• Create Datasets from Bitbucket in Domo Workbench and Build Visualizations of Bitbucket Data in Domo

  Use the CData Software ODBC Driver for Bitbucket to create datasets from Bitbucket in Domo Workbench and then build visualizations in the Domo service.

• Bidirectional Access to PDFMonkey Data from FileMaker Pro

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

• How to Seamlessly Import Keap Data into IBM SPSS Modeler

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

• Automated Continuous FHIR Replication to Amazon Redshift

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

• Use the CData ODBC Driver for Onfleet from SharePoint Excel Services

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

• Access BigQuery Data as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Google BigQuery from your Oracle system.

• Build Apps with Live Authorize.Net in Adalo using CData Connect AI

  Use CData Connect AI to integrate live Authorize.Net into the Adalo platform and build custom mobile and web applications with real-time Authorize.Net.

• How to Build an ETL App for Microsoft Teams Data in Python with CData

  Create ETL applications and real-time data pipelines for Microsoft Teams in Python with petl.

• Integrate with Live Vertica Data in MuleSoft (via CData Connect AI)

  Use CData Connect AI to connect to Vertica from the MuleSoft Anypoint Platform to integrate live Vertica into custom reports and dashboards.

• Integrate Google Sheets Data in Pentaho Data Integration

  Build ETL pipelines based on Google Sheets in the Pentaho Data Integration tool.

• How to Connect to & Open LionDesk Data in Microsoft Excel

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

• How to import IBM Informix Data into Apache Solr

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

• Connect to Cosmos DB from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Cosmos DB to connect to Azure Cosmos DB from Web applications running on WebLogic.

• Publish Crystal Reports on SAS xpt Data

  Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SAS XPORT.

• Getting Started with the CData Tableau Connector for Bitly

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

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

  Connect Clari with Mendix to build apps using the CData API Driver for JDBC.

• Query Perplexity Data in DataGrip

  Create a Data Source for Perplexity in DataGrip and use SQL to query live Perplexity.

• Integrate Snowflake Data in the Pentaho Report Designer

  Publish reports based on Snowflake in the Pentaho BI tool.

• Visualize GraphQL Data in TIBCO Spotfire through OData

  Integrate GraphQL into dashboards in TIBCO Spotfire.

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

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

• «
• 1091
• 1092
• 1093
• 1094
• 1095
• 1096
• 1097
• 1098
• 1099
• 1100
• »