Sample Data

Owned by Jodie Miners
Last updated: Jul 30, 2020
1 min read

I need to do a demo in my dev org and I want lots and lots of sample data. 

Here's what I've found. 

https://knthornt.wordpress.com/2011/06/23/quickly-creating-sandbox-dummy-data/ - note the comments though

http://th3silverlining.com/2011/01/28/salesforce-programmatically-populating-sample-data-post-deployment/

https://developer.salesforce.com/page/Generating_and_Loading_Representative_Test_Data_for_Salesforce_and_Force.com_Orgs

All of these are very coder oriented, which does not suit me. 

There is this http://www.shellblack.com/data/create-import-file-accounts-and-contacts/ which is great, but it's just NOT enough data!. 


This is a nice resource for sample data sets

http://stackoverflow.com/questions/57068/where-can-i-find-sample-databases-with-common-formatted-data-that-i-can-use-in-m

http://stackoverflow.com/questions/1982678/freely-available-example-datasets-of-hierarchical-information-and-realistic-nam

https://mehulharry.wordpress.com/2012/02/21/free-data-sets-northwind-alternatives/


The master of all sample databases however is Northwind! 

https://northwinddatabase.codeplex.com/

Ooh, and look someone has already put it all in CSV format for us https://github.com/tmcnab/northwind-mongo 

https://raw.githubusercontent.com/tmcnab/northwind-mongo/master/northwind.csv


I ended up using this one http://timecenter.cs.aau.dk/software.htm and downloading the employeeTemporarlDataSet.zip and extracting some of the sample data for use in my  Excel Power Query talk

Sample Orgs

After a discussion on twitter Jennifer Wobser recommended Mockaroo which looks great (although I do hate the misappropriation of Aussieness from non-aussie companies - no, Outback Steakhouse is not an Aussie thing).  

From that discussion I was asking for a full mock org with custom objects etc. I am sick of apps that show simple scenarios on how to use their apps, just using Accounts and Contacts, and I was wondering if there was something like Northwind or Fabrikam in the Microsoft circles for Salesforce. 

In Salesforce land there is Universal Containers which is used in Training, and to great effect on AutomationChampion blog for his business use-cases, and I did not know about the Warehousing App, so I will have to try that one out too. 

Other Data

Files

This site is good http://www.sample-videos.com/

Phone Numbers 

Australian fictional phone numbers can be found at https://www.acma.gov.au/choose-your-phone-number 

ABN

And you can test if an ABN is valid http://www.mathgen.ch/codes/abn.html#:~:text=If%20you%20don't%20have,ABN%2053%20004%20085%20616.

TFN

Some valid TFNs are here https://support.yourpayroll.com.au/hc/en-au/articles/200077535-Special-Tax-File-Numbers

To Test a TFN go here http://www.mathgen.ch/codes/tfn.html