CData Software - Knowledge Base

Recent Articles

• «
• 107
• 108
• 109
• 110
• 111
• 112
• 113
• 114
• 115
• 116
• »

• Using the CData Software ODBC Driver for Google Ads in PyCharm

  Connect to Google Ads as an ODBC data source in PyCharm using the CData Software ODBC Driver for Google Ads.

• Connect to Google Sheets in as an External Source in Dremio

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

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

• Automate Freshdesk Replication to Azure Data Lake

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

• Import and Visualize Workday in Power View

  Create data visualizations based on Workday in Excel.

• Automated Continuous ShipStation Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable ShipStation replication to Google Cloud SQL.

• PowerShell Scripting to Replicate Presto to MySQL

  Write a simple PowerShell script to replicate Presto to a MySQL database.

• Analyze Live GitHub in SAS Viya

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

• Query Todoist through ODBC in Node.js

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

• Analyze SAP Concur in Looker

  Use CData Connect Cloud to connect to SAP Concur from Looker and build custom apps using live SAP Concur.

• How to connect to Cloudant from Spring Boot

  Connect to Cloudant in a Spring Boot Application using CData JDBC Cloudant Driver

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

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

• Model, Search, and Visualize Live Salesforce Pardot in ThoughtSpot

  Use CData Connect Cloud to connect to live Salesforce Pardot for modeling, searching, and visualizing.

• Analyze Sage Cloud Accounting in Infragistics Reveal

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

• Connect to SAS Data Sets in Aqua Data Studio

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

• Import PostgreSQL into FileMaker Pro

  Create reports that integrate PostgreSQL in Filemaker Pro.

• Create YouTube Analytics-Connected Enterprise Applications in OutSystems

  Use CData Connect Cloud to connect to YouTube Analytics from OutSystems and build custom enterprise apps using live YouTube Analytics.

• Build MVC Applications with Connectivity to SAP ByDesign

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

• Automate Outreach.io Integration Tasks from PowerShell

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

• Using AngularJS to Build Dynamic Web Pages with Bing Search Results

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

• Create Informatica Mappings From/To an ODBC Data Source for Snapchat Ads

  Create an ODBC connection to Snapchat Ads in Informatica and browse and transfer Snapchat Ads.

• Access Live HarperDB in AWS Lambda (with IntelliJ IDEA)

  Connect to live HarperDB in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

• DataBind Charts to SAP Ariba Source

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

• Create TaxJar-Connected Visualizations in Klipfolio

  Use CData Software Connect Server to connect to TaxJar from Klipfolio and build custom visualizations using live TaxJar.

• Create Data Visualizations in Cognos BI with Azure Data Lake Storage

  Access Azure Data Lake Storage as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

• How to work with SAP Business One in Apache Spark using SQL

  Access and process SAP Business One in Apache Spark using the CData Software JDBC Driver.

• Connect to and Query NetSuite in QlikView over ODBC

  Create data visualizations with NetSuite CRM & ERP in QlikView.

• How to use SQLAlchemy ORM to access LDAP Objects in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of LDAP.

• Work with Zoho Books in FoxPro

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

• Automated Continuous Couchbase Replication to PostgreSQL

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

• Visualize Live Harvest in the Power BI Service

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

• Visualize Amazon S3 in TIBCO Spotfire through OData

  Integrate Amazon S3 into dashboards in TIBCO Spotfire.

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

  Provide connectivity to Microsoft Project through an SAP BusinessObjects universe.

• A PostgreSQL Interface for Facebook

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

• Build Sugar CRM-Connected Visualizations in datapine

  Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Sugar CRM.

• Establish a Live Connection with Smartsheet using Tableau Bridge

  The CData ODBC Driver for Smartsheet enables you to integrate live Smartsheet into Tableau Cloud dashboards using the Tableau Bridge.

• Connect to HDFS in Google Apps Script

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

• Connect to MariaDB in Ruby

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

• How to publish and share SAP ByDesign dashboards with Tableau Server

  The CData ODBC driver for SAP ByDesign enables you integrate SAP Business ByDesign into Tableau dashboards.

• Access Excel Online 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 Microsoft Excel Online.

• Visualize Jira Service Management in TIBCO Spotfire through ODBC

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

• PowerShell Scripting to Replicate Veeva to MySQL

  Write a simple PowerShell script to replicate Veeva Vault to a MySQL database.

• Create Informatica Mappings From/To an ODBC Data Source for Tableau CRM Analytics

  Create an ODBC connection to Tableau CRM Analytics in Informatica and browse and transfer Tableau CRM Analytics.

• How to connect to Parquet from MS Excel on Mac OS X

  Create a Data Source Name in iODBC with the CData ODBC Driver for Parquet and work with Apache Parquet in Microsoft Excel on Mac OS X.

• How to use SQLAlchemy ORM to access Oracle Eloqua in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Oracle Eloqua.

• How to connect to Google Analytics from IntelliJ

  Integrate connectivity to Google Analytics with wizards in IntelliJ.

• DataBind SAS xpt to the DevExpress Data Grid

  Use the CData Software ADO.NET Provider for SAS xpt with the DevExpress Windows Forms and Web controls to provide SAS XPORT to a chart.

• How to connect to Basecamp from Google Apps Script

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

• How to connect to Google Sheets in DBVisualizer

  Integrate Google Sheets with visual data analysis tools and data connection wizards in DBVisualizer

• Configure the CData JDBC Driver for Raisers Edge NXT in a Connection Pool in Tomcat

  Connect to Raisers Edge NXT from a connection pool in Tomcat.

• Operational Reporting on Google Contacts from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Google Contacts.

• Use Dash to Build to Web Apps on Sage Intacct

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

• How to connect to Sage 200 from MS Excel on Mac OS X

  Create a Data Source Name in iODBC with the CData ODBC Driver for Sage 200 and work with Sage 200 in Microsoft Excel on Mac OS X.

• Bidirectional Access to Bing Ads from FileMaker Pro

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

• Extract, Transform, and Load Drip in Informatica PowerCenter

  Create a simple Workflow for Drip in Informatica PowerCenter.

• How to Access Dynamics 365 Using Entity Framework

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

• Access Live Google Cloud Storage in AWS Lambda

  Connect to live Google Cloud Storage in AWS Lambda using the CData JDBC Driver.

• How to connect to Clio from MS Excel on Mac OS X

  Create a Data Source Name in iODBC with the CData ODBC Driver for Clio and work with Clio in Microsoft Excel on Mac OS X.

• Model Quickbase Using Azure Analysis Services

  Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and Quickbase, enabling the direct import of real-time Quickbase.

• Automated Continuous SAP Fieldglass Replication to AlloyDB

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

• Replicate Splunk for Use in Salesforce Connect

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

• How to connect Amazon QuickSight to Zoho Books

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

• Automated Continuous Monday.com Replication to Google BigQuery

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

• Automated SendGrid Replication to Teradata

  Use CData Sync to Customize and automate SendGrid replication to Teradata.

• Connect to Azure Synapse as an External Data Source using PolyBase

  Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live Azure Synapse.

• How to publish and share ConstantContact dashboards with Tableau Server

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

• LINQ to CouchDB

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

• Use JayDeBeApi to access Oracle Service Cloud in Python

  Use standard Python scripting and the development environment of your choice to access live Oracle Service Cloud.

• How to Connect to Oracle Sales in Using Python: 6 Steps

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

• Automated Continuous Sage 300 Replication to Oracle

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

• Query Oracle Eloqua in MySQL Workbench

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

• DataBind Authorize.Net to the DevExpress Data Grid

  Use the CData Software ADO.NET Provider for Authorize.Net with the DevExpress Windows Forms and Web controls to provide Authorize.Net to a chart.

• Model, Search, and Visualize Live Snowflake in ThoughtSpot

  Use CData Connect Cloud to connect to live Snowflake for modeling, searching, and visualizing.

• How to connect to Tableau CRM Analytics from Spring Boot

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

• Build Apps with Live Exact Online Using the Low-Code Development Platform of Mendix

• «
• 107
• 108
• 109
• 110
• 111
• 112
• 113
• 114
• 115
• 116
• »