CData Software - Knowledge Base

Recent Articles

• «
• 112
• 113
• 114
• 115
• 116
• 117
• 118
• 119
• 120
• 121
• »

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

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

• Import Oracle HCM Cloud into the Power BI Service for Visualizations

  Use CData Connect Cloud to connect to Oracle HCM Cloud and provide access to live Oracle HCM Cloud for custom reports in the Power BI Service.

• How to connect to SAP HANA with Squirrel SQL client

  Connect to SAP HANA and execute queries in the Squirrel SQL Client.

• Access Calendly in PHP through Connect Server

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

• Build Semantic Layer Views for Databricks in APOS Live Data Gateway

  Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for Databricks.

• Build MVC Applications with Connectivity to eBay Analytics

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

• Connect to Sage Cloud Accounting as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Sage Business Cloud Accounting.

• Automate IBM Cloud Data Engine Integration Tasks from PowerShell

  Are you in search of a quick and easy way to access IBM Cloud Data Engine from PowerShell? This article demonstrates how to utilize the IBM Cloud Data Engine Cmdlets for tasks like connecting to IBM Cloud Data Engine, automating operations, downloading data, and more.

• Validate Azure DevOps with QuerySurge

  Access and validate Azure DevOps in QuerySurge using the CData JDBC Driver.

• Connect to SQL Analysis Services from a Connection Pool in JBoss

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

• Create Apps from MariaDB in Qlik Sense Cloud

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

• Connect to Bullhorn CRM in Google Apps Script via Connect Cloud

  Use CData Connect Cloud to access Bullhorn CRM in Google Apps Script.

• Use Dash to Build to Web Apps on Unbounce

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

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

• Use the CData Software JDBC Driver for Unbounce in MicroStrategy

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

• Replicate XML to Multiple Databases

  Replicate XML Files to disparate databases with a point-and-click configuration.

• Build an OLAP Cube in SSAS from DB2

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

• Automated Continuous Unbounce Replication to Apache Kafka

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

• Connect to SingleStore in Airbyte ELT Pipelines

  Use CData Connect Cloud to build ELT pipelines for SingleStore in Airbyte.

• How to connect to Harvest from IntelliJ

  Integrate connectivity to Harvest with wizards in IntelliJ.

• Integrate with live Google Spanner in Jitterbit

  Use CData Connect Cloud to connect to and integrate live Google Spanner in Jitterbit.

• Visualize Okta in Tableau

  The CData ODBC driver for Okta enables you integrate Okta into Tableau dashboards.

• DataBind Controls to Odoo in C++Builder

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

• Build Box-Connected Web Apps in Servoy

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

• Visualize Live Invoiced in the Power BI Service

  Use CData Software Connect Server to create a virtual SQL Server database for Invoiced and create custom reports in the Power BI Service.

• Access Google Ad Manager from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Google Ad Manager from HeidiSQL.

• Integrate CData Connect Cloud into Automated Tasks with Power Automate

  Use CData Software Connect Server to create a virtual SQL Server database for CData Connect Cloud and integrate live CData Connect Cloud into your Power Automate (Microsoft Flow) tasks.

• Build Charts with Shippo in Clear Analytics

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

• Automated Continuous Zoho CRM Replication to MySQL

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

• Access Jira Service Management from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Atlassian Jira Service Management from HeidiSQL.

• Access HarperDB from MySQL in HeidiSQL

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

• How to Connect to LDAP Objects in Using Python: 6 Steps

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

• Provide OData Services of Sage 200 from a WCF Application

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

• Integrate Printful in Pentaho Data Integration

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

• Work with FTP in FoxPro

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

• Integrate MongoDB in the Pentaho Report Designer

  Publish reports based on MongoDB in the Pentaho BI tool.

• Sync Google Contacts with QuickBooks

  The CData ADO.NET Providers offer an easy way to integrate with different data sources. This article walks through the downloadable, fully functional application that can be used to synchronize contacts between Google and QuickBooks.

• Explore Geographical Relationships in Dynamics CRM with Power Map

  Create data visualizations with Microsoft Dynamics CRM in Power Map.

• How to import Marketo into Apache Solr

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

• Query Power BI XMLA through ODBC in Node.js

  Use node-odbc to execute SQL queries against Power BI XMLA from Node.js.

• Design BIRT Reports on MarkLogic

  Provide current MarkLogic to your embedded analytics.

• How to work with Invoiced in Apache Spark using SQL

  Access and process Invoiced in Apache Spark using the CData Software JDBC Driver.

• Build an OLAP Cube in SSAS from Hive

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

• Build Amazon Marketplace-Connected Apps in Bubble

  Use CData Connect Cloud to create an OData feed for Amazon Marketplace and create custom apps in Bubble.

• Build Visualizations of SAP Concur in Birst

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

• Use the CData ODBC Driver for Google Directory from SharePoint Excel Services

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

• Use JayDeBeApi to access EventBrite in Python

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

• Easily Integrate OneNote in Lazarus Pascal IDE

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

• Create JotForm Reports on JasperReports Server

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

• Connect to Databricks from PowerBuilder via ODBC

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

• Prepare, Blend, and Analyze Printify in Alteryx Designer (ODBC)

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

• How to Work with Certinia in AWS Glue Jobs Using JDBC

  Connect to Certinia from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• Automate SAP Fieldglass Replication to Azure Data Lake

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

• Access Live Azure Active Directory in Excel for the Web (Excel 365/Online) through Connect Spreadsheets

  Connect to Azure Active Directory from Excel 365 Online (Excel for the web) with Connect Spreadsheets.

• How to Access XML Using Entity Framework

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

• How to Visualize Sage Cloud Accounting Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Sage Business Cloud Accounting in Python.

• DataBind Controls to GraphQL in Delphi

  DataBind to GraphQL in Delphi with standard data access components and controls.

• Use CData Connect Cloud to Access Oracle Service Cloud in Microsoft Power Pivot

  Use CData Connect Cloud to connect to live Oracle Service Cloud in the Power Pivot business intelligence tool.

• Connect to Live ActiveCampaign in PostGresSQL Interface through CData Connect Cloud

  Create a live connection to ActiveCampaign in CData Connect Cloud and connect to your ActiveCampaign from PostgreSQL.

• Use Dash to Build to Web Apps on Snowflake

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

• Replicate xBase for Use in Salesforce Connect

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

• Automated Continuous SAP Replication to MongoDB

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

• Connect to Azure Active Directory in JRuby

  Create a simple JRuby app with access to live Azure Active Directory.

• Connect to Zendesk in RunMyProcess through Connect Cloud

  Use CData Connect Cloud to create on OData API for Zendesk and connect to Zendesk in Akorbi Digital RunMyProcess.

• Publish Crystal Reports on Avalara AvaTax

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

• Access Live Adobe Analytics in Excel (Desktop) through Connect Spreadsheets

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

• Automate SuiteCRM Integration Tasks from PowerShell

  Are you in search of a quick and easy way to access SuiteCRM from PowerShell? This article demonstrates how to utilize the SuiteCRM Cmdlets for tasks like connecting to SuiteCRM, automating operations, downloading data, and more.

• Automated Continuous Invoiced Replication to Amazon S3

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

• Build Data Flows from SQL Server to Google Spanner through SSIS

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

• Use CData Connect Cloud to Access SendGrid in Microsoft Power Pivot

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

• How to work with Drip in Apache Spark using SQL

  Access and process Drip in Apache Spark using the CData Software JDBC Driver.

• Automated Continuous Twilio Replication to Google BigQuery

  Use CData Sync for automated, continuous, customizable Twilio replication to Google BigQuery.

• Visualize CData Connect Cloud in Tableau Desktop (through CData Connect)

  Create a virtual SQL Server database for CData Connect Cloud in CData Software Connect (or Connect Server) and build visualizations from live CData Connect Cloud in Tableau Desktop.

• Connect to Hive from Filemaker Pro (Mac)

  Use CData Connect Cloud to connect to and query live Apache Hive from Filemaker Pro on Mac.

• Connect to SAP Concur in Jaspersoft Studio

  Execute SQL to remote SAP Concur in Jaspersoft Studio.

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

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

• Load Cosmos DB to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Azure Cosmos DB to a database.

• Analyze REST in R via ODBC

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

• Build PostgreSQL-Connected Web Apps with Axios and CData Connect Cloud

  Use CData Connect Cloud to connect to live PostgreSQL and build PostgreSQL-connected web apps with Axios.

• Connect to and Query SAP BusinessObjects BI in QlikView over ODBC

  Create data visualizations with SAP BusinessObjects BI in QlikView.

• Query Microsoft Planner in ColdFusion

  Write standard ColdFusion data access code to connect to Microsoft Planner.

• How to Connect to SAP Hybris C4C in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to SAP Hybris C4C. Leverage the pyodbc module for ODBC in Python.

• Deploy the ADO.NET Provider for Azure Synapse on an SSRS Report Server

  Connect to Azure Synapse from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

• Import Real-Time NetSuite via JDBC in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use NetSuite CRM & ERP in ColdFusion.

• Connect to Salesforce in CloverDX (formerly CloverETL)

  Transfer Salesforce & Force.com using the visual workflow in the CloverDX data integration tool.

• Connect to WordPress as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for WordPress.

• Replicate Procore to Multiple Databases

  Replicate Procore to disparate databases with a point-and-click configuration.

• Access Live WooCommerce in Coginiti Pro

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

• Prepare, Blend, and Analyze Azure Data Lake Storage in Alteryx Designer (Connect Cloud)

  Build workflows to access live Azure Data Lake Storage for self-service data analytics.

• Integrate Live Active Directory into Amazon SageMaker Canvas with RDS

  Use CData Connect Cloud to connect to Active Directory from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Active Directory.

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

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

• Replicate Kafka for Use in Salesforce Connect

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

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

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

• Use the CData SSIS Components to Insert New or Update Existing Stripe Records from SQL Server

  Easily push SQL Server data to Stripe using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Stripe or update existing records with data from a SQL Server database.

• Query Dynamics NAV in DataGrip

  Create a Data Source for Dynamics NAV in DataGrip and use SQL to query live Microsoft Dynamics NAV.

• Import BCart into the Power BI Service for Visualizations

  Use CData Connect Cloud to connect to BCart and provide access to live BCart for custom reports in the Power BI Service.

• Natively Connect to ActiveCampaign in PHP

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

• Use the CData Software ODBC Driver for Square in MicroStrategy

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

• Build Dashboards with Google Spanner in Dundas BI

  Create dynamic dashboards and perform analytics based on Google Spanner in Dundas BI.

• How to load SFTP data into Elasticsearch via Logstash

  Introducing a simple method to load SFTP data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.

• «
• 112
• 113
• 114
• 115
• 116
• 117
• 118
• 119
• 120
• 121
• »