Archives

Microsoft Bing Adwords Java Integration

Step 1: Setup Bing BulkServiceManager Configuration Step 2: Setup Bing Adwords Service

Rate this:

Read More

Apache Camel Kafka Spring Integration

1. Configure Camel Kafka Component 2. Configure Kafka Consume and Producer Route 3. Start Kafka test by adding routes to CamelContext and starting

Rate this:

Read More

Google Adwords Java Integration

Step 1: Create Google AdwordSession configuration 2. Create AdWord Service to export KeyWords, Campaigns, AdGroups and Ads.

Rate this:

Read More

Apache Camel Salesforce Integration

1. Setup SalesforceLoginConfig 2. Setup SalesforceCamelEndpointConfig 3. Setup SalesforceCamelComponent 4. Setup SalesforceCamelRouteConfig 5. Run SalesforceCamelIntegrationTest 1. Setup SalesforceLoginConfig 2. Setup SalesforceCamelEndpointConfig 3. Setup SalesforceCamelComponent 4. Setup SalesforceCamelRouteConfig 5. Run SalesforceCamelIntegrationTest OUTPUT: >>>>>>> Salesforce Basics Info: {“objectDescribe”:{“name”:”Account”,”label”:”Account”,”updateable”:true,”keyPrefix”:”001″,”custom”:false,”urls”:{“sobject”:”/services/data/v33.0/sobjects/Account”,”describe”:”/services/data/v33.0/sobjects/Account/describe”,”rowTemplate”:”/services/data/v33.0/sobjects/Account/{ID}”,”approvalLayouts”:”/services/data/v33.0/sobjects/Account/describe/approvalLayouts”,”quickActions”:”/services/data/v33.0/sobjects/Account/quickActions”,”listviews”:”/services/data/v33.0/sobjects/Account/listviews”,”layouts”:”/services/data/v33.0/sobjects/Account/describe/layouts”,”compactLayouts”:”/services/data/v33.0/sobjects/Account/describe/compactLayouts”},”searchable”:true,”labelPlural”:”Accounts”,”layoutable”:true,”activateable”:false,”createable”:true,”deprecatedAndHidden”:false,”deletable”:true,”customSetting”:false,”feedEnabled”:true,”mergeable”:true,”queryable”:true,”replicateable”:true,”retrieveable”:true,”undeletable”:true,”triggerable”:true},”recentItems”:[{“attributes”:{“type”:”Account”,”url”:”/services/data/v33.0/sobjects/Account/001W000000JhUzlIAF”},”Name”:”Pope John XXIII Regional High School”,”Id”:”001W000000JhUzlIAF”},{“attributes”:{“type”:”Account”,”url”:”/services/data/v33.0/sobjects/Account/001W000000JhZFQIA3″},”Name”:”A PLAZA DRIVING SCHOOL”,”Id”:”001W000000JhZFQIA3″},{“attributes”:{“type”:”Account”,”url”:”/services/data/v33.0/sobjects/Account/001W000000JgxxXIAR”},”Name”:”Advanced Reproductive Care, Inc. (ARC)”,”Id”:”001W000000JgxxXIAR”},{“attributes”:{“type”:”Account”,”url”:”/services/data/v33.0/sobjects/Account/001W000000JrwqvIAB”},”Name”:”name”,”Id”:”001W000000JrwqvIAB”},{“attributes”:{“type”:”Account”,”url”:”/services/data/v33.0/sobjects/Account/001W000000JhXSnIAN”},”Name”:”Stella Niagara Education Park”,”Id”:”001W000000JhXSnIAN”},{“attributes”:{“type”:”Account”,”url”:”/services/data/v33.0/sobjects/Account/001W000000Jr1WOIAZ”},”Name”:”A J DIANA SONS INC”,”Id”:”001W000000Jr1WOIAZ”},{“attributes”:{“type”:”Account”,”url”:”/services/data/v33.0/sobjects/Account/001W000000Jr1TIIAZ”},”Name”:”A […]

Rate this:

Read More

Salesforce Integration JUnit Testing Using Spring

Spring Configuration to test integration to Salesforce using PartnerConnection, EnterpriseConnection and BulkConnection. Create a properties file called salesforcesync.properties with all the login details salesforcesync.properties Salesforce Authentication Spring Configuration Junit test class to assert login was successful

Rate this:

Read More

Java Code: Apex Bulk Loading MySQL

Creating a bulk sync between MySQL and Salesforce using the Salesforce Bulk API. I created a Bulk Loader that connects to MySQL exports data to CSV and imports it into Salesforce. In this example I am syncing the Lead object. package com.thysmichels; import java.io.*; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import java.util.*; import […]

Rate this:

Read More

Java Code: Salesforce Export into Excel

Export Salesforce records into Excel. In my example I read records from Excel and also from Salesforce. Reuse my code by providing your own username and password to your Salesforce org to create more advanced SFDC to Excel integrations. You will need to download or add jxl to your maven project: http://mvnrepository.com/artifact/net.sourceforge.jexcelapi/jxl

Rate this:

Read More

Insert row DB2 with Websphere Cast Iron

How to insert a row into DB2 using Websphere Cast Iron. Step 1: Create an DB2 Endpoint by specifying the following information: DB2 Database Name DB2 Host Name DB2 Port Number DB2 Username DB2 Password Please make sure that the Cast Iron appliance or Virtual image has rights to insert a row onto DB2. This […]

Rate this:

Read More

Cast Iron Websphere MQ integration Flow

How to integrate Websphere MQ integration flow with Cast Iron tutorial. Before starting this tutorial make sure that you have the MQ jar files added to the -> Install Module Providers Menu Step 1: Create a Websphere MQ endpoint by specifying the following information: Websphere MQ hostname Websphere MQ port Queue Manager Name Server Connection […]

Rate this:

Read More

Salesforce and DB2 integration with Cast Iron

Below is a short tutorial on how to integrate Salesforce with IBM DB2 using Cast Iron. 1. Define your SalesForce Endpoint by providing the following information (you must be a registered member of Salesforce): Username Password Ste 2: Test the connection and make sure that it is successful. Step 3: Define the DB2 Endpoint by […]

Rate this:

Read More