CData Software - Knowledge Base

Recent Articles

• «
• 251
• 252
• 253
• 254
• 255
• 256
• 257
• 258
• 259
• 260
• »

• Replicate Multiple Azure DevOps Accounts

  Replicate multiple Azure DevOps accounts to one or many databases.

• Rapidly Develop IBM Cloud Data Engine-Driven Apps with Active Query Builder

  Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.

• Create Apps from Harvest in Qlik Sense Cloud

  Use the CData Connect Server to create an OData API for Harvest and build apps from live Harvest in Qlik Sense Cloud.

• Replicate Sage 50 UK for Use in Salesforce Connect

  Replicate Sage 50 UK to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

• How to update Zoho CRM from Excel

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

• Build Visualizations of Google Calendar in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Google Calendar in Birst.

• Access Dynamics 365 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 Microsoft Dynamics 365.

• Query Shippo in DataGrip

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

• Visualize CouchDB in TIBCO Spotfire through ODBC

  The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Apache CouchDB into TIBCO Spotfire.

• Choosing the Best Method to Connect YouTube Analytics to SQL Server: 5 Options Explained

  Discover multiple ways to connect and use YouTube Analytics from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.

• Integrate Live XML into Custom Business Apps Built in Power Apps

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

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

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

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

• Using AngularJS to Build Dynamic Web Pages with SAP BusinessObjects BI

  Use the CData Connect Server to create SAP BusinessObjects BI OData feeds and build single-page applications with live SAP BusinessObjects BI.

• LINQ to SharePoint

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

• Object-Relational Mapping (ORM) with MySQL Entities in Java

  Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to MySQL into a Java-based ORM framework, Hibernate.

• Build MVC Applications with Connectivity to Odoo

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

• Validate Zoho Creator with QuerySurge

  Access and validate Zoho Creator in QuerySurge using the CData JDBC Driver.

• Use Dash to Build to Web Apps on LinkedIn Ads

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

• Create Cassandra Reports on JasperReports Server

  Deploy the CData JDBC Driver on JasperReports Server to provide real-time Cassandra data access from reports, embedded analytics, and more.

• Connect to IBM Informix from a Connection Pool in JBoss

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

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

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

• Import and Visualize Certinia in Power View

  Create data visualizations based on Certinia in Excel.

• Excel Spreadsheet Automation on Salesforce Data Cloud with the QUERY Formula

  Pull data, automate spreadsheets, and more with the QUERY formula.

• Automated Continuous Cassandra Replication to MySQL

  Use CData Sync for automated, continuous, customizable Cassandra replication to MySQL.

• Publish Wave Financial-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Wave Financial.

• Create Dynamic Clio Grids Using the Infragistics XamDataGrid

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

• Publish Crystal Reports on Oracle HCM Cloud

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

• Use the CData Software ODBC Driver for SAP HANA in MicroStrategy Web

  Connect to SAP HANA in MicroStrategy Web using the CData Software ODBC Driver for SAP HANA.

• Integrate Asana in the Pentaho Report Designer

  Publish reports based on Asana in the Pentaho BI tool.

• Connect to and Visualize Live Microsoft Planner in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Microsoft Planner.

• Connect to GitHub from a Connection Pool in Jetty

  The GitHub JDBC Driver supports connection pooling: This article shows how to connect faster to GitHub from Web apps in Jetty.

• Integrate Live Salesforce into Custom Business Apps Built in Power Apps

  Use CData Connect Cloud to connect to Salesforce & Force.com and integrate live Salesforce & Force.com into apps built in Microsoft Power Apps.

• Visualize EventBrite in TIBCO Spotfire through OData

  Integrate Eventbrite into dashboards in TIBCO Spotfire.

• Connect to YouTube Analytics from Asprova with CData Software ODBC Driver for YouTube Analytics

  This article shows how to connect faster to YouTube Analytics data from Asprova.

• Manage Oracle Financials Cloud in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for Oracle Financials Cloud.

• Validate Workday with QuerySurge

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

• Visualize Jira Assets in TIBCO Spotfire through ADO.NET

  Integrate Jira Assets into dashboards in TIBCO Spotfire.

• Using the CData Software ODBC Driver for Google Calendar in PyCharm

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

• Connect to Microsoft Teams in SpagoBI

  Create reports featuring live Microsoft Teams in SpagoBI Studio. Host Microsoft Teams reports on SpagoBI Server.

• How to create an RPA flow for Dynamics NAV in UiPath Studio

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

• Replicate Klipfolio to Multiple Databases via the CData Sync CLI

  Replicate Klipfolio to disparate databases with a single configuration.

• Connect to WordPress in Jaspersoft Studio

  Execute SQL to remote WordPress in Jaspersoft Studio.

• Analyze Cvent in R via ODBC

  Create data visualizations and use high-performance statistical functions to analyze Cvent in Microsoft R Open.

• Connect to NetSuite as an External Source in Dremio

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

• Publish Reports with SAP Business One in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date SAP Business One.

• Build SurveyMonkey-Connected Visualizations in datapine

  Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live SurveyMonkey.

• How to Access Harvest Using Entity Framework

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

• How to Connect the Power BI Service to Clio: Complete Guide

  Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.

• How to connect to Procore with Squirrel SQL client

  Connect to Procore and execute queries in the Squirrel SQL Client.

• Edit and Search External YouTube Analytics Objects in Salesforce Connect

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

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

  Create ETL applications and real-time data pipelines for Microsoft Dataverse (CDS) in Python with petl.

• Access Live Redis in Google Sheets through Connect Spreadsheets

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

• Access LDAP Objects in PHP through Connect Server

  Connect to LDAP through the standard SQL Server libraries in PHP.

• Automated Continuous Bullhorn CRM Replication to Apache Cassandra

  Use CData Sync for automated, continuous, customizable Bullhorn CRM replication to Apache Cassandra.

• Query Splunk in ColdFusion

  Write standard ColdFusion data access code to connect to Splunk.

• Query Dynamics 365 Business Central in MySQL Workbench

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

• Work with Outreach.io in FoxPro

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

• Connect to Harvest in RapidMiner

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

• Build Epicor Kinetic-Connected Dashboards Using Zoho Analytics

  Use CData Connect Cloud to connect to Epicor Kinetic from Zoho Analytics and import live Epicor Kinetic.

• Automated Continuous Confluence Replication to MySQL

  Use CData Sync for automated, continuous, customizable Confluence replication to MySQL.

• How to Visualize HBase Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Apache HBase in Python.

• Build Visualizations of Live Drift in Power BI (through CData Connect)

  Use CData Connect to create a virtual database for Drift and build custom reports in Power BI.

• Automated Continuous xBase Replication to Local Delimited Files

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

• Build SendGrid-Connected Apps in Mendix

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

• Design BIRT Reports on Coinbase

  Provide current Coinbase to your embedded analytics.

• Build BigCommerce-Connected Web Apps in Servoy

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

• Integrate with NetSuite using Apache Camel2

  Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy NetSuite CRM & ERP to a JSON file on disk.

• Integrate PayPal in Pentaho Data Integration

  Build ETL pipelines based on PayPal in the Pentaho Data Integration tool.

• How to connect and process Presto from Azure Databricks

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

• Analyze Zenefits in R via JDBC

  Use standard R functions and the development environment of your choice to analyze Zenefits with the CData JDBC Driver for Zenefits.

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

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

• Visualize Jira Service Management from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Atlassian Jira Service Management.

• Automated Continuous JotForm Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable JotForm replication to Amazon S3.

• Access NetSuite RESTlets as Views

  Use CData Data Providers for NetSuite to access RESTlets from third-party tools.

• Connect to Blackbaud FE NXT from PowerBuilder via JDBC

  This article demonstrates how to access Blackbaud FE NXT from PowerBuilder using the Blackbaud FE NXT JDBC Driver.

• How to pipe Microsoft Project to CSV in PowerShell

  Use standard PowerShell cmdlets to access Microsoft Project tables.

• ETL Zoho Projects in Oracle Data Integrator

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

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

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

• Connect to Zoho Creator in CloverDX (formerly CloverETL)

  Transfer Zoho Creator using the visual workflow in the CloverDX data integration tool.

• Connect to Dynamics 365 in Ruby

  Connect to Microsoft Dynamics 365 in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

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

  Connect to IBM DB2 from a connection pool in Tomcat.

• Validate Google Calendar with QuerySurge

  Access and validate Google Calendar in QuerySurge using the CData JDBC Driver.

• Automate Dynamics CRM Replication to Couchbase

  Use CData Sync to Customize and automate Microsoft Dynamics CRM replication to Couchbase.

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

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

• How to Connect to Greenplum in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to Pivotal GreenPlum. Leverage the pyodbc module for ODBC in Python.

• Build Microsoft Exchange-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Microsoft Exchange.

• Automated Continuous PayPal Replication to AlloyDB

  Use CData Sync for automated, continuous, customizable PayPal replication to AlloyDB.

• Publish Crystal Reports on Blackbaud FE NXT

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

• Connect to Zenefits from a Connection Pool in Jetty

  The Zenefits JDBC Driver supports connection pooling: This article shows how to connect faster to Zenefits from Web apps in Jetty.

• Analyze REST in R via JDBC

  Use standard R functions and the development environment of your choice to analyze REST with the CData JDBC Driver for REST.

• Build AI/ML Models with Live Google Ads Data using Dataiku

• «
• 251
• 252
• 253
• 254
• 255
• 256
• 257
• 258
• 259
• 260
• »