CData Software - Knowledge Base

Recent Articles

• «
• 291
• 292
• 293
• 294
• 295
• 296
• 297
• 298
• 299
• 300
• »

• Automated Continuous SAP BusinessObjects BI Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to Amazon S3.

• Access LinkedIn Ads in PHP through Connect Server

  Connect to LinkedIn Ads through the standard SQL Server libraries in PHP.

• Use JayDeBeApi to access Tally in Python

  Use standard Python scripting and the development environment of your choice to access live Tally ERP.

• Create Data Visualizations in Cognos BI with Zoho Creator

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

• Build Dashboards with Google Sheets in DBxtra

  Create dynamic dashboards and perform analytics based on Google Sheets in DBxtra.

• Natively Connect to Cassandra in PHP

  The CData ODBC driver for Cassandra enables you to create PHP applications with connectivity to Apache Cassandra. Leverage the native support for ODBC in PHP.

• Access Live Veeva Vault in Google Sheets through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Veeva Vault & Vault CRM from your Google Sheets.

• How to Connect DBeaver to Email via a JDBC Driver

  Manage Email with visual tools in DBeaver like the query browser.

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

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

• How to load QuickBooks Time data into Elasticsearch via Logstash

  Introducing a simple method to load QuickBooks Time data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.

• Build Dashboards with Reckon Accounts Hosted in Dundas BI

  Create dynamic dashboards and perform analytics based on Reckon Accounts Hosted in Dundas BI.

• Automated Continuous IBM Informix Replication to SingleStore

  Use CData Sync for automated, continuous, customizable IBM Informix replication to SingleStore.

• Connect to Snowflake from PowerBuilder via JDBC

  This article demonstrates how to access Snowflake from PowerBuilder using the Snowflake JDBC Driver.

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

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

• Provide OData Services of Sage Cloud Accounting from a WCF Application

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

• Publish Sage Intacct-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Sage Intacct.

• Operational Reporting on Oracle SCM from Spotfire Server

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

• Working with Azure Analysis Services in LINQPad

  Execute LINQ queries to Azure Analysis Services in LINQPad.

• Operational Reporting on Redis from Spotfire Server

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

• Query CouchDB in MySQL Workbench

  Create a virtual MySQL database for Apache CouchDB in CData Software Connect (or Connect Server) and work with live Apache CouchDB in MySQL Workbench.

• How to publish and share ConstantContact dashboards with Tableau Server

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

• Connect to Zendesk in NetBeans

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

• Publish Google Contacts-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Google Contacts.

• Analyze BigQuery in Infragistics Reveal

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

• How to connect to EventBrite from IntelliJ

  Integrate connectivity to Eventbrite with wizards in IntelliJ.

• Import ConstantContact into the Power BI Service for Visualizations

  Use CData Software Connect Server to create an OData feed for ConstantContact and create custom reports in the Power BI Service.

• Feed Coinbase into FineReport

  How to set Coinbase as a JDBC data source in FineReport.

• How to connect to IBM Cloud Object Storage from Spring Boot

  Connect to IBM Cloud Object Storage in a Spring Boot Application using CData JDBC IBM Cloud Object Storage Driver

• Access QuickBooks from RazorSQL

  Connect to QuickBooks company file data through the RazorSQL database query tool.

• Use the CData Software ODBC Driver for TigerGraph in SAS for Real-Time Reporting and Analytics

  Connect to real-time TigerGraph in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for TigerGraph.

• Integrate Real-Time Access to CouchDB in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Apache CouchDB in real time.

• Automated Continuous Zoho Books Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable Zoho Books replication to OneLake in Microsoft Fabric.

• Connect to Microsoft Project as a SQL Server Linked Server

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

• Build SAP BusinessObjects BI-Connected Apps in Choreo

  Use CData Connect Cloud to connect to SAP BusinessObjects BI from Choreo and build custom apps using live SAP BusinessObjects BI.

• Operational Reporting on Redshift from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Amazon Redshift.

• How to pipe Salesforce Pardot to CSV in PowerShell

  Use standard PowerShell cmdlets to access Salesforce Pardot tables.

• Automated Continuous Zoho Books Replication to Local Delimited Files

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

• How to Use a Microsoft Access Database to Update Oracle Service Cloud in Real Time

  Update Oracle Service Cloud data by creating a linked table in Microsoft Access with the CData Oracle Service Cloud ODBC Driver.

• Access Reckon from MySQL in PHP

  Connect to Reckon through the standard MySQL libraries in PHP.

• Use Biml to Build SSIS Tasks to Replicate Azure Table to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Azure Table Storage to SQL Server.

• Analyze LDAP Objects with Power Pivot

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

• Integrate with Couchbase in JReport Designer

  Create charts and reports based on Couchbase in JReport Designer.

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

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

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

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

• Connect to and Visualize Live Sage Cloud Accounting in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Sage Business Cloud Accounting.

• Connect to Azure Synapse from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Azure Synapse to connect to Azure Synapse from Web applications running on WebLogic.

• DataBind Charts to Google Sheets

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Google Sheets 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.

• PowerShell Scripting to Replicate YouTube Analytics to MySQL

  Write a simple PowerShell script to replicate YouTube Analytics to a MySQL database.

• Build Dynamics 365-Connected Apps in Bubble

  Use CData Connect Cloud to create an OData feed for Dynamics 365 and create custom apps in Bubble.

• DataBind Charts to Unbounce

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Unbounce 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.

• Operational Reporting on IBM Cloud Object Storage from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote IBM Cloud Object Storage.

• Connect to SAP SuccessFactors in RapidMiner

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

• Connect to Oracle Financials Cloud in CloverDX (formerly CloverETL)

  Transfer Oracle Financials Cloud using the visual workflow in the CloverDX data integration tool.

• Automated Continuous Paylocity Replication to Amazon Redshift

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

• How to connect to eBay Analytics from Spring Boot

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

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

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

• Bidirectional Access to Greenplum from FileMaker Pro

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

• Create Smaregi-Connected Visualizations in Klipfolio

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

• Build Semantic Layer Views for Airtable in APOS Live Data Gateway

  Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for Airtable.

• Integrate MarkLogic in the Pentaho Report Designer

  Publish reports based on MarkLogic in the Pentaho BI tool.

• How to connect to QuickBooks Online from IntelliJ

  Integrate connectivity to QuickBooks Online with wizards in IntelliJ.

• Query Drift in ColdFusion

  Write standard ColdFusion data access code to connect to Drift.

• How to create an RPA flow for Google Search Results in UiPath Studio

  Use the Google Search ODBC Driver to create workflows that access real-time Google Search without any coding.

• Connect to Live Elasticsearch in PostGresSQL Interface through CData Connect Cloud

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

• Connect to Certinia from a Connection Pool in WebLogic

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

• Connect to TaxJar from Blazor Apps

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

• Connect to Cosmos DB in DBArtisan

  Use wizards in DBArtisan to configure Azure Cosmos DB as a data source.

• Connect to Microsoft Dataverse from PowerBuilder via ADO.NET

  This article demonstrates how to access Microsoft Dataverse (CDS) from Appeon PowerBuilder using the CData ADO.NET Provider for Microsoft Dataverse.

• Viewing ActiveCampaign in RAD Studio Data Explorer

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

• Build Typeform Visualizations in Tableau Cloud

  Use CData Software Connect Server to create a virtual SQL Server Database for Typeform and build visualizations in Tableau Cloud.

• Access Live Gmail in AWS Lambda

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

• How to Connect DBeaver to Box via a JDBC Driver

  Manage Box with visual tools in DBeaver like the query browser.

• Configure the CData JDBC Driver for Active Directory in a Connection Pool in Tomcat

  Connect to Active Directory from a connection pool in Tomcat.

• How to Access Live Avalara AvaTax in Power Automate Desktop via ODBC

  The CData ODBC Driver for Avalara AvaTax enables you to integrate Avalara AvaTax into workflows built using Microsoft Power Automate Desktop.

• Replicate NetSuite to Multiple Databases via the CData Sync CLI

  Replicate NetSuite CRM & ERP to disparate databases with a single configuration.

• Connect to SAP HANA 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 SAP HANA.

• Natively Connect to Active Directory in PHP via ODBC (Linux)

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

• Connect to Microsoft Dataverse from AWS Glue

  Use CData Connect Cloud to gain access to live Microsoft Dataverse (CDS) from your AWS Glue jobs.

• How to integrate Metabase with Veeva Vault

  Use CData Connect Cloud to connect to live Veeva Vault & Vault CRM and create an interactive dashboard in Metabase from Veeva Vault & Vault CRM.

• How to update Acumatica from Excel

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

• Connect to SharePoint in NetBeans

  Connect to Microsoft SharePoint in NetBeans with the data source configuration wizard.

• How to connect to Square from Spring Boot

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

• Connect to Sage 300 from a Connection Pool in JBoss

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

• Deploy the ADO.NET Provider for Kafka on an SSRS Report Server

  Connect to Apache Kafka from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

• Automated Continuous LDAP Replication to SingleStore

  Use CData Sync for automated, continuous, customizable LDAP replication to SingleStore.

• Analyze SAP Netweaver Gateway with Power Pivot

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

• Stream Google Contacts into Apache Kafka Topics

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

• Connect to Dropbox in Aqua Data Studio

  Access Dropbox from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• Connect to Okta from Blazor Apps

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

• Visualize ShipStation from Tableau

  Use the Tableau Desktop business intelligence tool to connect to ShipStation.

• Connect to Zoho Inventory in JRuby

  Create a simple JRuby app with access to live Zoho Inventory.

• How to connect and process PostgreSQL from Azure Databricks

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

• How to Easily Query Neo4J in OpenOffice Base

• «
• 291
• 292
• 293
• 294
• 295
• 296
• 297
• 298
• 299
• 300
• »