CData Software - Knowledge Base

Recent Articles

• «
• 286
• 287
• 288
• 289
• 290
• 291
• 292
• 293
• 294
• 295
• »

• Author and Share Power BI Reports on Real-Time Exact Online

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

• How to Import Pipedrive into SQL Server using SSIS

  Easily back up Pipedrive to SQL Server using the SSIS components for Pipedrive.

• Using AngularJS to Build Dynamic Web Pages with Zendesk

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

• Automated Google Ad Manager Replication to Teradata

  Use CData Sync to Customize and automate Google Ad Manager replication to Teradata.

• How to connect to SingleStore from IntelliJ

  Integrate connectivity to SingleStore with wizards in IntelliJ.

• Access Bing Ads from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Bing Ads from HeidiSQL.

• Automate Google Analytics Replication to Couchbase

  Use CData Sync to Customize and automate Google Analytics replication to Couchbase.

• Publish Avalara AvaTax-Connected Dashboards in Tableau Server

  Use CData JDBC drivers and Tableau Server to visualize live Avalara AvaTax.

• Access Live CouchDB in TIBCO Data Virtualization

  Use the CData Software TIBCO DV Adapter for CouchDB to create a Apache CouchDB source in TIBCO Data Virtualization Studio and gain access to live Apache CouchDB from your TDV Server.

• Enable the Tally JDBC Driver in KNIME

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

• Integrate with Live Slack in MuleSoft (via CData Connect Cloud)

  Use CData Connect Cloud to connect to Slack from the MuleSoft Anypoint Platform to integrate live Slack into custom reports and dashboards.

• Operational Reporting on Google Ad Manager from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Google Ad Manager.

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

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

• How to use SQLAlchemy ORM to access WooCommerce in Python

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

• Connect to Oracle SCM from AWS Glue

  Use CData Connect Cloud to gain access to live Oracle SCM from your AWS Glue jobs.

• How to create an RPA flow for Oracle Sales in UiPath Studio

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

• Replicate Facebook Ads to Multiple Databases

  Replicate Facebook Ads to disparate databases with a single configuration.

• Import and Visualize MailChimp in Power View

  Create data visualizations based on MailChimp in Excel.

• Automated Continuous ShipStation Replication to Databricks

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

• Connect to Facebook Ads in the Denodo Platform

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

• Write a Simple Go Application to work with QuickBooks Time on Linux

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

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

• Access Live Box in AWS Lambda

  Connect to live Box in AWS Lambda using the CData JDBC Driver.

• Automate Couchbase Replication to Azure Synapse

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

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

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

• Connect to Shippo in DBeaver

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

• Connect to SAP HANA XS Advanced in SpagoBI

  Create reports featuring live SAP HANA XS Advanced in SpagoBI Studio. Host SAP HANA XS Advanced reports on SpagoBI Server.

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

• Use the CData Software ODBC Driver for Epicor Kinetic in MicroStrategy Desktop

  Connect to Epicor Kinetic in MicroStrategy Desktop using the CData Software ODBC Driver for Epicor Kinetic.

• Analyze Klipfolio with Power Pivot

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

• Create Dynamics CRM-Connected Nintex Workflows

  Use CData Connect Cloud to connect to Dynamics CRM from Nintex Workflow Cloud and build custom workflows using live Microsoft Dynamics CRM.

• Publish Google Directory-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Google Directory.

• Visualize Live Monday.com in the Power BI Service

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

• Access EnterpriseDB from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live EnterpriseDB from HeidiSQL.

• Choosing the Best Method to Connect Google Data Catalog to SQL Server: 5 Options Explained

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

• How to Visualize HBase Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Apache HBase in Python.

• Build Charts with MariaDB in Clear Analytics

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

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

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

• Operational Reporting on Pipedrive from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Pipedrive.

• Publish Reports with Klaviyo in SAP Crystal Reports

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

• Access Parquet in PHP through Connect Server

  Connect to Parquet through the standard SQL Server libraries in PHP.

• Access Live Stripe in AWS Lambda

  Connect to live Stripe in AWS Lambda using the CData JDBC Driver.

• Integrate Live Google Contacts into Amazon SageMaker Canvas with RDS

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

• Query, Visualize, and Share live Google Search Results in Redash

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

• Use CData Connect Cloud to Access Outreach.io in Microsoft Power Pivot

  Use CData Connect Cloud to connect to live Outreach.io in the Power Pivot business intelligence tool.

• Write a Simple Go Application to work with Jira Service Management on Linux

  Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Atlassian Jira Service Management.

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

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

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

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

• Build Automated Workflows with Live Cloudant in Workato

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

• Visualize Microsoft Planner in Sisense

  Create an ElastiCube in Sisense app with access to Microsoft Planner.

• Build LinkedIn Ads-Connected Apps in Choreo

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

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

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

• Integrate Live Active Directory into Amazon SageMaker Canvas with RDS

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

• Access Confluence in PHP through Connect Server

  Connect to Confluence through the standard SQL Server libraries in PHP.

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for SuiteCRM

  Provide connectivity to SuiteCRM through an SAP BusinessObjects universe.

• Connect to Airtable in DBeaver

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

• HBase Reporting in OBIEE with the HBase JDBC Driver

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

• Connect to Tally from PowerBuilder

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

• Build Apps with Live Instagram in Adalo using CData Connect Cloud

  Use CData Connect Cloud to integrate live Instagram into the Adalo platform and build custom mobile and web applications with real-time Instagram.

• Using AngularJS to Build Dynamic Web Pages with Jira

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

• Create SSAS Tabular Models from Freshdesk

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

• How to connect PolyBase to Salesforce

  Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Salesforce & Force.com.

• Create Cloudant-Connected Business Apps in AppSheet

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

• Analyze Google Campaign Manager 360 in R

  Use standard R functions and the development environment of your choice to analyze Google Campaign Manager 360 with the CData JDBC Driver for Google Campaign Manager 360.

• Visualize Live Sybase IQ in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Sybase IQ.

• Validate Epicor Kinetic with QuerySurge

  Access and validate Epicor Kinetic in QuerySurge using the CData JDBC Driver.

• How to publish and share SQL Server dashboards with Tableau Server

  The CData ODBC driver for SQL Server enables you integrate Microsoft SQL Server into Tableau dashboards.

• DataBind SendGrid to the DevExpress Data Grid

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

• Excel Spreadsheet Automation with the QUERY Formula

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

• Build Epicor Kinetic-Connected Web Apps with Axios and CData Connect Cloud

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

• Connect to YouTube Analytics in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Publish Reports with Zoho Books in SAP Crystal Reports

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

• Automated Continuous SAP Replication to Vertica

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

• Access Live Snowflake in AWS Lambda

  Connect to live Snowflake in AWS Lambda using the CData JDBC Driver.

• Create SSAS Tabular Models from Xero

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

• Publish SAP Business One-Connected Dashboards in Tableau Server

  Use CData JDBC drivers and Tableau Server to visualize live SAP Business One.

• How to create an RPA flow for Sage Intacct in UiPath Studio

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

• How to Connect to & Open Smartsheet in Microsoft Excel

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

• How to Build Dynamic React Apps with Harvest

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

• DataBind Controls to Snowflake in Delphi

  DataBind to Snowflake in Delphi with standard data access components and controls.

• How to connect PolyBase to Bullhorn CRM

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

• Operational Reporting on OneNote from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote Microsoft OneNote.

• How to Visualize Veeva Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Veeva Vault in Python.

• Query ServiceNow as a MySQL Database in Node.js

  Execute MySQL queries against ServiceNow from Node.js.

• Analyze Salesforce Pardot with Power Pivot

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

• Build Active Directory-Connected Apps in Mendix

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

• Connect to HubDB in RapidMiner

  Integrate HubDB with standard components and data source configuration wizards in RapidMiner Studio.

• Connect to and Query Microsoft Project in QlikView over ODBC

  Create data visualizations with Microsoft Project in QlikView.

• How to connect to EventBrite from IntelliJ

  Integrate connectivity to Eventbrite with wizards in IntelliJ.

• How to Query Pinterest in MySQL Workbench

  Execute MySQL queries against live Pinterest from MySQL Workbench.

• Access Live Office 365 in AWS Lambda (with IntelliJ IDEA)

  Connect to live Microsoft Office 365 in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

• Create a Data Access Object for Shopify using JDBI

  A brief overview of creating a SQL Object API for Shopify in JDBI.

• Automated Continuous Unbounce Replication to Amazon Redshift

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

• How to Connect DBeaver to Dynamics 365 Business Central via a JDBC Driver

  Manage Dynamics 365 Business Central with visual tools in DBeaver like the query browser.

• Use the CData Software ODBC Driver for FHIR in MicroStrategy

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

• Query Shippo in DataGrip

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

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

  Create ETL applications and real-time data pipelines for Apache HDFS in Python with petl.

• Replicate Basecamp to Multiple Databases

  Replicate Basecamp to disparate databases with a single configuration.

• Automated Continuous Elasticsearch Replication to PostgreSQL

  Use CData Sync for automated, continuous, customizable Elasticsearch replication to PostgreSQL.

• Access Live Dynamics CRM in Coginiti Pro

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

• «
• 286
• 287
• 288
• 289
• 290
• 291
• 292
• 293
• 294
• 295
• »