CData Software - Knowledge Base

Recent Articles

---

• «
• 595
• 596
• 597
• 598
• 599
• 600
• 601
• 602
• 603
• 604
• »

• Excel Spreadsheet Automation on XML Data with the QUERY Formula

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

• How to work with SparkPost Data in Apache Spark using SQL

  Access and process SparkPost Data in Apache Spark using the CData Software JDBC Driver.

• How to Query Live SuiteCRM Data in Perplexity MacOS Desktop

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

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

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

• Automated Continuous SAP Ariba Source Replication to Vertica

  Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to Vertica.

• Automated Continuous ZohoDesk Replication to PostgreSQL

  Use CData Sync for automated, continuous, customizable ZohoDesk replication to PostgreSQL.

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

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

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

• Connect to SAP SuccessFactors LMS Data through External Services in Salesforce

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

• Automate Hive Data Replication to Azure Data Lake

  Use CData Sync to customize and automate Apache Hive replication to Azure Data Lake.

• Perform Batch Operations with Stripe Data in Apache NiFi

  Connect to Stripe and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

• Create SSAS Tabular Models from SageHR Data

  How to build a SQL Server Analysis Service Tabular Model from SageHR using CData drivers.

• Connect to Square Data in Claris FileMaker Pro

  Use the CData ODBC Driver for Square in FileMaker Pro to connect to Square and work with Square in your FileMaker applications.

• Connect to Opsgenie Data in DBeaver

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

• How to Work with Unbounce Data in ETL Validator JDBC

  Connect to Unbounce from ETL Validator jobs using the CData Software JDBC Driver.

• Automated Continuous OData Replication to PostgreSQL

  Use CData Sync for automated, continuous, customizable OData replication to PostgreSQL.

• Automated Continuous Amazon DynamoDB Replication to Google BigQuery

  Use CData Sync for automated, continuous, customizable Amazon DynamoDB replication to Google BigQuery.

• How to create Marketo federated tables in MySQL

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

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

• Connecting Mastra with Box Data via CData Connect AI MCP Server

  Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Box, no replication required.

• Build MVC Applications with Connectivity to SAP Hybris C4C Data

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

• Access Live SAP HANA Data in TIBCO Data Virtualization

  Use the SAP HANA Tibco DV Adapter to create a SAP HANA data source in TIBCO Data Virtualization Studio and gain access to live SAP HANA from your TDV Server.

• Analyze Okta Data in SAP Analytics Cloud

  Use CData Connect AI to create an OData API on top of Okta and visualize Okta in SAP Analytics Cloud.

• Build Azure Data Lake Storage-Connected Visualizations in datapine

  Use CData Connect AI and datapine to build visualizations and dashboards with access to live Azure Data Lake Storage.

• Connecting Moonlit Workflow with PostgreSQL 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 PostgreSQL in real time.

• Create FreshBooks-Connected Visualizations in Klipfolio

  Use CData Connect AI to connect to FreshBooks Data from Klipfolio and build custom visualizations using live FreshBooks.

• Create Airtable-Connected Dashboards in Grafana

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

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

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

• Connect to Sybase Data from HeidiSQL

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

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

  Use the CData API Server to connect to live Azure Data Catalog in the Power Pivot business intelligence tool.

• Using the CData Software ODBC Driver for Jira in PyCharm

  Connect to Jira as an ODBC data source in PyCharm using the CData Software ODBC Driver for Jira.

• How to connect to Active Directory Data with Squirrel SQL client

  Connect to Active Directory and execute queries in the Squirrel SQL Client.

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

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

• Publish Reports with Neo4J Data in SAP Crystal Reports

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

• Bidirectional Access to Nethunt Data from FileMaker Pro

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

• Use the CData Software ODBC Driver for Greenhouse in MicroStrategy

  Connect to Greenhouse in MicroStrategy Developer using the CData Software ODBC Driver for Greenhouse.

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

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

• How to Connect DBeaver to Pipedrive via a JDBC Driver

  Manage Pipedrive with visual tools in DBeaver like the query browser.

• Build Charts with Pipeliner CRM Data in Clear Analytics

  Create dynamic charts and perform analytics based on Pipeliner CRM in Clear Analytics.

• Getting Started with the CData Python Connector for BambooHR

  Learn to install and license the CData Python Connector

• Import Salesforce Data into the Power BI Service for Visualizations

  Use CData Connect AI to connect to Salesforce Data and provide access to live Salesforce & Force.com for custom reports in the Power BI Service.

• Automate Airtable Tasks in Power Automate Using CData API Server

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

• Visualize Factorial Data in TIBCO Spotfire through ADO.NET

  Integrate Factorial into dashboards in TIBCO Spotfire.

• Create Dynamic FTP Grids Using the Infragistics XamDataGrid

  Learn how you can connect FTP to Infragistics XamDataGrid to build dynamic grids.

• How to work with Sybase IQ Data in Apache Spark using SQL

  Access and process Sybase IQ Data in Apache Spark using the CData Software JDBC Driver.

• DataBind Controls to Sendwithus Data in Delphi

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

• Analyze Google Ads Data in Infragistics Reveal

  Use the CData API Server to create an OData API on top of Google Ads and visualize live Google Ads in Infragistics Reveal.

• Integrate Live SAP Ariba Procurement Data into Blue Prism for Intelligent Robotic Process Automation (RPA)

  Connect live SAP Ariba Procurement to Blue Prism using the CData ODBC Driver for SAP Ariba Procurement to create automated workflows for repetitive business tasks.

• Integrate Optimizely with JetBrains RubyMine using CData JDBC Drivers

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

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

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

• How to integrate MailChimp with Apache Airflow

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

• Connect to Salesforce in SpagoBI

  Create reports featuring live Salesforce & Force.com in SpagoBI Studio. Host Salesforce reports on SpagoBI Server.

• Connect to Act CRM Data from AWS Glue

  Use CData Connect AI to gain access to live Act CRM from your AWS Glue jobs.

• Design BIRT Reports on HCL Domino Data

  Provide current HCL Domino to your embedded analytics.

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

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

• How to Access FHIR Data Using Entity Framework

  This article shows how to access FHIR using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

• How to connect SharePoint with Vault CRM Data through external lists

  Provide Veeva Vault & Vault CRM to SharePoint users as an external list.

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

• Connect to ShipStation Data in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

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

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

• Build MVC Applications with Connectivity to ChargeOver Data

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

• Create GraphQL-Connected Nintex Workflows

  Use CData Connect AI to connect to GraphQL Data from Nintex Workflow Cloud and build custom workflows using live GraphQL.

• Integrate with XML Data in JReport Designer

  Create charts and reports based on XML Files in JReport Designer.

• Build MVC Applications with Connectivity to PagerDuty Data

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

• Integrate Float with External Services using SnapLogic

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

• Query Freshsales Data through ODBC in Node.js

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

• Connect to Jira from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Jira to connect to Atlassian Jira from Web applications running on WebLogic.

• Integrating LangChain with Amazon S3 Data via CData Connect AI

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

• Add REST Data to Informatica Enterprise Data Catalog

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

• Build SAP Ariba Procurement-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to SAP Ariba Procurement and build web apps with connectivity to live SAP Ariba Procurement.

• Publish Productboard-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Productboard.

• Microsoft Planner Reporting and Star Schemas in OBIEE

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

• Integrate Live Webex Data into Blue Prism for Intelligent Robotic Process Automation (RPA)

  Connect live Webex to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.

• Use Biml to Build SSIS Tasks to Replicate Outreach.io Data to SQL Server

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

• How to Connect DBeaver to FTP via a JDBC Driver

  Manage FTP Servers with visual tools in DBeaver like the query browser.

• Connect to Splunk Data in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

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

  Create a simple Workflow for Strava in Informatica PowerCenter.

• Automated Continuous Tickspot Replication to Vertica

  Use CData Sync for automated, continuous, customizable Tickspot replication to Vertica.

• Access Live Active Directory Data in AWS Lambda (with IntelliJ IDEA)

  Connect to live Active Directory in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

• Edit and Search External FreshBooks Objects in Salesforce Connect

  Use CData Connect AI to securely provide OData feeds of FreshBooks to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create FreshBooks Data objects that you can access from apps and the dashboard.

• LINQ to Shippo Data

  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 Shippo Data Provider.

• Access Pinterest Data as a Remote Oracle Database

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

• Connect to Amazon S3 Data in RazorSQL

  Connect to Amazon S3 from wizards and query Amazon S3 from the GUI in the RazorSQL database management tool.

• Import and Visualize Rootly Data in Power View

  Create data visualizations based on Rootly in Excel.

• Integrate Live Blackbaud FE NXT Data into Blue Prism for Intelligent Robotic Process Automation (RPA)

  Connect live Blackbaud FE NXT to Blue Prism using the CData ODBC Driver for Blackbaud FE NXT to create automated workflows for repetitive business tasks.

• Automated Continuous Monday.com Replication to Apache Cassandra

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

• Automated Continuous Procore Replication to Amazon Redshift

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

• Build Pipelines with Live Lakebase Data in Google Cloud Data Fusion (via CData Connect AI)

  Use CData Connect AI to connect to Lakebase from Google Cloud Data Fusion, enabling the integration of live Lakebase into the building and management of effective data pipelines.

• Automate Salesforce CRM Analytics Data Replication to Couchbase

  Use CData Sync to Customize and automate Salesforce CRM Analytics replication to Couchbase.

• Use Azure AI Foundry to Talk to Your HBase Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Apache HBase for you.

• Automated Continuous FormSite Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable FormSite replication to IBM DB2.

• Use Claude to Talk to Your Google Sheets Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Google Sheets for you.

• How to Connect the Power BI Service to Dropbox: Complete Guide

  Connect to the CData Software Power BI Connector for Dropbox from PowerBI.com to provide real-time Dropbox across the organization.

• Work with Unbounce Data in FoxPro

  Load Unbounce into a FoxPro database. This article includes full code and a walk-through of the process.

• Analyze HBase Data in Infragistics Reveal

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

• Connect to Cohere in SpagoBI

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

• Work with Live Instagram Data in Power Query

  Use CData Connect AI to connect to Instagram and work with live Instagram in Microsoft Power Query.

• How to Connect DBeaver to ActiveCampaign via a JDBC Driver

  Manage ActiveCampaign with visual tools in DBeaver like the query browser.

• Access Live Amazon Marketplace Data in SAS JMP via ODBC

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

• Access Live Greenhouse Data in Roo Code via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Greenhouse through MCP integration.

• «
• 595
• 596
• 597
• 598
• 599
• 600
• 601
• 602
• 603
• 604
• »