Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1171
  • Last Modified:

How to write TNS entry for salesforce.com server

Hi All,

I need to write TNS entry for salesforce.com to connect from organisation database.
like..
test_db =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hydhtc100350)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = test)
    )
  )

Also can i connect to salesforce.com server from my organisation server (SQL Server).

Thanks in advance.
0
SivaKumarArepogu
Asked:
SivaKumarArepogu
1 Solution
 
pauldesatadvologixdotcomCommented:
In answer to your connectivity to SQL server, the best option is dbAmp from Forceamp.com. It installs to your SQL server as an SQL Linked Server and uses a provider that installs to the server and connects to your salesforce.com instance.

You can read more about it in this post.
http://www.experts-exchange.com/Database/Software/CRM/Salesforce.com/Q_24110988.html?sfQueryTermInfo=1+dbamp

As for TNS, I'm not sure what that means. Can you clarify? It looks like you are looking for some sort of API access? If so, check out the salesforce.com API docs. Here is the SOAP sample for initiating a session with salesforce from an external source.

http://wiki.apexdevnet.com/index.php/PartnerLogin

The full API docs/samples are here:
http://wiki.apexdevnet.com/index.php/Web_Services_API#API
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now