CData Software - Knowledge Base

Recent Articles

• «
• 313
• 314
• 315
• 316
• 317
• 318
• 319
• 320
• 321
• 322
• »

• How to update Databricks from Excel

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

• Explore Geographical Relationships in Outreach.io with Power Map

  Create data visualizations with Outreach.io in Power Map.

• How to connect PolyBase to HDFS

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

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

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

• Automate Presto Replication to Couchbase

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

• Viewing Google Ad Manager in RAD Studio Data Explorer

  How to view Google Ad Manager in RAD Studio Data Explorer using the CData ODBC Driver for Google Ad Manager.

• Connect to Act CRM in Ruby

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

• Use the CData ODBC Driver for LDAP in Microsoft Power Query

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

• Analyze API in Infragistics Reveal

  Use CData Connect Cloud to create on OData API on top of API and visualize live API in Infragistics Reveal.

• Publish Azure Data Catalog-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Azure Data Catalog.

• Use the CData Software ODBC Driver for SAP Concur in MicroStrategy

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

• How to Query TigerGraph in MySQL Workbench

  Execute MySQL queries against live TigerGraph from MySQL Workbench.

• Connect to Live MYOB AccountRight in MicroStrategy through CData Connect Cloud

  Create a live connection to MYOB AccountRight in CData Connect Cloud and connect to your MYOB AccountRight from MicroStrategy.

• Back Up Stripe to SQL Server through SSIS

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

• Explore Geographical Relationships in WordPress with Power Map

  Create data visualizations with WordPress in Power Map.

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

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

• Connect to SQL Server through External Services in Salesforce

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

• How to Connect to & Open Twilio in Microsoft Excel

  This article uses the CData ODBC driver for Twilio to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

• Connect to Printify in RapidMiner

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

• Import Drift into FileMaker Pro

  Create reports that integrate Drift in Filemaker Pro.

• Analyze CockroachDB with Power Pivot

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

• Use the CData ODBC Driver for MailChimp in Microsoft Power Query

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

• How to Use CData Connect to Access Live Highrise in Power Automate

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

• How to Access Procore Using Entity Framework

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

• Use the CData ODBC Driver for Microsoft Exchange from SharePoint Excel Services

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

• Automated Continuous Basecamp Replication to Vertica

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

• Work with Live IBM Informix in Power Query

  Use CData Connect Cloud to connect to IBM Informix and work with live IBM Informix in Microsoft Power Query.

• Automated Continuous Certinia Replication to Oracle

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

• Connect to ServiceNow from Asprova with CData Software ODBC Driver for ServiceNow

  This article shows how to connect faster to ServiceNow data from Asprova.

• Stream Kintone into Apache Kafka Topics

  Access and stream Kintone in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Replicate Multiple IBM Informix Accounts

  Replicate multiple IBM Informix accounts to one or many databases.

• Visualize Quickbase in TIBCO Spotfire through OData

  Integrate Quickbase into dashboards in TIBCO Spotfire.

• How to Connect to & Open Todoist in Microsoft Excel

  This article uses the CData ODBC driver for Todoist to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

• Query Microsoft OneDrive in MySQL Workbench

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

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

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

• DataBind Controls to Azure Analysis Services in C++Builder

  DataBind to Azure Analysis Services in C++Builder with standard components and controls.

• Using AngularJS to Build Dynamic Web Pages with Salesforce Pardot

  Use the CData Connect Server to create Salesforce Pardot OData feeds and build single-page applications with live Salesforce Pardot.

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

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

• Visualize Live Zoho Books of Power BI Report Builder in Power BI Service

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

• Natively Connect to MySQL in PHP

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

• Author and Share Power BI Reports on Real-Time Microsoft Teams

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

• A PostgreSQL Interface for SAP BusinessObjects BI

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

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

  Connect to Email from a connection pool in Tomcat.

• Manage BambooHR in DBArtisan as a JDBC Source

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

• Create Data Visualizations in Cognos BI with Dynamics 365 Business Central

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

• Visualize Exact Online in TIBCO Spotfire through ADO.NET

  Integrate Exact Online into dashboards in TIBCO Spotfire.

• How to publish and share Zoho Creator dashboards with Tableau Server

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

• Visualize OData Services in TIBCO Spotfire through ADO.NET

  Integrate OData into dashboards in TIBCO Spotfire.

• Connect to SAP Concur in RazorSQL

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

• Create Amazon DynamoDB 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 Exact Online in AWS Lambda

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

• Access Cloudant as a Remote Oracle Database

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

• Analyze Live SharePoint in SAS Viya

  Use CData Connect Cloud to connect to Microsoft SharePoint from SAS Viya and deploy self-service analytics using live Microsoft SharePoint.

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

  Connect to SFTP 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.

• Automate Dynamics CRM Replication to Azure Data Lake

  Use CData Sync to customize and automate Microsoft Dynamics CRM replication to Azure Data Lake.

• Automated Continuous Bullhorn CRM Replication to Apache Kafka

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

• How to publish and share SAS Data Sets dashboards with Tableau Server

  The CData ODBC driver for SAS Data Sets enables you integrate SAS Data Sets into Tableau dashboards.

• Connect to Avalara AvaTax from PowerBuilder

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

• Automated Continuous BigCommerce Replication to SQL Server

  Use CData Sync for automated, continuous, customizable BigCommerce replication to SQL Server.

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

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

• Provide OData Services of PayPal from a WCF Application

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

• Query Facebook Ads as a MySQL Database in Node.js

  Execute MySQL queries against Facebook Ads from Node.js.

• Stream OData Services into Apache Kafka Topics

  Access and stream OData in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Create Reports from Microsoft Project in Looker Studio

  Use CData Connect Cloud to gain access to live Microsoft Project and create custom reports in Looker Studio.

• Connect to Odoo in as an External Source in Dremio

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

• Connect to FHIR as a Linked Server

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

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

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

• Visualize MariaDB in TIBCO Spotfire through ODBC

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

• Feed Bitbucket into FineReport

  How to set Bitbucket as a JDBC data source in FineReport.

• Connect to Dropbox from PowerBuilder

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

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

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

• How to connect to Microsoft Project from Spring Boot

  Connect to Microsoft Project in a Spring Boot Application using CData JDBC Microsoft Project Driver

• Connect to Live Azure Analysis Services in PostGresSQL Interface through CData Connect Cloud

  Create a live connection to Azure Analysis Services in CData Connect Cloud and connect to your Azure Analysis Services from PostgreSQL.

• Connect to and Query Twitter Ads in QlikView over ODBC

  Create data visualizations with Twitter Ads in QlikView.

• Access Live Okta in Coginiti Pro

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

• Analyze Facebook Ads with Power Pivot

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

• Extract, Transform, and Load Oracle HCM Cloud in Informatica PowerCenter

  Create a simple Workflow for Oracle HCM Cloud in Informatica PowerCenter.

• Connect to Acumatica in Aqua Data Studio

  Access Acumatica ERP from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• Access Live PostgreSQL in Google Sheets

  Use CData Connect Cloud to gain access to live PostgreSQL from your Google Sheets.

• Choosing the Best Method to Connect Salesforce Pardot to SQL Server: 5 Options Explained

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

• Import and Visualize Amazon Athena in Power View

  Create data visualizations based on Amazon Athena in Excel.

• Integrate CouchDB into Automated Tasks with Power Automate

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

• Automate Redshift Replication to SAP HANA

  Use CData Sync to customize and automate Amazon Redshift replication to SAP HANA.

• Creating Todoist-Connected Applications in Unqork

  You can use CData Connect to feed Todoist to Unqork and build custom business apps.

• Visualize Redis in TIBCO Spotfire through OData

  Integrate Redis into dashboards in TIBCO Spotfire.

• Access Live SAP HANA XS Advanced in Coginiti Pro

  Connect to and query live SAP HANA XS Advanced from the GUI in the Coginiti Pro: SQL Analytics Tool.

• Viewing Amazon Athena in RAD Studio Data Explorer

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

• Integrate Excel Online into Automated Tasks with Power Automate

  Use CData Connect Cloud to connect to Microsoft Excel Online and integrate live Microsoft Excel Online into your Power Automate tasks.

• Access Salesforce Pardot from MySQL in HeidiSQL

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

• Build Automated Workflows with Live Paylocity in Workato

  Use CData Connect Cloud to connect to live Paylocity and build automated workflows in Workato.

• Connect to Dynamics CRM in Google Apps Script

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

• Design BIRT Reports on Office 365

  Provide current Microsoft Office 365 to your embedded analytics.

• Use the CData Software JDBC Driver for Excel Online in MicroStrategy Desktop

  Connect to Microsoft Excel Online in MicroStrategy Desktop using the CData Software JDBC Driver for Excel Online.

• Visualize Live MarkLogic in Tableau

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

• Access Google Data Catalog as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Google Data Catalog from your Oracle system.

• Integrate with JSON Services in JReport Designer

  Create charts and reports based on JSON in JReport Designer.

• Replicate Multiple Dynamics 365 Business Central Accounts

  Replicate multiple Dynamics 365 Business Central accounts to one or many databases.

• Use the CData Software ODBC Driver for Zendesk in MicroStrategy Desktop

  Connect to Zendesk in MicroStrategy Desktop using the CData Software ODBC Driver for Zendesk.

• How to connect and process Airtable from Azure Databricks

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

• Build Redshift-Connected Apps in Choreo

  Use CData Connect Cloud to connect to Redshift from Choreo and build custom apps using live Amazon Redshift.

• «
• 313
• 314
• 315
• 316
• 317
• 318
• 319
• 320
• 321
• 322
• »