We have a requirement to accomplish Salesforce to Oracle Integration.
Phase 1 of the requirement says whenever a record or bulk upload is done for an object called say TestObject then in 4 to 5 mins or max 4 to 5 hours record should get saved/immediately reflect in Oracle. The Data should be sent from Salesforce in JSON format and will be received from Oracle in JSON format and that needs to be saved in Salesforce using REST API.
Thank You,Thank You & Thank You for any help :)
I need your help.
I have requirement of integration(Salesforce to Oracle Integration Cloud).
As we know OIC is the configuration tool. Trying to do but data get's failed.
I'm trying to connect my existing database with salesforce via heroku connect. I was able to synchronize the two solutions.
However, I wanted to know how to do complex matching.
First I would like to create lead / account / opportunity from my other application, I have synchronized my objects however I don't know what is the right method for this type of problem.
For example, I have in my existing application a companies table and a company_contacts table, I would obviously like to link my company to my custom object account as well as create leads for each new contact from my company_contacts table and that they keep their relationships.
Do you have any examples on this kind of use case? Is this the right way to synchronize my salesforce with my existing database? Knowing that I have thought of another much less pretty solution the RULES of postgres in order to fold on the salesforces tables the changes made on my existing base.
If anyone could elaborate on the best way(s) to integrate a SQL database with Salesforce Big Objects, that would be super helpful. Open to C#/.Net implementations ([we use this currently]), SQL Server connectors/adapters, 3rd party connector platforms, anything. Thank you!
We require to expose the Heroku Postgres Object into Salesforce as an External Object.
I know it is achievable with the help of Salesforce Connect, but that involves additional Licencing, hence looking for other possibilities without incuring additional costs.
Below is one of the option I think of but not sure if it can be achieved:
User uploads files in Salesforce. But it should actually save to SharePoint/Google Drive. User should not know that, file is being saved in SharePoint and Only the Reference to the files should be in Salesforce.
After save, User can access all these files and when he/she should clicks the file in Salesforce, it should pull the data from SharePoint and display it for him. So this way we will not use memory in Salesforce.
Any other suggestions are greatly appreciated.
Thanks in advance.
Can anyone help me how we can do this using third party app or any other way we can intergrate salesforce with google drive
Example if our users table email updates, we'd want to update the associated email on the person account, etc.. seems simple just looking for an experienced voice on how they did this without costing a fortune and using old ETL strategies and or tons of single API calls.
Thanks for all and any advice!
I have a requirement where we have data in mysql database and apex should be coded in such a way that it gets data from mysql and display on visualforce page. I donot have any idea on how to integrate Salesforce with mysql database.
I am looking for solutions on how to replicate and sync SF to a local database.
The three tools that I am considering are:
What are your experience using any of these products?
Are there any other that I have missed?
They need to work with a postgreSQL database, two way sync, custom fields and objects, attachments.
All comments are appreciated.