CData Software - Knowledge Base

Recent Articles

• «
• 537
• 538
• 539
• 540
• 541
• 542
• 543
• 544
• 545
• 546
• »

• Natively Connect to QuickBooks Online in PHP

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

• Query NetSuite as a SQL Server Database in Node.js

  Execute SQL Server queries against NetSuite CRM & ERP from Node.js.

• Excel Spreadsheet Automation on Twitter with the QUERY Formula

  Pull data, automate spreadsheets, and more with the QUERY formula.

• How to load eBay data into Elasticsearch via Logstash

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

• Connect to SAP HANA from Asprova with CData Software ODBC Driver for SAP HANA

  This article shows how to connect faster to SAP HANA data from Asprova.

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

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

• Automate Microsoft Exchange Integration Tasks from PowerShell

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

• Integrate PingOne with External Services using SnapLogic

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

• Analyze Cloudant in Infragistics Reveal

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

• Migrating data from ActiveCampaign to Snowflake using CData SSIS Components.

  Easily push ActiveCampaign to Snowflake using the CData SSIS Tasks for ActiveCampaign and Snowflake.

• Connect to Zoho Projects in RazorSQL

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

• Edit and Search Printful External Objects

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

• Connect to Microsoft Project in RazorSQL

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

• Build Dashboards with Confluence in Dundas BI

  Create dynamic dashboards and perform analytics based on Atlassian Confluence in Dundas BI.

• Create Reports from Yahoo! Ads in Looker Studio

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

• Connect to Dynamics CRM in Aqua Data Studio

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

• Query Clio as a MySQL Database in Node.js

  Execute MySQL queries against Clio from Node.js.

• Create Apps from Microsoft Dataverse in Qlik Sense Cloud

  Use CData Connect Cloud to connect to Microsoft Dataverse and build apps from live Microsoft Dataverse (CDS) in Qlik Sense Cloud.

• Access Live Reckon Accounts Hosted in SAS JMP via ODBC

  You can use the CData ODBC Driver to integrate Reckon Accounts Hosted into the statistical analysis tools available in SAS JMP. This article shows how to use Reckon Accounts Hosted in the Graph Builder and Query Builder.

• Automate Sage 200 Tasks in Power Automate Using CData API Server

  With CData API Server, easily create OData endpoints for live Sage 200 and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.

• Build Apps with Live SAP BusinessObjects BI in Adalo using CData Connect Cloud

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

• How to Access Live Snowflake in Power Automate Desktop via ODBC

  The CData ODBC Driver for Snowflake enables you to integrate Snowflake into workflows built using Microsoft Power Automate Desktop.

• DataBind Controls to SharePoint in C++Builder

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

• Connect to Calendly in CloverDX (formerly CloverETL)

  Transfer Calendly using the visual workflow in the CloverDX data integration tool.

• Bidirectional Access to LDAP Objects from FileMaker Pro

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

• Choosing the Best Method to Connect SAP Hybris C4C to SQL Server: 5 Options Explained

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

• Excel Spreadsheet Automation on Exact Online with the QUERY Formula

  Pull data, automate spreadsheets, and more with the QUERY formula.

• Connect to GMO MakeShop in Google Apps Script via Connect Cloud

  Use CData Connect Cloud to access GMO MakeShop in Google Apps Script.

• Automated Continuous Google Directory Replication to Local Delimited Files

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

• Access Live SAP HANA XS Advanced in SAS JMP via ODBC

  You can use the CData ODBC Driver to integrate SAP HANA XS Advanced into the statistical analysis tools available in SAS JMP. This article shows how to use SAP HANA XS Advanced in the Graph Builder and Query Builder.

• How to Visualize Acumatica Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Acumatica ERP in Python.

• Integrate Google Spanner in the Pentaho Report Designer

  Publish reports based on Google Spanner in the Pentaho BI tool.

• Connect to SAP Hybris C4C from a Connection Pool in Jetty

  The SAP Hybris C4C JDBC Driver supports connection pooling: This article shows how to connect faster to SAP Hybris C4C from Web apps in Jetty.

• Connect to SFTP in RapidMiner

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

• Access Live Reckon Accounts Hosted in TIBCO Data Virtualization

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

• Connect to Tableau CRM Analytics in Ruby

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

• Integrate Twilio in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Twilio from Informatica Cloud.

• Connect to SAP HANA XS Advanced from Blazor Apps

  Build ASP.NET Core Blazor C# apps that integrate with real-time SAP HANA XS Advanced using standard SQL.

• Access Live Spark in AWS Lambda

  Connect to live Apache Spark SQL in AWS Lambda using the CData JDBC Driver.

• Automated Continuous Cassandra Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable Apache Cassandra replication to OneLake in Microsoft Fabric.

• Connect to Bullhorn CRM in RunMyProcess through Connect Cloud

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

• Query Smartsheet in DataGrip

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

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

  Create ETL applications and real-time data pipelines for Atlassian Jira in Python with petl.

• Analyze Amazon Athena in Infragistics Reveal

  Use the CData API Server to create an OData API on top of Amazon Athena and visualize live Amazon Athena in Ingragistics Reveal.

• How to connect to SharePoint in DBVisualizer

  Integrate Microsoft SharePoint with visual data analysis tools and data connection wizards in DBVisualizer

• Visualize Airtable in Tableau

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

• Explore Geographical Relationships in Outreach.io with Power Map

  Create data visualizations with Outreach.io in Power Map.

• Connect to Exact Online from AWS Glue

  Use CData Connect Cloud to gain access to live Exact Online from your AWS Glue jobs.

• Prepare, Blend, and Analyze Google Campaign Manager 360 in Alteryx Designer (ODBC)

  Build workflows to access live Google Campaign Manager 360 for self-service data analytics.

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

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

• Feed Freshdesk into FineReport

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

• Analyze Box in Slingshot with CData API Server

  Use the CData API Server to build an OData API on top of Box and visualize the live in Slingshot (formerly Reveal BI) for seamless insights.

• Replicate Basecamp for Use in Salesforce Connect

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

• Query, Visualize, and Share live Raisers Edge NXT in Redash

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

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

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

• Create Couchbase-Connected Applications in Appsmith

  Connect to Couchbase via CData Connect Cloud in Appsmith and create custom business applications with real-time access to Couchbase.

• Use the CData Software JDBC Driver for Salesforce in MicroStrategy

  Connect to Salesforce & Force.com in MicroStrategy Developer using the CData Software JDBC Driver for Salesforce.

• Visualize SingleStore from Tableau

  Use the Tableau Desktop business intelligence tool to connect to SingleStore.

• Access Live Adobe Analytics in Google Sheets through Connect Spreadsheets

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

• Build Charts with HDFS in Clear Analytics

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

• Access Live Snapchat Ads in Excel (Desktop) through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live Snapchat Ads from your Excel spreadsheets.

• Connect to Dynamics CRM through External Services in Salesforce

  Use CData Connect Cloud to securely connect Salesforce External Services with Dynamics CRM using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.

• Visualize Salesforce Pardot in Sisense

  Create an ElastiCube in Sisense app with access to Salesforce Pardot.

• Consume Reckon Accounts Hosted OData Feeds in PowerBuilder

  This article demonstrates how to consume Reckon Accounts Hosted as OData feeds from PowerBuilder using the API Server.

• Automated Continuous Azure Blob Storage Replication to Microsoft Access

  Use CData Sync for automated, continuous, customizable Azure Blob Storage replication to Microsoft Access.

• Replicate Coinbase to Multiple Databases via the CData Sync CLI

  Replicate Coinbase to disparate databases with a single configuration.

• How to integrate Pipedrive with Apache Airflow

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

• Connect to Google Ad Manager as an External Source in Dremio

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

• How to Access Google Campaign Manager 360 Using Entity Framework

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

• Create Azure Data Lake Storage-Connected Applications in Appsmith

  Connect to Azure Data Lake Storage via CData Connect Cloud in Appsmith and create custom business applications with real-time access to Azure Data Lake Storage.

• A PostgreSQL Interface for Clio (MySQL Remoting via JDBC)

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

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

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

• Manage Impala in DBArtisan as a JDBC Source

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

• Publish Reports with SAP HANA in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date SAP HANA.

• Create Datasets from Google Cloud Storage in Domo Workbench and Build Visualizations of Google Cloud Storage in Domo

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

• Edit and Search External Excel Online Objects in Salesforce Connect

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

• Create Power BI Reports on Real-Time Spark

  Use the CData ODBC Driver for Spark to visualize Apache Spark SQL in Power BI Desktop.

• How to connect to Zoho Books from IntelliJ

  Integrate connectivity to Zoho Books with wizards in IntelliJ.

• How to create an RPA flow for EnterpriseDB in UiPath Studio

  Use the EnterpriseDB ODBC Driver to create workflows that access real-time EnterpriseDB without any coding.

• Publish Pinterest-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Pinterest.

• Connect to Airtable in Jaspersoft Studio

  Execute SQL to remote Airtable in Jaspersoft Studio.

• Create Data Visualizations in Cognos BI with Bitbucket

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

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

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

• Building Dynamic Web Pages with Wave Financial Using AngularJS

  Create single-page applications with live connectivity to Wave Financial using the CData API Server.

• Access Bullhorn CRM from MySQL in Amazon QuickSight

  Connect to Bullhorn CRM and build visualizations of Bullhorn CRM using a MySQL Connection in Amazon QuickSight.

• Connect to Oracle Financials Cloud Using the Script Function in Claris FileMaker Pro

• «
• 537
• 538
• 539
• 540
• 541
• 542
• 543
• 544
• 545
• 546
• »