CData Software - Knowledge Base

Recent Articles

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

• Deploy the ADO.NET Provider for SAP Business One on an SSRS Report Server

  Connect to SAP Business One 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.

• Zoho Inventory Reporting and Star Schemas in OBIEE

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

• Visualize Live Google Campaign Manager 360 in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Google Campaign Manager 360.

• Build Salesloft Visualizations in Tableau Cloud

  Use CData Software Connect Server to create a virtual SQL Server Database for Salesloft and build visualizations in Tableau Cloud.

• How to Connect DBeaver to Oracle HCM Cloud via a JDBC Driver

  Manage Oracle HCM Cloud with visual tools in DBeaver like the query browser.

• Load Drip to a Database Using Embulk

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

• Access Paylocity as a Remote Oracle Database

  Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Paylocity from your Oracle system.

• Publish Reports with Shippo in SAP Crystal Reports

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

• How to create Confluence federated tables in MySQL

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

• How to integrate Metabase with Square

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

• Build a Simple VCL Application for CouchDB

  How to build a simple VCL Application to view Apache CouchDB in RAD Studio using the CData ODBC Driver for CouchDB.

• Create FHIR Dataflows on PowerBI.com

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

• Feed Kafka into FineReport

  How to set Apache Kafka as a JDBC data source in FineReport.

• DataBind ADP to the DevExpress Data Grid

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

• Create Data Visualizations Based On SAP ByDesign in Mode

  Use CData Connect Cloud to connect to SAP ByDesign from Mode and build visualizations using live

• DataBind Charts to Office 365

  Use the standard ADO.NET procedures for databinding to provide bidirectional access to Microsoft Office 365 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.

• Visualize AlloyDB in Tableau

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

• Excel Spreadsheet Automation with the QUERY Formula

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

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

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

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

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

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

• LDAP Reporting and Star Schemas in OBIEE

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

• Build an OLAP Cube in SSAS from OData Services

  Establish a connection to OData data from SQL Server Analysis Services, and use the OData Data Provider to build OLAP cubes for use in analytics and reporting.

• Automated Continuous Slack Replication to Vertica

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

• Integrate with Twitter in JReport Designer

  Create charts and reports based on Twitter in JReport Designer.

• Automated Continuous SAP SuccessFactors Replication to Apache Cassandra

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

• Connect to and Query Power BI XMLA in QlikView over ODBC

  Create data visualizations with Power BI XMLA in QlikView.

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

  Execute SQL Server queries against Splunk from Node.js.

• Build Visualizations of SQL Analysis Services in Birst

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

• Create Apps from ServiceNow in Qlik Sense Cloud

  Use CData Connect Cloud to connect to ServiceNow and build apps from live ServiceNow in Qlik Sense Cloud.

• Create Power BI XMLA Reports on JasperReports Server

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

• Prepare, Blend, and Analyze REST in Alteryx Designer

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

• Import MarkLogic into Microsoft Power Query

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

• Load Email to a Database Using Embulk

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

• Load Kintone to a Database Using Embulk

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

• How to create FTP federated tables in MySQL

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

• Connect to Databricks through External Services in Salesforce

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

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

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

• Connect to SAP HANA XS Advanced in Google Apps Script

  Use the ODBC Driver for SAP HANA XS Advanced and the SQL Gateway to access SAP HANA XS Advanced from Google Apps Script.

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

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

• Creating SQL Analysis Services-Connected Applications in Unqork

  You can use CData Connect to feed SQL Analysis Services to Unqork and build custom business apps.

• Connect to Airtable in Ruby

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

• Prepare, Blend, and Analyze MailChimp in Alteryx Designer

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

• Connect to Presto in CloverDX (formerly CloverETL)

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

• Connect to Sage Intacct from AWS Glue

  Use CData Connect Cloud to gain access to live Sage Intacct from your AWS Glue jobs.

• Query Access as a SQL Server in Node.js

  Execute SQL Server queries against Microsoft Access from Node.js.

• Create Dynamics 365 Dashboards in Bold BI

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

• How to create an RPA flow for Zoho Creator in UiPath Studio

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

• A PostgreSQL Interface for Snowflake

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

• Build Dashboards with Cassandra in DBxtra

  Create dynamic dashboards and perform analytics based on Apache Cassandra in DBxtra.

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

  Provide connectivity to IBM DB2 through an SAP BusinessObjects universe.

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

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

• Replicate Multiple Excel Online Accounts

  Replicate multiple Excel Online accounts to one or many databases.

• Import MariaDB into the Power BI Service for Visualizations

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

• How to import Freshdesk into Apache Solr

  Use the CData Software JDBC Driver for Freshdesk in Data Import Handler and create an automated import of Freshdesk to Apache Solr Enterprise Search platform.

• Query QuickBooks Online in DataGrip

  Create a Data Source for QuickBooks Online in DataGrip and use SQL to query live QuickBooks Online.

• Create Zoho Inventory Dataflows on PowerBI.com

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

• Automated Continuous Slack Replication to Amazon Redshift

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

• Query Zoho Inventory in ColdFusion

  Write standard ColdFusion data access code to connect to Zoho Inventory.

• Model, Search, and Visualize Live Bullhorn CRM in ThoughtSpot

  Use CData Connect Cloud to connect to live Bullhorn CRM for modeling, searching, and visualizing.

• Connect to Greenplum in NetBeans

  Connect to Pivotal GreenPlum in NetBeans with the data source configuration wizard.

• Build MVC Applications with Connectivity to Zoho Creator

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

• Visualize Live Twitter in the Power BI Service

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

• Build Shopify Visualizations in Tableau Desktop

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

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

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

• Visualize Twitter in TIBCO Spotfire through ODBC

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

• Connect to and Query Coinbase in QlikView over ODBC

  Create data visualizations with Coinbase in QlikView.

• A PostgreSQL Interface for Avalara AvaTax

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

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

• How to connect and process SAP SuccessFactors from Azure Databricks

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

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for Jira Service Management

  Provide connectivity to Atlassian Jira Service Management through an SAP BusinessObjects universe.

• Build Charts with QuickBooks in Clear Analytics

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

• Integrate Square with External Services using SnapLogic

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

• Feed HDFS into FineReport

  How to set Apache HDFS as a JDBC data source in FineReport.

• Replicate Drip from PowerShell

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

• Connect Cloud Guide: SSO (Single Sign-On) and User-Defined Credentials

  A basic guide to Connect Cloud features: Single Sign-On (SSO) and User-Defined Credentials

• Import Real-Time Amazon Athena in ColdFusion to Build Applications

  Use CData ODBC drivers to import and use Amazon Athena in ColdFusion.

• Connect to OData Services from Crystal Reports

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

• How to connect and process eBay Analytics from Azure Databricks

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

• Access Live Neo4J in Coginiti Pro

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

• Visualize BigCommerce in Sisense

  Create an ElastiCube in Sisense app with access to BigCommerce.

• Connect to Microsoft Teams from Asprova with CData Software ODBC Driver for Microsoft Teams

  This article shows how to connect faster to Microsoft Teams data from Asprova.

• Create Datasets from Email in Domo Workbench and Build Visualizations of Email in Domo

  Use the CData Software ODBC Driver for Email to create datasets from Email in Domo Workbench and then build visualizations in the Domo service.

• Automated Continuous Pipedrive Replication to IBM DB2

  Use CData Sync for automated, continuous, customizable Pipedrive replication to IBM DB2.

• Build Google Calendar-Connected Visualizations in datapine

  Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Google Calendar.

• Build Dashboards with LinkedIn Ads in DBxtra

  Create dynamic dashboards and perform analytics based on LinkedIn Ads in DBxtra.

• Connect to Azure Analysis Services in Aqua Data Studio

  Access Azure Analysis Services from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• Visualize Harvest in Sisense

  Create an ElastiCube in Sisense app with access to Harvest.

• Connect to OneNote in Ruby

  Connect to Microsoft OneNote in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

• Enable the HubDB JDBC Driver in KNIME

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

• Replicate Unbounce for Use in Salesforce Connect

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

• How to publish and share YouTube Analytics dashboards with Tableau Server

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

• How to connect to HCL Domino from MS Excel on Mac OS X

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

• Build Automated Workflows with Live OData Services in Workato

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

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

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

• Access Twitter Ads in PHP through Connect Server

  Connect to Twitter Ads through the standard SQL Server libraries in PHP.

• Manage Outreach.io in DBArtisan as a JDBC Source

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

• Access Smartsheet from MySQL in Amazon QuickSight

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

• Use the CData Software ODBC Driver for BambooHR in MicroStrategy

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

• Connect to Avalara AvaTax from a Connection Pool in WebLogic

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

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