IBM Support

Extracting Data from multiple tables using Data Extract

Question & Answer


Question

How to extract data from multiple tables using Data Extract feature of IBM Commerce on Cloud?

Answer

Data Extract by default is run on a per-table basis.

If you want to extract data from multiple tables(JOIN), you can create a VIEW and extract the data from the VIEW using Data Extract functionality.

In order to create a new VIEW , you need to open a case with IBM Support to reach out to the App Delivery team and provide the syntax of CREATE VIEW command which needs to be executed. App Delivery and Dev Ops teams will then review and likely have a discussion with your team to ensure there is unintentional impact due to the view specifically on the system performance.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSWT7D","label":"Commerce on Cloud"},"Component":"","Platform":[{"code":"PF016","label":"Linux"}],"Version":"17.x,18.x","Edition":"","Line of Business":{"code":"LOB31","label":"WCE Watson Marketing and Commerce"}}]

Document Information

Modified date:
17 October 2018

UID

ibm10716311

Page Feedback