Search
Twitter
« Use SOQL's OFFSET Clause to Paginate your Visualforce Pages | Main | Salesforce Adds "Social Intelligence" for Chatter »
Thursday
Apr112013

Administer Your Force Database with Cloudingo Studio

CDS-logo-dowload-now

I recently came across Cloudingo Studio; a cool, free app provided by Symphonic Source. Cloudingo Studio is a simple database Force.com administration tool which enables the user to connect, design, and browse a database, run SQL scripts, as well as search custom objects and fields

 

Developers know that database systems are complex and time consuming to design. Also, the initial training requires a great deal of time and energy. A particularly groundbreaking feature of Cloudingo Studio, which I know will prove helpful for many developers out there, is that it has the ability to translate/convert SQL commands into Force's SOQL.

Here's how the translation engine works: it takes the SQL commands entered in Cloudingo Studio and converts them into API calls (which works with simple updates of records as well as clearing out a large number of them). Here's an example of using the UPDATE statement to change the Name field in an account record:

UPDATE Account SET Name = 'Updated Names' WHERE Id = '001G000000000r5la';
Here's the link to download Cloudingo Studio (for Windows): http://www.symphonicsource.com/cloudingo-studio/

PrintView Printer Friendly Version

EmailEmail Article to Friend

Reader Comments

There are no comments for this journal entry. To create a new comment, use the form below.

PostPost a New Comment

Enter your information below to add a new comment.

My response is on my own website »
Author Email (optional):
Author URL (optional):
Post:
 
All HTML will be escaped. Hyperlinks will be created for URLs automatically.