top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How to view server connections of a session or workflow

+2 votes
400 views

As an SQA, I need to verify that all connections associated with a set of workflows have been updated. How can I view all connections associated with a workflow? Is there a connection, or connections, assigned to individual workflows, or would I need to find the connections for each individual session? If so, how do I view the connection(s) of a session?

posted Apr 11, 2016 by anonymous

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote

There may be plenty connections used by a single session - that's very often the point of ETL and data integration. Those connections used in session (or sessions!) may be defined in this session. But a session can use parameter for the connection that will be replaced with some value defined in a parameter file. A parameter file can be defined on the session itself, or it can be defined for a workflow. Or there can be some external utility that stores the configuration and executes the workflow with a generated parameter file that you will not find in the workflow definition at all.

There are some tools that would help you get all the connections for a session or all sessions in a workflow, but deriving the values for the parameters is more difficult. You need to know where they come from in your environment.

Please note that workflows and sessions hold the connection name only - where does it actually connect depends on the connection definition.

In addition, the very same workflow and sessions can be executed with different connection values, e.g. to perform the same set of operations on a different set of sources and/or targets.

answer Apr 18, 2016 by Manikandan J
Similar Questions
0 votes

For cleaning up unused IPC-Sources I need a Repository Query for getting Workflow, Session, Mapping and Source/Target of Mapping.I have startet by joining REP_LOAD_SESSIONS and REP_TBL_MAPPING on mapping_id but only a fraction of mappings seem to be present in the joined output. I can't find the right tables to join to get the job done. Any help will be greatly appreciated!

+2 votes

How to tune the session, workflow for better performance, what are the things we consider for better performance?

+2 votes

I have two sessions I a workflow like below

workflow1->session1->session2

I have a join_date column in a table in Mapping1 , in session1. I want to pick this join_date value and pass to mpping2/session2

If join date value changes in the table in session1 then the same value should pick and pass to session2. I will use this date value in a query in session2 .

Please suggest how to achieve this?

0 votes

I want to maintain audit information of each and every mapping in table which contains

workflow_name | start_time | end_time | source_success_rows | target_success_rows | error_record_count

i am able to do it using workflow variables assigning them with built-in session variables and then using the property of prevariableAssignment in session assigning the workflowflow variables to mapping variables of audit_session

It is working fine , But the issue is if i want to maintain audit for other mapping i have to create the whole process again . So is there any possibility of automating the process so that it does not require recreation of the whole thing again.

0 votes

I have a scenario where my source file name will be coming from one db table I have to read that value and pass it in the value of Source File Name in Session properties.

Till now I have tried like I have created 2 sessions where the 1st session will read the db table where the source file name is stored and store it in one mapping variable and in post success variable assignment I am assigning the mapping variable value to workflow variable and in the next main session I am trying to give the workflow variable in the session file name attribute .

But it is showing error like below

fail to expand variables in file field [$$WL_File].

How can I achieve this.

Please suggest some ideas.

...