CData Software - Knowledge Base

Recent Articles

• «
• 434
• 435
• 436
• 437
• 438
• 439
• 440
• 441
• 442
• 443
• »

• Use the CData API Server in Microsoft Power BI

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

• Automate Teradata Replication to Azure Data Lake

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

• Analyze Google Analytics in Slingshot with CData API Server

  Use the CData API Server to build an OData API on top of Google Analytics and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.

• Rapidly Develop Sage 50 UK-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.

• Connect to Active Directory in Google Apps Script via Connect Cloud

  Use CData Connect Cloud to access Active Directory in Google Apps Script.

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

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

• How to connect to Google Analytics from Spring Boot

  Connect to Google Analytics in a Spring Boot Application using CData JDBC Google Analytics Driver

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

• Connect to Xero in the Denodo Platform

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

• Integrate with SAP Ariba Source using Apache Camel2

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

• How to Work with Microsoft Dataverse in AWS Glue Jobs Using JDBC

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

• Connect to Zenefits in RapidMiner

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

• How to Work with SAP Hybris C4C in ETL Validator JDBC

  Connect to SAP Hybris C4C from ETL Validator jobs using the CData Software JDBC Driver.

• Feed Jira into FineReport

  How to set Atlassian Jira as a JDBC data source in FineReport.

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

  Use CData Connect Cloud to connect to live Apache Spark SQL in the Power Pivot business intelligence tool.

• Integrate Google Directory into Automated Tasks with Power Automate

  Use CData Connect Cloud to connect to Google Directory and integrate live Google Directory into your Power Automate tasks.

• Automate Smartsheet Replication to Azure Synapse

  Use CData Sync to customize and automate Smartsheet replication to Azure Synapse.

• Connect to and Query Salesforce Pardot in QlikView over ODBC

  Create data visualizations with Salesforce Pardot in QlikView.

• How to connect to SAP Business One in DBVisualizer

  Integrate SAP Business One with visual data analysis tools and data connection wizards in DBVisualizer

• Visualize Excel in TIBCO Spotfire through OData

  Integrate Microsoft Excel into dashboards in TIBCO Spotfire.

• Query Confluence as a MySQL Database in Node.js

  Execute MySQL queries against Atlassian Confluence from Node.js.

• Bridge Presto Connectivity with Apache NiFi

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

• Connect to AlloyDB as a SQL Server Linked Server

  Use CData Connect Cloud to create a linked server for live Google AlloyDB.

• Use the CData Software ODBC Driver for Oracle Sales in MicroStrategy Web

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

• Integrate Azure DevOps in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Azure DevOps from Informatica Cloud.

• Connect to Sugar CRM in JRuby

  Create a simple JRuby app with access to live Sugar CRM.

• How to connect SharePoint with Sage Intacct through external lists

  Provide Sage Intacct to SharePoint users as an external list.

• How to pipe WooCommerce to CSV in PowerShell

  Use standard PowerShell cmdlets to access WooCommerce tables.

• Create Data Visualizations in Cognos BI with Slack

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

• Amazon Athena Cloud Connectivity

  Explore a compilation of guides and tutorials demonstrating how to establish connections to Amazon Athena through CData Connect Cloud using different applications and tools.

• Work with Live LinkedIn Ads in Power Query

  Use CData Connect Cloud to connect to LinkedIn Ads and work with live LinkedIn Ads in Microsoft Power Query.

• DataBind Controls to Odoo in C++Builder

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

• Operational Reporting on Oracle from Spotfire Server

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

• Query SAS xpt in ColdFusion

  Write standard ColdFusion data access code to connect to SAS XPORT.

• Connect to Trello from Excel & GoogleSheets!

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

• How to connect to Pinterest with Squirrel SQL client

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

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

  Use CData ODBC drivers to import and use Amazon Redshift in ColdFusion.

• Create Airtable-Connected Enterprise Applications in OutSystems

  Use CData Connect Cloud to connect to Airtable from OutSystems and build custom enterprise apps using live Airtable.

• How to connect SharePoint with XML through external lists

  Provide XML Files to SharePoint users as an external list.

• Connect DB2 to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

  Connect to your IBM DB2 using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

• Access Live Monday.com in AWS Lambda (with IntelliJ IDEA)

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

• Migrating data from Jira to Databricks using CData SSIS Components.

  Easily push Atlassian Jira to Databricks using the CData SSIS Tasks for Jira and Databricks.

• How to create Dynamics NAV federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for Microsoft Dynamics NAV in MySQL .

• Use the CData ODBC Driver for Marketo in Microsoft Power Query

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

• Automate LinkedIn Replication to Azure Data Lake

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

• Visualize Live QuickBooks Time of Power BI Report Builder in Power BI Service

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

• Create Dynamic HubSpot Grids Using the Infragistics XamDataGrid

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

• Connect to SAP HANA in DBeaver

  Use the CData ODBC Driver to connect to SAP HANA in DBeaver.

• Access Live IBM Informix in AWS Lambda

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

• Analyze QuickBooks Online in Infragistics Reveal

  Use CData Connect Cloud to create on OData API on top of QuickBooks Online and visualize live QuickBooks Online in Infragistics Reveal.

• Consume Blackbaud FE NXT OData Feeds in SAP Lumira

  Use the API Server to create data visualizations on Blackbaud FE NXT feeds that reflect any changes in SAP Lumira.

• Connect to Sage Intacct from a Connection Pool in JBoss

  Integrate Sage Intacct into Java servlets: Use the Management Console in JBoss to install the Sage Intacct JDBC Driver.

• Analyze Google Campaign Manager 360 in R via ODBC

  Create data visualizations and use high-performance statistical functions to analyze Google Campaign Manager 360 in Microsoft R Open.

• Connect to ServiceNow from Blazor Apps

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

• Query Wave Financial using the OData SDK for PHP

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

• Query ADP in ColdFusion

  Write standard ColdFusion data access code to connect to ADP.

• Publish Reports with Google Ads in SAP Crystal Reports

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

• How to Connect to & Open Zoho Projects in Microsoft Excel

  This article uses the CData ODBC driver for Zoho Projects to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

• Import Presto into the Power BI Service for Visualizations

  Use CData Connect Cloud to connect to Presto and provide access to live Presto for custom reports in the Power BI Service.

• Build Databricks-Connected Web Apps with Axios and CData Connect Cloud

  Use CData Connect Cloud to connect to live Databricks and build Databricks-connected web apps with Axios.

• Analyze Office 365 in SAP Analytics Cloud

  Use CData Connect Cloud to create an OData API on top of Microsoft Office 365 and visualize Microsoft Office 365 in SAP Analytics Cloud.

• Model Yahoo! Japan Data Solution Using Azure Analysis Services

  Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and Yahoo! Japan Data Solution, enabling the direct import of real-time Yahoo! Japan Data Solution.

• Visualize Live ADP in Power BI (via CData Connect Cloud)

  Use the CData Power BI Connector and CData Connect Cloud to integrate live ADP into custom reports in Power BI.

• Connect to and Query Google Drive in QlikView over ODBC

  Create data visualizations with Google Drive in QlikView.

• Create a Data Access Object for Shippo using JDBI

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

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

• Analyze Live Active Directory in SAS Viya

  Use CData Connect Cloud to connect to Active Directory from SAS Viya and deploy self-service analytics using live Active Directory.

• Connect to Microsoft OneDrive from Blazor Apps

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

• Build a Simple VCL Application for Zoho Books

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

• Import Real-Time Paylocity via JDBC in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Paylocity in ColdFusion.

• Connect to Real-Time Certinia Data in Power Apps Using Dataflows to Build Custom Applications

• «
• 434
• 435
• 436
• 437
• 438
• 439
• 440
• 441
• 442
• 443
• »