CData Software - Knowledge Base

Recent Articles

---

• «
• 979
• 980
• 981
• 982
• 983
• 984
• 985
• 986
• 987
• 988
• »

• Create a Data Access Object for Templated Data using JDBI

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

• Getting Started with the CData SSIS Components for Calendly

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

• Connect and Query Live Microsoft Planner Data in Databricks with CData Connect AI

  Use CData Connect AI to integrate live Microsoft Planner into Databricks

• Build SAP SuccessFactors LMS-Connected ETL Processes in Google Data Fusion

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

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

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

• Connect to YouTube Analytics from Asprova with CData Software ODBC Driver for YouTube Analytics

  This article shows how to connect faster to YouTube Analytics data from Asprova.

• Create Apps from OneNote Data in Qlik Sense Cloud

  Use CData Connect AI to connect to OneNote Data and build apps from live Microsoft OneNote in Qlik Sense Cloud.

• Configure the CData JDBC Driver for YouTube Analytics in a Connection Pool in Tomcat

  Connect to YouTube Analytics from a connection pool in Tomcat.

• Create Dashboards and Visualize Live FreshBooks Data in Geckoboard

  Use CData Connect AI to connect to live FreshBooks and create dashboards for real-time monitoring and visualization in Geckoboard.

• Integrate CloudConvert with JetBrains RubyMine using CData JDBC Drivers

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

• How to Query Browserless Data in MySQL Workbench

  Execute MySQL queries against live Browserless from MySQL Workbench.

• Getting Started with the CData ADO.NET Provider for Raisers Edge NXT

  Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Raisers Edge NXT.

• A PostgreSQL Interface for Float Data using the CData ODBC Driver

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

• Connect to Discord Data in HULFT Integrate

  Connect to Discord as a JDBC data source in HULFT Integrate

• Work with Datadog Data in FoxPro

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

• Access Wave Financial Data from MySQL in Amazon QuickSight

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

• Access Live Salesforce Data in TIBCO Data Virtualization

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

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

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

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

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

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

• Integrate SAP Ariba Procurement Data in Pentaho Data Integration

  Build ETL pipelines based on SAP Ariba Procurement in the Pentaho Data Integration tool.

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

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

• How to connect and process FreshBooks from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live FreshBooks.

• How to Visualize XML Data in Python with pandas

  Use pandas and other modules to analyze and visualize live XML Files in Python.

• Import Real-Time Azure Data Lake Storage Data via ODBC in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Azure Data Lake Storage in ColdFusion.

• Model, Search, and Visualize Live MongoDB Data in ThoughtSpot

  Use CData Connect AI to connect to live MongoDB for modeling, searching, and visualizing.

• How to Connect Power BI XMLA Data to Gemini Enterprise via CData Connect AI

  Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Power BI XMLA data in real time using natural language.

• How to Work with Hive Data in ETL Validator JDBC

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

• How to connect Amazon QuickSight to Acumatica Data

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

• How to Access SAP Ariba Source Data Using Entity Framework

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

• A PostgreSQL Interface for Zoho Inventory Data using the CData ODBC Driver

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

• Visualize Apollo Data in Sisense

  Create an ElastiCube in Sisense app with access to Apollo.

• Integrating Antigravity CLI with Float via CData CLI

  Connect Float to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.

• How to Connect to Live Zoho Creator Data from Claude Agent SDK (via CData Connect AI)

  Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Zoho Creator for you.

• Automate Zoho Projects Data Replication to SAP HANA

  Use CData Sync to customize and automate Zoho Projects replication to SAP HANA.

• Use the CData Software JDBC Driver for Coinbase in MicroStrategy

  Connect to Coinbase in MicroStrategy Developer using the CData Software JDBC Driver for Coinbase.

• How to Easily Query Reply.io Data in OpenOffice Base

  Connect to Reply.io data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.

• How to Query Epicor Kinetic Data in MySQL Workbench

  Execute MySQL queries against live Epicor Kinetic from MySQL Workbench.

• How to Connect to Live Oracle Sales Data from OpenAI Python Applications (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Oracle Sales through natural language.

• Automated Continuous MYOB AccountRight Data Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to OneLake in Microsoft Fabric.

• Access Apollo Data from MySQL in Amazon QuickSight

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

• Process & Analyze Microsoft Planner Data in Databricks (AWS)

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

• Import and Visualize Oracle HCM Cloud Data in Power View

  Create data visualizations based on Oracle HCM Cloud in Excel.

• Connect to Google Spanner Data in RazorSQL

  Connect to Google Spanner from wizards and query Google Spanner from the GUI in the RazorSQL database management tool.

• Connect to Sybase IQ Data in Ruby

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

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

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

• Access Hugging Face Data as a Remote Oracle Database

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

• Connect to Avro Data in Jaspersoft Studio

  Execute SQL to remote Apache Avro in Jaspersoft Studio.

• Automated Continuous FormSite Replication to SingleStore

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

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

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

• Manage Tickspot Data in DBArtisan as a JDBC Source

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

• Back Up Discourse 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 Discourse data.

• Create Power BI Reports on Real-Time Cohere Data

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

• Build a Simple VCL Application for Printful Data

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

• Connect to and Visualize Live Salesloft Data in Tableau Prep

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

• Connect to SingleStore Data as an External Source in Dremio

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

• Connecting GenSpark with QuickBooks Time Data via CData Connect AI MCP Server

  Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to QuickBooks Time without any replication or custom integration required.

• Automated Continuous GraphQL Replication to MySQL

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

• Connect to SAP ByDesign from a Connection Pool in WebLogic

  Use the CData JDBC Driver for SAP ByDesign to connect to SAP Business ByDesign from Web applications running on WebLogic.

• Getting Started with the CData Python Connector for Odoo

  Learn to install and license the CData Python Connector

• Access Live SAP SuccessFactors LMS Data in SAS JMP via ODBC

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

• Connect to BambooHR Data in Airbyte ELT Pipelines

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

• Automated Continuous Zoho CRM Replication to Google BigQuery

  Use CData Sync for automated, continuous, customizable Zoho CRM replication to Google BigQuery.

• Replicate Wave Financial Data to Multiple Databases

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

• Build AI Agents with Salesforce CRM Analytics 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 Salesforce CRM Analytics through CData Connect AI.

• How to Seamlessly Import Okta Data into IBM SPSS Modeler

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

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

  Create a simple Workflow for Bitly in Informatica PowerCenter.

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

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

• Automated Continuous Samanage Replication to SQLite

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

• How to Connect the Power BI Service to Zoho Recruit: Complete Guide

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

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

  Execute SQL Server queries against PostgreSQL from Node.js.

• How to load Google Campaign Manager 360 data into Elasticsearch via Logstash

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

• Visualize Live FormSite Data in Tableau

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

• Build Data Flows from Nethunt to SQL Server using SSIS

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

• Query, Visualize, and Share live Highrise Data in Redash

  Use CData Connect AI to connect to live Highrise CRM in Redash for querying, visualizing, and sharing.

• Connect to Google Ads Data in JRuby

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

• Connect to HubSpot Data from AWS Glue

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

• Migrating data from HelloSign to Databricks using CData SSIS Components.

  Easily push HelloSign to Databricks using the CData SSIS Tasks for HelloSign and Databricks.

• Analyze Typeform Data with Power Pivot

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

• Access Azure Synapse Data from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Azure Synapse from HeidiSQL.

• Automated Continuous Todoist Replication to MongoDB

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

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

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

• Create Jira Assets Dataflows on PowerBI.com

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

• Integrating Cursor CLI with Mistral AI 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.

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

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

• Build AI Agents with CockroachDB 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 CockroachDB through CData Connect AI.

• Use Dash to Build to Web Apps on Bullhorn CRM Data

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

• Notice for all Marketo Driver Users Regarding December 2024 Release

  This article serves as a notice to all users regarding the CData Software Marketo connectivity solutions update from December 2024.

• Connect to WooCommerce Data in NetBeans

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

• Integrating Kiro CLI with Slack 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.

• LINQ to Certinia 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 Certinia Data Provider.

• Use Grok to Talk to Your Sugar CRM Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Sugar CRM for you.

• How to connect to Gorgias Data from IntelliJ

  Integrate connectivity to Gorgias with wizards in IntelliJ.

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

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

• Integrating LangChain with Raisers Edge NXT Data via CData Connect AI

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

• How to Work with Outlook Data in ETL Validator JDBC

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

• Load Teradata Data to a Database Using Embulk

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

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

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

• How to integrate Metabase with Apollo Data

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

• How to Easily Query Beeminder Data in OpenOffice Base

  Connect to Beeminder data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.

• «
• 979
• 980
• 981
• 982
• 983
• 984
• 985
• 986
• 987
• 988
• »