CData Software - Knowledge Base

Recent Articles

• «
• 125
• 126
• 127
• 128
• 129
• 130
• 131
• 132
• 133
• 134
• »

• Automate Odoo Replication to Couchbase

  Use CData Sync to Customize and automate Odoo ERP replication to Couchbase.

• Build a Simple VCL Application for Coinbase

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

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

  Use the CData ODBC Driver for NetSuite to visualize NetSuite CRM & ERP in Power BI Desktop and then upload to the Power BI service.

• Connect to Xero through External Services in Salesforce

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

• Automated Continuous Aha Replication to Google BigQuery

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

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

  Provide connectivity to Microsoft Dynamics GP through an SAP BusinessObjects universe.

• Connect to Microsoft Project as an External Source in Dremio

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

• Build eBay-Connected Web Apps in Servoy

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

• Automate Twitter Replication to Azure Synapse

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

• Build Charts with Bitbucket in Clear Analytics

  Create dynamic charts and perform analytics based on Bitbucket in Clear Analytics.

• Connect to Drift as a Linked Server via CData Connect

  Use CData Connect to set up a linked server for Drift.

• Access Live Asana in Excel 365 Online (Excel for the web)

  Connect to Asana from Excel 365 Online (Excel for the web) with CData Connect Cloud.

• Connect to Microsoft Dataverse from Excel & GoogleSheets!

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

• Automated Continuous Oracle HCM Cloud Replication to MongoDB

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

• Connect to MongoDB in SpagoBI

  Create reports featuring live MongoDB in SpagoBI Studio. Host MongoDB reports on SpagoBI Server.

• A PostgreSQL Interface for Klaviyo using the CData ODBC Driver

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

• View Reports on Real-Time Excel Online in Power BI Report Server

  Use the CData ODBC Driver for Excel Online to visualize Microsoft Excel Online in Power BI Desktop and then publish them to Power BI Report Server.

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

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

• Working with SAP SuccessFactors in LINQPad

  Execute LINQ queries to SAP SuccessFactors in LINQPad.

• Bridge AlloyDB Connectivity with Apache NiFi

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

• Connect to Impala as an External Data Source using PolyBase

  Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live Apache Impala.

• Connect to SQL Server from PowerBuilder via JDBC

  This article demonstrates how to access Microsoft SQL Server from PowerBuilder using the SQL Server JDBC Driver.

• Create Reports with SharePoint in SAP Crystal Reports

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

• Build a PostgreSQL Interface for Oracle Sales using the CData JDBC Driver

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

• Working with Wave Financial in LINQPad

  Execute LINQ queries to Wave Financial in LINQPad.

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

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

• LINQ to Microsoft OneDrive

  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 Microsoft OneDrive Data Provider.

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

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

• Stream Access into Apache Kafka Topics

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

• Work with Redis in FoxPro

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

• Automated Continuous Klaviyo Replication to SQL Server

  Use CData Sync for automated, continuous, customizable Klaviyo replication to SQL Server.

• Validate YouTube Analytics with QuerySurge

  Access and validate YouTube Analytics in QuerySurge using the CData JDBC Driver.

• Bridge HubDB Connectivity with Apache NiFi

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

• Access Excel from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Microsoft Excel from HeidiSQL.

• Feed Avalara AvaTax into FineReport

  How to set Avalara AvaTax as a JDBC data source in FineReport.

• Publish Crystal Reports on SingleStore

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

• Connect to FTP as a Linked Server via SQL Gateway

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

• Connect to HDFS in RunMyProcess through Connect Server

  Use CData Connect Server to create an OData API for HDFS and connect to Apache HDFS in Akorbi Digital RunMyProcess.

• How to connect to Odoo from Spring Boot

  Connect to Odoo in a Spring Boot Application using CData JDBC Odoo Driver

• Analyze Sybase with Power Pivot

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

• Provide OData Services of Sage 50 UK from a WCF Application

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

• Build Gmail-Connected Apps in Mendix

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

• Natively Connect to Workday in PHP via ODBC (Linux)

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

• Visualize MySQL in TIBCO Spotfire through OData

  Integrate MySQL into dashboards in TIBCO Spotfire.

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

• Access Live SuiteCRM in SAS JMP via ODBC

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

• LINQ to ShipStation

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

• Integrate Dropbox in Your Informatica Cloud Instance

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

• Use the CData Software JDBC Driver for Twilio in MicroStrategy

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

• Use Dash to Build to Web Apps on Splunk

  Create Python applications that use pandas and Dash to build Splunk-connected web apps.

• Access Live Excel in Coginiti Pro

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

• Load Salesforce to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Salesforce & Force.com to a database.

• Establish a Live Connection with Tally using Tableau Bridge

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

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

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

• Automated Continuous Presto Replication to Snowflake

  Use CData Sync for automated, continuous, customizable Presto replication to Snowflake.

• Edit and Search External Sybase Objects in Salesforce Connect

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

• Create Sansan-Connected Visualizations in Klipfolio

  Use CData Connect Cloud to connect to Sansan from Klipfolio and build custom visualizations using live Sansan.

• Feed CSV into FineReport

  How to set CSV/TSV Files as a JDBC data source in FineReport.

• Automated Continuous Certinia Replication to Apache Kafka

  Use CData Sync for automated, continuous, customizable Certinia replication to Apache Kafka.

• How to Work with QuickBooks in ETL Validator JDBC

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

• Build an OLAP Cube in SSAS from Sage Cloud Accounting

  Establish a connection to Sage Business Cloud Accounting data from SQL Server Analysis Services, and use the Sage Cloud Accounting Data Provider to build OLAP cubes for use in analytics and reporting.

• Query SQL Analysis Services in DataGrip

  Create a Data Source for SQL Analysis Services in DataGrip and use SQL to query live SQL Analysis Services.

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

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

• How to connect and process Unbounce from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live Unbounce

• Access Live Kintone in Coginiti Pro

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

• Use the CData Software JDBC Driver for Zoho Creator in MicroStrategy Web

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

• Integrate with Outreach.io in JReport Designer

  Create charts and reports based on Outreach.io in JReport Designer.

• Connect to Shopify in JRuby

  Create a simple JRuby app with access to live Shopify.

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

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

• Automated Continuous PostgreSQL Replication to Databricks

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

• Integrating Adobe Commerce in Talend Cloud Data Management Platform

• «
• 125
• 126
• 127
• 128
• 129
• 130
• 131
• 132
• 133
• 134
• »