CData Software - Knowledge Base

Recent Articles

• «
• 41
• 42
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• »

• MongoDB Cloud Connectivity

  Explore a compilation of guides and tutorials demonstrating how to establish connections to MongoDB through CData Connect Cloud using different applications and tools.

• How to work with Xero in Apache Spark using SQL

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

• How to connect to Freshdesk in DBVisualizer

  Integrate Freshdesk with visual data analysis tools and data connection wizards in DBVisualizer

• Automated Continuous Reckon Accounts Hosted Replication to Google Cloud SQL

  Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to Google Cloud SQL.

• Query Sugar CRM as a SQL Server Database in Node.js

  Execute SQL Server queries against Sugar CRM from Node.js.

• DataBind Controls to DocuSign in C++Builder

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

• Automated Continuous Amazon Athena Replication to MongoDB

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

• How to connect to PostgreSQL in DBVisualizer

  Integrate PostgreSQL with visual data analysis tools and data connection wizards in DBVisualizer

• Use the CData Software JDBC Driver for Square in MicroStrategy Web

  Connect to Square in MicroStrategy Web using the CData Software JDBC Driver for Square.

• Publish Shippo-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Shippo.

• Automated Continuous WooCommerce Replication to Microsoft Access

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

• Use the CData ODBC Driver for SAP Hybris C4C in Microsoft Power Query

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

• How to use SQLAlchemy ORM to access Marketo in Python

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

• Integrate Live SAP SuccessFactors into Custom Business Apps Built in Power Apps

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

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

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

• How to Build an ETL App for Xero in Python with CData

  Create ETL applications and real-time data pipelines for Xero Accounting in Python with petl.

• Connect to Marketo in SpagoBI

  Create reports featuring live Marketo in SpagoBI Studio. Host Marketo reports on SpagoBI Server.

• Access Live Active Directory in TIBCO Data Virtualization

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

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

• Visualize HBase in Sisense

  Create an ElastiCube in Sisense app with access to Apache HBase.

• Create Reports with eBay Analytics in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date eBay Analytics.

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

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

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

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

• Work with Live GraphQL in Power Query

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

• Manage Sybase in DBArtisan as a JDBC Source

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

• Create Google Directory-Connected Enterprise Applications in OutSystems

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

• Automated Continuous MarkLogic Replication to AlloyDB

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

• Query Hive in DataGrip

  Create a Data Source for Hive in DataGrip and use SQL to query live Apache Hive.

• Automated Continuous Todoist Replication to Oracle

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

• Automated Continuous Azure Active Directory Replication to MongoDB

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

• Connect to Email as an External Source in Dremio

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

• Working with Certinia in LINQPad

  Execute LINQ queries to Certinia in LINQPad.

• Automated Continuous SharePoint Replication to Oracle

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

• Connect to Drift in Aqua Data Studio

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

• Write a Simple Go Application to work with SQL Analysis Services on Linux

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

• Replicate Power BI XMLA to Multiple Databases

  Replicate Power BI XMLA to disparate databases with a point-and-click configuration.

• Create Datasets from MYOB AccountRight in Domo Workbench and Build Visualizations of MYOB AccountRight in Domo

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

• Using the CData Software ODBC Driver for Okta in PyCharm

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

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

• Publish Reports with Excel in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Microsoft Excel.

• DataBind Wijmo Grid to Hive

  Provide real-time Apache Hive to interactive controls.

• Integrate HCL Domino with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate HCL Domino with External Services.

• Connect to Quickbase from Excel & GoogleSheets!

  Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Quickbase, and over 250 other data sources, right inside your Excel and Google spreadsheets!

• How to integrate Azure DevOps with Apache Airflow

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

• Query Procore in DataGrip

  Create a Data Source for Procore in DataGrip and use SQL to query live Procore.

• Import and Visualize Google Sheets in Power View

  Create data visualizations based on Google Sheets in Excel.

• Create Dropbox-Connected Nintex Workflows

  Use CData Software Connect Server to connect to Dropbox from Nintex Workflow Cloud and build custom workflows using live Dropbox.

• How to integrate Greenplum with Apache Airflow

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

• Connect to Bing Search Results from a Connection Pool in JBoss

  Integrate Bing Search into Java servlets: Use the Management Console in JBoss to install the Bing Search JDBC Driver.

• Integrate with Live ServiceNow in MuleSoft (via CData Connect Cloud)

  Use CData Connect Cloud to connect to ServiceNow from the MuleSoft Anypoint Platform to integrate live ServiceNow into custom reports and dashboards.

• Connect to BigCommerce in RazorSQL

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

• How to connect to QuickBooks Online with Squirrel SQL client

  Connect to QuickBooks Online and execute queries in the Squirrel SQL Client.

• Connect to Google Calendar from Filemaker Pro (Mac)

  Use CData Connect Cloud to connect to and query live Google Calendar from Filemaker Pro on Mac.

• How to Query Live Google Campaign Manager 360 Data in Natural Language in Python using LlamaIndex

  Use LlamaIndex to query live Google Campaign Manager 360 data in natural language using Python.

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

  Connect to Oracle Sales from a connection pool in Tomcat.

• Automated Continuous Exact Online Replication to Local Delimited Files

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

• Analyze Live Adobe Analytics in SAS Viya

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

• Replicate OneNote to Multiple Databases via the CData Sync CLI

  Replicate Microsoft OneNote to disparate databases with a single configuration.

• Viewing Excel Online in RAD Studio Data Explorer

  How to view Microsoft Excel Online in RAD Studio Data Explorer using the CData ODBC Driver for Excel Online.

• Automated Continuous Highrise Replication to Apache Cassandra

  Use CData Sync for automated, continuous, customizable Highrise replication to Apache Cassandra.

• Create Data Visualizations Based On Twitter in Mode

  Use CData Connect Cloud to connect to Twitter from Mode and build visualizations using live

• How to integrate Metabase with OneNote

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

• Replicate GraphQL for Use in Salesforce Connect

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

• Connect to Raisers Edge NXT from a Connection Pool in Jetty

  The Raisers Edge NXT JDBC Driver supports connection pooling: This article shows how to connect faster to Raisers Edge NXT from Web apps in Jetty.

• How to connect to Azure Analysis Services with Squirrel SQL client

  Connect to Azure Analysis Services and execute queries in the Squirrel SQL Client.

• Replicate Impala to Multiple Databases

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

• Provide OData Services of Impala from a WCF Application

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

• Build an OLAP Cube in SSAS from HarperDB

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

• Replicate Multiple Square Accounts

  Replicate multiple Square accounts to one or many databases.

• Connect to Unbounce from PowerBuilder via ODBC

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

• A PostgreSQL Interface for Marketo using the CData ODBC Driver

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

• Create Reports from Twitter in Looker Studio

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

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

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

• Integrate with live Gmail in Jitterbit

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

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

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

• Integrate with live HCL Domino in Jitterbit

  Use CData Connect Cloud to connect to and integrate live HCL Domino in Jitterbit.

• Analyze Exact Online in SAP Analytics Cloud

  Use CData Connect Cloud to create an OData API on top of Exact Online and visualize Exact Online in SAP Analytics Cloud.

• Visualize Dynamics GP in Tableau Desktop (through CData Connect)

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

• Automated Google Ad Manager Replication to Teradata

  Use CData Sync to Customize and automate Google Ad Manager replication to Teradata.

• PowerShell Scripting to Replicate SAP SuccessFactors to MySQL

  Write a simple PowerShell script to replicate SAP SuccessFactors to a MySQL database.

• Query Twilio in MySQL Workbench

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

• Work with Sybase IQ in FoxPro

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

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

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

• Connect to ShipStation from Crystal Reports

  Use CData Connect Cloud to connect to and report on live ShipStation from Crystal Reports.

• Access Live Smaregi in Google Sheets via Connect Cloud

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

• Connect to QuickBooks in RazorSQL

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

• Build Interactive Dashboards from Aha in Amazon QuickSight

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

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

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

• Build Charts with Sage 50 UK in Clear Analytics

  Create dynamic charts and perform analytics based on Sage 50 UK in Clear Analytics.

• Build Google Search-Connected Visualizations in datapine

  Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Google Search.

• Build Oracle SCM-Connected Apps in Choreo

  Use CData Connect Cloud to connect to Oracle SCM from Choreo and build custom apps using live Oracle SCM.

• Use the CData Software JDBC Driver for Okta in MicroStrategy Desktop

  Connect to Okta in MicroStrategy Desktop using the CData Software JDBC Driver for Okta.

• Visualize Live Google Calendar of Power BI Report Builder in Power BI Service

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

• How to import Databricks into Apache Solr

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

• Automated Continuous Pipedrive Replication to Oracle

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

• Connect and Visualize Live IBM Informix Data in Databricks Lakehouse Federation with CData Connect Cloud

  Use CData Connect Cloud to integrate live IBM Informix into the Databricks platform and create visualization dashboards with real-time IBM Informix.

• Analyze Square in Cognos Analytics

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

• Connect to Excel Online as an External Source in Dremio

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

• Analyze Azure DevOps in R via JDBC

  Use standard R functions and the development environment of your choice to analyze Azure DevOps with the CData JDBC Driver for Azure DevOps.

• Process & Analyze Twilio in Databricks (AWS)

  Use CData, AWS, and Databricks to perform data engineering and data science on live Twilio .

• «
• 41
• 42
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• »