CData Software - Knowledge Base

Recent Articles

• «
• 474
• 475
• 476
• 477
• 478
• 479
• 480
• 481
• 482
• 483
• »

• How to Seamlessly Import Tableau CRM Analytics Data into IBM SPSS Modeler

  Integrate Tableau CRM Analytics data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.

• LINQ to Microsoft Planner

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

• Connect to Cosmos DB from HeidiSQL

  Use CData Connect Cloud to connect to and query live Azure Cosmos DB from HeidiSQL.

• How to Connect DBeaver to XML via a JDBC Driver

  Manage XML Files with visual tools in DBeaver like the query browser.

• Automate Stripe Replication to Azure Synapse

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

• Build a Simple VCL Application for Shippo

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

• Connect to Avalara AvaTax as an External Source in Dremio

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

• Validate Instagram with QuerySurge

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

• Access Live Sansan in Excel (Desktop) through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Sansan from your Excel spreadsheets.

• Create Data Visualizations in Cognos BI with Zuora

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

• Rapidly Develop Email-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.

• How to Connect to MYOB AccountRight in Using Python: 6 Steps

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

• Work with Live SAP HANA in Power Query

  Use CData Connect Cloud to connect to SAP HANA and work with live SAP HANA in Microsoft Power Query.

• Automated Continuous Sybase Replication to Microsoft Access

  Use CData Sync for automated, continuous, customizable Sybase replication to Microsoft Access.

• Automate QuickBooks Online Replication to Couchbase

  Use CData Sync to Customize and automate QuickBooks Online replication to Couchbase.

• Use the CData Software JDBC Driver for Greenplum in MicroStrategy Desktop

  Connect to Pivotal GreenPlum in MicroStrategy Desktop using the CData Software JDBC Driver for Greenplum.

• Building Dynamic Web Pages with Salesforce Marketing Using AngularJS

  Create single-page applications with live connectivity to Salesforce Marketing using the CData API Server.

• Connect to Stripe from Excel & GoogleSheets!

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

• How to connect PolyBase to ClickUp

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

• Build Google Search-Connected Visualizations in datapine

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

• Connect to Klipfolio in DBArtisan

  Use wizards in DBArtisan to configure Klipfolio as a data source.

• Create Dynamic Freshdesk Grids Using the Infragistics XamDataGrid

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

• Build a PostgreSQL Interface for Sage 200 using the CData JDBC Driver

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

• Automate Azure DevOps Replication to Azure Data Lake

  Use CData Sync to customize and automate Azure DevOps replication to Azure Data Lake.

• How to Create Power BI Visual Reports with Real-Time IBM Informix

  Use CData Power BI Connectors to visualize IBM Informix in Power BI.

• Query SAP ByDesign in DataGrip

  Create a Data Source for SAP ByDesign in DataGrip and use SQL to query live SAP Business ByDesign.

• Automated Continuous Microsoft Teams Replication to Databricks

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

• Publish Oracle SCM-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Oracle SCM.

• How to connect to Dynamics CRM from Spring Boot

  Connect to Dynamics CRM in a Spring Boot Application using CData JDBC Dynamics CRM Driver

• DataBind Charts to Calendly

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

• LINQ to Google Sheets

  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 Google Sheets Data Provider.

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

  Provide connectivity to Procore through an SAP BusinessObjects universe.

• Analyze Google Contacts with Power Pivot

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

• Build a PostgreSQL Interface for Microsoft Teams using the CData JDBC Driver

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

• Manage Oracle Service Cloud in DBArtisan as a JDBC Source

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

• Build Twitter-Connected Dashboards Using Zoho Analytics

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

• Publish Crystal Reports on Shippo

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

• Integrate Real-Time Access to Authorize.Net in SAPUI5 MVC Apps

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

• Access SAP BusinessObjects BI 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 SAP BusinessObjects BI.

• Analyze Gmail in Infragistics Reveal

  Use the CData API Server to create an OData API on top of Gmail and visualize live Gmail in Ingragistics Reveal.

• How to Seamlessly Import Trello Data into IBM SPSS Modeler

  Integrate Trello data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.

• Connect Reckon to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway

  Connect to your Reckon using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.

• How to Seamlessly Import IBM Cloud Object Storage Data into IBM SPSS Modeler

  Integrate IBM Cloud Object Storage data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.

• Import Real-Time Facebook via ODBC in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Facebook in ColdFusion.

• Publish Reports with Quickbase in SAP Crystal Reports

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

• Build Charts with Oracle Eloqua in Clear Analytics

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

• Access Freshdesk as a Remote Oracle Database

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

• Use the CData Software ODBC Driver for Freshdesk in MicroStrategy

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

• Reckon Reporting in OBIEE with the Reckon JDBC Driver

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

• Visualize Oracle Sales in TIBCO Spotfire through ADO.NET

  Integrate Oracle Sales into dashboards in TIBCO Spotfire.

• Visualize SFTP in Sisense

  Create an ElastiCube in Sisense app with access to SFTP.

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

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

• How to connect to SAP Fieldglass from Spring Boot

  Connect to SAP Fieldglass in a Spring Boot Application using CData JDBC SAP Fieldglass Driver

• Explore Geographical Relationships in ClickUp with Power Map

  Create data visualizations with ClickUp in Power Map.

• Build Dashboards with ShipStation in DBxtra

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

• Integrate Bullhorn CRM in the Pentaho Report Designer

  Publish reports based on Bullhorn CRM in the Pentaho BI tool.

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

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

• Natively Connect to BigQuery in PHP

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

• Bridge Microsoft Planner Connectivity with Apache NiFi

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

• How to Use a Microsoft Access Database to Update MailChimp in Real Time

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

• Analyze HBase in Slingshot with CData API Server

  Use the CData API Server to build an OData API on top of Apache HBase and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.

• Connect to Shippo in Ruby

  Connect to Shippo in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• Integrate with Typeform using Apache Camel2

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

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

  Provide connectivity to ServiceNow through an SAP BusinessObjects universe.

• Automated Continuous HubSpot Replication to SQLite

  Use CData Sync for automated, continuous, customizable HubSpot replication to SQLite.

• Use Biml to Build SSIS Tasks to Replicate Azure Active Directory to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Azure Active Directory to SQL Server.

• Extract, Transform, and Load Dynamics NAV in Informatica PowerCenter

  Create a simple Workflow for Microsoft Dynamics NAV in Informatica PowerCenter.

• How to connect to Amazon Marketplace from IntelliJ

  Integrate connectivity to Amazon Marketplace with wizards in IntelliJ.

• Publish Procore-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Procore.

• Build Charts with WordPress in Clear Analytics

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

• How to connect Amazon QuickSight to Zoho Inventory

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

• How to connect and process Twitter from Azure Databricks

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

• DataBind Controls to Asana in C++Builder

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

• Build Spark-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Apache Spark SQL.

• Create Dynamic Email Grids Using the Infragistics XamDataGrid

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

• Create Instagram Reports on JasperReports Server

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

• Use Biml to Build SSIS Tasks to Replicate GraphQL to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate GraphQL to SQL Server.

• Integrate FHIR into Power Automate Desktop using CData Connect

  CData Connect for FHIR enables you to integrate FHIR into workflows built using Microsoft Power Automate Desktop.

• Create Data Visualizations in Cognos BI with NetSuite

  Access NetSuite CRM & ERP as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

• Load Zoho Books to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Zoho Books to a database.

• Access Aha from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Aha! from HeidiSQL.

• Analyze Xero in Infragistics Reveal

  Use the CData API Server to create an OData API on top of Xero Accounting and visualize live Xero Accounting in Ingragistics Reveal.

• Consume Redshift OData Feeds in SAP Lumira

  Use the API Server to create data visualizations on Redshift feeds that reflect any changes in SAP Lumira.

• Connect to Bullhorn CRM in Google Apps Script via SQL Gateway

  Use the ODBC Driver for Bullhorn CRM and the SQL Gateway to access Bullhorn CRM from Google Apps Script.

• Analyze Epicor Kinetic in Cognos Analytics

  Use CData Connect Cloud to connect to Epicor Kinetic from Cognos Analytics and analyze live Epicor Kinetic.

• Connect to JDBC-ODBC Bridge in RapidMiner

  Integrate JDBC-ODBC Bridge with standard components and data source configuration wizards in RapidMiner Studio.

• Explore Geographical Relationships in Google Analytics with Power Map

  Create data visualizations with Google Analytics in Power Map.

• Publish Crystal Reports on MongoDB

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

• Back Up Unbounce to SQL Server through SSIS

  Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Unbounce. In this article, we will employ an SSIS workflow to populate a database with Unbounce data.

• Excel Spreadsheet Automation on Quickbase with the QUERY Formula

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

• Build Redis Visualizations in Tableau Desktop

  Use CData Connect Cloud to connect to live Redis and build visualizations in Tableau.

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

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

• Build MVC Applications with Connectivity to PayPal

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

• Create Azure Data Catalog Dataflows on PowerBI.com

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

• Access Live REST in TIBCO Data Virtualization

  Use the CData Software TIBCO DV Adapter for REST to create a REST source in TIBCO Data Virtualization Studio and gain access to live REST from your TDV Server.

• Query Pinterest through ODBC in Node.js

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

• Automated Continuous Facebook Ads Replication to Microsoft Access

  Use CData Sync for automated, continuous, customizable Facebook Ads replication to Microsoft Access.

• Access Live Sage 200 in Google Sheets through Connect Spreadsheets

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

• Build Backlog-Connected Dashboards Using Zoho Analytics

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

• Connect to MariaDB in DBeaver

  Use the CData ODBC Driver to connect to MariaDB in DBeaver.

• «
• 474
• 475
• 476
• 477
• 478
• 479
• 480
• 481
• 482
• 483
• »