CData Software - Knowledge Base

Recent Articles

• «
• 221
• 222
• 223
• 224
• 225
• 226
• 227
• 228
• 229
• 230
• »

• Connect to YouTube Analytics in DBArtisan

  Use wizards in DBArtisan to configure YouTube Analytics as a data source.

• Access Live SQL Analysis Services in Coginiti Pro

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

• Automated Continuous Oracle SCM Replication to IBM DB2

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

• Natively Connect to Workday in PHP

  Create PHP applications on Linux/UNIX machines with connectivity to Workday. Leverage the native support for ODBC in PHP.

• Connect to Salesforce from PowerBuilder

  This article demonstrates how to use the CData ODBC Driver for Salesforce to connect to Salesforce & Force.com and execute queries in PowerBuilder.

• How to Work with Sybase in ETL Validator JDBC

  Connect to Sybase from ETL Validator jobs using the CData Software JDBC Driver.

• Connect to Dynamics 365 Business Central in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• Connect to Live MongoDB in PostGresSQL Interface through CData Connect Cloud

  Create a live connection to MongoDB in CData Connect Cloud and connect to your MongoDB from PostgreSQL.

• Automated Continuous SAP BusinessObjects BI Replication to Google BigQuery

  Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to Google BigQuery.

• Process & Analyze NetSuite in Databricks (AWS)

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

• How to Create Power BI Visual Reports with Real-Time Monday.com

  Use CData Power BI Connectors to visualize Monday.com in Power BI.

• Feed Tableau CRM Analytics into FineReport

  How to set Tableau CRM Analytics as a JDBC data source in FineReport.

• LINQ to SAP Concur

  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 SAP Concur Data Provider.

• Connect to Exact Online in Google Apps Script

  Use the ODBC Driver for Exact Online and the SQL Gateway to access Exact Online from Google Apps Script.

• Use Dash to Build to Web Apps on SAP Fieldglass

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

• Integrate Real-Time Access to Splunk in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Splunk in real time.

• Connect to Zoom from PowerBuilder

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

• Build Dashboards with Xero in Dundas BI

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

• Model, Search, and Visualize Live LinkedIn Ads in ThoughtSpot

  Use CData Connect Cloud to connect to live LinkedIn Ads for modeling, searching, and visualizing.

• Use JayDeBeApi to access Authorize.Net in Python

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

• How to use SQLAlchemy ORM to access SAP SuccessFactors in Python

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

• Connect to Excel Online from AWS Glue

  Use CData Connect Cloud to gain access to live Microsoft Excel Online from your AWS Glue jobs.

• Query Kafka in DataGrip

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

• Manage QuickBooks Online in DBArtisan as a JDBC Source

  Use wizards in DBArtisan to create a JDBC data source for QuickBooks Online.

• Create Apps from Oracle SCM in Qlik Sense Cloud

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

• Connect to GitHub in Airbyte ELT Pipelines

  Use CData Connect Cloud to build ELT pipelines for GitHub in Airbyte.

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

  Connect to Reckon from a connection pool in Tomcat.

• Automated Continuous Drip Replication to SQLite

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

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

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

• Access Live Odoo in Excel (Desktop)

  Use CData Connect Cloud to gain access to live Odoo ERP from your Excel spreadsheets.

• Connect to Clio in RunMyProcess through Connect Server

  Use CData Connect Server to create an OData API for Clio and connect to Clio in Akorbi Digital RunMyProcess.

• Access MarkLogic from MySQL in PHP

  Connect to MarkLogic through the standard MySQL libraries in PHP.

• Automated Continuous SingleStore Replication to SQL Server

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

• Automated Continuous xBase Replication to Amazon S3

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

• Create Data Visualizations in Cognos BI with YouTube Analytics

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

• Connect to SQL Analysis Services from Asprova with CData Software ODBC Driver for SQL Analysis Services

  This article shows how to connect faster to SQL Analysis Services data from Asprova.

• Automated Continuous eBay Analytics Replication to Apache Cassandra

  Use CData Sync for automated, continuous, customizable eBay Analytics replication to Apache Cassandra.

• How to integrate Metabase with Zoho Creator

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

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

• Use Biml to Build SSIS Tasks to Replicate Bing Ads to SQL Server

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

• Replicate Multiple Sage 200 Accounts

  Replicate multiple Sage 200 accounts to one or many databases.

• Automated Continuous SAP Ariba Source Replication to Vertica

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

• Automated Continuous OData Replication to PostgreSQL

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

• Build an OLAP Cube in SSAS from Google Data Catalog

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

• How to Work with SAS xpt in AWS Glue Jobs Using JDBC

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

• Create SAP BusinessObjects BI-Connected Nintex Workflows

  Use CData Software Connect Server to connect to SAP BusinessObjects BI from Nintex Workflow Cloud and build custom workflows using live SAP BusinessObjects BI.

• Build SendGrid-Connected Dashboards Using Zoho Analytics

  Use CData Connect Cloud to connect to SendGrid from Zoho Analytics and import live SendGrid.

• Prepare, Blend, and Analyze QuickBooks Online in Alteryx Designer

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

• Query Twilio as a MySQL Database in Node.js

  Execute MySQL queries against Twilio from Node.js.

• Automated Continuous ActiveCampaign Replication to Vertica

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

• Automated Continuous ADP Replication to Azure SQL

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

• Integrate CouchDB with External Services using SnapLogic

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

• Access Live Gmail in AWS Lambda

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

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

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

• A PostgreSQL Interface for Sugar CRM

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

• How to Access Microsoft Project Using Entity Framework

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

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

• How to Query Google Campaign Manager 360 in MySQL Workbench

  Execute MySQL queries against live Google Campaign Manager 360 from MySQL Workbench.

• Explore Geographical Relationships in SharePoint with Power Map

  Create data visualizations with Microsoft SharePoint in Power Map.

• Publish Sage 300-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Sage 300.

• Create SAP Business One Reports on JasperReports Server

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

• Replicate Zuora from PowerShell

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

• Import Splunk Using Azure Data Factory

  Use CData Connect Cloud to connect to Splunk from Azure Data Factory and import live Splunk.

• Build Apps with Live Slack Using the Low-Code Development Platform of Mendix

• «
• 221
• 222
• 223
• 224
• 225
• 226
• 227
• 228
• 229
• 230
• »