Tuesday, September 27, 2011

Salesforce Winter 12 Release


Salesforce's Winter 12 Features Announced

After Dreamforce 11, salesforce has just published the Winter 12 release notes. There are many new features in this release, and some influential ones. I am posting few of them
  • Analytics Enhancements - Coming out of Dreamforce (more on my Dreamforce thoughts in another post), this is what I was most excited about. Starting with this release, there is a terrific roadmap of new features for reports and dashboards, which is going to be a big win for customers. Just to name a few of the new ones in Winter 12:

    • Dashboard Filters - Tired of creating a clone for a dashboard just to get a cut on a different metric, like Region or Industry? Dashboard filters allows you to add a filter to the dashboard, that when changed, applies to the filter to all the dashboard components. A small, but terrific feature. For now, it can only be a picklist, lookup or text field. (let's hope date fields are close behind)
    • New Reports Tab - A slick re-design of the Reports tab. The image shows it nicely, but essentially it combines Reports and Dashboards into one place to find and run them. An enhanced search has also been added for those customers with lots of reports or dashboards. A few other additions helps admins manage the folders and creation a bit better, so all around a good addition.
    • Visualforce Charting - This is a pilot, but salesforce showed it at Dreamforce and it looked very slick. Essentially, visualforce reports are much easier to build as there are now pre-built components for reports and charts which means you won't need to start from scratch building them.
    • Reports are now in the Recent Items list

  • Chatter Enhancements - As expected, there's a few new Chatter enhancements, but I almost see this as the next level of Chatter. It's no longer just a feed.

    • Chatter Messages - Messaging and Presence now built directly into salesforce. This is a big collaboration enhancement, as now users can see if someone is logged into salesforce, and send them a private message. Just another step to allowing the team to remain in salesforce to get all the information they need.
    • Customers in Private Chatter Groups - Your Customers (or Partners, which I think is even bigger), can now be invited into private and secure Chatter groups so they can collaborate with your salesforce users. Share files, posts, messages, etc. just like you would with a normal salesforce user. Best of all, it's free.
    • Chatter Approvals - Approvals can now be managed through the Chatter feed
  • SiteForce - Salesforce showed this off at Dreamforce 10, and it's coming live in Winter 12. Too many details to cover here, but essentially, SiteForce is a CMS editor to create pages for Sites easier. Currently, if you want to really change your portal look and feel, you'd need to create visualforce pages. With this, you get much more flexibility in what you can customize, and from the look of it, the ability to do it a lot easier than visualforce.
  • Social Contacts - Directly from the Contact record, you can now view a Contact's Twitter, Facebook, or Linkedin feed. This is the next step in Salesforce's push to "socialize" the enterprise and I can see where Radian6 will step in soon to enhance this even further. For now, this is simply a way to view the feeds, as long as you know your contact's user ID for these services. Speaking of which...
  • Data.com - Jigsaw is now called data.com. First, one of the big announcements at Dreamforce was that Data.com now contains a subset of D&B information. This is big. Previously, Jigsaw was great for contact data, but pretty poor around Account information. D&B was the exact opposite. Now, with one service you can get the best of both, completely integrated with salesforce and with the ability to make it even more powerful with API access. This is becoming a must have if you do serious lead nurturing or outbound calling. In addition to this announcement, there are a few new enhancements within salesforce, including the ability for users to save searches and improved exporting. Finally, back to the Social Contacts. With salesforce.com's focus on the "social enterprise", it is clear that Data.com will be making a strong push to start capturing company's and contact's social accounts as well as their email and phone.
  • Forecasts - A revamp of the Forecasts feature. A new, impressive looking UI, and some nice improvements to the usability. From the notes, it's hard to tell if it is more flexible though, which has always been the biggest issue.
  • Salesforce for Outlook now supports Outlook 2010, including 64 bit. Still no ability to create Cases from an email though.
  • CTI 4.0 - Of course, this doesn't mean the phone vendors will support it just yet, so may be a lag before you can take advantage of this. Biggest part of this is it now supports Chrome as well the Mac.
Winter 12 is a big release with great enhancements and a lot of smaller enhancements to really fill it out. Please comment if you find out more.

Monday, September 26, 2011

Salesforce CRM Overview


Software as a service (SaaS), sometimes referred to as "on-demand software," is a software delivery model in which software and its associated data are hosted centrally on a service offering compnies premise(called as on "cloud") and are typically accessed by users using a thin client, normally using a web browser over the Internet.
Force.com is a platform provided by salesforce which is totaly on cloud. It is generally known as PaaS (Platform as a Service). Customer need not to maintain any Application or database server simply buy licenses to use services on per user basis.

Salesforce application operate on Multitenant Environment. A multitenant application cost-efficiently shares 
a single stack of resources to satisfy the needs of multiple tenant (organization).

Single-tenant systems give a user its own database and its own instance of the software application. Placed on either  individual server, or segregated via extensive security controls to create its own virtual server, users of single-tenant systems enjoy the benefits of significant configurability of software, robust functionality, and enhanced security.

i think below screen shot make more sense.
Single Tenant Architecture

Multitenant Architecture



Salesforce Admin Exam                               Identity Confirmation  





Field datatype mapping between Oracle/SQL Server and Salesforce

Over the time I have started developing a tool that pulls salesforce metadata information and creates oracle/sql server “create table” scripts. Isn’t that really awesome!!
The most useful part of the tool is field data type mapping i.e, what data type of salesforce maps to what data type of oracle/sql server. Below is the list of mapping that I used while generating create table scripts – enjoy!!

salesforce data typesql server data typeoracle data type
booleanbitvarchar2(1)
datesmalldatetimedate
datetimeDatetimedate
currencydecimal(precision,scale)number(precision,scale)
doubledecimal(precision,scale)number(precision,scale)
intIntnumber(10)
picklistnvarchar(255)varchar2(255)
idnvarchar(18)varchar2(18)
referencenvarchar(18)varchar2(18)
textareanvarchar(max)varchar2(4000)
emailnvarchar(255)varchar2(255)
phonenvarchar(255)varchar2(255)
urlnvarchar(255)varchar2(255)
textareanvarchar(max)varchar2(4000)
multipicklistnvarchar(max)varchar2(4000)
anyTypenvarchar(max)varchar2(4000)
percentdecimal(5,2)number(5,2)
comboboxnvarchar(max)varchar2(4000)
base64nvarchar(max)varchar2(4000)
timenvarchar(255)varchar2(255)
stringnvarchar(length)varchar2(length)

Sunday, September 25, 2011

Salesforce CRM Overview

In this post i am going to cover all about Salesforce CRM overview, however the topic is vast enough and can take 100 pages of blogs but we will stick to the Admin Exam's perspective.