CData Software - Knowledge Base

Recent Articles

---

• «
• 697
• 698
• 699
• 700
• 701
• 702
• 703
• 704
• 705
• 706
• »

• Automated Continuous Cosmos DB Replication to AlloyDB

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

• Connect to Adobe Experience Manager Data in CloverDX (formerly CloverETL)

  Transfer Adobe Experience Manager using the visual workflow in the CloverDX data integration tool.

• How to Create Power BI Visual Reports with Real-Time Instagram Data

  Use CData Power BI Connectors to visualize Instagram in Power BI.

• Getting Started with the CData ADO.NET Provider for Google Drive

  Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Google Drive.

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

  Execute MySQL queries against Mouseflow from Node.js.

• How to create an RPA flow for Dynamics CRM Data in UiPath Studio

  Use the Dynamics CRM ODBC Driver to create workflows that access real-time Microsoft Dynamics CRM without any coding.

• Access Live Zoho CRM Data in Coginiti Pro

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

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

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

• How to Work with SAP Business Warehouse Data in ETL Validator JDBC

  Connect to SAP Business Warehouse from ETL Validator jobs using the CData Software JDBC Driver.

• Connect to Notion Data in HULFT Integrate

  Connect to Notion as a JDBC data source in HULFT Integrate

• Connect to Sage 200 Data in NetBeans

  Connect to Sage 200 in NetBeans with the data source configuration wizard.

• Perform Batch Operations with SendGrid Data in Apache NiFi

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

• Analyze SAP Hybris C4C Data in Looker

  Use CData Connect AI to connect to SAP Hybris C4C Data from Looker and build custom apps using live SAP Hybris C4C.

• How to load OneNote data into Elasticsearch via Logstash

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

• Build Automated Workflows with Live Zoom Data in Workato

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

• Feed Wistia Data into FineReport

  How to set Wistia as a JDBC data source in FineReport.

• Connect to Oracle SCM Data in the Denodo Platform

  Use CData driver technologies to create a virtual data source for Oracle SCM in the Denodo Virtual DataPort Administrator.

• How to connect to ScrapingBee Data from IntelliJ

  Integrate connectivity to ScrapingBee with wizards in IntelliJ.

• Easily Integrate SAP Business Warehouse Data in Lazarus Pascal IDE

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

• Access Attio Data in Mule Applications Using the CData JDBC Driver

  Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Attio.

• Create Google Translate Reports on JasperReports Server

  Deploy the CData JDBC Driver on JasperReports Server to provide real-time Google Translate data access from reports, embedded analytics, and more.

• Connect to Onfleet Data in Ruby

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

• Build a Simple VCL Application for SpaceX Data

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

• Automated Continuous Azure DevOps Replication to Databricks

  Use CData Sync for automated, continuous, customizable Azure DevOps replication to Databricks.

• How to Visualize JSON Services in Python with pandas via CData Connect AI

  Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live JSON in Python.

• Use Agno to Talk to Your Oracle Eloqua Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Oracle Eloqua for you.

• Work with Pipedrive Data in FoxPro

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

• Connect to FHIR Data in HULFT Integrate

  Connect to FHIR as a JDBC data source in HULFT Integrate

• DataBind Controls to Gmail Data in C++Builder

  DataBind to Gmail in C++Builder with standard components and controls.

• Automated Continuous AgileCRM Replication to Google Cloud SQL

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

• Automated Continuous Campaigner Replication to Apache Kafka

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

• Automated Continuous Retently Replication to Oracle

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

• Integrating Boomi Agentstudio with Raisers Edge NXT Data via CData Connect AI

  Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Raisers Edge NXT, enabling AI agents to act on live enterprise data within your integration and automation workflows.

• Build an OLAP Cube in SSAS from Datadog Data

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

• How to Query SAP Ariba Source Data in MySQL Workbench

  Execute MySQL queries against live SAP Ariba Source from MySQL Workbench.

• Viewing Pinterest Data in RAD Studio Data Explorer

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

• Connect to GitHub Data in the Denodo Platform

  Use CData driver technologies to create a virtual data source for GitHub in the Denodo Virtual DataPort Administrator.

• Connect to SAP HANA XS Advanced Data in NetBeans

  Connect to SAP HANA XS Advanced in NetBeans with the data source configuration wizard.

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

  Execute MySQL queries against Copper from Node.js.

• Use JayDeBeApi to access Oracle Eloqua Data in Python

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

• Use the CData Software JDBC Driver for SAP ByDesign in MicroStrategy Web

  Connect to SAP Business ByDesign in MicroStrategy Web using the CData Software JDBC Driver for SAP ByDesign.

• Use Databricks Agent Bricks to Talk to Your DocuSign Data via CData Connect AI

  Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your DocuSign for you.

• Getting Started with the CData Power BI Connector for AdRoll

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

• Connect to Elasticsearch Data as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Elasticsearch.

• How to connect to CouchDB Data in DBVisualizer

  Integrate Apache CouchDB with visual data analysis tools and data connection wizards in DBVisualizer

• Use Microsoft Copilot Studio to talk to your Okta Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Okta for you.

• Use the CData SSIS Components to Insert New or Update Existing Snowflake Records from SQL Server

  Easily push SQL Server data to Snowflake using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Snowflake or update existing records with data from a SQL Server database.

• Replicate Bitbucket Data from PowerShell

  Write a quick PowerShell script to query Bitbucket. Use connectivity to the live data to replicate Bitbucket to SQL Server.

• Automated Continuous Google Ads Replication to MySQL

  Use CData Sync for automated, continuous, customizable Google Ads replication to MySQL.

• Connect to Paylocity Data in Airbyte ELT Pipelines

  Use CData Connect AI to build ELT pipelines for Paylocity in Airbyte.

• Analyze Missive Data with Power Pivot

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

• Connect to SAP BusinessObjects BI Data from Blazor Apps

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

• Automated Continuous Couchbase Replication to PostgreSQL

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

• Integrate Goose with Live Avalara AvaTax Data via CData Connect AI

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

• Build Charts with Exa Data in Clear Analytics

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

• Connect BambooHR Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

  Connect to your BambooHR using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

• Connect to and Query Beeminder Data in QlikView over ODBC

  Create data visualizations with Beeminder in QlikView.

• Edit and Search External Azure Synapse Objects in Salesforce Connect

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

• Build MVC Applications with Connectivity to Mailjet Data

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

• Access Live Act CRM Data in TIBCO Data Virtualization

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

• Integrate Notion Data in the Pentaho Report Designer

  Publish reports based on Notion in the Pentaho BI tool.

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

• Publish TigerGraph-Connected Dashboards in Tableau Server

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

• Build Spark-Powered Applications in Cursor with CData MCP Server

  Use the CData MCP Server for Spark to explore live Spark Data in Cursor to assist with building Spark-powered applications.

• Integrate REST Data in Pentaho Data Integration

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

• Build Data Flows from FormSite to SQL Server using SSIS

  Easily back up FormSite to SQL Server using the SSIS components for FormSite.

• Automated Todoist Data Replication to Teradata

  Use CData Sync to Customize and automate Todoist replication to Teradata.

• Automated Continuous PagerDuty Replication to Snowflake

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

• Use the CData Software ODBC Driver for REST in MicroStrategy

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

• Access Live Samanage Data in SAS JMP via ODBC

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

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

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

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

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

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

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

• Google Forms Reporting and Star Schemas in OBIEE

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

• Access Live Flowlu Data in AWS Lambda

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

• How to connect to Paylocity Data with Squirrel SQL client

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

• Integrate Goose with Live SAS Data Sets Data via CData Connect AI

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

• Connect to ZohoSubscriptions Data in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Using the CData Software ODBC Driver for QuickBooks Time in PyCharm

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

• Bidirectional Access to MarkLogic Data from FileMaker Pro

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

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

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

• How to Connect to Live Azure Analysis Services Data from Gemini CLI (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Azure Analysis Services for you.

• Publish Crystal Reports on Cloudflare Data

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

• Connect ConvertAPI to AI Assistants With the CData Python MCP Server

  Learn how to give AI assistants like Claude direct access to live ConvertAPI using the CData Python MCP Server.

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

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

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

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

• How to Work with Google Campaign Manager 360 Data in ETL Validator JDBC

  Connect to Google Campaign Manager 360 from ETL Validator jobs using the CData Software JDBC Driver.

• Feed PhantomBuster Data into FineReport

  How to set PhantomBuster as a JDBC data source in FineReport.

• Automated Continuous Asana Replication to MongoDB

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

• How to Query Google Directory Data in MySQL Workbench

  Execute MySQL queries against live Google Directory from MySQL Workbench.

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

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

• Excel Spreadsheet Automation on Everhour Data with the QUERY Formula

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

• Connect to Marketo Data from PowerBuilder via ODBC

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

• Natively Connect to SAP Concur Data in PHP

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

• Use Agno to Talk to Your IBM Informix Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your IBM Informix for you.

• How to Connect to Okta Data in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to Okta. Leverage the pyodbc module for ODBC in Python.

• How to Build an ETL App for SAS xpt Data in Python with CData

  Create ETL applications and real-time data pipelines for SAS XPORT in Python with petl.

• Getting Started with the CData ODBC Driver for ZendeskSell

  Complete guide to installing, licensing, and connecting with the CData ODBC Driver for ZendeskSell.

• Use JayDeBeApi to access Cvent Data in Python

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

• How to use SQLAlchemy ORM to access Browserless Data in Python

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

• «
• 697
• 698
• 699
• 700
• 701
• 702
• 703
• 704
• 705
• 706
• »