CData Software - Knowledge Base

Recent Articles

• «
• 104
• 105
• 106
• 107
• 108
• 109
• 110
• 111
• 112
• 113
• »

• DataBind Wijmo Grid to Adobe Commerce

  Provide real-time Adobe Commerce to interactive controls.

• How to connect to FHIR from IntelliJ

  Integrate connectivity to FHIR with wizards in IntelliJ.

• How to Access Dynamics 365 Using Entity Framework

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

• Automate Zoom Replication to Couchbase

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

• Connect to Sage Cloud Accounting in Airbyte ELT Pipelines

  Use CData Connect Cloud to build ELT pipelines for Sage Business Cloud Accounting in Airbyte.

• A PostgreSQL Interface for Impala (MySQL Remoting via JDBC)

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

• How to import Freshdesk into Apache Solr

  Use the CData Software JDBC Driver for Freshdesk in Data Import Handler and create an automated import of Freshdesk to Apache Solr Enterprise Search platform.

• Connect to Shippo in HULFT Integrate

  Connect to Shippo as a JDBC data source in HULFT Integrate

• Build Apps with Live WooCommerce in Adalo using CData Connect Cloud

  Use CData Connect Cloud to integrate live WooCommerce into the Adalo platform and build custom mobile and web applications with real-time WooCommerce.

• How to create Visio diagrams from Zoho Projects

  Automatically update Zoho Projects with the changes you make to Visio master shapes.

• DataBind Wijmo Grid to eBay Analytics

  Provide real-time eBay Analytics to interactive controls.

• Connect to Facebook Ads through External Services in Salesforce

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

• Connect to Sugar CRM in Jaspersoft Studio

  Execute SQL to remote Sugar CRM in Jaspersoft Studio.

• Connect to SAP HANA XS Advanced as an External Source in Dremio

  Use the CData JDBC Driver to connect to SAP HANA XS Advanced as an External Source in Dremio.

• Feed Act-On into FineReport

  How to set Act-On as a JDBC data source in FineReport.

• Build Dashboards with Sage 300 in DBxtra

  Create dynamic dashboards and perform analytics based on Sage 300 in DBxtra.

• Automated Continuous SendGrid Replication to Databricks

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

• Connect to Phoenix from PowerBuilder via ADO.NET

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

• Use CData Connect Cloud to Access Google Calendar in Microsoft Power Pivot

  Use CData Connect Cloud to connect to live Google Calendar in the Power Pivot business intelligence tool.

• Design BIRT Reports on XML

  Provide current XML Files to your embedded analytics.

• Connect to Reckon from Excel & GoogleSheets!

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

• Access Google Drive from MySQL in Amazon QuickSight

  Connect to Google Drive and build visualizations of Google Drive using a MySQL Connection in Amazon QuickSight.

• Perform Batch Operations with Google Ad Manager in Apache NiFi

  Connect to Google Ad Manager and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

• Build an OLAP Cube in SSAS from Phoenix

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

• Import and Visualize Epicor Kinetic in Power View

  Create data visualizations based on Epicor Kinetic in Excel.

• Automate CData Connect Cloud Replication to Azure Synapse

  Use CData Sync to customize and automate CData Connect Cloud replication to Azure Synapse.

• DataBind Controls to SurveyMonkey in C++Builder

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

• Work with Zendesk in FoxPro

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

• Build Pinterest Visualizations in Tableau Cloud

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

• Operational Reporting on Basecamp from Spotfire Server

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

• Create Data Visualizations in Cognos BI with Salesforce

  Access Salesforce & Force.com as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

• PowerShell Scripting to Replicate Snowflake to MySQL

  Write a simple PowerShell script to replicate Snowflake to a MySQL database.

• LINQ to Confluence

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

• Create Apps from Acumatica in Qlik Sense Cloud

  Use CData Connect Cloud to connect to Acumatica and build apps from live Acumatica ERP in Qlik Sense Cloud.

• Query, Visualize, and Share live HCL Domino in Redash

  Use CData Connect Cloud to connect to live HCL Domino in Redash for querying, visualizing, and sharing.

• Connect to Odoo from AWS Glue

  Use CData Connect Cloud to gain access to live Odoo ERP from your AWS Glue jobs.

• Validate Facebook with QuerySurge

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

• Viewing Twitter Ads in RAD Studio Data Explorer

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

• Query Marketo in MySQL Workbench

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

• Feed MongoDB into FineReport

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

• Access Sage 300 from MySQL in PHP

  Connect to Sage 300 through the standard MySQL libraries in PHP.

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

  Connect to Cvent from a connection pool in Tomcat.

• Access Live SharePoint Excel Services in SAS JMP via ODBC

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

• Replicate Zoom to Multiple Databases via the CData Sync CLI

  Replicate Zoom to disparate databases with a single configuration.

• Access Live Amazon Athena in Google Sheets through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Amazon Athena from your Google Sheets.

• Connect to Authorize.Net in CloverDX (formerly CloverETL)

  Transfer Authorize.Net using the visual workflow in the CloverDX data integration tool.

• Access HubDB from MySQL in Amazon QuickSight

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

• Query Google Analytics as a SQL Server Database in Node.js

  Execute SQL Server queries against Google Analytics from Node.js.

• How to Connect to & Open Box in Microsoft Excel

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

• Build Microsoft Exchange-Connected Apps in Mendix

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

• Prepare, Blend, and Analyze Elasticsearch in Alteryx Designer (Connect Cloud)

  Build workflows to access live Elasticsearch for self-service data analytics.

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

  Connect to Azure Cosmos DB from Excel 365 Online (Excel for the web) with CData Connect Cloud.

• Create Dashboards and Visualize Live Google Ads in Geckoboard

  Use CData Connect Cloud to connect to live Google Ads and create dashboards for real-time monitoring and visualization in Geckoboard.

• Import and Visualize eBay in Power View

  Create data visualizations based on eBay in Excel.

• Replicate Multiple HBase Accounts

  Replicate multiple HBase accounts to one or many databases.

• ETL Typeform in Oracle Data Integrator

  This article shows how to transfer Typeform into a data warehouse using Oracle Data Integrator.

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

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

• Using the CData Software ODBC Driver for Amazon Marketplace in PyCharm

  Connect to Amazon Marketplace as an ODBC data source in PyCharm using the CData Software ODBC Driver for Amazon Marketplace.

• Build Charts with Bullhorn CRM in Clear Analytics

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

• How to connect to Cassandra from IntelliJ

  Integrate connectivity to Apache Cassandra with wizards in IntelliJ.

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

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

• Access Live SAP Concur in Excel (Desktop) via Connect Cloud

  Use CData Connect Cloud to gain access to live SAP Concur from your Excel spreadsheets.

• Build Dashboards with XML in Dundas BI

  Create dynamic dashboards and perform analytics based on XML Files in Dundas BI.

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

  Connect to FTP Servers from a connection pool in Tomcat.

• Viewing LDAP Objects in RAD Studio Data Explorer

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

• Viewing Zoom in RAD Studio Data Explorer

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

• Visualize Live CockroachDB in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live CockroachDB.

• QuickBooks Online Reporting in OBIEE with the QuickBooks Online JDBC Driver

  Deploy the QuickBooks Online JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• Connect to GraphQL in HULFT Integrate

  Connect to GraphQL as a JDBC data source in HULFT Integrate

• Build Facebook-Connected Web Apps in Servoy

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

• Build Automated Google Spanner-Connected Workflows in Zapier

  Use CData Connect Cloud to connect to live Google Spanner and build automated workflows in Zapier.

• Avro Reporting in OBIEE with the Avro JDBC Driver

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

• Build Data Flows from SAP BusinessObjects BI to SQL Server using SSIS

  Easily back up SAP BusinessObjects BI to SQL Server using the SSIS components for SAP BusinessObjects BI.

• Connect to Office 365 in the Denodo Platform

  Use CData driver technologies to create a virtual data source for Microsoft Office 365 in the Denodo Virtual DataPort Administrator.

• Integrate Live Google Ad Manager into Blue Prism for Intelligent Robotic Process Automation (RPA)

• «
• 104
• 105
• 106
• 107
• 108
• 109
• 110
• 111
• 112
• 113
• »