CData Software - Knowledge Base

Recent Articles

• «
• 76
• 77
• 78
• 79
• 80
• 81
• 82
• 83
• 84
• 85
• »

• How to integrate Metabase with Redshift

  Use CData Connect Cloud to connect to live Amazon Redshift and create an interactive dashboard in Metabase from Amazon Redshift.

• Create Informatica Mappings From/To a JDBC Data Source for Amazon DynamoDB

  Create Amazon DynamoDB data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

• Create MailChimp-Connected Dashboards in Grafana

  Connect to MailChimp via CData Connect Cloud in Grafana and create custom business dashboards with real-time access to MailChimp.

• PayPal Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on PayPal facts in real time.

• Analyze Calendly with Power Pivot

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

• Connect to Impala from PowerBuilder via ADO.NET

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

• Analyze Elasticsearch in Infragistics Reveal

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

• Use CData Connect Cloud to Access SAP Ariba Source in Microsoft Power Pivot

  Use CData Connect Cloud to connect to live SAP Ariba Source in the Power Pivot business intelligence tool.

• How to Access Pinterest Using Entity Framework

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

• Add Databricks to Informatica Enterprise Data Catalog

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

• Connect to QuickBooks Time in Google Apps Script via SQL Gateway

  Use the ODBC Driver for QuickBooks Time and the SQL Gateway to access QuickBooks Time from Google Apps Script.

• A PostgreSQL Interface for Zuora using the CData ODBC Driver

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

• Import Invoiced into Microsoft Power Query

  The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Invoiced. In this article, you will use the OData format to import Invoiced into Microsoft Power Query.

• Create Power BI Reports on Real-Time Oracle Financials Cloud

  Use the CData ODBC Driver for Oracle Financials Cloud to visualize Oracle Financials Cloud in Power BI Desktop.

• Automated Continuous Active Directory Replication to Oracle

  Use CData Sync for automated, continuous, customizable Active Directory replication to Oracle.

• Easily Integrate GitHub in Lazarus Pascal IDE

  Learn how to easily integrate live GitHub in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.

• Automated Continuous Clio Replication to OneLake in Microsoft Fabric

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

• Replicate Multiple MongoDB Accounts

  Replicate multiple MongoDB accounts to one or many databases.

• Access Live Raisers Edge NXT in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

  Connect to Raisers Edge NXT from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

• Edit and Search External Azure Synapse Objects in Salesforce Connect

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

• DataBind Controls to Twitter in C++Builder

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

• Build MVC Applications with Connectivity to Wave Financial

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

• Automated Continuous Sybase IQ Replication to SQLite

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

• Viewing Bullhorn CRM in RAD Studio Data Explorer

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

• Bidirectional Access to Coinbase from FileMaker Pro

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

• Replicate Sage 50 UK in Heroku for Use in Salesforce Connect

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

• Build MVC Applications with Connectivity to Power BI XMLA

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

• Access Live DB2 in Coginiti Pro

  Connect to and query live IBM DB2 from the GUI in the Coginiti Pro: SQL Analytics Tool.

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

• Access Live Marketo in TIBCO Data Virtualization

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

• Connect to Basecamp in CloverDX (formerly CloverETL)

  Transfer Basecamp using the visual workflow in the CloverDX data integration tool.

• Visualize Live API in Power BI (via CData Connect Cloud)

  Use the CData Power BI Connector and CData Connect Cloud to integrate live API into custom reports in Power BI.

• Automated Continuous Sage 300 Replication to Vertica

  Use CData Sync for automated, continuous, customizable Sage 300 replication to Vertica.

• Automated Continuous SAP Concur Replication to PostgreSQL

  Use CData Sync for automated, continuous, customizable SAP Concur replication to PostgreSQL.

• Use the CData Software ODBC Driver for Excel in MicroStrategy

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

• Create Informatica Mappings From/To a JDBC Data Source for Databricks

  Create Databricks data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

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

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

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

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

• Connect to MySQL in Google Apps Script via SQL Gateway

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

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

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

• Visualize Live REST in Tableau

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

• Automated Continuous Kafka Replication to Amazon S3

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

• Provide OData Services of CockroachDB from a WCF Application

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

• Build Charts with Oracle HCM Cloud in Clear Analytics

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

• Automated SAP ByDesign Replication to Teradata

  Use CData Sync to Customize and automate SAP Business ByDesign replication to Teradata.

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

• Publish Google Cloud Storage-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Google Cloud Storage.

• Migrating data from Email to Google BigQuery using CData SSIS Components.

  Easily push Email to Google BigQuery using the CData SSIS Tasks for Email and Google BigQuery.

• Build Visualizations of QuickBooks Online in Birst

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

• Automated Continuous HubSpot Replication to MySQL

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

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

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

• Automated Continuous MongoDB Replication to IBM DB2

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

• Build Google Ads-Connected Dashboards Using Zoho Analytics

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

• How to Access Google Data Catalog Using Entity Framework

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

• Connect to Gmail from PowerBuilder via ODBC

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

• Add NetSuite to Informatica Enterprise Data Catalog

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

• Query, Visualize, and Share live Microsoft Planner in Redash

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

• Automated Continuous Drift Replication to Oracle

  Use CData Sync for automated, continuous, customizable Drift replication to Oracle.

• How to Access Live Exact Online in Power Automate Desktop via ODBC

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

• How to connect to MySQL with Squirrel SQL client

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

• Manage WooCommerce in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for WooCommerce.

• Importing Google BigQuery Data into H2O

  Use the CData JDBC Driver for Google BigQuery in R and Python to import BigQuery data into H2O for machine learning and AI.

• Connect and Query Live eBay Data in Databricks with CData Connect Cloud

  Use CData Connect Cloud to integrate live eBay into Databricks

• Import Microsoft Dataverse into Microsoft Power Query

  The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Microsoft Dataverse (CDS). In this article, you will use the OData format to import Microsoft Dataverse (CDS) into Microsoft Power Query.

• Edit and Search External LinkedIn Ads Objects in Salesforce Connect

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

• Connect to QuickBooks Online in Google Apps Script via Connect Cloud

  Use CData Connect Cloud to access QuickBooks Online in Google Apps Script.

• Create QuickBooks Time-Connected Applications in Appsmith

  Connect to QuickBooks Time via CData Connect Cloud in Appsmith and create custom business applications with real-time access to QuickBooks Time.

• Use Biml to Build SSIS Tasks to Replicate SAP HANA to SQL Server

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

• Connect to SurveyMonkey in RazorSQL

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

• Import Real-Time SAS Data Sets via ODBC in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use SAS Data Sets in ColdFusion.

• How to integrate MariaDB with Apache Airflow

  Access and process MariaDB in Apache Airflow using the CData JDBC Driver.

• Access Live Amazon Athena in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

  Connect to Amazon Athena from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

• How to connect to Freshdesk with Squirrel SQL client

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

• Analyze Sage Intacct in Infragistics Reveal

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

• Use the CData API Server in Microsoft Power BI

  You can use the CData API Server to feed SAP HANA to Power BI dashboards. Simply drag and drop SAP HANA into data visuals on the Power BI canvas.

• Object-Relational Mapping (ORM) with Harvest 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 Harvest into a Java-based ORM framework, Hibernate.

• Create a Data Access Object for Zoho Books using JDBI

  A brief overview of creating a SQL Object API for Zoho Books in JDBI.

• Analyze Epicor Kinetic in Cognos Analytics

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

• Access Dynamics CRM from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Microsoft Dynamics CRM from HeidiSQL.

• Build Data Flows from Typeform to SQL Server using SSIS

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

• How to connect to SAP ByDesign from Spring Boot

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

• Build Automated Amazon DynamoDB-Connected Workflows in Zapier

  Use CData Connect Cloud to connect to live Amazon DynamoDB and build automated workflows in Zapier.

• Viewing MarkLogic in RAD Studio Data Explorer

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

• Automate Avalara AvaTax Replication to Couchbase

  Use CData Sync to Customize and automate Avalara AvaTax replication to Couchbase.

• How to connect PolyBase to MYOB AccountRight

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

• Migrating data from Todoist to Snowflake using CData SSIS Components.

  Easily push Todoist to Snowflake using the CData SSIS Tasks for Todoist and Snowflake.

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

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

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

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

• Connect to Cvent in RapidMiner

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

• Migrating data from ConstantContact to Databricks using CData SSIS Components.

  Easily push ConstantContact to Databricks using the CData SSIS Tasks for ConstantContact and Databricks.

• Access Live Marketo in Coginiti Pro

  Connect to and query live Marketo from the GUI in the Coginiti Pro: SQL Analytics Tool.

• How to Connect DBeaver to Zendesk via a JDBC Driver

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

• Automate GitHub Replication to Couchbase

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

• Connect to Salesloft in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• How to Connect DBeaver to GraphQL via a JDBC Driver

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

• Work with NetSuite in FoxPro

  Load NetSuite CRM & ERP into a FoxPro database. This article includes full code and a walk-through of the process.

• Connect to Xero in SpagoBI

  Create reports featuring live Xero Accounting in SpagoBI Studio. Host Xero reports on SpagoBI Server.

• Build a PostgreSQL Interface for Google Campaign Manager 360 using the CData JDBC Driver

  Use the Remoting features of the Google Campaign Manager 360 JDBC Driver to create a PostgreSQL entry-point for data access.

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

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

• Building Dynamic Web Pages with Highrise Using AngularJS

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

• «
• 76
• 77
• 78
• 79
• 80
• 81
• 82
• 83
• 84
• 85
• »