CData Software - Knowledge Base

Recent Articles

---

• «
• 383
• 384
• 385
• 386
• 387
• 388
• 389
• 390
• 391
• 392
• »

• Create Avro Dataflows on PowerBI.com

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

• Import Real-Time GraphQL Data via ODBC in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use GraphQL in ColdFusion.

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

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

• Connect to DocuSign Data in RazorSQL

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

• Visualize Live Act-On Data in the Power BI Service

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

• SendInBlue Reporting and Star Schemas in OBIEE

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

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

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

• Visualize Live ServiceNow Data in Tableau

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

• Build Data Flows from JotForm to SQL Server using SSIS

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

• Replicate Paddle Data from PowerShell

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

• A PostgreSQL Interface for Azure DevOps Data using the CData ODBC Driver

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

• Integrate Live MessageBird Data into Blue Prism for Intelligent Robotic Process Automation (RPA)

  Connect live MessageBird to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.

• Automate Workday Integration Tasks from PowerShell

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

• Integrate with live MySQL Data in Jitterbit

  Use CData Connect AI to connect to and integrate live MySQL in Jitterbit.

• How to Work with HelloSign Data in ETL Validator JDBC

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

• Create SSAS Tabular Models from Delighted Data

  How to build a SQL Server Analysis Service Tabular Model from Delighted using CData drivers.

• Automated Continuous Facebook Data Replication to OneLake in Microsoft Fabric

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

• Integrate Sage Cloud Accounting Data in the Pentaho Report Designer

  Publish reports based on Sage Business Cloud Accounting in the Pentaho BI tool.

• Visualize Salesforce Pardot 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 Salesforce Pardot into TIBCO Spotfire.

• Connect to Facebook Ads Data as a SQL Server Linked Server

  Use CData Connect AI to create a linked server for live Facebook Ads.

• Connect to and Query Zoho Inventory Data in QlikView over ODBC

  Create data visualizations with Zoho Inventory in QlikView.

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

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

• Automated Continuous Freshsales Replication to Vertica

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

• How to Connect to Live Email 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 Email for you.

• Seamlessly Bring Avalara AvaTax Data into Retool Using CData Connect AI

  Integrate Avalara AvaTax data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.

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

  Use the CData Connector for Spark in APOS Live Data Gateway to build Semantic Layer Views for Apache Spark SQL.

• Connect to Dynamics 365 Data from Blazor Apps

  Build ASP.NET Core Blazor C# apps that integrate with real-time Microsoft Dynamics 365 using standard SQL.

• Integrate Real-Time Access to Google Ads in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Google Ads in real time.

• Integrate Pinterest with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Pinterest with External Services.

• Integrate Google

  Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live GitLab using the Model Context Protocol.

• Automate Amazon Athena Data Replication to SAP HANA

  Use CData Sync to customize and automate Amazon Athena replication to SAP HANA.

• How to connect to Drift Data in DBVisualizer

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

• How to Connect to Live Bullhorn CRM Data from Google ADK Agents (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Bullhorn CRM for you.

• Provide OData Services of ZarMoney Data from a WCF Application

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

• Automated Continuous Klipfolio Replication to Local Delimited Files

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

• Automated Continuous Bullhorn CRM Replication to MongoDB

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

• How to connect to HubDB Data with Squirrel SQL client

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

• Access Live Google Directory Data in Emergent via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Google Directory through MCP integration.

• Connect to Shopify Data in RazorSQL

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

• Access Live LinkedIn Data in Tableau with CData API Server

  With CData API Server, easily create OData endpoints for live LinkedIn data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.

• How to connect to Billsby Data from Spring Boot

  Connect to Billsby in a Spring Boot Application using the CData API Driver for JDBC

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

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

• Access Telegram Data from MySQL in Amazon QuickSight

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

• Connect to Landbot Data in JRuby

  Create a simple JRuby app with access to live Landbot.

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

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

• Integrate Live Zendesk Data into Custom Business Apps Built in Power Apps

  Use CData Connect AI to connect to Zendesk and integrate live Zendesk into apps built in Microsoft Power Apps.

• A PostgreSQL Interface for Invoiced Data (MySQL Remoting via JDBC)

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

• Automated Continuous Campaigner Replication to Vertica

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

• Migrating data from Epicor Kinetic to Snowflake using CData SSIS Components.

  Easily push Epicor Kinetic to Snowflake using the CData SSIS Tasks for Epicor Kinetic and Snowflake.

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

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

• Analyze Live BigCommerce Data in SAS Viya

  Use CData Connect AI to connect to BigCommerce from SAS Viya and deploy self-service analytics using live BigCommerce.

• Connect to Oracle Eloqua Reporting Data in CloverDX (formerly CloverETL)

  Transfer Oracle Eloqua Reporting using the visual workflow in the CloverDX data integration tool.

• Query Live Impala Data in Zed Editor via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Apache Impala directly from the development environment.

• Connect to Gmail Data in Ruby

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

• Build a Simple VCL Application for MarkLogic Data

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

• How to connect PolyBase to Cosmos DB

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Azure Cosmos DB.

• Integrate with Smartsheet Data in SnapLogic

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

• Build an OLAP Cube in SSAS from Aha! Data

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

• Query Quickbase Data in ColdFusion

  Write standard ColdFusion data access code to connect to Quickbase.

• Publish Salesforce CRM Analytics-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Salesforce CRM Analytics.

• Feed Sage 300 Data into FineReport

  How to set Sage 300 as a JDBC data source in FineReport.

• Bidirectional Access to Close Data from FileMaker Pro

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

• Integrating Antigravity CLI with FHIR via CData CLI

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

• Extract, Transform, and Load Dynamics NAV Data in Informatica PowerCenter

  Create a simple Workflow for Microsoft Dynamics NAV in Informatica PowerCenter.

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

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

• Use Dash to Build to Web Apps on SageHR Data

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

• Access AdRoll Data from MySQL in HeidiSQL

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

• Connect to Browserless Data in Claris FileMaker Pro

  Use the CData API Driver for ODBC in FileMaker Pro to connect to Browserless and work with Browserless in your FileMaker applications.

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

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

• Excel Spreadsheet Automation on Retently Data with the QUERY Formula

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

• Natively Connect to HBase Data in PHP

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

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

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

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

• Analyze Epicor Kinetic Data with Power Pivot

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

• How to Seamlessly Import Google Contacts Data into IBM SPSS Modeler

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

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

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

• Visualize Azure Data Catalog Data in TIBCO Spotfire through OData

  Integrate Azure Data Catalog into dashboards in TIBCO Spotfire.

• Connect to Live Google Calendar Data in MicroStrategy through CData Connect AI

  Create a live connection to Google Calendar Data in CData Connect AI and connect to your Google Calendar from MicroStrategy.

• Build AI/ML Models with Live SAS xpt Data using Dataiku

  Connect SAS xpt Data with Dataiku using the CData JDBC Driver for SAS xpt.

• Create Informatica Mappings From/To an ODBC Data Source for MySQL

  Create an ODBC connection to MySQL in Informatica and browse and transfer MySQL.

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

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

• Create Reports from eBay Data in Looker Studio

  Use CData Connect AI to gain access to live eBay and create custom reports in Looker Studio.

• Build Charts with CapsuleCRM Data in Clear Analytics

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

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

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

• Integrate MongoDB with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate MongoDB with External Services.

• Visualize Google Spanner 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 Google Spanner into TIBCO Spotfire.

• Automate Presto Data Replication to SAP HANA

  Use CData Sync to customize and automate Presto replication to SAP HANA.

• Import Lakebase Data into the Power BI Service for Visualizations

  Use CData Connect AI to connect to Lakebase Data and provide access to live Lakebase for custom reports in the Power BI Service.

• Use the CData Software ODBC Driver for PayPal in MicroStrategy

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

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

• Use the CData ODBC Driver for Missive from SharePoint Excel Services

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

• Getting Started with the CData SSIS Components for TaxJar

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

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

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

• Connect to Coda Data in NetBeans

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

• Mocean Reporting in OBIEE with the Mocean JDBC Driver

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

• Create Data Visualizations in Cognos BI with Foursquare Data

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

• Build Automated Bullhorn CRM-Connected Workflows in Zapier

  Use CData Connect AI to connect to live Bullhorn CRM and build automated workflows in Zapier.

• Use JayDeBeApi to access Klaviyo Data in Python

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

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

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

• Validate Typeform Data with QuerySurge

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

• «
• 383
• 384
• 385
• 386
• 387
• 388
• 389
• 390
• 391
• 392
• »