CData Software - Knowledge Base

Recent Articles

• «
• 133
• 134
• 135
• 136
• 137
• 138
• 139
• 140
• 141
• 142
• »

• Work with FTP in FoxPro

  Load FTP Servers into a FoxPro database. This article includes full code and a walk-through of the process.

• Access Live Google Ads in Excel (Desktop)

  Use CData Connect Cloud to gain access to live Google Ads from your Excel spreadsheets.

• Integrate with Oracle HCM Cloud using Apache Camel2

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

• Publish Reports with Paylocity in SAP Crystal Reports

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

• Integrate Live Dynamics NAV into Custom Business Apps Built in Power Apps

  Use CData Software Connect Server to create a virtual SQL Server Database for Microsoft Dynamics NAV and integrate live Microsoft Dynamics NAV into apps built in Microsoft Power Apps.

• Integrate Azure Data Lake Storage in the Pentaho Report Designer

  Publish reports based on Azure Data Lake Storage in the Pentaho BI tool.

• Enable the Square JDBC Driver in KNIME

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

• How to Build Dynamic React Apps with SingleStore

  Use the CData Connect and React to Build Dynamic Web Apps with Live SingleStore .

• How to Connect to & Open Amazon S3 in Microsoft Excel

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

• Connect to SAP HANA in HULFT Integrate

  Connect to SAP HANA as a JDBC data source in HULFT Integrate

• Connect to Azure Data Catalog in JRuby

  Create a simple JRuby app with access to live Azure Data Catalog.

• Publish Crystal Reports on Spark

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

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

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

• Query QuickBooks Online as a SQL Server Database in Node.js

  Execute SQL Server queries against QuickBooks Online from Node.js.

• How to connect to Todoist in DBVisualizer

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

• Automated Continuous Microsoft Exchange Replication to Oracle

  Use CData Sync for automated, continuous, customizable Microsoft Exchange replication to Oracle.

• Build Interactive Dashboards from Google Cloud Storage in Amazon QuickSight

  Create a virtual SQL Server database for Google Cloud Storage in CData Software Connect Server and import Google Cloud Storage into Amazon QuickSight SPICE to build interactive dashboards.

• Visualize TaxJar in TIBCO Spotfire through ADO.NET

  Integrate TaxJar into dashboards in TIBCO Spotfire.

• Connect to Basecamp in CloverDX (formerly CloverETL)

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

• Access Zoho Inventory from MySQL in PHP

  Connect to Zoho Inventory through the standard MySQL libraries in PHP.

• Connect to Certinia in NetBeans

  Connect to Certinia in NetBeans with the data source configuration wizard.

• How to update SuiteCRM from Excel

  This article explains how to transfer data from Excel to SuiteCRM using the Excel Add-In for SuiteCRM.

• How to Access QuickBooks Using Entity Framework

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

• How to Create Power BI Visual Reports with Real-Time Coinbase

  Use CData Power BI Connectors to visualize Coinbase in Power BI.

• SAP ByDesign Reporting in OBIEE with the SAP ByDesign JDBC Driver

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

• A PostgreSQL Interface for Parquet

  Use the SQL Gateway and Parquet ODBC Driver to create a PostgreSQL entry-point for data access.

• Connect to Couchbase in HULFT Integrate

  Connect to Couchbase as a JDBC data source in HULFT Integrate

• Publish Reports with Sybase IQ in SAP Crystal Reports

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

• Automated Continuous Google Ads Replication to Google BigQuery

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

• Design BIRT Reports on SAS Data Sets

  Provide current SAS Data Sets to your embedded analytics.

• Author and Share Power BI Reports on Real-Time BigCommerce

  Use the CData ODBC Driver for BigCommerce to visualize BigCommerce in Power BI Desktop and then upload to the Power BI service.

• Connect to Azure Analysis Services from PowerBuilder

  This article demonstrates how to access Azure Analysis Services from Appeon PowerBuilder using the CData ADO.NET Provider for Azure Analysis Services.

• Connect to Live Azure Table in PostGresSQL Interface through CData Connect Cloud

  Create a live connection to Azure Table in CData Connect Cloud and connect to your Azure Table Storage from PostgreSQL.

• Connect to FHIR as a SQL Server Linked Server

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

• Bridge SAP ByDesign Connectivity with Apache NiFi

  Access and process SAP Business ByDesign in Apache NiFi using the CData JDBC Driver.

• Feed Google Spanner into FineReport

  How to set Google Spanner as a JDBC data source in FineReport.

• Use the CData Software JDBC Driver for xBase in MicroStrategy

  Connect to xBase in MicroStrategy Developer using the CData Software JDBC Driver for xBase.

• Model MailChimp Using Azure Analysis Services

  Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and MailChimp, enabling the direct import of real-time MailChimp.

• How to Use CData Connect to Access Live Pinterest in Power Automate

  CData Connect for Pinterest enables you to integrate Pinterest into workflows built using Microsoft Power Automate Desktop.

• Connect to Azure DevOps from PowerBuilder

  This article demonstrates how to access Azure DevOps from Appeon PowerBuilder using the CData ADO.NET Provider for Azure DevOps.

• How to Work with Amazon Marketplace in ETL Validator JDBC

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

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

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

• Validate REST with QuerySurge

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

• How to Query Live Monday.com Data in Natural Language in Python using LlamaIndex

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

• Validate Shippo with QuerySurge

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

• Use the CData Software ODBC Driver for Act CRM in MicroStrategy Web

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

• Viewing BigQuery in RAD Studio Data Explorer

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

• Connect to Phoenix in RazorSQL

  Connect to Phoenix from wizards and query Apache Phoenix from the GUI in the RazorSQL database management tool.

• Use the CData ODBC Driver for Monday.com in SAS JMP

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

• Connect to Stripe in CloverDX (formerly CloverETL)

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

• Stream Sage Intacct into Apache Kafka Topics

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

• Integrate Splunk with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Splunk with External Services.

• Connect to FHIR from PowerBuilder

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

• Connect to MongoDB in as an External Source in Dremio

  Use the CData JDBC Driver to connect to MongoDB as an External Source in Dremio.

• Replicate HubSpot from PowerShell

  Write a quick PowerShell script to query HubSpot. Use connectivity to the live data to replicate HubSpot to SQL Server.

• Natively Connect to Printify in PHP

  Create PHP applications on Linux/UNIX machines with connectivity to Printify. Leverage the native support for ODBC in PHP.

• Connect to Confluence from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Confluence to connect to Atlassian Confluence from Web applications running on WebLogic.

• Import Real-Time Presto in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Presto in ColdFusion.

• Automated Continuous ServiceNow Replication to SQLite

  Use CData Sync for automated, continuous, customizable ServiceNow replication to SQLite.

• Build Salesforce Pardot Visualizations in Tableau Cloud

  Use CData Connect Cloud to connect to live Salesforce Pardot and build visualizations in Tableau Cloud.

• Create Google Sheets-Connected Enterprise Applications in OutSystems

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

• Use the CData Software JDBC Driver for SAP Fieldglass in MicroStrategy

  Connect to SAP Fieldglass in MicroStrategy Developer using the CData Software JDBC Driver for SAP Fieldglass.

• Working with Airtable in LINQPad

  Execute LINQ queries to Airtable in LINQPad.

• Create a Data Access Object for HBase using JDBI

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

• Create Excel Dataflows on PowerBI.com

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

• Create SSAS Tabular Models from Azure Active Directory

  How to build a SQL Server Analysis Service Tabular Model from Azure Active Directory using CData drivers.

• Build Apps with Live Sage Cloud Accounting Using the Low-Code Development Platform of Mendix

• «
• 133
• 134
• 135
• 136
• 137
• 138
• 139
• 140
• 141
• 142
• »