CData Software - Knowledge Base

Recent Articles

• «
• 86
• 87
• 88
• 89
• 90
• 91
• 92
• 93
• 94
• 95
• »

• Automated Continuous MongoDB Replication to Apache Cassandra

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

• Visualize Live Aha in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Aha!.

• Build Tableau CRM Analytics Visualizations in Tableau Cloud

  Use CData Connect Cloud to connect to live Tableau CRM Analytics and build visualizations in Tableau Cloud.

• Use the CData Software ODBC Driver for Oracle SCM in MicroStrategy Desktop

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

• Connect to LinkedIn Ads from a Connection Pool in Jetty

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

• Prepare, Blend, and Analyze Acumatica in Alteryx Designer

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

• How to create Visio diagrams from PostgreSQL

  Automatically update PostgreSQL with the changes you make to Visio master shapes.

• Create Data Visualizations in Cognos BI with Oracle Service Cloud

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

• Create Data Visualizations in Cognos BI with Active Directory

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

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

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

• Load SAP Business One to a Database Using Embulk

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

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

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

• How to integrate Acumatica with Apache Airflow

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

• Viewing Instagram in RAD Studio Data Explorer

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

• Use CData Sync to Replicate NetSuite Data to Snowflake

  Use CData Sync to add NetSuite data to your Snowflake data warehouse.

• Visualize Zoho Inventory from Tableau

  Use the Tableau Desktop business intelligence tool to connect to Zoho Inventory.

• How to connect to Elasticsearch from Spring Boot

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

• Create Avro-Connected Visualizations in Klipfolio

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

• How to Access Amazon Athena Using Entity Framework

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

• Build Semantic Layer Views for Clio in APOS Live Data Gateway

  Use the CData Connector for Clio in APOS Live Data Gateway to build Semantic Layer Views for Clio.

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

• Visualize CockroachDB in TIBCO Spotfire through OData

  Integrate CockroachDB into dashboards in TIBCO Spotfire.

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

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

• Automated Continuous MariaDB Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable MariaDB replication to Amazon S3.

• Back Up Odoo ERP to SQL Server through SSIS

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

• Add JSON Services to Informatica Enterprise Data Catalog

  Use the CData Software JDBC Driver for JSON with the Informatica Enterprise Data Catalog to classify and organize data.

• Automate Phoenix Replication to Azure Synapse

  Use CData Sync to customize and automate Apache Phoenix replication to Azure Synapse.

• Automate Sage 200 Replication to SAP HANA

  Use CData Sync to customize and automate Sage 200 replication to SAP HANA.

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

  Connect to Exact Online from a connection pool in Tomcat.

• Manage LinkedIn Ads in DBArtisan as a JDBC Source

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

• Use Dash to Build to Web Apps on Drip

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

• Build MVC Applications with Connectivity to Twilio

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

• How to Connect the Power BI Service to Azure Table: Complete Guide

  Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.

• Integrate Avalara AvaTax in Your Informatica Cloud Instance

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

• How to create Visio diagrams from Oracle Service Cloud

  Automatically update Oracle Service Cloud with the changes you make to Visio master shapes.

• Excel Spreadsheet Automation with the QUERY Formula

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

• Connect to Twitter Ads in SpagoBI

  Create reports featuring live Twitter Ads in SpagoBI Studio. Host Twitter Ads reports on SpagoBI Server.

• Query Drip in MySQL Workbench

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

• Connect to QuickBooks Online from Crystal Reports

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

• Connect to SingleStore in DBeaver

  Use the CData ODBC Driver to connect to SingleStore in DBeaver.

• Build WordPress-Connected Dashboards Using Zoho Analytics

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

• How to connect to Google Cloud Storage from IntelliJ

  Integrate connectivity to Google Cloud Storage with wizards in IntelliJ.

• Feed Oracle HCM Cloud into FineReport

  How to set Oracle HCM Cloud as a JDBC data source in FineReport.

• Build Semantic Layer Views for Oracle in APOS Live Data Gateway

  Use the CData Connector for Oracle in APOS Live Data Gateway to build Semantic Layer Views for Oracle Database.

• Integrate with WooCommerce in JReport Designer

  Create charts and reports based on WooCommerce in JReport Designer.

• How to connect to Active Directory with Squirrel SQL client

  Connect to Active Directory and execute queries in the Squirrel SQL Client.

• Build Zoho Inventory-Connected Visualizations in datapine

  Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Zoho Inventory.

• Create Data Visualizations Based On Sage 200 in Mode

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

• Connect to Jira Service Management 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 Atlassian Jira Service Management.

• Build Pipelines with Live Outreach.io in Google Cloud Data Fusion (via CData Connect Cloud)

  Use CData Connect Cloud to connect to Outreach.io from Google Cloud Data Fusion, enabling the integration of live Outreach.io into the building and management of effective data pipelines.

• Build Visualizations of Airtable in Birst

  Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Airtable in Birst.

• Connect to Jira in CloverDX (formerly CloverETL)

  Transfer Atlassian Jira using the visual workflow in the CloverDX data integration tool.

• Connect to QuickBooks Time in Google Apps Script

  Use the ODBC Driver for QuickBooks Time and the SQL Gateway to access QuickBooks Time from Google Apps Script.

• How to Visualize Amazon DynamoDB Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Amazon DynamoDB in Python.

• Analyze Asana in Cognos Analytics

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

• Validate Drip with QuerySurge

  Access and validate Drip in QuerySurge using the CData JDBC Driver.

• Creating PayPal-Connected Applications in Unqork

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

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

  Connect to Clio from a connection pool in Tomcat.

• Prepare, Blend, and Analyze Dynamics 365 in Alteryx Designer

  Build workflows to access live Microsoft Dynamics 365 for self-service data analytics.

• Automated Continuous XML Replication to Apache Cassandra

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

• Build Acumatica-Connected Dashboards Using Zoho Analytics

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

• Export Data from SQL Server to PostgreSQL through SSIS

  Easily push SQL Server data to PostgreSQL using the CData SSIS Tasks for PostgreSQL.

• Connect to Redshift in DBArtisan

  Use wizards in DBArtisan to configure Amazon Redshift as a data source.

• Process & Analyze Airtable in Databricks (AWS)

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

• Adobe Analytics Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on Adobe Analytics facts in real time.

• Build Charts with MarkLogic in Clear Analytics

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

• A PostgreSQL Interface for Instagram

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

• Create Workday-Connected Business Apps in AppSheet

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

• Visualize Live Facebook in Tableau

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

• Connect to Calendly in DBArtisan

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

• Connect to Sage Cloud Accounting in CloverDX (formerly CloverETL)

  Transfer Sage Business Cloud Accounting using the visual workflow in the CloverDX data integration tool.

• Connect to Salesforce Marketing in HULFT Integrate

  Connect to Salesforce Marketing as a JDBC data source in HULFT Integrate

• How to create Epicor Kinetic federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for Epicor Kinetic in MySQL .

• Integrate BigCommerce with External Services using SnapLogic

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

• Automated Continuous Blackbaud FE NXT Replication to Microsoft Access

  Use CData Sync for automated, continuous, customizable Blackbaud FE NXT replication to Microsoft Access.

• Build Shippo-Connected Dashboards in Redash

  Use CData Software Connect Server to create a virtual SQL Server Database for Shippo and build visualizations and dashbaords from Shippo in Redash.

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

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

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

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

• Replicate JotForm from PowerShell

  Write a quick PowerShell script to query JotForm. Use connectivity to the live data to replicate JotForm to SQL Server.

• Visualize Live Raisers Edge NXT of Power BI Report Builder in Power BI Service

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

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

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

• Replicate Drift to Multiple Databases

  Replicate Drift to disparate databases with a single configuration.

• Analyze Cosmos DB in Cognos Analytics

  Use CData Connect Cloud to connect to Cosmos DB from Cognos Analytics and analyze live Azure Cosmos DB.

• Connect to Zoho Creator through External Services in Salesforce

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

• Analyze Adobe Analytics in Cognos Analytics

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

• Analyze MailChimp in Cognos Analytics

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

• Connect to SharePoint Excel Services in SpagoBI

  Create reports featuring live SharePoint Excel Services in SpagoBI Studio. Host SharePoint Excel Services reports on SpagoBI Server.

• Replicate Multiple REST Accounts

  Replicate multiple REST accounts to one or many databases.

• Automated Continuous Box Replication to Google BigQuery

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

• Replicate Microsoft Exchange to Multiple Databases

  Replicate Microsoft Exchange to disparate databases with a point-and-click configuration.

• Integrate with live Paylocity in Jitterbit

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

• Replicate Multiple HubSpot Accounts

  Replicate multiple HubSpot accounts to one or many databases.

• Integrate SAP HANA into Power Automate Desktop using CData Connect

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

• Access Live SAP SuccessFactors in Google Sheets

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

• Connect to Facebook 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 Facebook.

• How to Access Live SAP Fieldglass in Power Automate Desktop via ODBC

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

• Natively Connect to Instagram in PHP

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

• Query, Visualize, and Share live Quickbase in Redash

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

• Establish a Live Connection with Zoho CRM using Tableau Bridge

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

• How to use SQLAlchemy ORM to access IBM Cloud Object Storage in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of IBM Cloud Object Storage.

• «
• 86
• 87
• 88
• 89
• 90
• 91
• 92
• 93
• 94
• 95
• »