General Settings

Service Endpoint

The Service Endpoint option allows you to specify the API you want to connect to Salesforce with. There are two options available:

• SOAP
• REST

Instance Type

The Instance Type option allows you to specify what Salesforce instance you are connecting to. There are three options available:

• Production
• Sandbox
• Other

For the first two options, the Service URL option below will be automatically populated. In the case the "Other" option is selected, you can specify an alternate Service URL which may not be a default one. This can be used for the case that you are connecting to a special Salesforce deployment including the situation that you use your own custom domain for Salesforce access.

Service URL

Using this option to provide an alternate URL that will be used to post transactions to your Salesforce instance. This field is only available when the Instance Type option above has been selected as "Other", for the other two options (Production and Sandbox), the Service URL is automatically populated using a default value.

The Advanced Settings page allows you to specify advanced settings for the connection.

Statement statement = connection.createStatement();	

String query = "SELECT * FROM Account";
		
ResultSet resultSet = statement.executeQuery(query);

while (resultSet.next()) {
    for (int i = 1; i <= resultSet.getMetaData().getColumnCount(); i++) {
        LOGGER.info(resultSet.getMetaData().getColumnLabel(i) + "=" + resultSet.getString(i));
    }
}

try {	
    Statement statement = connection.createStatement();	
    String query = "INSERT INTO Account (Name,type) VALUES ('test', 'test type')";		
    statement.executeUpdate(query);
    LOGGER.info(statement.getResultSet().toString());
} catch (SQLException e) {
    LOGGER.error(e);
}	

id,errorcode,errormessage,processdata,haserrors
0016T00003BuPrPQAV,null,null,{"attributes":{"type":"Account"},"Type":"test type","Name":"test"},false

try {	
    Statement statement = connection.createStatement();	
    String query = "UPDATE Account SET AccountNumber = '12345' WHERE type IN ('test type');";		
    statement.executeUpdate(query);
    LOGGER.info(statement.getResultSet().toString());
} catch (SQLException e) {
    LOGGER.error(e);
}	

id,errorcode,errormessage,processdata,haserrors
0016T00003BuPrPQAV,null,null,{"attributes":{"type":"Account"},"Id":"0016T00003BuPrPQAV","AccountNumber":"12345"},false

try {
    Statement statement = connection.createStatement();	
    String query = "DELETE FROM Account WHERE Name = 'test1'";			
    statement.executeUpdate(query);
    LOGGER.info(statement.getResultSet().toString());
} catch (SQLException e) {
    LOGGER.error(e);
}	

id,errorcode,errormessage,processdata,haserrors
0016T00003BvAZZQA3,null,null,null,false

String query = "UPSERT INTO Account (Name, AccountNumber, type, id) "
    + "VALUES ('test1', '123456', 'test type', null), "
    + "('test2', '123456', 'test type', '0016T00003Bv8vjQAB') "
    + "ON DUPLICATE KEY UPDATE UPSERTFIELDS = id";

try {	
    Statement statement = connection.createStatement();			
    statement.executeUpdate(query);
    LOGGER.info(statement.getResultSet().toString());
} catch (SQLException e) {
    LOGGER.error(e);
}	

id,errorcode,errormessage,processdata,haserrors,isNew
0016T00003BvAZZQA3,null,null,SOAP Object=[Type=test type;Id=null;Name=test1;AccountNumber=123456;],false,true
0016T00003Bv8vjQAB,null,null,SOAP Object=[Type=test type;Id=0016T00003Bv8vjQAB;Name=test2;AccountNumber=123456;],false,false

String query = "SELECT Accountnumber, Name, CreatedByid, CreatedDate FROM Account WHERE name = ?";
try {	
    PreparedStatement ps = connection.prepareStatement(query);
    ps.setString(1, "test1");
    ps.execute(query);
    while (ps.getResultSet().next()) {
        for (int i = 1; i <= ps.getResultSet().getMetaData().getColumnCount(); i++) {
            LOGGER.info(ps.getResultSet().getMetaData().getColumnLabel(i) + "=" + ps.getResultSet().getString(i));
        }
    }
} catch (SQLException e) {
    LOGGER.error(e);
}	

String query = "INSERT INTO Account (Name, AccountNumber, type) VALUES (?, ?, ?)";

try {
    PreparedStatement ps = connection.prepareStatement(query);			
    ps.setString(1, "test2");
    ps.setString(2, "123456");
    ps.setString(3, "test type");
    ps.executeUpdate();
    LOGGER.info(ps.getResultSet().toString());
} catch (SQLException e) {
    LOGGER.error(e);
}	

id,errorcode,errormessage,processdata,haserrors
0016T00003BvS9uQAF,null,null,SOAP Object=[Type=test type;Name=test2;AccountNumber=123456;],false

String query = "UPDATE Account SET AccountNumber = ? WHERE type IN (?)";

try {	
    PreparedStatement ps = connection.prepareStatement(query);
    ps.setString(1, "654321");
    ps.setString(2, "test type");
    ps.executeUpdate();
    LOGGER.info(ps.getResultSet().toString());
} catch (SQLException e) {
    LOGGER.error(e);
}	

id,errorcode,errormessage,processdata,haserrors
0016T00003BvSJpQAN,null,null,SOAP Object=[AccountNumber=654321;],false

String query = "DELETE FROM Account WHERE Name = ?";

try {	
    PreparedStatement ps = connection.prepareStatement(query);
    ps.setString(1, "test1");
    ps.executeUpdate();
    LOGGER.info(ps.getResultSet().toString());
} catch (SQLException e) {
    LOGGER.error(e);
}	

id,errorcode,errormessage,processdata,haserrors
0016T00003BvSMFQA3,null,null,null,false

String query = "UPSERT INTO Account (Name, AccountNumber, type, id) "
    + "VALUES (?, ?, ?, ?)"
    + "ON DUPLICATE KEY UPDATE UPSERTFIELDS = id";

try {	
    PreparedStatement ps = connection.prepareStatement(query);
    ps.setString(1, "test3");
    ps.setString(2, "654321");
    ps.setString(3, "test type");			
    ps.setNull(4, Types.VARCHAR);
    ps.executeUpdate();
    LOGGER.info(ps.getResultSet().toString());
} catch (SQLException e) {
    LOGGER.error(e);
}	

id,errorcode,errormessage,processdata,haserrors,isNew
null,null,SOAP Errors:[[StatusCode=DUPLICATES_DETECTED;Message=Use one of these records?];],SOAP Object=[Type="test type";Id="0016T000033urGHQAY";Name="test3";AccountNumber="654321";],false,false

Class.forName("com.kingswaysoft.jdbc.Drivers");

Properties connectionProps = new Properties();
connectionProps.put("user", "username");
connectionProps.put("password", "password");
connectionProps.put("securityToken", "token");

Connection connection = DriverManager.getConnection("jdbc:kingswaysoft:url=https://login.salesforce.com/services/Soap/u/58.0;serviceEndpoint=SOAP;", connectionProps);

ResultSet resultSet = connection.getMetaData().getTables(null, null, null, null);
LOGGER.info(resultSet.toString());

TABLE_CAT,TABLE_SCHEM,TABLE_NAME,TABLE_TYPE,REMARKS
null,null,AcceptedEventRelation,Table,
null,null,Account,Table,
null,null,AccountContactRole,Table,
null,null,AccountFeed,Table,

Class.forName("com.kingswaysoft.jdbc.Drivers");

Properties connectionProps = new Properties();
connectionProps.put("user", "username");
connectionProps.put("password", "password");
connectionProps.put("securityToken", "token");

Connection connection = DriverManager.getConnection("jdbc:kingswaysoft:url=https://login.salesforce.com/services/Soap/u/58.0;serviceEndpoint=SOAP;", connectionProps);

ResultSet resultSet = connection.getMetaData().getColumns(null, null, "Contact", null);
LOGGER.info(resultSet.toString());

TABLE_CAT,TABLE_SCHEM,TABLE_NAME,COLUMN_NAME,DATA_TYPE,TYPE_NAME,COLUMN_SIZE,BUFFER_LENGTH,DECIMAL_DIGITS,NUM_PREC_RADIX,NULLABLE,COLUMN_DEF,SQL_DATA_TYPE,SQL_DATETIME_SUB,CHAR_OCTET_LENGTH,ORDINAL_POSITION,IS_NULLABLE,IS_AUTOINCREMENT,IS_GENERATEDCOLUMN,SALES_FORCE_TYPE
null,null,Contact,AccountId,1,java.lang.Character,18,null,0,0,null,null,null,1,null,null,null,null,null,null,reference
null,null,Contact,AssistantName,12,java.lang.String,40,null,0,0,null,null,null,12,null,null,null,null,null,null,stringnull,null,Contact,AssistantPhone,12,java.lang.String,40,null,0,0,null,null,null,12,null,null,null,null,null,null,phone

Class.forName("com.kingswaysoft.jdbc.Drivers");

Properties connectionProps = new Properties();
connectionProps.put("user", "username");
connectionProps.put("password", "password");
connectionProps.put("securityToken", "token");

Connection connection = DriverManager.getConnection("jdbc:kingswaysoft:url=https://login.salesforce.com/services/Soap/u/58.0;serviceEndpoint=SOAP;", connectionProps);

ResultSet resultSet = connection.getMetaData().getPrimaryKeys(null, null, "Account");
LOGGER.info(resultSet.toString());

TABLE_NAME,PRIMARY_COLUMN_NAME
Account,Id