CData Software - Knowledge Base

Recent Articles

• «
• 93
• 94
• 95
• 96
• 97
• 98
• 99
• 100
• 101
• 102
• »

• Connect to DocuSign in Airbyte ELT Pipelines

  Use CData Connect Cloud to build ELT pipelines for DocuSign in Airbyte.

• Connect to Cvent in DBArtisan

  Use wizards in DBArtisan to configure Cvent as a data source.

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

• Access Live Azure Analysis Services in Excel 365 Online (Excel for the web)

  Connect to Azure Analysis Services from Excel 365 Online (Excel for the web) with CData Connect Cloud.

• How to Create Power BI Visual Reports with Real-Time SAP Hybris C4C

  Use CData Power BI Connectors to visualize SAP Hybris C4C in Power BI.

• Visualize Microsoft OneDrive in TIBCO Spotfire through ODBC

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

• Query Confluence through ODBC in Node.js

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

• Connect to Amazon Athena from a Connection Pool in JBoss

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

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

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

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

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

• Integrate CSV with External Services using SnapLogic

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

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

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

• Integrate with Live Azure Data Lake Storage in MuleSoft (via CData Connect Cloud)

  Use CData Connect Cloud to connect to Azure Data Lake Storage from the MuleSoft Anypoint Platform to integrate live Azure Data Lake Storage into custom reports and dashboards.

• Connect to Power BI XMLA from Crystal Reports

  Use CData Connect Cloud to connect to and report on live Power BI XMLA from Crystal Reports.

• Create Salesforce Pardot-Connected Business Apps in AppSheet

  Connect to Salesforce Pardot via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to Salesforce Pardot.

• Access Certinia from MySQL in Amazon QuickSight

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

• Connect to REST in CloverDX (formerly CloverETL)

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

• Query SAP Business One in DataGrip

  Create a Data Source for SAP Business One in DataGrip and use SQL to query live SAP Business One.

• Automate Azure Data Catalog Integration Tasks from PowerShell

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

• Load WordPress to a Database Using Embulk

  Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load WordPress to a database.

• Build Dashboards with Azure Active Directory in Dundas BI

  Create dynamic dashboards and perform analytics based on Azure Active Directory in Dundas BI.

• Visualize JDBC-ODBC Bridge from Tableau

  Use the Tableau Desktop business intelligence tool to connect to JDBC-ODBC Bridge.

• Feed SharePoint Excel Services into FineReport

  How to set SharePoint Excel Services as a JDBC data source in FineReport.

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

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

• PowerShell Scripting to Replicate Sage Cloud Accounting to MySQL

  Write a simple PowerShell script to replicate Sage Business Cloud Accounting to a MySQL database.

• Use the Connect Server to Access Phoenix in Microsoft Power Pivot

  Use the Connect Server to connect to live Apache Phoenix in the Power Pivot business intelligence tool.

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for SendGrid

  Provide connectivity to SendGrid through an SAP BusinessObjects universe.

• How to integrate QuickBooks with Apache Airflow

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

• Automated PostgreSQL Replication to Teradata

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

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

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

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

  Execute SQL Server queries against Google AlloyDB from Node.js.

• Automated Continuous Printify Replication to MySQL

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

• Object-Relational Mapping (ORM) with Azure Active Directory Entities in Java

  Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Azure Active Directory into a Java-based ORM framework, Hibernate.

• Write a Simple Go Application to work with Calendly on Linux

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

• Automated Xero Replication to Teradata

  Use CData Sync to Customize and automate Xero Accounting replication to Teradata.

• How to Connect to & Open Twitter in Microsoft Excel

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

• How to Create Power BI Visual Reports with Real-Time Bitbucket

  Use CData Power BI Connectors to visualize Bitbucket in Power BI.

• Access Google Directory 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 Google Directory.

• Edit and Search External Veeva Objects in Salesforce Connect

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

• Access Avalara AvaTax from MySQL in Amazon QuickSight

  Connect to Avalara AvaTax and build visualizations of Avalara AvaTax using a MySQL Connection in Amazon QuickSight.

• Working with Stripe in LINQPad

  Execute LINQ queries to Stripe in LINQPad.

• How to load SuiteCRM data into Elasticsearch via Logstash

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

• Build a Simple VCL Application for Dynamics NAV

  How to build a simple VCL Application to view Microsoft Dynamics NAV in RAD Studio using the CData ODBC Driver for Dynamics NAV.

• Automated Continuous ClickUp Replication to SingleStore

  Use CData Sync for automated, continuous, customizable ClickUp replication to SingleStore.

• LINQ to EnterpriseDB

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

• How to connect to Sybase IQ from Spring Boot

  Connect to Sybase IQ in a Spring Boot Application using CData JDBC Sybase IQ Driver

• Process & Analyze SAP Fieldglass in Databricks (AWS)

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

• Use the CData Software ODBC Driver for Facebook in MicroStrategy

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

• Explore Geographical Relationships in JSON Services with Power Map

  Create data visualizations with JSON in Power Map.

• Visualize Google Ads in Tableau

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

• Visualize Bitbucket in Tableau

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

• Manage Klipfolio in DBArtisan as a JDBC Source

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

• How to connect PolyBase to HubDB

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

• Use Dash to Build to Web Apps on Basecamp

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

• Calendly Reporting in OBIEE with the Calendly JDBC Driver

  Deploy the Calendly JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• Use the CData Software ODBC Driver for Bitbucket in MicroStrategy Web

  Connect to Bitbucket in MicroStrategy Web using the CData Software ODBC Driver for Bitbucket.

• DataBind Controls to Office 365 in Delphi

  DataBind to Microsoft Office 365 in Delphi with standard data access components and controls.

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

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

• Create Data Visualizations in Cognos BI with eBay Analytics

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

• Use the CData Software ODBC Driver for Veeva in MicroStrategy Web

  Connect to Veeva Vault in MicroStrategy Web using the CData Software ODBC Driver for Veeva.

• Integrate Google Calendar in Your Informatica Cloud Instance

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

• Connect to Zuora in Google Apps Script

  Use CData Connect Cloud to access Zuora in Google Apps Script.

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

• Automated Continuous CouchDB Replication to Amazon Redshift

  Use CData Sync for automated, continuous, customizable CouchDB replication to Amazon Redshift.

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

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

• Automated Oracle SCM Replication to Teradata

  Use CData Sync to Customize and automate Oracle SCM replication to Teradata.

• Connect to Amazon S3 in RapidMiner

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

• Build Zoho Projects-Connected Dashboards Using Zoho Analytics

  Use CData Connect Cloud to connect to Zoho Projects from Zoho Analytics and import live Zoho Projects.

• Connect to Azure Data Catalog from a Connection Pool in Jetty

  The Azure Data Catalog JDBC Driver supports connection pooling: This article shows how to connect faster to Azure Data Catalog from Web apps in Jetty.

• DocuSign Reporting in OBIEE with the DocuSign JDBC Driver

  Deploy the DocuSign JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• Build Dashboards with Redshift in Dundas BI

  Create dynamic dashboards and perform analytics based on Amazon Redshift in Dundas BI.

• Automated Continuous Facebook Ads Replication to Snowflake

  Use CData Sync for automated, continuous, customizable Facebook Ads replication to Snowflake.

• Import SingleStore into the Power BI Service for Visualizations

  Use CData Connect Cloud to connect to SingleStore and provide access to live SingleStore for custom reports in the Power BI Service.

• Publish Reports with Greenplum in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Pivotal GreenPlum.

• Automated Continuous Facebook Replication to Vertica

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

• Automated Continuous Marketo Replication to SingleStore

  Use CData Sync for automated, continuous, customizable Marketo replication to SingleStore.

• Create a Data Access Object for SFTP using JDBI

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

• Connect to Dynamics 365 Business Central from Crystal Reports

  Use CData Connect Cloud to connect to and report on live Dynamics 365 Business Central from Crystal Reports.

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

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

• Explore Geographical Relationships in Zendesk with Power Map

  Create data visualizations with Zendesk in Power Map.

• LINQ to MariaDB

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

• Create Basecamp-Connected Business Apps in AppSheet

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

• DataBind Cassandra to the DevExpress Data Grid

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

• Analyze BigQuery in R

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

• Use the CData ODBC Driver for Cosmos DB in SAS JMP

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

• How to connect and process Zenefits from Azure Databricks

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

• Design BIRT Reports on Raisers Edge NXT

  Provide current Raisers Edge NXT to your embedded analytics.

• How to connect and process eBay from Azure Databricks

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

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

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

• Connect to Microsoft Project in HULFT Integrate

  Connect to Microsoft Project as a JDBC data source in HULFT Integrate

• Connect to MySQL in Airbyte ELT Pipelines

  Use CData Connect Cloud to build ELT pipelines for MySQL in Airbyte.

• A PostgreSQL Interface for Zoho CRM

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

• Connect to Real-Time CouchDB Data in Power Apps Using Dataflows to Build Custom Applications

• «
• 93
• 94
• 95
• 96
• 97
• 98
• 99
• 100
• 101
• 102
• »