CData Software - Knowledge Base

Recent Articles

• «
• 276
• 277
• 278
• 279
• 280
• 281
• 282
• 283
• 284
• 285
• »

• How to Query SingleStore in MySQL Workbench

  Execute MySQL queries against live SingleStore from MySQL Workbench.

• How to publish and share Elasticsearch dashboards with Tableau Server

  The CData ODBC driver for Elasticsearch enables you integrate Elasticsearch into Tableau dashboards.

• Use Biml to Build SSIS Tasks to Replicate SAP SuccessFactors to SQL Server

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

• Visualize Live eBay Analytics in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live eBay Analytics.

• Connect Office 365 to AI Assistants With the CData Python MCP Server

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

• Integrate Epicor Kinetic in the Pentaho Report Designer

  Publish reports based on Epicor Kinetic in the Pentaho BI tool.

• Visualize Jira Assets in TIBCO Spotfire through ODBC

  The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Jira Assets into TIBCO Spotfire.

• How to Query Live Zoom Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live Zoom data in natural language using Python.

• Work with MySQL in FoxPro

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

• How to create ShipStation federated tables in MySQL

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

• How to Connect DBeaver to Google Calendar via a JDBC Driver

  Manage Google Calendar with visual tools in DBeaver like the query browser.

• Access Asana from MySQL in HeidiSQL

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

• Bidirectional Access to Oracle Eloqua from FileMaker Pro

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

• Use the CData Software ODBC Driver for Dynamics NAV in MicroStrategy

  Connect to Microsoft Dynamics NAV in MicroStrategy Developer using the CData Software ODBC Driver for Dynamics NAV.

• Load JSON Services to a Database Using Embulk

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

• Build an OLAP Cube in SSAS from Greenhouse

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

• Automated Continuous EnterpriseDB Replication to Google BigQuery

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

• Deploy the ADO.NET Provider for Bing Ads on an SSRS Report Server

  Connect to Bing Ads from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

• Operational Reporting on Zoho Projects from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Zoho Projects.

• Build ServiceNow-Connected Apps in Mendix

  Use CData Connect Cloud to create an OData feed for ServiceNow and create custom apps in Mendix.

• View Reports on Real-Time Oracle Service Cloud in Power BI Report Server

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

• Use Biml to Build SSIS Tasks to Replicate Highrise to SQL Server

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

• Integrate with SQL Analysis Services in JReport Designer

  Create charts and reports based on SQL Analysis Services in JReport Designer.

• Prepare, Blend, and Analyze Google Directory in Alteryx Designer (Connect Cloud)

  Build workflows to access live Google Directory for self-service data analytics.

• How to Design Twilio Power Apps with Database-Like Connectivity

  This article shows how to gain real-time, database-like connectivity from mobile and tablet Power Apps.

• Build Dashboards with BigCommerce in Dundas BI

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

• Automated Continuous Dynamics NAV Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable Microsoft Dynamics NAV replication to OneLake in Microsoft Fabric.

• How to connect PolyBase to HDFS

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

• Oracle SCM Cloud Connectivity

  Explore a compilation of guides and tutorials demonstrating how to establish connections to Oracle SCM through CData Connect Cloud using different applications and tools.

• How to update Access from Excel

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

• Create Datasets from HubSpot in Domo Workbench and Build Visualizations of HubSpot in Domo

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

• Create Azure DevOps-Connected Nintex Workflows

  Use CData Connect Cloud to connect to Azure DevOps from Nintex Workflow Cloud and build custom workflows using live Azure DevOps.

• Create Dynamics 365 Business Central-Connected Visualizations in Klipfolio

  Use CData Connect Cloud to connect to Dynamics 365 Business Central from Klipfolio and build custom visualizations using live Dynamics 365 Business Central.

• Access GraphQL 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 GraphQL.

• Perform Batch Operations with JDBC-ODBC Bridge in Apache NiFi

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

• Viewing Microsoft OneDrive in RAD Studio Data Explorer

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

• Automated Continuous Drip Replication to SQLite

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

• Access Live SAP Hybris C4C in AWS Lambda

  Connect to live SAP Hybris C4C in AWS Lambda using the CData JDBC Driver.

• Google Drive Reporting in OBIEE with the Google Drive JDBC Driver

  Deploy the Google Drive JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• Automated Continuous Stripe Replication to SQLite

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

• DataBind Adobe Target to the DevExpress Data Grid

  Use the CData Software ADO.NET Provider for Adobe Target with the DevExpress Windows Forms and Web controls to provide Adobe Target to a chart.

• Connect to Salesforce Marketing as an External Source in Dremio

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

• Use Claude to Talk to Your Google Campaign Manager 360 via CData Connect Cloud

  Leverage CData Connect Cloud Remote MCP to enable Claude to securely answer questions and take actions on your Google Campaign Manager 360 for you.

• Visualize Live Neo4J in Tableau

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

• How to Import Data from Sage Intacct into Google Sheets

  Import Sage Intacct into a Google spreadsheet that is automatically refreshed.

• Use Dash to Build to Web Apps on Printful

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

• Automated Continuous Zuora Replication to SQLite

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

• Replicate Multiple Microsoft Teams Accounts via the CData Sync CLI

  Replicate multiple Microsoft Teams accounts to one or many databases.

• Work with Live AlloyDB in Power Query

  Use CData Connect Cloud to connect to Google AlloyDB and work with live Google AlloyDB in Microsoft Power Query.

• Trigger Instagram IFTTT Flows in Azure App Service

  This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps.

• Automate MySQL Replication to Azure Data Lake

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

• Create Power BI Reports on Real-Time Raisers Edge NXT

  Use the CData ODBC Driver for Raisers Edge NXT to visualize Raisers Edge NXT in Power BI Desktop.

• Connect to Teradata in DBeaver

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

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

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

• How to integrate CouchDB with Apache Airflow

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

• Publish Reports with Azure Synapse in SAP Crystal Reports

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

• Build Cosmos DB-Connected Visualizations in datapine

  Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Azure Cosmos DB.

• Replicate Harvest from PowerShell

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

• DataBind Charts to ShipStation

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to ShipStation 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.

• Import FHIR into the Power BI Service for Visualizations

  Use CData Connect Cloud to connect to FHIR and provide access to live FHIR for custom reports in the Power BI Service.

• How to Build an ETL App for Drip in Python with CData

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

• Validate Marketo with QuerySurge

  Access and validate Marketo in QuerySurge using the CData JDBC Driver.

• Automated Continuous Salesforce Replication to Amazon Redshift

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

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

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

• Integrate with live Databricks in Jitterbit

  Use CData Connect Cloud to connect to and integrate live Databricks in Jitterbit.

• Replicate Facebook Ads to Multiple Databases via the CData Sync CLI

  Replicate Facebook Ads to disparate databases with a single configuration.

• Connect to MySQL in the Denodo Platform

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

• Visualize Live SAP Business One in the Power BI Service

  Use CData Connect Cloud to connect to live SAP Business One and create custom reports in the Power BI Service through the On-Premises Gateway.

• Replicate CData Connect Cloud to Multiple Databases

  Replicate CData Connect Cloud to disparate databases with a point-and-click configuration.

• Connect to Asana in Ruby

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

• Office 365 Cloud Connectivity

  Explore a compilation of guides and tutorials demonstrating how to establish connections to Microsoft Office 365 through CData Connect Cloud using different applications and tools.

• How to integrate Metabase with Redis

  Use CData Connect Cloud to connect to live Redis and create an interactive dashboard in Metabase from Redis.

• Prepare, Blend, and Analyze Airtable in Alteryx Designer (Connect Cloud)

  Build workflows to access live Airtable for self-service data analytics.

• Build Presto-Connected Apps in Bubble

  Use CData Connect Cloud to create an OData feed for Presto and create custom apps in Bubble.

• Automated Continuous HDFS Replication to Amazon Redshift

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

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

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

• Connect to AlloyDB in CloverDX (formerly CloverETL)

  Transfer Google AlloyDB using the visual workflow in the CloverDX data integration tool.

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

  Connect to Kintone from a connection pool in Tomcat.

• Integrating Oracle Eloqua in Talend Cloud Data Management Platform

• «
• 276
• 277
• 278
• 279
• 280
• 281
• 282
• 283
• 284
• 285
• »