CData Software - Knowledge Base

Recent Articles

---

• «
• 335
• 336
• 337
• 338
• 339
• 340
• 341
• 342
• 343
• 344
• »

• Use the CData API Server to Access Salesloft Data in Microsoft PowerPivot

  Use the CData API Server to connect to live Salesloft in the Power Pivot business intelligence tool.

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

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

• Enable the Yelp JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with Yelp.

• Integrate Smartsheet with JetBrains RubyMine using CData JDBC Drivers

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

• Visualize GitHub Data in Sisense

  Create an ElastiCube in Sisense app with access to GitHub.

• Create Act CRM-Connected Business Apps in AppSheet

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

• Connect to Amazon Marketplace from Asprova with CData Software ODBC Driver for Amazon Marketplace

  This article shows how to connect faster to Amazon Marketplace data from Asprova.

• Build an OLAP Cube in SSAS from Sage 200 Data

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

• Building Dynamic Web Pages with SAP Concur Data Using AngularJS

  Create single-page applications with live connectivity to SAP Concur using the CData API Server.

• Connect to and Query SparkPost Data in QlikView over ODBC

  Create data visualizations with SparkPost in QlikView.

• How to Work with Placid Data in ETL Validator JDBC

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

• How to Connect to Teamgate Data in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to Teamgate. Leverage the pyodbc module for ODBC in Python.

• Use the CData Software ODBC Driver for ZohoExpense in SAS for Real-Time Reporting and Analytics

  Connect to real-time ZohoExpense in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ZohoExpense.

• Connect to GitHub Data in Ruby

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

• Automated Continuous GraphQL Data Replication to OneLake in Microsoft Fabric

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

• Easily Integrate ADP Data in Lazarus Pascal IDE

  Learn how to easily integrate live ADP in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.

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

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

• How to Connect to Live MYOB AccountRight Data in n8n Workflows and Agents (via CData Connect AI)

  Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your MYOB AccountRight for you.

• DataBind Controls to Drift Data in C++Builder

  DataBind to Drift in C++Builder with standard components and controls.

• Publish Reports with Odoo Data in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Odoo ERP.

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

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

• Visualize Live Google Spanner Data in the Power BI Service

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

• Connect Wave Financial to IBM WebSphere Using the CData JDBC Driver

  Use the CData JDBC Driver to connect Wave Financial with IBM WebSphere for seamless data integration and connectivity.

• Query Miro Data as a MySQL Database in Node.js

  Execute MySQL queries against Miro from Node.js.

• Smartsheet Reporting and Star Schemas in OBIEE

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

• Visualize Blackbaud FE NXT Data from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Blackbaud FE NXT.

• How to Build an ETL App for Google Contacts Data in Python with CData Connect AI

  Build ETL pipelines that read and write live Google Contacts in Python with petl and the CData Connect AI Python SDK.

• How to connect to SendInBlue Data with Squirrel SQL client

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

• Connect to Pingdom Data in Jaspersoft Studio

  Execute SQL to remote Pingdom in Jaspersoft Studio.

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

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

• Create Reports with MariaDB Data in SAP Crystal Reports

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

• Migrating data from Google Sheets to Snowflake using CData SSIS Components.

  Easily push Google Sheets to Snowflake using the CData SSIS Tasks for Google Sheets and Snowflake.

• Connecting Agentforce with Shopify Data via CData Connect AI MCP Server

  Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Shopify for you.

• Build MVC Applications with Connectivity to DB2 Data

  This article shows how to use only the Entity Framework and the CData ADO.NET provider to access DB2 from an ASP.NET MVC application.

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

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

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

  Provide connectivity to Xero Accounting through an SAP BusinessObjects universe.

• Create Dashboards and Visualize Live SAS xpt Data in Geckoboard

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

• Connect to Ontraport Data in CloverDX (formerly CloverETL)

  Transfer Ontraport using the visual workflow in the CloverDX data integration tool.

• Publish Sage 200-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Sage 200.

• How to publish and share Blackbaud FE NXT Data dashboards with Tableau Server

  The CData ODBC driver for Blackbaud FE NXT enables you integrate Blackbaud FE NXT into Tableau dashboards.

• Connecting Moonlit Workflow with Act-On Data via CData Connect AI MCP Server

  Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Act-On in real time.

• Excel Spreadsheet Automation on Google Ad Manager Data with the QUERY Formula

  Pull data from Google Ad Manager, automate spreadsheets, and more with the QUERY formula.

• Automated Continuous Facebook Replication to Google BigQuery

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

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

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

• Automated Continuous Eventbrite Replication to Apache Cassandra

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

• Visualize XML Data in Tableau

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

• How to connect to Jumpseller Data in DBVisualizer

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

• Use Biml to Build SSIS Tasks to Replicate ZendeskSell Data to SQL Server

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

• Explore Geographical Relationships in Factorial Data with Power Map

  Create data visualizations with Factorial in Power Map.

• Getting Started with the CData Power BI Connector for Couchbase

  Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Couchbase.

• Manage Azure DevOps Data in DBArtisan as a JDBC Source

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

• Analyze Anaplan Data with Power Pivot

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

• Access Live Accelo Data in SAS JMP via ODBC

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

• Integrate Gong Data into Automated Tasks with Power Automate

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

• Connect to PayPal Data as a SQL Server Linked Server

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

• Use Biml to Build SSIS Tasks to Replicate Teradata Data to SQL Server

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

• Connect to Mistral AI Data in RapidMiner

  Integrate Mistral AI with standard components and data source configuration wizards in RapidMiner Studio.

• Publish Placid-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Placid.

• Use the CData Software JDBC Driver for Tickspot in MicroStrategy Desktop

  Connect to Tickspot in MicroStrategy Desktop using the CData Software JDBC Driver for Tickspot.

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

• DataBind Controls to SQL Analysis Services Data in Delphi

  DataBind to SQL Analysis Services in Delphi with standard data access components and controls.

• Build MVC Applications with Connectivity to SAP Ariba Source Data

  This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SAP Ariba Source from an ASP.NET MVC application.

• Access ZohoInvoice Data 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 ZohoInvoice.

• Use the CData API Server in Microsoft Power BI

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

• Create Bitbucket Dataflows on PowerBI.com

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

• Integrating Keap Data in Talend Cloud Data Management Platform

  Connect Keap Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.

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

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

• Connect to OpenWeatherMap Data in DBArtisan

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

• Prepare, Blend, and Analyze Smartsheet Data in Alteryx Designer (Connect AI)

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

• Explore Geographical Relationships in Oracle HCM Cloud Data with Power Map

  Create data visualizations with Oracle HCM Cloud in Power Map.

• Create a Data Access Object for Azure Table Data using JDBI

  A brief overview of creating a SQL Object API for Azure Table Storage in JDBI.

• Integrating LlamaIndex with Oracle Sales Data via CData Connect AI

  Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Oracle Sales in real time.

• Build Charts with Presto Data in Clear Analytics

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

• Analyze Jira Assets Data in R via ODBC

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

• Access Contentful Data from MySQL in Amazon QuickSight

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

• Automated Continuous Salesforce Marketing Replication to Vertica

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

• Work with Live Slack Data in Power Query

  Use CData Connect AI to connect to Slack and work with live Slack in Microsoft Power Query.

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

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

• Build an OLAP Cube in SSAS from NASA Data

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

• Connect to Google Ads Data in ACL Analytics

  Connect to Google Ads via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Google Ads.

• Prepare, Blend, and Analyze Oracle Eloqua Reporting Data in Alteryx Designer (ODBC)

  Build workflows to access live Oracle Eloqua Reporting for self-service data analytics.

• Edit and Search External MarkLogic Objects in Salesforce Connect

  Use CData Connect AI to securely provide OData feeds of MarkLogic to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create MarkLogic Data objects that you can access from apps and the dashboard.

• Rapidly Develop PabblySubscriptions-Driven Apps with Active Query Builder

  Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by PabblySubscriptions.

• Build Apps with Live Workable Data Using the Low-Code Development Platform of Mendix

  Connect Workable with Mendix to build apps using the CData API Driver for JDBC.

• Getting Started with the CData SSIS Components for Facebook Ads

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

• Model, Search, and Visualize Live Twitter Ads Data in ThoughtSpot

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

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

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

• Connect to Oracle Sales Data in Aqua Data Studio

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

• ETL SingleStore in Oracle Data Integrator

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

• Create HDFS Reports on JasperReports Server

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

• Design BIRT Reports on SharePoint Excel Services Data

  Provide current SharePoint Excel Services to your embedded analytics.

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

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

• Automate Google Ads Data Replication to Azure Data Lake

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

• Integrate Microsoft Exchange Data in the Pentaho Report Designer

  Publish reports based on Microsoft Exchange in the Pentaho BI tool.

• How to Query Live WordPress Data in Claude Desktop

  Connect to and query live WordPress Data in Claude Desktop using CData MCP Server.

• Build Data Flows from CockroachDB to SQL Server using SSIS

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

• Import AlloyDB Data Using Azure Data Factory

  Use CData Connect AI to connect to AlloyDB Data from Azure Data Factory and import live Google AlloyDB.

• Replicate MessageBird Data to Multiple Databases via the CData Sync CLI

  Replicate MessageBird to disparate databases with a single configuration.

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

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

• Automated Continuous Yelp Replication to PostgreSQL

  Use CData Sync for automated, continuous, customizable Yelp replication to PostgreSQL.

• «
• 335
• 336
• 337
• 338
• 339
• 340
• 341
• 342
• 343
• 344
• »