CData Software - Knowledge Base

Recent Articles

• «
• 157
• 158
• 159
• 160
• 161
• 162
• 163
• 164
• 165
• 166
• »

• Build MVC Applications with Connectivity to Bitbucket

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

• How to Import Azure DevOps into SQL Server using SSIS

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

• Connect to Parquet in DBArtisan

  Use wizards in DBArtisan to configure Apache Parquet as a data source.

• Publish Reports with Typeform in SAP Crystal Reports

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

• Create Data Visualizations Based On Excel Online in Mode

  Use CData Connect Cloud to connect to Excel Online from Mode and build visualizations using live

• Connect to Google Search Results from PowerBuilder

  This article demonstrates how to access Google Search from PowerBuilder using the Google Search JDBC Driver.

• Creating Email-Connected Applications in Unqork

  You can use CData Connect to feed Email to Unqork and build custom business apps.

• Connect to SAP HANA XS Advanced in RazorSQL

  Connect to SAP HANA XS Advanced from wizards and query SAP HANA XS Advanced from the GUI in the RazorSQL database management tool.

• Bridge SQL Server Connectivity with Apache NiFi

  Access and process Microsoft SQL Server in Apache NiFi using the CData JDBC Driver.

• Connect to Live PayPal in MicroStrategy through CData Connect Cloud

  Create a live connection to PayPal in CData Connect Cloud and connect to your PayPal from MicroStrategy.

• LINQ to Confluence

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

• Using AngularJS to Build Dynamic Web Pages with Google Ad Manager

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

• How to connect to LDAP Objects in DBVisualizer

  Integrate LDAP with visual data analysis tools and data connection wizards in DBVisualizer

• Connect to Oracle SCM in DBeaver

  Use the CData ODBC Driver to connect to Oracle SCM in DBeaver.

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

  Provide connectivity to Marketo through an SAP BusinessObjects universe.

• Replicate Printful to Multiple Databases

  Replicate Printful to disparate databases with a point-and-click configuration.

• Automate Active Directory Replication to Azure Data Lake

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

• How to create HubDB federated tables in MySQL

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

• Integrate with live Sage 200 in Jitterbit

  Use CData Connect Cloud to connect to and integrate live Sage 200 in Jitterbit.

• Connect to NetSuite in Airbyte ELT Pipelines

  Use CData Connect Cloud to build ELT pipelines for NetSuite CRM & ERP in Airbyte.

• Enable the Slack JDBC Driver in KNIME

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

• Automate Impala Replication to Azure Data Lake

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

• Automated Continuous SAP Business One Replication to MySQL

  Use CData Sync for automated, continuous, customizable SAP Business One replication to MySQL.

• Operational Reporting on Zoho Inventory from Spotfire Server

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

• Connect to Presto from PowerBuilder

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

• How to create Visio diagrams from Snowflake

  Automatically update Snowflake with the changes you make to Visio master shapes.

• Publish Oracle SCM-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Oracle SCM.

• Create Box Reports on JasperReports Server

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

• Connect to Salesforce Marketing from PowerBuilder

  This article demonstrates how to access Salesforce Marketing Cloud from PowerBuilder using the Salesforce Marketing JDBC Driver.

• Connect to Quickbase through External Services in Salesforce

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

• How to Work with Pipedrive in ETL Validator JDBC

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

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

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

• Connect to IBM Informix in DigitalSuite Studio through RunMyProcess DSEC

  Use Arkobi Digital

• How to Connect to Microsoft Teams in Using Python: 6 Steps

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

• Connect to SuiteCRM in NetBeans

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

• Use the CData Software JDBC Driver for Azure Data Catalog in MicroStrategy Desktop

  Connect to Azure Data Catalog in MicroStrategy Desktop using the CData Software JDBC Driver for Azure Data Catalog.

• Visualize Live Zendesk in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Zendesk.

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

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

• Visualize Live Klaviyo in Tableau

  Use CData Tableau Connectors and Tableau Desktop to visualize live Klaviyo.

• Integrate Certinia in Your Informatica Cloud Instance

  Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Certinia from Informatica Cloud.

• How to Connect to & Open Oracle Sales in Microsoft Excel

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

• How to create Sugar CRM federated tables in MySQL

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

• Automated Continuous Databricks Replication to Azure SQL

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

• Query Workday through ODBC in Node.js

  Use node-odbc to execute SQL queries against Workday from Node.js.

• Build HCL Domino-Connected Apps in Mendix

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

• Visualize Zoho Projects in TIBCO Spotfire through ADO.NET

  Integrate Zoho Projects into dashboards in TIBCO Spotfire.

• Create Klaviyo-Connected Visualizations in Klipfolio

  Use CData Software Connect Server to connect to Klaviyo from Klipfolio and build custom visualizations using live Klaviyo.

• Query Smartsheet as a MySQL Database in Node.js

  Execute MySQL queries against Smartsheet from Node.js.

• Create Informatica Mappings From/To an ODBC Data Source for SAP Business One

  Create an ODBC connection to SAP Business One in Informatica and browse and transfer SAP Business One.

• Build Charts with Wave Financial in Clear Analytics

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

• Connect to Splunk from a Connection Pool in WebLogic

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

• Excel Reporting in OBIEE with the Excel JDBC Driver

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

• Replicate EnterpriseDB to Multiple Databases

  Replicate EnterpriseDB to disparate databases with a single configuration.

• Excel Spreadsheet Automation with the QUERY Formula

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

• Query Workday in MySQL Workbench

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

• How to Connect to Calendly in Using Python: 6 Steps

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

• View Reports on Real-Time ServiceNow in Power BI Report Server

  Use the CData ODBC Driver for ServiceNow to visualize ServiceNow in Power BI Desktop and then publish them to Power BI Report Server.

• Integrate Zoho Projects into Automated Tasks with Power Automate

  Use CData Connect Cloud to connect to Zoho Projects and integrate live Zoho Projects into your Power Automate tasks.

• Query SAS xpt in MySQL Workbench

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

• Connect to Bing Search Results in RazorSQL

  Connect to Bing Search from wizards and query Bing Search from the GUI in the RazorSQL database management tool.

• Automated Continuous Acumatica Replication to SQL Server

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

• Integrate with Teradata in JReport Designer

  Create charts and reports based on Teradata in JReport Designer.

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

  Connect to Sage 300 from a connection pool in Tomcat.

• Automated Continuous CockroachDB Replication to PostgreSQL

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

• Visualize Twilio in TIBCO Spotfire through ODBC

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

• Connect to Excel Online in RapidMiner

  Integrate Microsoft Excel Online with standard components and data source configuration wizards in RapidMiner Studio.

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

  Provide connectivity to Zuora through an SAP BusinessObjects universe.

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

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

• Integrate with Amazon Athena in SnapLogic

  Use CData Connect Cloud to connect to and integrate with live Amazon Athena in SnapLogic.

• Automate Power BI XMLA Replication to SAP HANA

  Use CData Sync to customize and automate Power BI XMLA replication to SAP HANA.

• View Reports on Real-Time Redis in Power BI Report Server

  Use the CData ODBC Driver for Redis to visualize Redis in Power BI Desktop and then publish them to Power BI Report Server.

• Use the CData Software ODBC Driver for REST in MicroStrategy

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

• Publish Phoenix-Connected Dashboards in Tableau Server

  Use CData Tableau Connectors and Tableau Server to visualize live Apache Phoenix.

• LINQ to Microsoft Exchange

  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 Microsoft Exchange Data Provider.

• Visualize TaxJar in TIBCO Spotfire through ODBC

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

• Automated Continuous Salesloft Replication to Vertica

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

• Replicate Multiple QuickBooks Accounts

  Replicate multiple QuickBooks accounts to one or many databases.

• Build Pipelines with Live Azure Table in Google Cloud Data Fusion (via CData Connect Cloud)

  Use CData Connect Cloud to connect to Azure Table from Google Cloud Data Fusion, enabling the integration of live Azure Table Storage into the building and management of effective data pipelines.

• Bridge Google Ads Connectivity with Apache NiFi

  Access and process Google Ads in Apache NiFi using the CData JDBC Driver.

• Use Biml to Build SSIS Tasks to Replicate Oracle Financials Cloud to SQL Server

  Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Oracle Financials Cloud to SQL Server.

• Build Interactive Dashboards from REST in Amazon QuickSight

  Create a virtual SQL Server database for REST in CData Software Connect Server and import REST into Amazon QuickSight SPICE to build interactive dashboards.

• Connect to Microsoft Project in Aqua Data Studio

  Access Microsoft Project from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• Working with Greenhouse in LINQPad

  Execute LINQ queries to Greenhouse in LINQPad.

• A PostgreSQL Interface for Google Ads

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

• Analyze Google Ad Manager with Power Pivot

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

• Query WooCommerce in ColdFusion

  Write standard ColdFusion data access code to connect to WooCommerce.

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

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

• Automated Continuous Exact Online Replication to MongoDB

  Use CData Sync for automated, continuous, customizable Exact Online replication to MongoDB.

• Build a Simple VCL Application for Adobe Analytics

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

• Create an SAP BusinessObjects Universe on the CData ODBC Driver for Oracle Financials Cloud

  Provide connectivity to Oracle Financials Cloud through an SAP BusinessObjects universe.

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

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

• Connect to Tally in RazorSQL

  Connect to Tally from wizards and query Tally ERP from the GUI in the RazorSQL database management tool.

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

• «
• 157
• 158
• 159
• 160
• 161
• 162
• 163
• 164
• 165
• 166
• »