CData Software - Knowledge Base

Recent Articles

• «
• 54
• 55
• 56
• 57
• 58
• 59
• 60
• 61
• 62
• 63
• »

• How to Access HDFS Using Entity Framework

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

• Query Bing Ads in MySQL Workbench

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

• How to Connect DBeaver to Typeform via a JDBC Driver

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

• How to Work with RSS Feeds in ETL Validator JDBC

  Connect to RSS from ETL Validator jobs using the CData Software JDBC Driver.

• Connect to Marketo in Jaspersoft Studio

  Execute SQL to remote Marketo in Jaspersoft Studio.

• Explore Geographical Relationships in JotForm with Power Map

  Create data visualizations with JotForm in Power Map.

• Automated Continuous Zoho Creator Replication to MongoDB

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

• Connect to Live Klaviyo in MicroStrategy through CData Software Connect Server

  Create a virtual database for Klaviyo in CData Software Connect Server and connect to it from MicroStrategy.

• How to import SuiteCRM into Apache Solr

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

• Create JotForm-Connected Business Apps in AppSheet

  Use CData Software Connect Server to connect to JotForm from AppSheet and build custom business apps using live JotForm.

• Connect to LinkedIn in HULFT Integrate

  Connect to LinkedIn as a JDBC data source in HULFT Integrate

• Create SingleStore 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 Email in AWS Lambda

  Connect to live Email in AWS Lambda using the CData JDBC Driver.

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

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

• How to load Paylocity data into Elasticsearch via Logstash

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

• Connect to Sage 200 as a SQL Server Linked Server

  Use CData Connect Cloud to create a linked server for live Sage 200.

• Connect to SurveyMonkey in NetBeans

  Connect to SurveyMonkey in NetBeans with the data source configuration wizard.

• How to connect to Excel with Squirrel SQL client

  Connect to Microsoft Excel and execute queries in the Squirrel SQL Client.

• Automated Continuous Asana Replication to SQLite

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

• Automated Continuous Microsoft Dataverse Replication to Microsoft Access

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

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

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

• Create Reports from Act-On in Looker Studio

  Use CData Connect Cloud to gain access to live Act-On and create custom reports in Looker Studio.

• Publish Reports with Salesforce Pardot in SAP Crystal Reports

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

• Connect to Dynamics NAV from PowerBuilder

  This article demonstrates how to access Microsoft Dynamics NAV from PowerBuilder using the Dynamics NAV JDBC Driver.

• Import Real-Time LDAP Objects in ColdFusion to Build Applications

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

• Integrate with Printify using Apache Camel2

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

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

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

• Design BIRT Reports on ClickUp

  Provide current ClickUp to your embedded analytics.

• Bridge Cloudant Connectivity with Apache NiFi

  Access and process IBM Cloudant in Apache NiFi using the CData JDBC Driver.

• How to connect to BambooHR from Google Apps Script

  Use CData Software Connect Server to access BambooHR in Google Apps Script.

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

  Use CData Connect Cloud to connect to Apache Impala and integrate live Apache Impala into apps built in Microsoft Power Apps.

• Visualize HCL Domino in TIBCO Spotfire through ODBC

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

• Visualize Live Act CRM of Power BI Report Builder in Power BI Service

  Use CData Power BI Connectors to connect to live Act CRM using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

• Automate Klipfolio Replication to SAP HANA

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

• How to connect to Google Search Results from Spring Boot

  Connect to Google Search in a Spring Boot Application using CData JDBC Google Search Driver

• Use the CData ODBC Driver for SAP BusinessObjects BI in Microsoft Power Query

  You can use the CData SAP BusinessObjects BI ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SAP BusinessObjects BI into Microsoft Power Query.

• A PostgreSQL Interface for Confluence

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

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

  Connect to Pivotal GreenPlum from Excel 365 Online (Excel for the web) with CData Connect Cloud.

• Access Live Smartsheet in Google Sheets

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

• A PostgreSQL Interface for ActiveCampaign

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

• Build Apps with Live MailChimp in Adalo using CData Connect Cloud

  Use CData Connect Cloud to integrate live MailChimp into the Adalo platform and build custom mobile and web applications with real-time MailChimp.

• Integrate SAP SuccessFactors into Power Automate Desktop using CData Connect

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

• Design BIRT Reports on HCL Domino

  Provide current HCL Domino to your embedded analytics.

• How to pipe Dynamics 365 Business Central to CSV in PowerShell

  Use standard PowerShell cmdlets to access Dynamics 365 Business Central tables.

• Bidirectional Access to GitHub from FileMaker Pro

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

• Create FHIR Reports on JasperReports Server

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

• Build Sage 50 UK-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Sage 50 UK.

• A PostgreSQL Interface for Reckon Accounts Hosted

  Use the Remoting features of the Reckon Accounts Hosted JDBC Driver to create a PostgreSQL entry-point for data access.

• Choosing the Best Method to Connect Cosmos DB to SQL Server: 5 Options Explained

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

• Rapidly Develop Oracle HCM Cloud-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.

• Query Amazon Athena as a MySQL Database in Node.js

  Execute MySQL queries against Amazon Athena from Node.js.

• Import and Visualize FTP in Power View

  Create data visualizations based on FTP Servers in Excel.

• A PostgreSQL Interface for Google Spanner

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

• Build Apps with Live Xero Accounting in Adalo using CData Connect Cloud

  Use CData Connect Cloud to integrate live Xero Accounting into the Adalo platform and build custom mobile and web applications with real-time Xero Accounting.

• Access Live DocuSign in AWS Lambda

  Connect to live DocuSign in AWS Lambda using the CData JDBC Driver.

• Connect to OData Services from PowerBuilder

  This article demonstrates how to access OData from PowerBuilder using the OData JDBC Driver.

• How to connect PolyBase to SQL Analysis Services

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

• Create a Data Access Object for GraphQL using JDBI

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

• Create Google Campaign Manager 360 Dataflows on PowerBI.com

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

• Build Interactive Dashboards from Shippo in Amazon QuickSight

  Create a virtual SQL Server database for Shippo in CData Software Connect Server and import Shippo into Amazon QuickSight SPICE to build interactive dashboards.

• Build Visualizations of Trello in Birst

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

• Connect to Microsoft OneDrive as a Linked Server

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

• How to integrate Databricks with Apache Airflow

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

• How to connect and process SAP HANA from Azure Databricks

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

• Replicate Marketo for Use in Salesforce Connect

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

• Build IBM Informix-Connected ETL Processes in Google Data Fusion

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

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

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

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

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

• Automated Continuous Azure Active Directory Replication to SingleStore

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

• Bidirectional Access to Azure Data Catalog from FileMaker Pro

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

• Access Live Dropbox in Coginiti Pro

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

• Connect to Unbounce in NetBeans

  Connect to Unbounce in NetBeans with the data source configuration wizard.

• Explore Geographical Relationships in Azure Table with Power Map

  Create data visualizations with Azure Table Storage in Power Map.

• Query, Visualize, and Share live Spark in Redash

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

• Access Highrise from MySQL in PHP

  Connect to Highrise through the standard MySQL libraries in PHP.

• Visualize Live Hive of Power BI Report Builder in Power BI Service

  Use CData Power BI Connectors to connect to live Apache Hive using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

• Visualize Live Amazon DynamoDB of Power BI Report Builder in Power BI Service

  Use CData Power BI Connectors to connect to live Amazon DynamoDB using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

• View Reports on Real-Time MariaDB in Power BI Report Server

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

• Connect to and Visualize Live Zuora in Tableau Prep

  Use CData Tableau Connectors and Tableau Prep Builder to visualize live Zuora.

• Export Data from SQL Server to SAP HANA through SSIS

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

• Automated Continuous Dynamics NAV Replication to SQLite

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

• Connect to Azure Analysis Services from PowerBuilder

  This article demonstrates how to access Azure Analysis Services from Appeon PowerBuilder using the CData ADO.NET Provider for Azure Analysis Services.

• Build Reckon Visualizations in Tableau Cloud

  Use CData Software Connect Server to create a virtual SQL Server Database for Reckon and build visualizations in Tableau Cloud.

• Manage Oracle Eloqua in DBArtisan as a JDBC Source

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

• How to create Jira Service Management federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for Atlassian Jira Service Management in MySQL .

• Automated Continuous Dynamics GP Replication to MySQL

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

• Create Dynamics 365 Business Central Dataflows on PowerBI.com

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

• Automated Continuous Outreach.io Replication to Local Delimited Files

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

• How to Access Stripe Using Entity Framework

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

• Automated Continuous Oracle Eloqua Replication to Azure SQL

  Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to Azure SQL.

• How to load Xero data into Elasticsearch via Logstash

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

• How to connect and process Drift from Azure Databricks

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

• How to connect to Azure Data Catalog in DBVisualizer

  Integrate Azure Data Catalog with visual data analysis tools and data connection wizards in DBVisualizer

• Build Semantic Layer Views for Dynamics 365 Business Central in APOS Live Data Gateway

  Use the CData Connector for Dynamics 365 Business Central in APOS Live Data Gateway to build Semantic Layer Views for Dynamics 365 Business Central.

• Visualize Snapchat Ads in TIBCO Spotfire through OData

  Integrate Snapchat Ads into dashboards in TIBCO Spotfire.

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

• Build Semantic Layer Views for Bing Ads in APOS Live Data Gateway

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

• Analyze Dynamics CRM in R

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

• Query, Visualize, and Share live Stripe in Redash

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

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

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

• «
• 54
• 55
• 56
• 57
• 58
• 59
• 60
• 61
• 62
• 63
• »