Learn more
 

CData Software - Knowledge Base

Recent Oracle Sales Articles

Use the CData ODBC Driver for Oracle Sales from SharePoint Excel Services

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

Query Oracle Sales in ColdFusion

Write standard ColdFusion data access code to connect to Oracle Sales.

Connect to Oracle Sales in DBArtisan

Use wizards in DBArtisan to configure Oracle Sales as a data source.

How to Use a Microsoft Access Database to Update Oracle Sales in Real Time

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

Publish Oracle Sales-Connected Dashboards in Tableau Server

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

How to Build an ETL App for Oracle Sales in Python with CData

Create ETL applications and real-time data pipelines for Oracle Sales in Python with petl.

Bidirectional Access to Oracle Sales from FileMaker Pro

Use the MySQL Remoting feature of the JDBC driver to integrate Oracle Sales in Filemaker Pro for Mac or Windows.

Visualize Oracle Sales in Sisense

Create an ElastiCube in Sisense app with access to Oracle Sales.

Use Dash to Build to Web Apps on Oracle Sales

Create Python applications that use pandas and Dash to build Oracle Sales-connected web apps.

How to create Oracle Sales federated tables in MySQL

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

Connect to Oracle Sales in Ruby

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

Object-Relational Mapping (ORM) with Oracle Sales Entities in Java

Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Oracle Sales into a Java-based ORM framework, Hibernate.

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.

Build an OLAP Cube in SSAS from Oracle Sales

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

Build Dashboards with Oracle Sales in Dundas BI

Create dynamic dashboards and perform analytics based on Oracle Sales in Dundas BI.