CData Software - Knowledge Base

Recent Articles

• «
• 361
• 362
• 363
• 364
• 365
• 366
• 367
• 368
• 369
• 370
• »

• How to connect to SAS xpt from Spring Boot

  Connect to SAS xpt in a Spring Boot Application using CData JDBC SAS xpt Driver

• Access Live SharePoint Excel Services Data in Tableau with CData API Server

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

• Stream Power BI XMLA into Apache Kafka Topics

  Access and stream Power BI XMLA in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

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

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

• Connect to Office 365 in RazorSQL

  Connect to Office 365 from wizards and query Microsoft Office 365 from the GUI in the RazorSQL database management tool.

• Analyze IBM Informix with Power Pivot

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

• How to connect to Google Cloud Storage in DBVisualizer

  Integrate Google Cloud Storage with visual data analysis tools and data connection wizards in DBVisualizer

• 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.

• How to connect and process Google Cloud Storage from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Google Cloud Storage.

• Query Oracle HCM Cloud in ColdFusion

  Write standard ColdFusion data access code to connect to Oracle HCM Cloud.

• Create Office 365-Connected Applications in Appsmith

  Connect to Office 365 via CData Connect Cloud in Appsmith and create custom business applications with real-time access to Microsoft Office 365.

• Build a Simple VCL Application for Azure Data Lake Storage

  How to build a simple VCL Application to view Azure Data Lake Storage in RAD Studio using the CData ODBC Driver for Azure Data Lake Storage.

• Connect to QuickBooks Time in DBArtisan

  Use wizards in DBArtisan to configure QuickBooks Time as a data source.

• Work with Live Active Directory in Power Query

  Use CData Connect Cloud to connect to Active Directory and work with live Active Directory in Microsoft Power Query.

• Validate Office 365 with QuerySurge

  Access and validate Microsoft Office 365 in QuerySurge using the CData JDBC Driver.

• How to pipe BigQuery to CSV in PowerShell

  Use standard PowerShell cmdlets to access BigQuery tables.

• Connect to Google Ads in Jaspersoft Studio

  Execute SQL to remote Google Ads in Jaspersoft Studio.

• Establish a Live Connection with XML using Tableau Bridge

  The CData ODBC Driver for XML enables you to integrate live XML Files into Tableau Cloud dashboards using the Tableau Bridge.

• Object-Relational Mapping (ORM) with OneNote Entities in Java

  Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Microsoft OneNote into a Java-based ORM framework, Hibernate.

• How to connect Amazon QuickSight to PayPal

  Create a connection to PayPal in CData Connect Cloud and insert PayPal into Amazon QuickSight SPICE to build interactive dashboards.

• Analyze Power BI XMLA in Infragistics Reveal

  Use the CData API Server to create an OData API on top of Power BI XMLA and visualize live Power BI XMLA in Ingragistics Reveal.

• Connect to Amazon S3 in CloverDX (formerly CloverETL)

  Transfer Amazon S3 using the visual workflow in the CloverDX data integration tool.

• Import Real-Time Blackbaud FE NXT via ODBC in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Blackbaud FE NXT in ColdFusion.

• Load Harvest to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Harvest to a database.

• Connect to Sage Cloud Accounting from PowerBuilder via JDBC

  This article demonstrates how to access Sage Business Cloud Accounting from PowerBuilder using the Sage Cloud Accounting JDBC Driver.

• Integrate Live LinkedIn Ads into Amazon SageMaker Canvas with RDS

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

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

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

• Visualize Live PCA Sales in the Power BI Service

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

• Connect to Greenhouse in HULFT Integrate

  Connect to Greenhouse as a JDBC data source in HULFT Integrate

• Automate Paylocity Integration Tasks from PowerShell

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

• Create Reports from Raisers Edge NXT in Looker Studio

  Use CData Connect Cloud to gain access to live Raisers Edge NXT and create custom reports in Looker Studio.

• Validate Azure Analysis Services with QuerySurge

  Access and validate Azure Analysis Services in QuerySurge using the CData JDBC Driver.

• Access Azure DevOps from MySQL in Amazon QuickSight

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

• Automate Trello Integration Tasks from PowerShell

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

• Automated Continuous Hive Replication to PostgreSQL

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

• How to Work with LinkedIn in ETL Validator JDBC

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

• Design BIRT Reports on Highrise

  Provide current Highrise CRM to your embedded analytics.

• Automated Continuous Salesforce Marketing Replication to Local Delimited Files

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

• Use the CData API Server to Access Amazon Athena in Microsoft PowerPivot

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

• Create Oracle Financials Cloud-Connected Applications in Appsmith

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

• Import Freshdesk into Microsoft Power Query

  The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Freshdesk. In this article, you will use the OData format to import Freshdesk into Microsoft Power Query.

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

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

• Query Parquet as a MySQL Database in Node.js

  Execute MySQL queries against Apache Parquet from Node.js.

• Create Power BI Reports on Real-Time LDAP Objects

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

• Use the CData Software JDBC Driver for SAP HANA in MicroStrategy Web

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

• Automate Office 365 Replication to SAP HANA

  Use CData Sync to customize and automate Microsoft Office 365 replication to SAP HANA.

• Connect to Live Google Drive in PostGresSQL Interface through CData Connect Cloud

  Create a live connection to Google Drive in CData Connect Cloud and connect to your Google Drive from PostgreSQL.

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

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

• Bidirectional Access to Zoho Projects from FileMaker Pro

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

• Automated Continuous ConstantContact Replication to Amazon Redshift

  Use CData Sync for automated, continuous, customizable ConstantContact replication to Amazon Redshift.

• Create Dynamic GraphQL Grids Using the Infragistics XamDataGrid

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

• DataBind Charts to Kintone

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Kintone from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.

• Publish Crystal Reports on Email

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

• Automate MySQL Replication to Couchbase

  Use CData Sync to Customize and automate MySQL replication to Couchbase.

• Connect to ConstantContact in Claris FileMaker Pro

• «
• 361
• 362
• 363
• 364
• 365
• 366
• 367
• 368
• 369
• 370
• »