CData Software - Knowledge Base

Recent Articles

• «
• 60
• 61
• 62
• 63
• 64
• 65
• 66
• 67
• 68
• 69
• »

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

  Create an ODBC connection to CSV in Informatica and browse and transfer CSV/TSV Files.

• Automated Continuous NetSuite SuiteAnalytics Replication to Azure SQL Database

  Use CData Sync for automated, continuous, customizable NetSuite SuiteAnalytics replication to Azure SQL Database.

• Automate Square Integration Tasks from PowerShell

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

• How to Connect to Office 365 in Using Python: 6 Steps

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

• Access Xero 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 Xero Accounting.

• Connect to JotForm in HULFT Integrate

  Connect to JotForm as a JDBC data source in HULFT Integrate

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

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

• Publish SQL Analysis Services-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live SQL Analysis Services.

• Stream Email into Apache Kafka Topics

  Access and stream Email in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Visualize SAP ByDesign in TIBCO Spotfire through ODBC

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

• Create Apps from Bullhorn CRM in Qlik Sense Cloud

  Use CData Connect Cloud to connect to Bullhorn CRM and build apps from live Bullhorn CRM in Qlik Sense Cloud.

• Sage 300 Reporting and Star Schemas in OBIEE

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

• Work with Live Bullhorn CRM in Power Query

  Use CData Connect Cloud to connect to Bullhorn CRM and work with live Bullhorn CRM in Microsoft Power Query.

• Analyze SharePoint Excel Services in R via JDBC

  Use standard R functions and the development environment of your choice to analyze SharePoint Excel Services with the CData JDBC Driver for SharePoint Excel Services.

• How to Access Live SAP HANA XS Advanced in Visual Studio Code via Cline

  Run the CData MCP Server for SAP HANA XS Advanced on Windows Subsytem for Linux (WSL) and connect to live SAP HANA XS Advanced from the Cline extension in Visual Studio Code.

• Bidirectional Access to Adobe Commerce from FileMaker Pro

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

• Visualize Sybase IQ in Tableau

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

• Query MySQL from Node.js

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

• Model, Search, and Visualize Live AlloyDB in ThoughtSpot

  Use CData Connect Cloud to connect to live Google AlloyDB for modeling, searching, and visualizing.

• Access Live SharePoint Excel Services in Coginiti Pro

  Connect to and query live SharePoint Excel Services from the GUI in the Coginiti Pro: SQL Analytics Tool.

• Create Power BI Reports on Real-Time Zoho Inventory

  Use the CData ODBC Driver for Zoho Inventory to visualize Zoho Inventory in Power BI Desktop.

• Use the CData Software ODBC Driver for REST in MicroStrategy Web

  Connect to REST in MicroStrategy Web using the CData Software ODBC Driver for REST.

• Extend Google Sheets with OneNote

  Make calls to the API Server from Google Apps Script.

• Query CouchDB using the OData SDK for PHP

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

• Use the CData API Server in Microsoft Power BI

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

• Use the CData Software ODBC Driver for OData in MicroStrategy

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

• Replicate Multiple SAP HANA Accounts

  Replicate multiple SAP HANA accounts to one or many databases.

• How to Import Data from Microsoft Teams into Google Sheets

  Import Microsoft Teams into a Google spreadsheet that is automatically refreshed.

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

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

• Publish Crystal Reports on HarperDB

  Use the Report Wizard and standard ADO.NET to design a report based on up-to-date HarperDB.

• Access Live SAP Fieldglass in Coginiti Pro

  Connect to and query live SAP Fieldglass from the GUI in the Coginiti Pro: SQL Analytics Tool.

• Visualize Sage 300 in TIBCO Spotfire through ODBC

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

• Automate Todoist Integration Tasks from PowerShell

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

• Analyze Google Search Results in Looker

  Use CData Connect Cloud to connect to Google Search Results from Looker and build custom apps using live Google Search.

• How to Access Monday.com Using Entity Framework

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

• LINQ to Coinbase

  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 Coinbase Data Provider.

• Gmail Reporting in OBIEE with the Gmail JDBC Driver

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

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

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

• Model, Search, and Visualize Live Google Sheets in ThoughtSpot

  Use CData Connect Cloud to connect to live Google Sheets for modeling, searching, and visualizing.

• Visualize SAP SuccessFactors in Tableau

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

• Visualize Live SFTP in Tableau

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

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

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

• Connect and Query Live Airtable Data in Databricks with CData Connect Cloud

  Use CData Connect Cloud to integrate live Airtable into Databricks

• Connect to Microsoft Teams from PowerBuilder via ODBC

  This article demonstrates how to use the CData ODBC Driver for Microsoft Teams to connect to Microsoft Teams and execute queries in PowerBuilder.

• Consume Amazon Marketplace OData Feeds in SAP Lumira

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

• Connect to Presto through External Services in Salesforce

  Use CData Connect Cloud to securely connect Salesforce External Services with Presto using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.

• Connect to Google Campaign Manager 360 in Google Apps Script via SQL Gateway

  Use the ODBC Driver for Google Campaign Manager 360 and the SQL Gateway to access Google Campaign Manager 360 from Google Apps Script.

• Automated Continuous Zoho Books Replication to MongoDB

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

• Automate Azure DevOps Tasks in Power Automate Using CData API Server

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

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

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

• Access Parquet from MySQL in HeidiSQL

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

• Automated Continuous Oracle HCM Cloud Replication to Google BigQuery

  Use CData Sync for automated, continuous, customizable Oracle HCM Cloud replication to Google BigQuery.

• Connect to Monday.com from Filemaker Pro (Mac)

  Use CData Connect Cloud to connect to and query live Monday.com from Filemaker Pro on Mac.

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

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

• Automated Paylocity Replication to Teradata

  Use CData Sync to Customize and automate Paylocity replication to Teradata.

• Build Dashboards with Act-On in DBxtra

  Create dynamic dashboards and perform analytics based on Act-On in DBxtra.

• Rapidly Develop HubDB-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.

• Access Live OData Services in AWS Lambda

  Connect to live OData in AWS Lambda using the CData JDBC Driver.

• How to Seamlessly Import ClickUp Data into IBM SPSS Modeler

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

• Access Reckon Accounts Hosted from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Reckon Accounts Hosted from HeidiSQL.

• Create YouTube Analytics-Connected Applications in Appsmith

  Connect to YouTube Analytics via CData Connect Cloud in Appsmith and create custom business applications with real-time access to YouTube Analytics.

• Automate Tasks in Power Automate Using the CData API Server

  Automate actions like sending emails to a contact list, posting to social media, or syncing CRM and ERP.

• Automated Continuous DocuSign Replication to Vertica

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

• Prepare, Blend, and Analyze Azure DevOps in Alteryx Designer (ODBC)

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

• Model, Search, and Visualize Live Excel Online in ThoughtSpot

  Use CData Connect Cloud to connect to live Microsoft Excel Online for modeling, searching, and visualizing.

• Use CData Connect Cloud to Access Instagram in Microsoft Power Pivot

  Use CData Connect Cloud to connect to live Instagram in the Power Pivot business intelligence tool.

• Design BIRT Reports on Greenhouse

  Provide current Greenhouse to your embedded analytics.

• Create an SAP BusinessObjects Universe on the CData JDBC Driver for Typeform

  Provide connectivity to Typeform through an SAP BusinessObjects universe.

• Connect to and Visualize Live Teradata in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Teradata.

• DataBind Controls to MarkLogic in C++Builder

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

• Build Microsoft Exchange-Connected Apps in Choreo

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

• How to Easily Query Neo4J in OpenOffice Base

• «
• 60
• 61
• 62
• 63
• 64
• 65
• 66
• 67
• 68
• 69
• »