Passing Date into a Graph File

CloverDX Platform
1

Hi,

This is Vijay and I am new to Graph file coding. So it would be gr8 if you could help me on this.

I have a graph file which uses SQL query to connect to DB and generate a data file. I wish to pass a parameter date to the graph file accordingly from which date, details can be extracted.

I have attached my graph file here. It would be gr8 if you could suggest me in this regard…

<?xml version="1.0" encoding="UTF-8"?>

Thanks and regards,

Vijay Murali

2

Hi Vijay,

The functionality you are looking for is a part of commercial version of CloverETL. The component designed for such purposes is DBJoin (receives data from incoming edge, use them to join with data in a database). However, there is a workaround you might take into consideration. You can prepare the query in another component and send the whole query over the edge into DBInput.

3

Above suggested workaround could be done as follows:

  • Prepare the whole query in preceding component and assign it to output record.

  • In DBOutputTable enter the following:

port:$0.<QueryFiledName>:discrete

For more information about DBOutputTable please refer to: http://doc.cloveretl.com/documentation/UserGuide/index.jsp?topic=/com.cloveretl.gui.docs/docs/index.html