Hi, If we need to authenticate with salesforce from external application (i.e Java or PHP) then we create connected app. Yes we can get all objects and records by standard API for which we need to create connected app.
Actually, I'm in need to connect Salesforce to SQL server. I need to generate an endpoint URL so that I can access all objects and records from that URL. How to create that using a connected app. can you just help me?
How are you plannig to use those endpoint to integrate with mysql server. I assume you have java or php code from where you will fetch Salesforce records and then push to SQL server. Let me know if this is the scenario for which I need to provide the salesforce endpoints reference and steps?
Actually, my work is to give data using endpoint URL. is that possible using connected app? from that URL, all salesforce objects and records can be exported? this is my requirement.
Ok. So you need to send data to SQL server from Salesforce. In this case connected app don't required. For this I have introduced java middleware earliear. We need to create own API in java application then our server's endpoint will be call from Salesforce. In java code by using JDBC ODBC driver we push the data in mysql server.
I meant currently I don't have all related code, I need to write all those from scratch. Please start developing and I will assist if any issue in any steps.
Talking about middleware I can suggest you to try Skyvia Connect (https://skyvia.com/connect/salesforce-odata) - it is a web-based service for creating Salesforce OData endpoints without any coding.
Have you tried this article:
https://developer.salesforce.com/page/Integrate_Salesforce.com_With_Your_On-premise_Database
Can you say me how to create a connected app? what is the purpose?
can I get all objects and records using connected app?
If we need to authenticate with salesforce from external application (i.e Java or PHP) then we create connected app.
Yes we can get all objects and records by standard API for which we need to create connected app.
Let me know if any additional query for the same
Please find step for createing Connected App.
https://trailhead.salesforce.com/en/projects/workshop-electric-imp/steps/connected-app-setup
Defining Connected Apps
https://developer.salesforce.com/docs/atlas.en-us.api_rest.meta/api_rest/intro_defining_remote_access_applications.htm
I need to generate an endpoint URL so that I can access all objects and records from that URL.
How to create that using a connected app. can you just help me?
I assume you have java or php code from where you will fetch Salesforce records and then push to SQL server.
Let me know if this is the scenario for which I need to provide the salesforce endpoints reference and steps?
In this case connected app don't required.
For this I have introduced java middleware earliear.
We need to create own API in java application then our server's endpoint will be call from Salesforce.
In java code by using JDBC ODBC driver we push the data in mysql server.
Unfortunately I don't have all code currently which required multiple steps as bellow.
If one time data export then I suggest to use dataloader.
Call External Services from Salesforce
https://trailhead.salesforce.com/en/modules/apex_integration_services/units/apex_integration_rest_callouts
Sample for Java and SQL connection
http://www.codejava.net/java-se/jdbc/connect-to-microsoft-sql-server-via-jdbc
Java Rest Sample
https://www.tutorialspoint.com/restful/restful_first_application.htm
Please start developing and I will assist if any issue in any steps.
This article suggest something without developing middleware.
Have a look if seems useful.
https://www.easysoft.com/support/kb/kb01050.html