You need to sign in to do that
Don't have an account?

How can I get a view of all of my data stored in salesforce? urgent
Hi All,
I want to get the data out of salesforce and process them for my own. how could I know which data located in which table?
Is is possible for me to get a view of those data? such as we use pl/sql to connect Oracle.
Thank you!!
Relational Junction creates a perfect replica of your Salesforce.com data into an Oracle, SQL Server, MySQL, DB2, Sybase, or PostgreSQL schema, and allows you to conveniently map that data into your internal applications.
Features include
- automatic creation of Salesforce entities and fields as tables and columns in the database
- timestamp-based two-way replication of all data
- handling of all objects and all fields, including binary attachments and long text
- fast, efficient, and secure operation, utilizing SOAP compression
- fault-tolerant, restartable handling of network outages and disconnects
Our ETL Manager uses an intuitive SQL interface rather than a proprietary scripting language. Learning time is minutes rather than weeks. Many of our customers already own an ETL product or a data bus technology. Others are building additional CRM functionality directly in our database. Our unique product architecture allows you to use the database integration technology you prefer, yet treat Salesforce.com as if it were an on-premise database application.Replication of your entire Salesforce.com site to your warehouse takes 5 minutes to set up and no design work. There is no requirement for using our professional services, no proprietary hardware, and no smoke and mirrors architecture. We have the first and only solution that demystifies the whole process, putting you in control. This is an Enterprise product suite that customers rely on for mission-critical operations. Relational Junction for Salesforce is certified by Salesforce.com, and has been in large-scale commercial use since 2004. Using Relational Junction for Salesforce, you can:
Try using Force.com explorer (available on developer site) to look at what relationships, fields,table of your salesforce bd.It is like pq/sql editor.
hi,
Try 'extract' using apex data loader.
you can extract the data from all the object even which are not visible as a tab.
If you do not want to do the extract manually then go for scheduling of the data loader. hope it gives the answer.
regards,
rupinder jeet singh.
You can use Apex Data Loader, You can also write SOQL on that particular object in Developer Console