CData Software - Knowledge Base

Recent Articles

• «
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• 46
• »

• Create Informatica Mappings From/To an ODBC Data Source for PostgreSQL

  Create an ODBC connection to PostgreSQL in Informatica and browse and transfer PostgreSQL.

• Enable the Gmail JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with Gmail.

• How to Connect DBeaver to Okta via a JDBC Driver

  Manage Okta with visual tools in DBeaver like the query browser.

• How to Access Live Oracle Service Cloud in Power Automate Desktop via ODBC

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

• Work with Bing Search Results in FoxPro

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

• Visualize SQL Server in TIBCO Spotfire through OData

  Integrate Microsoft SQL Server into dashboards in TIBCO Spotfire.

• Build MVC Applications with Connectivity to Stripe

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

• Author and Share Power BI Reports on Real-Time Epicor Kinetic

  Use the CData ODBC Driver for Epicor Kinetic to visualize Epicor Kinetic in Power BI Desktop and then upload to the Power BI service.

• Connect to Cloudant in RazorSQL

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

• Connect to Oracle in Google Apps Script

  Use the ODBC Driver for Oracle and the SQL Gateway to access Oracle Database from Google Apps Script.

• How to Connect the Power BI Service to Zoho Books: Complete Guide

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

• Connect to Marketo in HULFT Integrate

  Connect to Marketo as a JDBC data source in HULFT Integrate

• Integrate with Zendesk in JReport Designer

  Create charts and reports based on Zendesk in JReport Designer.

• How to Build Dynamic React Apps with Power BI XMLA

  Use the CData Connect and React to Build Dynamic Web Apps with Live Power BI XMLA .

• Write a Simple Go Application to work with Act-On on Linux

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

• Integrate with ServiceNow in JReport Designer

  Create charts and reports based on ServiceNow in JReport Designer.

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

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

• Excel Spreadsheet Automation with the QUERY Formula

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

• Integrate Jira Service Management in the Pentaho Report Designer

  Publish reports based on Atlassian Jira Service Management in the Pentaho BI tool.

• Build RSS-Connected Web Apps in Servoy

  Use Servoy Developer to easily connect to RSS Feeds and build web apps with connectivity to live RSS Feeds.

• How to Connect to Zoho Books in Using Python: 6 Steps

  Create Python applications on Linux/UNIX machines with connectivity to Zoho Books. Leverage the pyodbc module for ODBC in Python.

• Bidirectional Access to Google Ad Manager from FileMaker Pro

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

• How to work with Freshdesk in Apache Spark using SQL

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

• How to connect PolyBase to MarkLogic

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

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

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

• Automated Continuous Calendly Replication to Apache Kafka

  Use CData Sync for automated, continuous, customizable Calendly replication to Apache Kafka.

• Integrate SAP Netweaver Gateway into Automated Tasks with Power Automate

  Use CData Software Connect Server to create a virtual SQL Server database for SAP Netweaver Gateway and integrate live SAP Netweaver Gateway into your Power Automate (Microsoft Flow) tasks.

• Replicate Multiple LDAP Accounts

  Replicate multiple LDAP accounts to one or many databases.

• Analyze Amazon Marketplace with Power Pivot

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

• How to Work with Stripe in AWS Glue Jobs Using JDBC

  Connect to Stripe from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

• Import and Visualize Coinbase in Power View

  Create data visualizations based on Coinbase in Excel.

• Automated Continuous Zoho Creator Replication to Apache Cassandra

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

• Access Reckon Accounts Hosted as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Reckon Accounts Hosted from your Oracle system.

• How to load SQL Server data into Elasticsearch via Logstash

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

• Query Reckon Accounts Hosted as a SQL Server in Node.js

  Execute SQL Server queries against Reckon Accounts Hosted from Node.js.

• How to Build Dynamic React Apps with JotForm

  Use the CData Connect and React to Build Dynamic Web Apps with Live JotForm .

• Use Dash to Build to Web Apps on Zendesk

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

• Visualize SFTP in TIBCO Spotfire through OData

  Integrate SFTP into dashboards in TIBCO Spotfire.

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

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

• Replicate Typeform from PowerShell

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

• Create Gmail Dataflows on PowerBI.com

  Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.

• Access Live SAP HANA in AWS Lambda (with IntelliJ IDEA)

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

• Replicate Acumatica for Use in Salesforce Connect

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

• Enable the SAP SuccessFactors JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with SAP SuccessFactors.

• Using AngularJS to Build Dynamic Web Pages with ActiveCampaign

  Use the CData Connect Server to create ActiveCampaign OData feeds and build single-page applications with live ActiveCampaign.

• Publish Crystal Reports on Elasticsearch

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

• Connect to Zenefits in SpagoBI

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

• Create IBM Informix-Connected Business Apps in AppSheet

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

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

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

• Integrate Live DocuSign into Custom Business Apps Built in Power Apps

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

• How to Use CData Connect to Access Live TaxJar in Power Automate

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

• Connect to Spark in JRuby

  Create a simple JRuby app with access to live Apache Spark SQL.

• Analyze Oracle Sales in SAP Analytics Cloud

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

• Feed MariaDB into FineReport

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

• How to connect and process Odoo from Azure Databricks

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

• Create Xero Reports on JasperReports Server

  Deploy the CData JDBC Driver on JasperReports Server to provide real-time Xero data access from reports, embedded analytics, and more.

• Use the CData Software ODBC Driver for CockroachDB in MicroStrategy

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

• A PostgreSQL Interface for Spark

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

• How to Use a Microsoft Access Database to Update Google Campaign Manager 360 in Real Time

  Update Google Campaign Manager 360 data by creating a linked table in Microsoft Access with the CData Google Campaign Manager 360 ODBC Driver.

• Connect to Epicor Kinetic from HeidiSQL

  Use CData Connect Cloud to connect to and query live Epicor Kinetic from HeidiSQL.

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

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

• Basecamp Reporting in OBIEE with the Basecamp JDBC Driver

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

• Connect to LinkedIn as a SQL Server Linked Server

  Use CData Connect Cloud to create a linked server for live LinkedIn.

• How to Access Sybase Using Entity Framework

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

• Deploy the ADO.NET Provider for Office 365 on an SSRS Report Server

  Connect to Microsoft Office 365 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.

• Automated Continuous Phoenix Replication to Databricks

  Use CData Sync for automated, continuous, customizable Phoenix replication to Databricks.

• Visualize Bing Ads in Tableau

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

• A PostgreSQL Interface for SAP Business One

  Use the Remoting features of the SAP Business One ODBC Driver to create a PostgreSQL entry-point for data access.

• How to Build Dynamic React Apps with GraphQL

  Use the CData Connect and React to Build Dynamic Web Apps with Live GraphQL .

• PowerShell Scripting to Replicate Klipfolio to MySQL

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

• Create Sage Intacct Dataflows on PowerBI.com

  Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.

• How to Connect to & Open TigerGraph in Microsoft Excel

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

• Add Sage Cloud Accounting to Informatica Enterprise Data Catalog

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

• Viewing Sage Intacct in RAD Studio Data Explorer

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

• Analyze HarperDB in R

  Create data visualizations and use high-performance statistical functions to analyze HarperDB in Microsoft R Open.

• DataBind Charts to Dynamics 365 Business Central

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Dynamics 365 Business Central from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.

• Create Parquet Reports on JasperReports Server

  Deploy the CData JDBC Driver on JasperReports Server to provide real-time Parquet data access from reports, embedded analytics, and more.

• Connect to SAP Concur from a Connection Pool in WebLogic

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

• How to connect to IBM Cloud Object Storage in DBVisualizer

  Integrate IBM Cloud Object Storage with visual data analysis tools and data connection wizards in DBVisualizer

• Create Informatica Mappings From/To an ODBC Data Source for PayPal

  Create an ODBC connection to PayPal in Informatica and browse and transfer PayPal.

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

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

  Connect to HubDB from a connection pool in Tomcat.

• Automated Continuous Dynamics CRM Replication to MongoDB

  Use CData Sync for automated, continuous, customizable Dynamics CRM replication to MongoDB.

• Connect to SAP Fieldglass in Ruby

  Connect to SAP Fieldglass in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

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

  Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for BigCommerce.

• Automated Continuous SAP HANA Replication to Vertica

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

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

• Connect to LinkedIn in SpagoBI

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

• Automate Impala Replication to Azure Synapse

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

• Use JayDeBeApi to access Zoho Creator in Python

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

• Access QuickBooks Online 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 QuickBooks Online.

• Integrate Azure Table in the Pentaho Report Designer

  Publish reports based on Azure Table Storage in the Pentaho BI tool.

• Build Monday.com-Connected Visualizations in datapine

  Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Monday.com.

• Google Drive Reporting and Star Schemas in OBIEE

  Create a star schema that shows perspectives on Google Drive facts in real time.

• Create SendGrid Reports on JasperReports Server

  Deploy the CData JDBC Driver on JasperReports Server to provide real-time SendGrid data access from reports, embedded analytics, and more.

• How to load GraphQL data into Elasticsearch via Logstash

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

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

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

• Use the CData Software ODBC Driver for Klipfolio in MicroStrategy

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

• Model FHIR Using Azure Analysis Services

  Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and FHIR, enabling the direct import of real-time FHIR.

• Replicate TaxJar for Use in Salesforce Connect

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

• «
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• 46
• »