使用 SSIS 将数据从 SQL Server 导出到 Oracle CRM On-Demand
我的公司已与 Oracle CRM On-Demand 签约，在不讨论该应用程序优点的情况下，我想了解 SO 社区中是否有人使用 SSIS 通过 CRMOD Web 服务从 SQL Server 导入数据。
如果是这样，随着时间的推移，维护它的经验如何？您在处理 Web 服务调用时是否经历过任何痛苦？
我希望能够让计划的作业从 SQL Server 中的 DW 获取更新信息到 CRMOD，并开始对其进行修改，但如果有人已经解决了问题并愿意分享一些细节，那将会有所帮助。
My company has signed on with Oracle CRM On-Demand, and without debating the merits of the application, I wanted to find out if anyone in the SO community is using SSIS to import data from SQL Server through the CRMOD web service.
If so, how is the experience been in maintaining it over time and have you gone through any pains in dealing with the web service calls?
My hope is to be able to have scheduled jobs take updated information from our DW in SQL Server over to CRMOD and have started tinkering around with it, but if anyone's already solved the problem and willing to share some details, that would be helpful.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
所以，我解决了我自己的问题。基本上，我从 SQL DB 导出数据，将它们加载到 CSV 文件中，并使用 CRMOD 通过基于 java 的 CLI 数据加载器生成的批处理命令和映射文件循环访问这些文件。 CLI 加载程序只是构建一个 Web 服务推送，只要您可以插入您的凭据，您就可以开始运行。
从 CRMOD 导出到 SQL 的工作仍在进行中，但这是另一篇文章的内容了。
So, I solved my own issue. Basically, I took exports of data from my SQL DB, loaded them into CSV files and looped through those files with a batch command and mapping file that CRMOD generates through the java based CLI data loader. The CLI loader just builds a web service push and as long as you can plug in your credentials, you're off and running.
Still in the works is the export out from CRMOD to SQL, but that's for another post.