Use Java For Data Integration

import com.twoewe.cloudjdbc.coreutil.StringUtil;
import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Properties;

public class DemoHeadless
{
    /**
     * args[0]      = Fusion Cloud hostname
     * args[1]      = Username
     * args[2]      = Password
     * args[3]      = Registered (in STFWorks) Fusion host
     * @param args
     */
    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]);
            //
            // Note the additional jdbc Property for type
            jdbcProperties.put("type", "headless");

            //
            // Connection URL
            //--------------------------
            // Example 1, normal connection with username and password
            jdbcProperties.put("password", args[2]);        // Password required
            String url = "jdbc:twoewes:saas:@" + args[0] + ":443";

            // Example 2, using a certificate authentication with a registered host
            //  "jdbc:twoewes:saas:@hostname/registration"
            //      This example will connect using the registered certificate for
            //      the given host. Notice, no password
            //
            //String url = "jdbc:twoewes:saas:@"+args[0]+":443/"+args[3];

            Connection l_conn = DriverManager.getConnection(url, jdbcProperties);
            l_conn.setAutoCommit(false);

            //
            // Note here we are using the register command to set the username
            // and license key. This only needs to be done once. Afterwords, the
            // driver will pick it up from the users home directory in
            // {userhome}/.twoewe/connection.properties
            //
            stmnt = l_conn.createStatement();
            stmnt.execute("register "+args[3]+ " " + args[4]);
            l_conn.close();

            //
            // After the registration, it's business as usual for JDBC
            //
            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 TRUNC(B.EFFECTIVE_END_DATE) > SYSDATE" +
                            "   AND TRUNC(A.EFFECTIVE_END_DATE) > SYSDATE" +
                            "   AND rownum<10");

            rset = pstmnt.executeQuery();
            StringUtil.printSQLResultSet(rset);
        }
        catch (Exception e)
        {
            System.err.println(e.getMessage());
            e.printStackTrace();
        }
    }
}

                    

PERSON_ID          NAME_TYPE          FIRST_NAME           LAST_NAME
------------------ ------------------ -------------------- ------------------
300000047606111    GLOBAL             Alan                 Cook
300000047606111    US                 Alan                 Cook
300000047626100    US                 Mandy                Steward
300000047626100    GLOBAL             Mandy                Steward
300000047631116    US                 Marion               MarketingMgr
300000047631116    GLOBAL             Marion               MarketingMgr
300000047683157    US                 Aakash               Sharma
300000047683157    GLOBAL             Aakash               Sharma
300000047690191    US                 Bala                 Gupta

Process finished with exit code 0