Pipeline monitoring to API Access Only user
I am trying to access pipeline monitoring information using the SnapLogic public API. I am currently using the /api/1/rest/public/runtime/ endpoint. When I use my own user access the endpoint, I get ...
Forum Discussion
Attached is a sample pipeline with a couple of options using the Pivot Snap to produce results similar to what your sample pipeline appears to be attempting. Both options use the same logic - the second just brings the grouping back together if desired.
It may not be your target solution, and my expressions could need a little work, but I hope it helps some with the direction you want to go.
Community.10510_2021_08_05.slp (30.4 KB)
Thank You @del … This works but in my case the number and name of fields will be different from one file to other as I am creating a generic pipeline. Is there anyway to make the Pivot snap number of fields and field names dynamic.
I am also not sure about performance as this method is going to divide each record into x records based on the number of fields.
I appreciate you looking into the use case and providing directions.
No, for SnapLogic you do not need to have the JDK installed to use the JDBC Snap. You will need to configure the JDBC Account to use the necessary DB2 JDBC driver, and include any dependencies.
If not prerequisite software installation required means, what I need to provide under JDBC Driver Class while configuring JDBC account to access mainframe DB2?
@Amardeep_Shanmugam
JDBC Driver Class name - com.ibm.db2.jcc.DB2Driver
