Can we create custom view in Google Big Query using the data set provided by SAP Emarsys?

[govinda_07]

Hello Experts,

I would like to understand if someone is using the Open Data feature of SAP Emarsys and have being building custom view in Google Big Query using the standard data set provided by SAP Emarsys. Is this possible in GBQ to generate some custom view and pull the data to third party system like SAP CDP via APIs.
Also if we can attach the customer number maintained as custom field in SAP Emarsys with the contact_ID imported to GBQ just to make sure that when we import these data to 3rd party system it become easy for analyst to relate the data with customer database.

Thanks
Govinda Parate

[SaurabhD1]

Hi govinda_0705,

Yes, it is possible to create custom tables/views in your google workspace under editable dataset. You can also send this data to other third party applications by scheduling jobs. Applications such as PowerBI can directly connect to GCP for accessing data and don't need to schedule any jobs explicitly.

You can also create custom field as you mentioned on contacts and export this data from Emarsys and upload it into your custom views/tables in editable dataset in GCP. However, you have to ensure that you are joining this uploaded data with the standard views provided by Emarsys so that you can relate them and send engagement data to any 3rd party applications.

Hope this is helpful !

Thanks and Regards,

Saurabh Deshpande