-

Use Java For Data Integration

Enable your non-Oracle Fusion applications to directly link to Oracle Fusion data using JDBC. Use custom Java code or an integrated development environment with the Fusion DB Connect JDBC driver.

public class SimpleQuery { public static void main(String[] args) { Statement stmnt = null; ResultSet rset = null; try { Class driverClass = Class.forName("com.twoewe.cloudjdbc.TwoEweSaaSDriver"); DriverManager.registerDriver((Driver) driverClass.newInstance()); Properties jdbcProperties = new Properties(); jdbcProperties.put("user", args[1]); jdbcProperties.put("password", args[2]); Connection l_conn = DriverManager.getConnection( "jdbc:twoewes:saas:@" + args[0] + ":443" , jdbcProperties); l_conn.setAutoCommit(false); PreparedStatement pstmnt = l_conn.prepareStatement( "SELECT A.PERSON_ID, B.NAME_TYPE, B.FIRST_NAME, B.LAST_NAME " + " FROM PER_ALL_PEOPLE_F A, PER_PERSON_NAMES_F B " + " WHERE A.PERSON_ID=B.PERSON_ID and rownum<10"); rset = pstmnt.executeQuery(); cloudDriverTest2.print(rset); l_conn.close(); } catch (Exception e) { System.err.println(e.getMessage()); e.printStackTrace(); } } }









PERSON_ID NAME_TYPE FIRST_NAME LAST_NAME ------------------ ------------------ -------------------- ------------------ 300000047606111 US Alan Cook 300000047606111 GLOBAL Alan Cook 300000047606111 GLOBAL Alan Cook 300000047606111 US Alan Cook 300000047606111 GLOBAL Alan Cook 300000047606111 US Alan Cook 300000047606111 GLOBAL Alan Cook 300000047606111 US Alan Cook 300000047626100 US Mandy Steward Process finished with exit code 0

-

Using Fusion DB Connect

Users Manual

Use any tool which supports JDBC to query you data in real-time.

Download...

Direct Data Query

Use any tool which supports JDBC to query you data in real-time.

Read more...

Integrations

Implement your own Java code to construct integrations collecting actual real-time information from Oracle Fusion Applications.

Read more...
-

What is the Fusion DB Connect JDBC Driver

JDBC Driver

Fusion DB Connect is a Java Database Connect driver. The Java Database Connectivity (JDBC) API provides universal data access from the Java programming language.

Simple Connections

Connect with SQL*Developer, or any database developer tool which supports JDBC, and directly query your Oracle Cloud Fusion Applications database.

Embed within Code

Use Java standards to conenct and query your Oracle Cloud Fusion Application data. Open result sets for your queries and process like using any other database solution.

JDBC Standard

Fully compliant with JSR 221: JDBCTM 4.0 API Specification. This specification seeks to improve Java application access to SQL data stores by the provision of ease-of-development focused features and improvements at both the utility and API level