CData Software - Knowledge Base

Recent Articles

---

• «
• 633
• 634
• 635
• 636
• 637
• 638
• 639
• 640
• 641
• 642
• »

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

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

• Perigon Reporting and Star Schemas in OBIEE

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

• Excel Spreadsheet Automation on Unbounce Data with the QUERY Formula

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

• Automated Continuous Figshare Replication to Azure SQL Database

  Use CData Sync for automated, continuous, customizable Figshare replication to Azure SQL Database.

• Connect to and Visualize Live Freshdesk Data in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Freshdesk data.

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

• Build a Simple VCL Application for Box Data

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

• Import and Visualize Splunk Data in Power View

  Create data visualizations based on Splunk data in Excel.

• How to update LinkedIn from Excel

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

• Connect to Sybase Data from PowerBuilder via ADO.NET

  This article demonstrates how to access Sybase data from Appeon PowerBuilder using the CData ADO.NET Provider for Sybase.

• How to Easily Query Couchbase Data in OpenOffice Base

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

• Automated Continuous Elorus Replication to IBM DB2

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

• Integrating Gumloop with ShipEngine Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on ShipEngine data within automated workflows.

• Build Charts with Cloudant Data in Clear Analytics

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

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

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

• How to create Aircall federated tables in MySQL

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

• How to Connect Cassandra 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 Cassandra data in real time using natural language.

• Publish Cvent-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Cvent data.

• Manage Epicor Kinetic Data in DBArtisan as a JDBC Source

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

• Build AI/ML Models with Live Sentry Data using Dataiku

  Connect Sentry Data with Dataiku using the CData API Driver for JDBC.

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

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

• Automated Continuous SendInBlue Replication to Apache Cassandra

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

• How to Connect to Live CouchDB Data in Mistral AI Workflows and Agents (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live CouchDB data without replication.

• Use ChatGPT to Talk to Your QuickBooks Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your QuickBooks data for you.

• Connect to HubSpot from Excel & GoogleSheets!

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

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

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

• Create Reports with Exa Data in SAP Crystal Reports

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

• Integrate Webex Data in the Pentaho Report Designer

  Publish reports based on Webex data in the Pentaho BI tool.

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

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

• DataBind Charts to Amplitude Data

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Amplitude data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.

• Build a Singer.io Tap for AgileCRM With the CData Python Connector

  Learn how to easily build a Singer.io Tap for live AgileCRM data using the CData Python Connector.

• Explore Geographical Relationships in Parquet Data with Power Map

  Create data visualizations with Parquet data in Power Map.

• Analyze Azure Data Catalog Data in Cognos Analytics

  Use CData Connect AI to connect to Azure Data Catalog Data from Cognos Analytics and analyze live Azure Data Catalog data.

• Replicate Qualaroo Data in Heroku for Use in Salesforce Connect

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

• Use the CData ODBC Driver for Oracle Eloqua in Microsoft Power Query

  You can use the CData Oracle Eloqua ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Oracle Eloqua data into Microsoft Power Query.

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

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

• Visualize Outlook Data in Sisense

  Create an ElastiCube in Sisense app with access to Outlook data.

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

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

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

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

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

• Automated Continuous SAP Replication to Local Delimited Files

  Use CData Sync for automated, continuous, customizable SAP replication to delimited files (CSV/TSV).

• Connect to Authorize.Net Data as an External Data Source using PolyBase

  Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Authorize.Net data.

• Create Google Cloud Storage-Connected Business Apps in AppSheet

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

• Integrate Demio Data in the Pentaho Report Designer

  Publish reports based on Demio data in the Pentaho BI tool.

• Link Mailjet with FileMaker Pro

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

• How to connect to Amplitude Data in DBVisualizer

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

• Build Timely Visualizations in Tableau Desktop

  Use CData Connect AI to connect to live Timely data and build visualizations in Tableau.

• Integrate Coda Data in the Pentaho Report Designer

  Publish reports based on Coda data in the Pentaho BI tool.

• Integrate Codat Data in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Codat data from Informatica Cloud.

• Provide OData Services of Hive Data from a WCF Application

  In this article, we will demonstrate the process of generating an OData feed for Hive data by developing a WCF Service Application.

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

  Provide connectivity to Snapchat Ads data through an SAP BusinessObjects universe.

• Use Dash to Build to Web Apps on Google Forms Data

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

• Analyze RSS Feeds in Looker

  Use CData Connect AI to connect to RSS Feeds from Looker and build custom apps using live RSS feeds.

• Connect to Samanage Data in Google Apps Script via Connect AI

  Use CData Connect AI to access Samanage data in Google Apps Script.

• Analyze Factorial Data in R via JDBC

  Use standard R functions and the development environment of your choice to analyze Factorial data with the CData JDBC Driver for Factorial.

• Create Workable Reports on JasperReports Server

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

• Connect to Active Directory Data in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Active Directory.

• ETL GitHub in Oracle Data Integrator

  This article shows how to transfer GitHub data into a data warehouse using Oracle Data Integrator.

• Bridge JSON Connectivity with Apache NiFi

  Access and process JSON services in Apache NiFi using the CData JDBC Driver.

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

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

• Connect to Exa Data in Ruby

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

• Model Google Spanner Data Using Azure Analysis Services

  Leverage CData Connect AI to establish a connection between Azure Analysis Services and Google Spanner, enabling the direct import of real-time Google Spanner data.

• How to integrate Metabase with Google Ad Manager Data

  Use CData Connect AI to connect to live Google Ad Manager data and create an interactive dashboard in Metabase from Google Ad Manager data.

• Integrate BigCommerce Data into Automated Tasks with Power Automate

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

• Use Dash to Build to Web Apps on MYOB AccountRight Data

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

• Use the CData Software JDBC Driver for Avro in MicroStrategy

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

• Access Live Zoho Books Data in Excel 365 Online (Excel for the web)

  Connect to Zoho Books data from Excel 365 Online (Excel for the web) with CData Connect AI.

• Create a Data Access Object for xBase Data using JDBI

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

• Automated Short.io Data Replication to Teradata

  Use CData Sync to Customize and automate Short.io data replication to Teradata.

• Automated Continuous REST Replication to Vertica

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

• Build Automated Workflows with Live Xero Data in Workato

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

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

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

• Access Discord Data from MySQL in Amazon QuickSight

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

• Automate MailerLite Integration Tasks from PowerShell

  Are you in search of a quick and easy way to access MailerLite data from PowerShell? This article demonstrates how to utilize the MailerLite Cmdlets for tasks like connecting to MailerLite data, automating operations, downloading data, and more.

• Connect to FTP from Excel & GoogleSheets!

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

• Analyze Close Data with Power Pivot

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

• Visualize IBM Informix Data in Sisense

  Create an ElastiCube in Sisense app with access to IBM Informix data.

• Query, Visualize, and Share live Dynamics 365 Business Central Data in Redash

  Use CData Connect AI to connect to live Dynamics 365 Business Central data in Redash for querying, visualizing, and sharing.

• How to Connect to Live HubDB Data in Mistral AI Workflows and Agents (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live HubDB data without replication.

• Connect to Bullhorn CRM Data from Blazor Apps

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

• Provide OData Services of Smartsheet Data from a WCF Application

  In this article, we will demonstrate the process of generating an OData feed for Smartsheet data by developing a WCF Service Application.

• How to publish and share Vault CRM Data dashboards with Tableau Server

  The CData ODBC driver for Vault CRM enables you integrate Vault CRM data into Tableau dashboards.

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

• DataBind Controls to Sugar CRM Data in Delphi

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

• Integrate with Vault CRM Data in SnapLogic

  Use CData Connect AI to connect to and integrate with live Vault CRM data in SnapLogic.

• Visualize Access Data in TIBCO Spotfire through ADO.NET

  Integrate Access data into dashboards in TIBCO Spotfire.

• Excel Spreadsheet Automation on Planio Data with the QUERY Formula

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

• Connect to AlloyDB Data through External Services in Salesforce

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

• Use Grok to Talk to Your Authorize.Net 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 Authorize.Net data for you.

• Migrating data from Google Search to Databricks using CData SSIS Components.

  Easily push Google Search results to Databricks using the CData SSIS Tasks for Google Search and Databricks.

• Analyze Samanage Data in R via ODBC

  Create data visualizations and use high-performance statistical functions to analyze Samanage data in Microsoft R Open.

• Access SFTP Data from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live SFTP data from HeidiSQL.

• Write a Simple Go Application to work with Moosend Data on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Moosend data.

• Access Live MariaDB Data in Excel (Desktop) through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live MariaDB data from your Excel spreadsheets.

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

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

• DataBind Controls to Recurly Data in Delphi

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

• How to integrate Freshteam with Apache Airflow

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

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

• Integrate Google's Vertex AI Agent with Live Sybase IQ Data via CData Connect AI

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

• Add Act-On Data to Informatica Enterprise Data Catalog

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

• «
• 633
• 634
• 635
• 636
• 637
• 638
• 639
• 640
• 641
• 642
• »