CData Software - Knowledge Base

Recent Articles

• «
• 131
• 132
• 133
• 134
• 135
• 136
• 137
• 138
• 139
• 140
• »

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

  Use CData Power BI Connectors to visualize Sage Intacct in Power BI.

• Create Reports with SAP Ariba Source in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date SAP Ariba Source.

• Model Sage Cloud Accounting Using Azure Analysis Services

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

• Automated Continuous DocuSign Replication to SQL Server

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

• Connect to MarkLogic in RunMyProcess through Connect Server

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

• Use the CData ODBC Driver for Microsoft OneDrive from SharePoint Excel Services

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

• Access Live Sugar CRM in Google Sheets

  Use CData Connect Cloud to gain access to live Sugar CRM from your Google Sheets.

• How to Build Dynamic React Apps with Dynamics GP

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

• Use JayDeBeApi to access MYOB AccountRight in Python

  Use standard Python scripting and the development environment of your choice to access live MYOB AccountRight.

• Connect to GitHub from PowerBuilder

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

• How to create an RPA flow for Azure Active Directory in UiPath Studio

  Use the Azure Active Directory ODBC Driver to create workflows that access real-time Azure Active Directory without any coding.

• Automated Continuous Veeva Replication to Amazon Redshift

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

• Working with Zoho Books in LINQPad

  Execute LINQ queries to Zoho Books in LINQPad.

• Build an OLAP Cube in SSAS from Kintone

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

• Create Datasets from Zoho CRM in Domo Workbench and Build Visualizations of Zoho CRM in Domo

  Use the CData Software ODBC Driver for Zoho CRM to create datasets from Zoho CRM in Domo Workbench and then build visualizations in the Domo service.

• Create Facebook-Connected Visualizations in Klipfolio

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

• Create Microsoft Teams Dataflows on PowerBI.com

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

• Create Power BI XMLA-Connected Enterprise Applications in OutSystems

  Use CData Connect Cloud to connect to Power BI XMLA from OutSystems and build custom enterprise apps using live Power BI XMLA.

• How to Build an ETL App for ADP in Python with CData

  Create ETL applications and real-time data pipelines for ADP in Python with petl.

• Build Phoenix-Connected Dashboards in Redash

  Use CData Software Connect Server to create a virtual SQL Server Database for Apache Phoenix and build visualizations and dashbaords from Apache Phoenix in Redash.

• Connect to HubSpot from a Connection Pool in JBoss

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

• Access Zendesk as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Zendesk from your Oracle system.

• How to Import Box into SQL Server using SSIS

  Easily back up Box to SQL Server using the SSIS components for Box.

• Explore Geographical Relationships in Tableau CRM Analytics with Power Map

  Create data visualizations with Tableau CRM Analytics in Power Map.

• How to create an RPA flow for Drip in UiPath Studio

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

• Add Azure Table to Informatica Enterprise Data Catalog

  Use the CData Software JDBC Driver for Azure Table with the Informatica Enterprise Data Catalog to classify and organize data.

• Create Reports with Certinia in SAP Crystal Reports

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

• How to Access Live MySQL in Power Automate Desktop via ODBC

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

• Use CData Connect Cloud to Access Sugar CRM in Microsoft Power Pivot

  Use CData Connect Cloud to connect to live Sugar CRM in the Power Pivot business intelligence tool.

• Access WooCommerce in Mule Applications Using the CData JDBC Driver

  Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for WooCommerce.

• Automate CSV Replication to Azure Data Lake

  Use CData Sync to customize and automate CSV/TSV Files replication to Azure Data Lake.

• How to connect Amazon QuickSight to Twitter

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

• Explore Geographical Relationships in YouTube Analytics with Power Map

  Create data visualizations with YouTube Analytics in Power Map.

• DataBind Wijmo Grid to SAP HANA XS Advanced

  Provide real-time SAP HANA XS Advanced to interactive controls.

• Automated Continuous Google Contacts Replication to Apache Kafka

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

• Access Live Odoo in AWS Lambda (with IntelliJ IDEA)

  Connect to live Odoo ERP in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

• Automated Continuous ADP Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable ADP replication to IBM DB2.

• Use the CData Software JDBC Driver for Wave Financial in MicroStrategy

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

• Natively Connect to SAP Hybris C4C in PHP

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

• How to connect to AlloyDB from Spring Boot

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

• Build a Simple VCL Application for Procore

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

• Write a Simple Go Application to work with CockroachDB on Linux

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

• How to import FHIR into Apache Solr

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

• DataBind Square to the DevExpress Data Grid

  Use the CData Software ADO.NET Provider for Square with the DevExpress Windows Forms and Web controls to provide Square to a chart.

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

  Provide connectivity to Clio through an SAP BusinessObjects universe.

• How to Connect DBeaver to Greenhouse via a JDBC Driver

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

• Create Dynamic XML Grids Using the Infragistics XamDataGrid

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

• How to Import Facebook into SQL Server using SSIS

  Easily back up Facebook to SQL Server using the SSIS components for Facebook.

• How to connect PolyBase to HBase

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Apache HBase.

• Visualize Twitter in TIBCO Spotfire through OData

  Integrate Twitter into dashboards in TIBCO Spotfire.

• Validate SAP Hybris C4C with QuerySurge

  Access and validate SAP Hybris C4C in QuerySurge using the CData JDBC Driver.

• Connect to Microsoft Planner in HULFT Integrate

  Connect to Microsoft Planner as a JDBC data source in HULFT Integrate

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

  Connect to Acumatica ERP from a connection pool in Tomcat.

• Publish Crystal Reports on OneNote

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

• Query Presto in DataGrip

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

• Use the CData Software JDBC Driver for Bullhorn CRM in MicroStrategy Web

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

• Build an OLAP Cube in SSAS from Microsoft Teams

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

• How to Access BigQuery Using Entity Framework

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

• Create Informatica Mappings From/To an ODBC Data Source for Excel Online

  Create an ODBC connection to Excel Online in Informatica and browse and transfer Microsoft Excel Online.

• Query Sugar CRM through ODBC in Node.js

  Use node-odbc to execute SQL queries against Sugar CRM from Node.js.

• Import Real-Time Wave Financial in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Wave Financial in ColdFusion.

• Connect to SAP Concur from a Connection Pool in JBoss

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

• Natively Connect to JSON Services in PHP

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

• Query Pipedrive in MySQL Workbench

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

• Integrate Real-Time Access to Google Spanner in SAPUI5 MVC Apps

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

• Establish a Live Connection with Drift using Tableau Bridge

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

• View Reports on Real-Time SQL Analysis Services in Power BI Report Server

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

• Build MVC Applications with Connectivity to Dynamics NAV

  This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Dynamics NAV from an ASP.NET MVC application.

• Automate SAP Hybris C4C Replication to SAP HANA

  Use CData Sync to customize and automate SAP Hybris C4C replication to SAP HANA.

• Edit and Search External CockroachDB Objects in Salesforce Connect

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

• Query Todoist in DataGrip

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

• Replicate Slack for Use in Salesforce Connect

  Replicate Slack to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Query, Visualize, and Share live WooCommerce in Redash

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

• Automate Marketo Replication to SAP HANA

  Use CData Sync to customize and automate Marketo replication to SAP HANA.

• Create AlloyDB-Connected Visualizations in Klipfolio

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

• Stream Amazon Marketplace into Apache Kafka Topics

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

• Use the CData Software ODBC Driver for Twitter Ads in MicroStrategy

  Connect to Twitter Ads in MicroStrategy Developer using the CData Software ODBC Driver for Twitter Ads.

• Analyze SAP Hybris C4C in Looker

  Use CData Connect Cloud to connect to SAP Hybris C4C from Looker and build custom apps using live SAP Hybris C4C.

• Replicate SuiteCRM for Use in Salesforce Connect

  Replicate SuiteCRM to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• Access YouTube Analytics from MySQL in Amazon QuickSight

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

• A PostgreSQL Interface for Microsoft Dataverse

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

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

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

• Connect to Zuora in the Denodo Platform

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

• A PostgreSQL Interface for Square

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

• Access Live Zuora in AWS Lambda (with IntelliJ IDEA)

  Connect to live Zuora in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

• Analyze Oracle in Cognos Analytics

  Use CData Connect Cloud to connect to Oracle from Cognos Analytics and analyze live Oracle Database.

• How to connect to MongoDB in DBVisualizer

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

• Connect to Wave Financial in Jaspersoft Studio

  Execute SQL to remote Wave Financial in Jaspersoft Studio.

• ETL IBM Informix in Oracle Data Integrator

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

• Replicate Multiple Snowflake Accounts

  Replicate multiple Snowflake accounts to one or many databases.

• How to create Visio diagrams from Facebook

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

• Build a Simple VCL Application for SharePoint

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

• Build Dashboards with eBay in DBxtra

  Create dynamic dashboards and perform analytics based on eBay in DBxtra.

• Export Data from SQL Server to EnterpriseDB through SSIS

  Easily push SQL Server data to EnterpriseDB using the CData SSIS Tasks for EnterpriseDB.

• Build Sage 50 UK-Connected Dashboards in Redash

  Use CData Software Connect Server to create a virtual SQL Server Database for Sage 50 UK and build visualizations and dashbaords from Sage 50 UK in Redash.

• Create Data Visualizations Based On Microsoft Project in Mode

  Use CData Connect Cloud to connect to Microsoft Project from Mode and build visualizations using live

• Connect to Google Ads in DBArtisan

  Use wizards in DBArtisan to configure Google Ads as a data source.

• Automated Continuous SAP Ariba Procurement Replication to MongoDB

  Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to MongoDB.

• Connect to Sugar CRM in RazorSQL

  Connect to Sugar CRM from wizards and query Sugar CRM from the GUI in the RazorSQL database management tool.

• Automated Continuous Odoo Replication to Snowflake

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

• «
• 131
• 132
• 133
• 134
• 135
• 136
• 137
• 138
• 139
• 140
• »