CData Software - Knowledge Base

Recent Articles

• «
• 189
• 190
• 191
• 192
• 193
• 194
• 195
• 196
• 197
• 198
• »

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

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

• Deploy the ADO.NET Provider for Reckon Accounts Hosted on an SSRS Report Server

  Connect to Reckon Accounts Hosted from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

• Automate ClickUp Replication to Azure Synapse

  Use CData Sync to customize and automate ClickUp replication to Azure Synapse.

• Build Pipelines with Live Bullhorn CRM in Google Cloud Data Fusion (via CData Connect Cloud)

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

• Use JayDeBeApi to access Teradata in Python

  Use standard Python scripting and the development environment of your choice to access live Teradata.

• Automated IBM Cloud Object Storage Replication to Teradata

  Use CData Sync to Customize and automate IBM Cloud Object Storage replication to Teradata.

• Automated Continuous Power BI XMLA Replication to Amazon Redshift

  Use CData Sync for automated, continuous, customizable Power BI XMLA replication to Amazon Redshift.

• A PostgreSQL Interface for Typeform using the CData ODBC Driver

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

• Publish Reports with Databricks in SAP Crystal Reports

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

• Connect to Live Power BI XMLA in MicroStrategy through CData Connect Cloud

  Create a live connection to Power BI XMLA in CData Connect Cloud and connect to your Power BI XMLA from MicroStrategy.

• Automated Continuous Avalara AvaTax Replication to SQL Server

  Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to SQL Server.

• A PostgreSQL Interface for GitHub using the CData ODBC Driver

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

• Connect to Presto from a Connection Pool in WebLogic

  Use the CData JDBC Driver for Presto to connect to Presto from Web applications running on WebLogic.

• Connect to API from Filemaker Pro (Mac)

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

• Build Dashboards with SAP HANA in Dundas BI

  Create dynamic dashboards and perform analytics based on SAP HANA in Dundas BI.

• Integrate with Sage 300 in JReport Designer

  Create charts and reports based on Sage 300 in JReport Designer.

• Build Dashboards with Neo4J in DBxtra

  Create dynamic dashboards and perform analytics based on Neo4J in DBxtra.

• How to connect and process SurveyMonkey from Azure Databricks

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

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

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

• Use the CData ODBC Driver for ServiceNow from SharePoint Excel Services

  This article demonstrates how to use the CData ODBC Driver for ServiceNow to connect to ServiceNow from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring ServiceNow in Excel.

• Back Up Certinia to SQL Server through SSIS

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

• Automated Continuous Sage 200 Replication to SQLite

  Use CData Sync for automated, continuous, customizable Sage 200 replication to SQLite.

• How to connect to SQL Server with Squirrel SQL client

  Connect to Microsoft SQL Server and execute queries in the Squirrel SQL Client.

• Manage SAP Netweaver Gateway in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for SAP Netweaver Gateway.

• How to update Odoo from Excel

  This article explains how to transfer data from Excel to Odoo using the Excel Add-In for Odoo.

• Import Salesforce into the Power BI Service for Visualizations

  Use CData Connect Cloud to connect to Salesforce and provide access to live Salesforce & Force.com for custom reports in the Power BI Service.

• Perform Batch Operations with Elasticsearch in Apache NiFi

  Connect to Elasticsearch and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

• Integrate Live Sage 200 into Amazon SageMaker Canvas with RDS

  Use CData Connect Cloud to connect to Sage 200 from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Sage 200.

• Integrate with Avalara AvaTax in SnapLogic

  Use CData Connect Cloud to connect to and integrate with live Avalara AvaTax in SnapLogic.

• How to connect to Bullhorn CRM from MS Excel on Mac OS X

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

• Automate DB2 Replication to Azure Data Lake

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

• Replicate Oracle Financials Cloud to Multiple Databases

  Replicate Oracle Financials Cloud to disparate databases with a point-and-click configuration.

• Connect to SAS xpt in NetBeans

  Connect to SAS XPORT in NetBeans with the data source configuration wizard.

• Connect to MailChimp in CloverDX (formerly CloverETL)

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

• SAP Fieldglass Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on SAP Fieldglass facts in real time.

• Create Azure Analysis Services-Connected Business Apps in AppSheet

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

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

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

• Stream Google Analytics into Apache Kafka Topics

  Access and stream Google Analytics in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• PowerShell Scripting to Replicate Gmail to MySQL

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

• How to use SQLAlchemy ORM to access Zenefits in Python

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

• Connect to Zuora from a Connection Pool in JBoss

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

• Connect to and Query Azure Active Directory in QlikView over ODBC

  Create data visualizations with Azure Active Directory in QlikView.

• Build Dashboards with Drift in Dundas BI

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

• Prepare, Blend, and Analyze Microsoft Teams in Alteryx Designer (Connect Cloud)

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

• Import and Visualize SurveyMonkey in Power View

  Create data visualizations based on SurveyMonkey in Excel.

• Analyze DB2 with Power Pivot

  This article walks you through the process of using the CData ODBC Driver for DB2 from Power Pivot. You will use the Table Import Wizard to load IBM DB2. You can visually build the import query or use any SQL supported by the driver.

• Query SAS xpt through ODBC in Node.js

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

• Automated Continuous DocuSign Replication to Google Cloud SQL

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

• How to Connect the Power BI Service to Databricks: Complete Guide

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

• Build Automated Workflows with Live Google Drive in Workato

  Use CData Connect Cloud to connect to live Google Drive and build automated workflows in Workato.

• Import Avro into the Power BI Service for Visualizations

  Use CData Software Connect Server to create an OData feed for Avro and create custom reports in the Power BI Service.

• Access OneNote from MySQL in Amazon QuickSight

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

• Automated Continuous Redis Replication to SQL Server

  Use CData Sync for automated, continuous, customizable Redis replication to SQL Server.

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

  Provide connectivity to Paylocity through an SAP BusinessObjects universe.

• Automated Continuous Box Replication to Amazon S3

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

• How to connect to Google Spanner from Spring Boot

  Connect to Google Spanner in a Spring Boot Application using CData JDBC Google Spanner Driver

• Connect to CouchDB in the Denodo Platform

  Use CData driver technologies to create a virtual data source for Apache CouchDB in the Denodo Virtual DataPort Administrator.

• Build Data Flows from Google Campaign Manager 360 to SQL Server using SSIS

  Easily back up Google Campaign Manager 360 to SQL Server using the SSIS components for Google Campaign Manager 360.

• Create SSAS Tabular Models from Google Directory

  How to build a SQL Server Analysis Service Tabular Model from Google Directory using CData drivers.

• Visualize Live MySQL in the Power BI Service

  Use CData Connect Cloud to connect to live MySQL and create custom reports in the Power BI Service through the On-Premises Gateway.

• Connect to Veeva Vault in the Denodo Platform

  Use CData driver technologies to create a virtual data source for Veeva Vault & Vault CRM in the Denodo Virtual DataPort Administrator.

• Visualize Salesforce Marketing in TIBCO Spotfire through ADO.NET

  Integrate Salesforce Marketing Cloud into dashboards in TIBCO Spotfire.

• How to create HubDB federated tables in MySQL

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

• PowerShell Scripting to Replicate Salesforce Data Cloud to MySQL

  Write a simple PowerShell script to replicate Salesforce Data Cloud to a MySQL database.

• Build Semantic Layer Views for eBay Analytics in APOS Live Data Gateway

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

• Neo4J Reporting in OBIEE with the Neo4J JDBC Driver

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

• Create Asana-Connected Visualizations in Klipfolio

  Use CData Connect Cloud to connect to Asana from Klipfolio and build custom visualizations using live Asana.

• Build MVC Applications with Connectivity to Databricks

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

• DataBind Cloudant to the DevExpress Data Grid

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

• How to connect to CSV with Squirrel SQL client

  Connect to CSV/TSV Files and execute queries in the Squirrel SQL Client.

• Connect to Printful from a Connection Pool in JBoss

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

• Build Visualizations of Trello in Birst

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

• Import Microsoft OneDrive into the Power BI Service for Visualizations

  Use CData Software Connect Server to create an OData feed for Microsoft OneDrive and create custom reports in the Power BI Service.

• Build Visualizations of AlloyDB in Birst

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

• Connect to JDBC-ODBC Bridge from a Connection Pool in Jetty

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

• Visualize Live TigerGraph in Tableau

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

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

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

• Connect to Cloudant in Ruby

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

• How to use SQLAlchemy ORM to access Neo4J in Python

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

• Publish Crystal Reports on Excel Online

  Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Microsoft Excel Online.

• How to integrate Metabase with GitHub

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

• Query Azure Synapse as a SQL Server Database in Node.js

  Execute SQL Server queries against Azure Synapse from Node.js.

• Build SAP ByDesign-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to SAP Business ByDesign and build web apps with connectivity to live SAP Business ByDesign.

• How to create an RPA flow for Raisers Edge NXT in UiPath Studio

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

• Connect to IBM Cloud Data Engine in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Feed Dynamics GP into FineReport

  How to set Microsoft Dynamics GP as a JDBC data source in FineReport.

• Automate Amazon DynamoDB Replication to Couchbase

  Use CData Sync to Customize and automate Amazon DynamoDB replication to Couchbase.

• Access Live Amazon Athena in Coginiti Pro

  Connect to and query live Amazon Athena from the GUI in the Coginiti Pro: SQL Analytics Tool.

• Connect to CockroachDB in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Connect to Dynamics CRM in RunMyProcess through Connect Cloud

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

• Create Reports with Google Spanner in SAP Crystal Reports

  Use the Report Wizard to design a report based on up-to-date Google Spanner.

• Create CockroachDB Dashboards in Bold BI

  Use CData Software Connect Server to create a virtual SQL Server Database for CockroachDB to build custom dashboards in Bold BI.

• Automated Continuous SharePoint Replication to Google Cloud SQL

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

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

• Use the CData ODBC Driver for Snowflake in Microsoft Power Query

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

• Use Biml to Build SSIS Tasks to Replicate Amazon Athena to SQL Server

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

• Replicate Active Directory for Use in Salesforce Connect

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

• Automated Continuous Unbounce Replication to Oracle

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

• Build ActiveCampaign-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live ActiveCampaign.

• ETL Google Sheets in Oracle Data Integrator

  This article shows how to transfer Google Sheets into a data warehouse using Oracle Data Integrator.

• «
• 189
• 190
• 191
• 192
• 193
• 194
• 195
• 196
• 197
• 198
• »