CData Software - Knowledge Base

Recent Articles

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

• Build Dashboards with Splunk in DBxtra

  Create dynamic dashboards and perform analytics based on Splunk in DBxtra.

• Connect to Paylocity in Ruby

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

• Connect to Amazon S3 in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Automated Vault CRM Replication to Teradata

  Use CData Sync to Customize and automate Veeva Vault & Vault CRM replication to Teradata.

• Use JayDeBeApi to access SQL Server in Python

  Use standard Python scripting and the development environment of your choice to access live Microsoft SQL Server.

• How to connect to Slack with Squirrel SQL client

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

• Build Data Flows from SQL Server to Facebook through SSIS

  Easily push SQL Server data to Facebook using the CData SSIS Tasks for Facebook.

• Connect to Slack in Aqua Data Studio

  Access Slack from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

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

  Learn how to easily build a Singer.io Tap for live Access data using

• Connect to Azure Data Catalog in JRuby

  Create a simple JRuby app with access to live Azure Data Catalog.

• Build Charts with QuickBooks Online in Clear Analytics

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

• Create Data Visualizations in Cognos BI with Twitter

  Access Twitter as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

• Extend Google Sheets with Acumatica

  Make calls to the API Server from Google Apps Script.

• Replicate Google Ads from PowerShell

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

• Create Adobe Commerce-Connected Applications in Appsmith

  Connect to Adobe Commerce via CData Connect AI in Appsmith and create custom business applications with real-time access to Adobe Commerce.

• How to Visualize Epicor Kinetic Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Epicor Kinetic in Python.

• Model, Search, and Visualize Live Salesforce Pardot in ThoughtSpot

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

• Connect and Query Live Google Campaign Manager 360 Data in Databricks with CData Connect AI

  Use CData Connect AI to integrate live Google Campaign Manager 360 into Databricks

• Bidirectional Access to Oracle Eloqua Reporting from FileMaker Pro

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

• Automate QuickBooks Online Integration Tasks from PowerShell

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

• Import Amazon Athena into Microsoft Power Query

  The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Amazon Athena. In this article, you will use the OData format to import Amazon Athena into Microsoft Power Query.

• How to Query Live RSS Feeds in Claude Desktop

  Connect to and query live RSS Feeds in Claude Desktop using the CData MCP Server.

• Operational Reporting on TaxJar from Spotfire Server

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

• Getting Started with the CData Python Connector for Snowflake

  Learn to install and license the CData Python Connector

• Establish a Live Connection with Klipfolio using Tableau Bridge

  The CData ODBC Driver for Klipfolio enables you to integrate live Klipfolio into Tableau Cloud dashboards using the Tableau Bridge.

• Automated Continuous Printify Replication to Google Cloud SQL

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

• Use Dash to Build to Web Apps on SAP Ariba Procurement

  Create Python applications that use pandas and Dash to build SAP Ariba Procurement-connected web apps.

• Connect to Live Sage 200 in MicroStrategy through CData Connect AI

  Create a live connection to Sage 200 in CData Connect AI and connect to your Sage 200 from MicroStrategy.

• Connect to Greenhouse in DBArtisan

  Use wizards in DBArtisan to configure Greenhouse as a data source.

• Consume Salesforce Marketing OData Feeds in SAP Lumira

  Use the API Server to create data visualizations on Salesforce Marketing feeds that reflect any changes in SAP Lumira.

• Automated Continuous AlloyDB Replication to MongoDB

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

• Integrating Gumloop with Google Contacts via CData Connect AI

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

• Migrating data from Microsoft Dataverse to Snowflake using CData SSIS Components.

  Easily push Microsoft Dataverse (CDS) to Snowflake using the CData SSIS Tasks for Microsoft Dataverse and Snowflake.

• Automated Continuous Box Replication to SQL Server

  Use CData Sync for automated, continuous, customizable Box replication to SQL Server.

• Visualize Live YouTube Analytics in the Power BI Service

  Use CData Connect AI to connect to live YouTube Analytics and create custom reports in the Power BI Service through the On-Premises Gateway.

• Connect to Invoiced in DBArtisan

  Use wizards in DBArtisan to configure Invoiced as a data source.

• Integrate Excel Online in the Pentaho Report Designer

  Publish reports based on Microsoft Excel Online in the Pentaho BI tool.

• Build an OLAP Cube in SSAS from Instagram

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

• Excel Spreadsheet Automation on MariaDB with the QUERY Formula

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

• Working with Avalara AvaTax in LINQPad

  Execute LINQ queries to Avalara AvaTax in LINQPad.

• Create eBay Reports on JasperReports Server

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

• Use the CData ODBC Driver for SAP Fieldglass in Microsoft Power Query

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

• Query eBay in DataGrip

  Create a Data Source for eBay in DataGrip and use SQL to query live eBay.

• How to load Todoist data into Elasticsearch via Logstash

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

• Manage Blackbaud FE NXT in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for Blackbaud FE NXT.

• Create Dashboards and Visualize Live Zuora in Geckoboard

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

• Visualize Twilio in Sisense

  Create an ElastiCube in Sisense app with access to Twilio.

• Query Greenplum using the OData SDK for PHP

  Use the API Server and the OData PHP SDK to easily consume Greenplum entities in PHP by modeling them as objects.

• Create Apps from MySQL in Qlik Sense Cloud

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

• Integrate Google

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

• Integrate Marketo in Pentaho Data Integration

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

• Bidirectional Access to SAP ByDesign from FileMaker Pro

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

• DataBind Charts to Printify

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

• Connect to eBay from PowerBuilder via ADO.NET

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

• Establish a Live Connection with HDFS using Tableau Bridge

  The CData ODBC Driver for HDFS enables you to integrate live Apache HDFS into Tableau Cloud dashboards using the Tableau Bridge.

• Replicate YouTube Analytics to Multiple Databases via the CData Sync CLI

  Replicate YouTube Analytics to disparate databases with a single configuration.

• Visualize TigerGraph from Tableau

  Use the Tableau Desktop business intelligence tool to connect to TigerGraph.

• Connect to Azure Synapse in CloverDX (formerly CloverETL)

  Transfer Azure Synapse using the visual workflow in the CloverDX data integration tool.

• Visualize xBase in TIBCO Spotfire through OData

  Integrate xBase into dashboards in TIBCO Spotfire.

• Publish Reports with SQL Server in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Microsoft SQL Server.

• Automated Continuous Azure Data Catalog Replication to Vertica

  Use CData Sync for automated, continuous, customizable Azure Data Catalog replication to Vertica.

• Publish Raisers Edge NXT-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Raisers Edge NXT.

• How to Work with Sage 200 in AWS Glue Jobs Using JDBC

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

• Visualize Live IBM Cloud Object Storage of Power BI Report Builder in Power BI Service

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

• Replicate Google Search Results in Heroku for Use in Salesforce Connect

  Replicate Google Search to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Query Phoenix from Node.js

  Use the OData endpoint of the CData API Server to connect to your Apache Phoenix and perform CRUD operations on Phoenix from Node.js.

• Bridge SingleStore Connectivity with Apache NiFi

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

• Feed REST into FineReport

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

• Automated Continuous Power BI XMLA Replication to Microsoft Access

  Use CData Sync for automated, continuous, customizable Power BI XMLA replication to Microsoft Access.

• How to Connect Flowise AI Agents to Live Smartsheet via CData Connect AI

  Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live data without replication.

• Create Dynamic Vault CRM Grids Using the Infragistics XamDataGrid

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

• Build DocuSign-Connected Apps in Choreo

  Use CData Connect AI to connect to DocuSign from Choreo and build custom apps using live DocuSign.

• How to Work with Kafka in ETL Validator JDBC

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

• Analyze SAP Ariba Source in R via ODBC

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

• Visualize Elasticsearch in TIBCO Spotfire through ADO.NET

  Integrate Elasticsearch into dashboards in TIBCO Spotfire.

• Integrating Boomi Agentstudio with Oracle Service Cloud via CData Connect AI

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

• Use Claude to Talk to Your Azure Synapse via CData Connect AI

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

• Use the CData ODBC Driver for Monday.com from SharePoint Excel Services

  This article demonstrates how to use the CData ODBC Driver for Monday.com to connect to Monday.com from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Monday.com in Excel.

• Use Biml to Build SSIS Tasks to Replicate Oracle Eloqua to SQL Server

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

• How to Access SAP Concur Using Entity Framework

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

• Use the CData API Server in Microsoft Power BI

  You can use the CData API Server to feed SFTP to Power BI dashboards. Simply drag and drop SFTP into data visuals on the Power BI canvas.

• Consume Cosmos DB OData Feeds in PowerBuilder

  This article demonstrates how to consume Azure Cosmos DB as OData feeds from PowerBuilder using the API Server.

• Integrate with Zoho CRM in SnapLogic

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

• Building Dynamic Web Pages with Zoho Books Using AngularJS

  Create single-page applications with live connectivity to Zoho Books using the CData API Server.

• Build a Singer.io Tap for Raisers Edge NXT With the CData Python Connector

  Learn how to easily build a Singer.io Tap for live Raisers Edge NXT data using

• Build an OLAP Cube in SSAS from Zuora

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

• Access EnterpriseDB from MySQL in Amazon QuickSight

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

• How to create Visio diagrams from Redshift

  Automatically update Amazon Redshift with the changes you make to Visio master shapes.

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

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

• How to Easily Query GraphQL in OpenOffice Base

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