Fielglass integration

[former_member1363883]

Hi Team,

We are trying to integrate Fieldglass data to Oracle Warehouse, We tried to do REST API using available connectors but we are being blocked at each step as we are donot have admin rights to the portal.

For an instance, we need additional columns other than that are available in the basic connector and we cant enhance the connector .

we are looking for different ways to get the Fieldglass data automatically (we use PowerShell)

Can you please let us know other than REST API how else we can get the data from Fieldglass?(If we can directly access the tables)

This is really blocking our development. Quick help is really appreciated.

Thanks,

Mounika

[AlexGourdet]

Thank you for visiting SAP Community to get answers to your questions.

Since you're asking a question here for the first time, I'd like to recommend you with the following steps so you can get the most out of your community membership:

• Please see: https://community.sap.com/resources/questions-and-answers as this resource page provides tips for preparing questions that draw responses from our members
• Consider to take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html. as that will help you when submitting questions to the community.

I also recommend that you include a profile picture. By personalizing your profile, you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html.

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

All the best,
-Alex

[brian_cicirello]

Hi, Mounika:

Column edits on connectors can be handled via a Configuration Manager user role. You will need to check with your company administrator(s) or program manager(s) to see if your organization is using SAP Fieldglass Configuration Manager.

Both native and custom fields can be added to the connectors via Configuration Manager. Once a Configuration Manager user logs in, the user can select View Integration Connector, select the connector in question, click "Edit," then navigate to the "Customize Fields" menu on the left side of the connector enablement wizard.

[former_member1363883]

Thanks Brian for quick response!

We are looking for different ways to get the data, wondering if we have other ways to fetch the data from fieldglass tables other than REST API?

can you please provide some insights on that?

[former_member1363883]

Also, if we do change the Fieldglass provided connectors like SOW download,is there a way that the custom fields added to it are only accessible to specific users?

[brian_cicirello]

Hi, Mounika:

The API will really be your best bet, either by using the direct module connector for the data you want to pull or by creating a report within the Reports module and calling it down in a similar manner. To my knowledge, there isn't another fetch method involving direct table access. That said, the connectors are really flexible in terms of what you can add to them so it's really not that far off from direct access.

If you add a field to the connector, whoever has access to run the connector, access the Integration Audit Trail via the UI, or has access on your end to the pulled data would be able to see it. For the connector and AT access, that should be governed by a user role permission. Once you pull the data, though, the app really has no way of managing user access since the data are no longer in the SAP FG application.

--Brian

[former_member1363883]

Thanks Brian! We have started using connectors to download the data and replicate the architecture in our warehouse.

We started using SOW Download Connector but we don't seem to get "SOW worker role" field (need it even though no active contractors exists for a sow).

We see the below sub modules under statement of work, do we have to create separate connectors for each of them or can they be included in the SOW Download connector?

What would be the best way to replicate the Fieldglass data in data warehouse through connectors?