尝试使用 Apache Gobblin 使用 SOAP API 而不是 REST API 读取 Salesforce 数据 [英] Trying to use Apache Gobblin to read Salesforce data using SOAP API(s) instead of REST API

问题描述

我正在使用现有工具(主要基于 Apache Gobblin)将数据从客户的 Salesforce 表导入本地 MySQL 数据库(每个客户一个数据库).

I am working on an existing tool (heavily based on Apache Gobblin) to import data from customers' Salesforce tables into local MySQL databases (one database per customer).

该工具(按原样)适用于已启用 Salesforce REST API 的客户，但一位客户没有(也不会)启用它，只允许通过 Salesforce SOAP API 访问 Salesforce.

The tool works (as is) for customers who have enabled the Salesforce REST APIs, but one customer does not (and will not) have it enabled, only allowing access to Salesforce via the Salesforce SOAP APIs.

是否可以向 Gobblin 表明需要使用 Salesforce SOAP API 从 Salesforce 导入(提取)数据?(现有的 SalesforceExtractor 类 扩展了 RestApiExtractor；没有现有的 SoapApiExtractor 可以继承.

Is it possible to indicate to Gobblin that the data needs to be imported (extracted) from Salesforce using the Salesforce SOAP Apis? (The existing SalesforceExtractor class extends RestApiExtractor; there's no existing SoapApiExtractor to inherit from.

有没有人向 Gobblin 添加类以允许它通过 SOAP 从 Salesforce 中提取，以这种方式工作?

Has anyone added classes to Gobblin to allow it to extract from Salesforce over SOAP, to work this way?

现有的 Gobblin 文档表明它可以以这种方式工作，但我没有看到这样做的源代码.

The existing Gobblin documentation indicates that it can work that way, but I don't see the source code that does it.

推荐答案

我基本上编写了大约 250 行调用 SOAP 对象 getter 将其结果提供给 REST 对象 setter 的代码.非常相似的名称(在大多数情况下)和相当丑陋的代码，但它有效.

I basically wrote about 250 lines of calling SOAP object getters feeding their results to REST object setters. Very similar names (for the most part) and rather ugly code, but it works.

这篇关于尝试使用 Apache Gobblin 使用 SOAP API 而不是 REST API 读取 Salesforce 数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！