CData Software - Knowledge Base

Recent Articles

• «
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• »

• Create Dashboards and Visualize Live Paylocity in Geckoboard

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

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

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

• How to Query Live SAP BusinessObjects BI Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live SAP BusinessObjects BI data in natural language using Python.

• PowerShell Scripting to Replicate Avalara AvaTax to MySQL

  Write a simple PowerShell script to replicate Avalara AvaTax to a MySQL database.

• Visualize Live SFTP of Power BI Report Builder in Power BI Service

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

• Consume DocuSign OData Feeds in PowerBuilder

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

• Connect to SAP Business One in RazorSQL

  Connect to SAP Business One from wizards and query SAP Business One from the GUI in the RazorSQL database management tool.

• Connect to TigerGraph in DBeaver

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

• Write a Simple Go Application to work with SuiteCRM on Linux

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

• Integrate with Shopify using Apache Camel2

  Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Shopify to a JSON file on disk.

• Connect to Google Drive in CloverDX (formerly CloverETL)

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

• Build Google Spanner-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Google Spanner.

• Automated Continuous Oracle Eloqua Replication to OneLake in Microsoft Fabric

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

• How to Access CockroachDB Using Entity Framework

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

• How to integrate Metabase with Cosmos DB

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

• Automate Hive Tasks in Power Automate Using CData API Server

  With CData API Server, easily create OData endpoints for live Apache Hive and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.

• Build a PostgreSQL Interface for SAP using the CData JDBC Driver

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

• Integrate with Databricks in SnapLogic

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

• Build MailChimp-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to MailChimp and build web apps with connectivity to live MailChimp.

• Analyze Presto with Power Pivot

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

• Access Live Google Spanner in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

  Connect to Google Spanner from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

• Automated Continuous Stripe Replication to Local Delimited Files

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

• How to Work with Monday.com in ETL Validator JDBC

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

• Microsoft Exchange Reporting and Star Schemas in OBIEE

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

• Connect to DocuSign from Excel & GoogleSheets!

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

• Access Live Spark in SAS JMP via ODBC

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

• Import Real-Time Sage 50 UK via ODBC in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Sage 50 UK in ColdFusion.

• Query Google Sheets using the OData SDK for PHP

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

• Integrate with Freshdesk using Apache Camel2

  Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Freshdesk to a JSON file on disk.

• How to pipe Excel Online to CSV in PowerShell

  Use standard PowerShell cmdlets to access Excel Online tables.

• Connect to SurveyMonkey in the Denodo Platform

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

• Access Live Google Directory in TIBCO Data Virtualization

  Use the CData Software TIBCO DV Adapter for Google Directory to create a Google Directory source in TIBCO Data Virtualization Studio and gain access to live Google Directory from your TDV Server.

• Visualize Live ADP in the Power BI Service

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

• Explore Geographical Relationships in Exact Online with Power Map

  Create data visualizations with Exact Online in Power Map.

• Viewing Sybase in RAD Studio Data Explorer

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

• Connect to EnterpriseDB in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Access Dynamics 365 as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Microsoft Dynamics 365 from your Oracle system.

• Analyze MariaDB in R via ODBC

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

• How to Query Live ServiceNow in Claude Desktop

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

• Query, Visualize, and Share live DocuSign in Redash

  Use CData Connect Cloud to connect to live DocuSign in Redash for querying, visualizing, and sharing.

• Connect to Freshdesk as a Linked Server via SQL Gateway

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

• Access Live WooCommerce in AWS Lambda (with IntelliJ IDEA)

  Connect to live WooCommerce in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

• How to Design SAS Data Sets Power Apps with Database-Like Connectivity

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

• Create SSAS Tabular Models from Oracle Service Cloud

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

• Build Stripe-Connected Apps in Choreo

  Use CData Connect Cloud to connect to Stripe from Choreo and build custom apps using live Stripe.

• Connect Snapchat Ads to AI Assistants With the CData Python MCP Server

  Learn how to give AI assistants like Claude direct access to live Snapchat Ads using the CData Python MCP Server.

• Integrate Live Google Spanner into Amazon SageMaker Canvas with RDS

  Use CData Connect Cloud to connect to Google Spanner from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Google Spanner.

• Provide OData Services of Zoho Books from a WCF Application

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

• How to create SAP HANA federated tables in MySQL

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

• Use Dash to Build to Web Apps on IBM Cloud Object Storage

  Create Python applications that use pandas and Dash to build IBM Cloud Object Storage-connected web apps.

• Create a Data Access Object for FHIR using JDBI

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

• Access Live Klaviyo in AWS Lambda (with IntelliJ IDEA)

  Connect to live Klaviyo in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

• Automate PostgreSQL Replication to Azure Data Lake

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

• Rapidly Develop Pinterest-Driven Apps with Active Query Builder

  Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.

• Use the CData Software JDBC Driver for Airtable in MicroStrategy Web

  Connect to Airtable in MicroStrategy Web using the CData Software JDBC Driver for Airtable.

• Edit and Search External Trello Objects in Salesforce Connect

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

• Bidirectional Access to Pipedrive from FileMaker Pro

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

• Connect to Klaviyo from Blazor Apps

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

• Connect to Google Ad Manager in Ruby

  Connect to Google Ad Manager in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• How to connect to Drift from IntelliJ

  Integrate connectivity to Drift with wizards in IntelliJ.

• Replicate Multiple Bullhorn CRM Accounts

  Replicate multiple Bullhorn CRM accounts to one or many databases.

• Validate Snowflake with QuerySurge

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

• LINQ to Google Cloud Storage

  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 Google Cloud Storage Data Provider.

• Edit and Search External Jira Objects in Salesforce Connect

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

• How to create Power BI XMLA federated tables in MySQL

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

• Build Databricks-Connected Apps in Mendix

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

• Integrate Live Blackbaud FE NXT into Custom Business Apps Built in Power Apps

  Use CData Connect Cloud to connect to Blackbaud FE NXT and integrate live Blackbaud FE NXT into apps built in Microsoft Power Apps.

• Visualize Greenplum in Tableau

  The CData ODBC driver for Greenplum enables you integrate Pivotal GreenPlum into Tableau dashboards.

• Connect to SAP ByDesign from PowerBuilder via ADO.NET

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

• How to Work with Snapchat Ads in AWS Glue Jobs Using JDBC

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

• Build Oracle HCM Cloud-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Oracle HCM Cloud.

• Migrating data from Outreach.io to Snowflake using CData SSIS Components.

  Easily push Outreach.io to Snowflake using the CData SSIS Tasks for Outreach.io and Snowflake.

• Access Live Email Data in Tableau with CData API Server

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

• Extract, Transform, and Load Salesforce Pardot in Informatica PowerCenter

  Create a simple Workflow for Salesforce Pardot in Informatica PowerCenter.

• How to Easily Query ServiceNow in OpenOffice Base

• «
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• »