CData Software - Knowledge Base

Recent Articles

• «
• 185
• 186
• 187
• 188
• 189
• 190
• 191
• 192
• 193
• 194
• »

• Stream Zoom into Apache Kafka Topics

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

• Query TaxJar in MySQL Workbench

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

• Automated Continuous Unbounce Replication to SQLite

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

• DataBind Charts to Spark

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Apache Spark SQL 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.

• Work with Live Microsoft Exchange in Power Query

  Use CData Connect Cloud to connect to Microsoft Exchange and work with live Microsoft Exchange in Microsoft Power Query.

• Create MYOB AccountRight Dataflows on PowerBI.com

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

• Access eBay from MySQL in PHP

  Connect to eBay through the standard MySQL libraries in PHP.

• Add Sage 50 UK to Informatica Enterprise Data Catalog

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

• Visualize Wave Financial in Tableau

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

• Publish Crystal Reports on Phoenix

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

• Automated BigCommerce Replication to Teradata

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

• Use CData Connect Cloud to Access Azure Analysis Services in Microsoft Power Pivot

  Use CData Connect Cloud to connect to live Azure Analysis Services in the Power Pivot business intelligence tool.

• Choosing the Best Method to Connect Couchbase to SQL Server: 5 Options Explained

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

• Build OneNote Visualizations in Tableau Desktop

  Use CData Connect Cloud to connect to live Microsoft OneNote and build visualizations in Tableau.

• How to Access Reckon Accounts Hosted Using Entity Framework

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

• Author and Share Power BI Reports on Real-Time Twitter

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

• Build Dynamics 365 Business Central Visualizations in Tableau Desktop

  Use CData Connect Cloud to connect to live Dynamics 365 Business Central and build visualizations in Tableau.

• Build Dashboards with HCL Domino in DBxtra

  Create dynamic dashboards and perform analytics based on HCL Domino in DBxtra.

• Build Microsoft Project-Connected Apps in Mendix

  Use CData Connect Cloud to create an OData feed for Microsoft Project and create custom apps in Mendix.

• Write a Simple Go Application to work with Oracle SCM on Linux

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

• Use Dash to Build to Web Apps on SAP Netweaver Gateway

  Create Python applications that use pandas and Dash to build SAP Netweaver Gateway-connected web apps.

• Automated Continuous YouTube Analytics Replication to Vertica

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

• A PostgreSQL Interface for Sage 300

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

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

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

• Import ClickUp into Microsoft Power Query

  The CData Software Connect Server offers standards-based Web service endpoints that allow a variety of applications to access ClickUp. In this article, you will use the OData format to import ClickUp into Microsoft Power Query.

• Build Automated Workflows with Live Oracle Service Cloud in Workato

  Use CData Connect Cloud to connect to live Oracle Service Cloud and build automated workflows in Workato.

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

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

• How to connect to Microsoft Exchange in DBVisualizer

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

• ETL Oracle Service Cloud in Oracle Data Integrator

  This article shows how to transfer Oracle Service Cloud into a data warehouse using Oracle Data Integrator.

• How to connect to Google Data Catalog from MS Excel on Mac OS X

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

• Automate MongoDB Replication to Azure Data Lake

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

• Model Azure Table Using Azure Analysis Services

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

• How to connect to Jira from IntelliJ

  Integrate connectivity to Atlassian Jira with wizards in IntelliJ.

• Publish Reports with Zoho CRM in SAP Crystal Reports

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

• ETL Kafka in Oracle Data Integrator

  This article shows how to transfer Apache Kafka into a data warehouse using Oracle Data Integrator.

• Create Data Visualizations in Cognos BI with Avalara AvaTax

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

• Automated Continuous Google Directory Replication to AlloyDB

  Use CData Sync for automated, continuous, customizable Google Directory replication to AlloyDB.

• Automated Continuous Cosmos DB Replication to SQLite

  Use CData Sync for automated, continuous, customizable Cosmos DB replication to SQLite.

• Publish Reports with Act CRM in SAP Crystal Reports

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

• Automate Cloudant Replication to SAP HANA

  Use CData Sync to customize and automate IBM Cloudant replication to SAP HANA.

• LINQ to Facebook

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

• Replicate Multiple IBM Cloud Object Storage Accounts

  Replicate multiple IBM Cloud Object Storage accounts to one or many databases.

• How to pipe Odoo to CSV in PowerShell

  Use standard PowerShell cmdlets to access Odoo tables.

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

• Automated Continuous HBase Replication to Google BigQuery

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

• Integrate with Google Campaign Manager 360 in JReport Designer

  Create charts and reports based on Google Campaign Manager 360 in JReport Designer.

• Import PayPal into FileMaker Pro

  Create reports that integrate PayPal in Filemaker Pro.

• Create Amazon Athena Dataflows on PowerBI.com

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

• Build Quickbase-Connected Apps in Choreo

  Use CData Connect Cloud to connect to Quickbase from Choreo and build custom apps using live Quickbase.

• Author and Share Power BI Reports on Real-Time Printful

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

• Access Amazon S3 in PHP through Connect Server

  Connect to Amazon S3 through the standard SQL Server libraries in PHP.

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

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

• Prepare, Blend, and Analyze Oracle Service Cloud in Alteryx Designer

  Build workflows to access live Oracle Service Cloud for self-service data analytics.

• How to Use a Microsoft Access Database to Update Zendesk in Real Time

  Update Zendesk data by creating a linked table in Microsoft Access with the CData Zendesk ODBC Driver.

• A PostgreSQL Interface for Stripe

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

• Process & Analyze LDAP Objects in Databricks (AWS)

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

• Visualize Live Cosmos DB in Power BI (via CData Connect Cloud)

  Use the CData Power BI Connector and CData Connect Cloud to integrate live Azure Cosmos DB into custom reports in Power BI.

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

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

• Analyze Dynamics 365 Business Central in Looker

  Use CData Connect Cloud to connect to Dynamics 365 Business Central from Looker and build custom apps using live Dynamics 365 Business Central.

• Connect to Klaviyo from a Connection Pool in WebLogic

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

• Viewing Snowflake in RAD Studio Data Explorer

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

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

  Execute SQL Server queries against HubSpot from Node.js.

• How to connect PolyBase to Splunk

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

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

  Connect to Drift 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.

• Analyze Google Cloud Storage in Infragistics Reveal

  Use the CData Connect Server to create an OData API on top of Google Cloud Storage and visualize live Google Cloud Storage in Ingragistics Reveal.

• Connect to and Query GitHub in QlikView over ODBC

  Create data visualizations with GitHub in QlikView.

• Work with REST in FoxPro

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

• Author and Share Power BI Reports on Real-Time IBM Cloud Object Storage

  Use the CData ODBC Driver for IBM Cloud Object Storage to visualize IBM Cloud Object Storage in Power BI Desktop and then upload to the Power BI service.

• Automated Continuous MYOB AccountRight Replication to Azure SQL

  Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to Azure SQL.

• How to Connect to Epicor Kinetic in Using Python: 6 Steps

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

• Connect to Outreach.io as a Linked Server

  Use the SQL Gateway and the ODBC Driver to set up a linked server for Outreach.io.

• How to use SQLAlchemy ORM to access IBM Informix in Python

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

• How to Connect to & Open Procore in Microsoft Excel

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

• HubDB Reporting and Star Schemas in OBIEE

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

• Build Automated Google Analytics-Connected Workflows in Zapier

  Use CData Connect Cloud to connect to live Google Analytics and build automated workflows in Zapier.

• Connect to PayPal in NetBeans

  Connect to PayPal in NetBeans with the data source configuration wizard.

• Connect to SAP from a Connection Pool in JBoss

  Integrate SAP ERP/NetWeaver into Java servlets: Use the Management Console in JBoss to install the SAP JDBC Driver.

• Create SSAS Tabular Models from BigCommerce

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

• Connect to eBay Analytics in NetBeans

  Connect to eBay Analytics in NetBeans with the data source configuration wizard.

• Extract, Transform, and Load Printify in Informatica PowerCenter

  Create a simple Workflow for Printify in Informatica PowerCenter.

• Displaying Data from Related Tables Using Angular with the API Server

  Use the API Server and Angular to build a Web App to dynamically display related tables.

• Connect to Microsoft OneDrive in as an External Source in Dremio

  Use the CData JDBC Driver to connect to Microsoft OneDrive as an External Source in Dremio.

• Access NetSuite Saved Searches as Views

  You can use CData NetSuite Data Providers to access saved searches from third-party tools.

• How to Import Dynamics CRM into SQL Server using SSIS

  Easily back up Microsoft Dynamics CRM to SQL Server using the SSIS components for Dynamics CRM.

• FTP Reporting in OBIEE with the FTP JDBC Driver

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

• Connect to Amazon S3 in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• How to connect to Sage Intacct from MS Excel on Mac OS X

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

• Connect to Workday from PowerBuilder

  This article demonstrates how to access Workday from Appeon PowerBuilder using the CData ADO.NET Provider for Workday.

• How to pipe Drip to CSV in PowerShell

  Use standard PowerShell cmdlets to access Drip tables.

• Connect to IBM Cloud Object Storage from PowerBuilder

  This article demonstrates how to access IBM Cloud Object Storage from PowerBuilder using the IBM Cloud Object Storage JDBC Driver.

• Connect to Neo4J in NetBeans

  Connect to Neo4J in NetBeans with the data source configuration wizard.

• Connect to and Query Azure Analysis Services in QlikView over ODBC

  Create data visualizations with Azure Analysis Services in QlikView.

• Google Ads Reporting and Star Schemas in OBIEE

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

• Connect to and Query Airtable in QlikView over ODBC

  Create data visualizations with Airtable in QlikView.

• Build Sybase IQ-Connected Dashboards in Redash

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

• PowerShell Scripting to Replicate MongoDB to MySQL

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

• Visualize Google Directory in TIBCO Spotfire through ODBC

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

• Connect to Jira from PowerBuilder

  This article demonstrates how to use the CData ODBC Driver for Jira to connect to Atlassian Jira and execute queries in PowerBuilder.

• Import Real-Time Oracle Service Cloud in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use Oracle Service Cloud in ColdFusion.

• Connect to BigCommerce in HULFT Integrate

  Connect to BigCommerce as a JDBC data source in HULFT Integrate

• «
• 185
• 186
• 187
• 188
• 189
• 190
• 191
• 192
• 193
• 194
• »