Archive for August, 2007

Replicate Salesforce Schema to Oracle or MySQL

Share

Mike Simonds released 2 scripts over the past few days that will create copies of your Salesforce schema into MySQL or Oracle databases. I haven’t tested either of them, but I think this could be pretty handy. Of course, you’ll need to have additional scripts actually bring your data over from Salesforce to these databases, but this is a start. Learn more about the scripts using the links below.

If you try these, feel free to comment here about how it went. If you actually want to let Mike know about your use of the scripts, you could submit replies on his site or at his forum postings about the functionality (Oracle, MySQL)

Comments (10) comments feed

Summer 07 Minutia

Summer 07 is in the process of rolling out. Although, it was originally expected to complete this past weekend, I don’t think that’s the case. Other than NA1, I am not certain it’s been released. In orgs on non-NA1 servers, I am getting scheduled improvement notices for this coming Friday night.

Anyway, I have been going through the Release Notes and have found some nice little enhancements that aren’t necessarily “big news”, so I thought I’d point them out. For the major changes, I would suggest going to the Summer 07 landing page.

  • Merging Contacts or Leads on Campaigns

    …when you merge duplicate contacts or leads that are members of different campaigns, the campaign date for each is retained and associated with the newly-merged contact or lead.

  • Specify the Number of Records to Display in Report Results: Just like in Dashboards, you can now limit the records returned in a tabular report. Also, if you specify this value, you can now use that tabular report in a Dashboard.
  • Opt-Out of System Maintenance Notifications

    With Summer ’07, administrators can go to Setup | Company Profile | Company Information to prevent advance notices about planned system maintenance or downtime from displaying to users when they log in.

  • Recycle Bin for Deleted Custom Field: Will save some people from major grief.
  • Report on API Usage
  • Workflow rules and actions can be packaged in an AppExchange app
  • Data Loader can export data from Relationship Fields

    To do so, use a SOQL query in your export request that includes fields from a related object.

  • Compliance BCC Emails: Force all outbound Salesforce emails to BCC to a corporate address without the ability to override by the end-user.
  • Delegated User Admins can now login as the users they support just like the regular Sys Admin can.
  • Record Locking

    If two users are editing the same record simultaneously, the user who saves the record first will have his or her changes saved, and the second user will receive an error message and be prompted to reload the record with the changes made by the first user.

  • Formula-based worklow rules

    When defining entry criteria for workflow rules, you can now use formulas that include calculations and multi-field comparisons, letting you create complex workflow rules. For example, you can leverage formula functions such as ISCHANGED and PRIORVALUE to build rules based on field value changes.

  • Dynamic selection of email alert recipients

    Send email alerts to any related user, contact, or email address that appears in any custom or standard field on the object specified for the email alert.

These are ones that are of particular interest to me. If you want to point out something you learned about that is buried in the details, but might be relevant to others, please post a comment and let us know.

Comments (0) comments feed

Next entries »