如何每天从Oracle出口到Salesforce LOV？
我想将数据从Oracle导出到Salesforce。有办法这样做吗？
找不到直接连接的方法。
谢谢。
I would like to export the data from oracle to salesforce . Is there a way to do this?
can't find a way to connect directly.
Thank you.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
Salesforce仅公开休息＆amp; SOAP API访问，没有ODBC/JDBC/...直接连接到基础数据库。
在SQL Server世界中，有一个假定SF是远程服务器或任何术语的软件包（ https：// www .cdata.com/dbamp/），隐藏API访问的一堆存储过程等。对于Oracle World ...查看 https://sesamesoftware.com/salesoftware.com/salesforce/ ？ （我均不隶属于任何一个）
ETL和ESB工具（Informatica，Azure Data Factory，Talend，Mulesoft）也有SF连接器，并且付费了额外的与ODATA兼容的API 如果您喜欢的话。
如果您想自己推出某些内容 - Salesforce Data Loader和SFDX（您的SF Admin / Developer可能已经使用的工具）可以从Commandline脚本导入 /导入 /导出CSV文件。
或在Java / .Net / PHP / Python中编写程序。要么制作其余 /肥皂消息（有WSDL可以加快您的速度），要么有Ready Libraries＆amp;例子。
无论您对什么都感到满意。
Salesforce exposes only REST & SOAP API access, there's no ODBC/JDBC/... direct connector to underlying database.
In SQL Server world there's a package that pretends SF is a remote server or whatever is the term (https://www.cdata.com/dbamp/), bunch of stored procedures etc that hide the API access. For Oracle world... look into https://sesamesoftware.com/salesforce/ ? (I'm not affiliated with any of these)
ETL and ESB tools (Informatica, Azure Data Factory, Talend, MuleSoft) have SF connectors too and there's paid extra OData-compatible API if that's something you'd prefer.
If you want to roll something out yourself - Salesforce Data Loader and SFDX (tools your SF Admin / Developer probably already use) can import/export CSV files, can be scripted from commandline.
Or write a program in Java / .Net / PHP / Python. Either craft the REST / SOAP messages (there are WSDLs to speed you up) or there are ready libraries & examples.
Whatever you're comfortable with really.
您可以使用第三方ODBC和JDBC连接器，例如我们在Datadirect提供的连接器。 https://www.progress.com/connectors/salesforce
我们还提供哪个数据网关可以提供对Salesforce作为关系来源的访问权限，同时还为ODATA启用现有资源提供了一种方法（请考虑MSSQL，Oracle，Rest等）与Salesforce Connect一起使用 - 他们的外部数据功能可访问其居住的数据。
https://www.progress.com/connectors/connectors/cloud-data-integration
全面披露 - 我是datadirect的SE。
You can use 3rd party ODBC and JDBC connectors, such as the ones we offer at DataDirect. https://www.progress.com/connectors/salesforce
We also offer a data gateway which can provide access to Salesforce as a relational source, while also providing a way to OData-enable existing sources (think MSSQL, Oracle, Rest, etc) for use with Salesforce Connect - their external data feature to access data where it lives.
https://www.progress.com/connectors/cloud-data-integration
Full disclosure - I am an SE with DataDirect.