Create CastIron Video Tutorials for 10 Salesforce integration scenarios; Phase-2 for Informatica Salesforce integration

Closed Posted Dec 21, 2012 Paid on delivery
Closed

The project is divided into two parts, with the first Part I of video tutorial part to be completed first, and submitted to us, before as assign the Part II tasks.

NOTE: It should take 30-40 minute to create each castIron integration with Salesforce video, but we'll pay for an hour for each of the 10 videos, and if we like the phase 1 videos, the next set will be for creating similar Salesforce integration videos with Informatica.

Details of training videos: We need detailed, clearly visible and audible step by step video tutorial of each of the following CastIron integration scenarios.

We expect an experience castIron integration expert to take no more than 30 - 40 minutes per video and we'll pay for an hour per video rate ie $10 per hour per video.

Please also see part II task also that has to be done once we review all the training videos.

Part - I: Develop using SnagIt or Comatasio screen videos capture tool these tutorials for each of the following CastIron integration scenario:

These are the Salesforce SFDC Data Integration Use Cases for Data Synchronization (Real Time & Batch) with Data Mapping, Data

Transformation, Data movement using CastIron Studio for:

NOTE: All these orchestrations must be load/performance tested for: four fields of Lead record ( FName, Lname, Company and email). with volume being:

a. Totals records to move = 50K,

b. Totals records to move = 500K &

c. Totals records to move = 1000K records.

1. One Time Data Load to Salesforce SFDC Oeg from MS-SQL server database for sample Lead records table in MS SQL server with four fields ( FName, Lname, Company and email). With Email sent upon orchestartion completion and logging.

2. Event Driven Batch for MS SQL server Leads data to Salesforce Leads records and vice-versa. Must test for 50K, 500K & 1000K records scenarios. Use Force Bulk API and standard API technique and measure the performance difference with BulkAPI and Standard API. With Email sent upon orchestartion completion and logging.

3. Event Driven Batch for MS SQL server On data change (ex: completion of a record) in database should execute a CastIron

Orchestration to feed from the Ms SQL database to SFDC (near real time). With Email sent upon orchestartion completion and logging.

4. Data Synchronization Update (SFDC to MS SQL server database) for both Near Real Time & Real time. Need capability for

Checking a real time update to a Salesforce Lead object and then execute CastIron orchestration to Build a real time update to

Ms SQL db via an action on SFDC like Save of a lead. With Email sent upon orchestartion completion and logging.

5. Synchronize update with Ms SQL database from Salesforce SFDC using both the following techniques with CastIron Studio:

a. Web services call & b. Pure Data Update With Email sent upon orchestartion completion and logging.

6. One Salesforce SFDC Org to another Salesforce SFDC Org With Email sent upon orchestartion completion and logging.

7. Continuous real time and schedule hourly load of Ms-SQL data to ==>> Salesforce for Leads With Email sent upon orchestartion completion and logging.

8. Continuous real time and schedule hourly load of Salesforce data to ==>> Ms-SQL for Leads With Email sent upon orchestartion completion and logging.

9. Continuous real time and schedule hourly load of Salesforce data to ==>> CSV/Excel file for Leads With Email sent upon orchestartion completion and logging.

Part - II - On Call tasks for CastIron integration, new development, maintenance, support:

We'll need someone to be on call for fixing castIron integration issues and/or developing castIron orchestration live in collabration with us like on webex/gotomeeting environment,

Video Services

Project ID: #4062484

About the project

1 proposal Remote project Active Jan 27, 2013

1 freelancer is bidding on average $15 for this job

modeomedia

Hi, You can visit my website at http://<b><i>Removed by Freelancer.com Admin.</i></b>.com/ I look forward to hearing from you. Warm Regards, Dennis

$15 USD / hour
(0 Reviews)
0.0