CData Software - Knowledge Base

Recent Articles

---

• «
• 1056
• 1057
• 1058
• 1059
• 1060
• 1061
• 1062
• 1063
• 1064
• 1065
• »

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

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

• Excel Spreadsheet Automation on BenchmarkEmail Data with the QUERY Formula

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

• Build Semantic Layer Views for Salesforce Pardot Data in APOS Live Data Gateway

  Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Salesforce Pardot.

• Query Power BI XMLA Data using the OData SDK for PHP

  Use the API Server and the OData PHP SDK to easily consume Power BI XMLA entities in PHP by modeling them as objects.

• Publish Exact Online-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Exact Online.

• Query Dynamics 365 Data as a SQL Server Database in Node.js

  Execute SQL Server queries against Microsoft Dynamics 365 from Node.js.

• How to integrate CSV with Apache Airflow

  Access and process CSV/TSV Files in Apache Airflow using the CData JDBC Driver.

• Connect to Coinbase Data from Blazor Apps

  Build ASP.NET Core Blazor C# apps that integrate with real-time Coinbase using standard SQL.

• Build Phoenix-Connected Apps in Choreo

  Use CData Connect AI to connect to Phoenix Data from Choreo and build custom apps using live Apache Phoenix.

• How to connect to Jira Data from IntelliJ

  Integrate connectivity to Atlassian Jira with wizards in IntelliJ.

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

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

• Moving Data from REST to SQL Server Using Toad Data Point and CData ODBC Driver

  Query, export, and automate live REST data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.

• Integrate Goose with Live Sybase Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Sybase from within the local AI agent.

• Query Jira Assets Data using the OData SDK for PHP

  Use the API Server and the OData PHP SDK to easily consume Jira Assets entities in PHP by modeling them as objects.

• Connect to SparkPost Data from a Connection Pool in JBoss

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

• How to integrate Avro with Apache Airflow

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

• How to connect to Microsoft Ads Data from Spring Boot

  Connect to Microsoft Ads in a Spring Boot Application using the CData JDBC Driver for Microsoft Ads

• How to connect PolyBase to Google Forms

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Google Forms.

• How to import LaunchDarkly Data into Apache Solr

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

• Integrate SharePoint Data into Automated Tasks with Power Automate

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

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

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

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

  Create an ODBC connection to Invoiced in Informatica and browse and transfer Invoiced.

• Back Up TaxJar to SQL Server through SSIS

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

• Query Dynamics 365 Business Central Data through ODBC in Node.js

  Use node-odbc to execute SQL queries against Dynamics 365 Business Central from Node.js.

• Connect to Jira Assets Data from PowerBuilder via JDBC

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

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for ScrapingBee

  Provide connectivity to ScrapingBee through an SAP BusinessObjects universe.

• Build Data Flows from SQL Server to Airtable through SSIS

  Easily push SQL Server data to Airtable using the CData SSIS Tasks for Airtable.

• Build Dynamics 365 Business Central-Connected Apps in Choreo

  Use CData Connect AI to connect to Dynamics 365 Business Central Data from Choreo and build custom apps using live Dynamics 365 Business Central.

• How to Query GetResponse Data in MySQL Workbench

  Execute MySQL queries against live GetResponse from MySQL Workbench.

• Nuclia Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on Nuclia facts in real time.

• Integrate Blackbaud FE NXT with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Blackbaud FE NXT with External Services.

• Connect to Stripe Data from HeidiSQL

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

• Connect to and Visualize Live BigCommerce Data in Tableau Prep

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

• Use Dash to Build to Web Apps on GraphQL Data

  Create Python applications that use pandas and Dash to build GraphQL-connected web apps.

• How to Access Live eBay Analytics Data in Visual Studio Code via Cline

  Run CData MCP Server for eBay Analytics on Windows Subsytem for Linux (WSL) and connect to live eBay Analytics from the Cline extension in Visual Studio Code.

• How to load BigCommerce data into Elasticsearch via Logstash

  Introducing a simple method to load BigCommerce data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.

• Integrating OpenCode Terminal with MailerLite 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.

• Operational Reporting on Power BI XMLA Data from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Power BI XMLA.

• Manage ZohoInvoice Data in DBArtisan as a JDBC Source

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

• Extend Google Sheets with Google Search Results

  Make calls to Google Search from Google Apps Script via the API Server.

• Getting Started with the CData SSIS Components for Insightly

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

• How to Connect Flowise AI Agents to Live eBay Data via CData Connect AI

  Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live eBay without replication.

• Build Dashboards with AgileCRM Data in Dundas BI

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

• Connect to Real-Time Pipedrive Data in Power Apps Using Dataflows to Build Custom Applications

  Use CData Power BI Connector for Pipedrive and Dataflow to import and use Pipedrive in Power Apps.

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

  Provide connectivity to NetSuite CRM & ERP through an SAP BusinessObjects universe.

• Publish Crystal Reports on Drift Data

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

• Automated Continuous CampaignMonitor Replication to SQLite

  Use CData Sync for automated, continuous, customizable CampaignMonitor replication to SQLite.

• Connect to SuiteCRM Data in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Build an OLAP Cube in SSAS from Dynamics 365 Data

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

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

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

• Integrate Google

  Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Workday within intelligent workflows.

• Query MongoDB Data through ODBC in Node.js

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

• Create a Data Access Object for OData Services using JDBI

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

• Analyze Live ADP Data in SAS Viya

  Use CData Connect AI to connect to ADP from SAS Viya and deploy self-service analytics using live ADP.

• Load SAP HANA Data to a Database Using Embulk

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

• Integrate PivotalTracker Data in the Pentaho Report Designer

  Publish reports based on PivotalTracker in the Pentaho BI tool.

• Xero: HTTP 503 Rate Limit Exceeded.

  What does this mean?

• Analyze CockroachDB Data in Infragistics Reveal

  Use CData Connect AI to create on OData API on top of CockroachDB and visualize live CockroachDB in Infragistics Reveal.

• Build Wave Financial-Connected ETL Processes in Google Data Fusion

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

• Visualize Mistral AI Data in Sisense

  Create an ElastiCube in Sisense app with access to Mistral AI.

• Connect to ConstantContact Data from PowerBuilder via ODBC

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

• Integrate with Workable Data in JReport Designer

  Create charts and reports based on Workable in JReport Designer.

• Create Facebook-Connected Business Apps in AppSheet

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

• Replicate xBase Data to Multiple Databases

  Replicate xBase to disparate databases with a point-and-click configuration.

• Automated Continuous Couchbase Replication to Apache Cassandra

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

• Integrate Pingdom Data in the Pentaho Report Designer

  Publish reports based on Pingdom in the Pentaho BI tool.

• Viewing Shippo Data in RAD Studio Data Explorer

  How to view Shippo in RAD Studio Data Explorer using the CData ODBC Driver for Shippo.

• Extract, Transform, and Load Workday Data in Informatica PowerCenter

  Create a simple Workflow for Workday in Informatica PowerCenter.

• Bidirectional Access to BambooHR Data from FileMaker Pro

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

• Visualize Live Confluence Data of Power BI Report Builder in Power BI Service

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

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for GitLab

  Provide connectivity to GitLab through an SAP BusinessObjects universe.

• Create Reports with Klaviyo Data in SAP Crystal Reports

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

• Connect to Azure Synapse Data Using the Script Function in Claris FileMaker Pro

  Use the CData ODBC Driver for Azure Synapse and the Script function in FileMaker Pro to connect to Azure Synapse and work with Azure Synapse in your FileMaker application.

• Integrate with Superchat Data using Apache Camel2

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

• Connect to Figshare Data from a Connection Pool in JBoss

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

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for Splunk

  Provide connectivity to Splunk through an SAP BusinessObjects universe.

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

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

• Connect to MariaDB in SpagoBI

  Create reports featuring live MariaDB in SpagoBI Studio. Host MariaDB reports on SpagoBI Server.

• Replicate Clari Data in Heroku for Use in Salesforce Connect

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

• Connect to OnePageCrm Data in Ruby

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

• Access Live Neo4J Data in SAS JMP via ODBC

  You can use the CData ODBC Driver to integrate Neo4J into the statistical analysis tools available in SAS JMP. This article shows how to use Neo4J in the Graph Builder and Query Builder.

• Access Live Azure DevOps Data in AWS Lambda

  Connect to live Azure DevOps in AWS Lambda using the CData JDBC Driver.

• Add Optimizely Data to Informatica Enterprise Data Catalog

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

• Connect to LinkedIn Ads Data in JRuby

  Create a simple JRuby app with access to live LinkedIn Ads.

• Use Dash to Build to Web Apps on ConvertKit Data

  Create Python applications that use pandas and Dash to build ConvertKit-connected web apps.

• Integrate Pipedrive with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Pipedrive with External Services.

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

• Integrating Codex CLI with SAP HANA 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.

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

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

• Connect to Real-Time SAP Hybris C4C Data in Power Apps Using Dataflows to Build Custom Applications

  Use CData Power BI Connector for SAP Hybris C4C and Dataflow to import and use SAP Hybris C4C in Power Apps.

• Access RabbitMQ Data as a Remote Oracle Database

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

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

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

• Connect to Exact Online Data in DBArtisan

  Use wizards in DBArtisan to configure Exact Online as a data source.

• Replicate SAP Business One Data to Multiple Databases via the CData Sync CLI

  Replicate SAP Business One to disparate databases with a single configuration.

• Automated Continuous LeadDesk Replication to Snowflake

  Use CData Sync for automated, continuous, customizable LeadDesk replication to Snowflake.

• Connecting Agentforce with Presto Data via CData Connect AI MCP Server

  Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Presto for you.

• Create CockroachDB-Connected Dashboards in Grafana

  Connect to CockroachDB Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to CockroachDB.

• Query HBase Data as a MySQL Database in Node.js

  Execute MySQL queries against Apache HBase from Node.js.

• Getting Started with the CData Python Connector for Act CRM

  Learn to install and license the CData Python Connector

• Easily Integrate Humanity Data in Lazarus Pascal IDE

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

• «
• 1056
• 1057
• 1058
• 1059
• 1060
• 1061
• 1062
• 1063
• 1064
• 1065
• »