Question Re: Adapter Property Sets in Technology Q&A

Adapter Property Sets

Former Member — Wed, 10 Jun 2015 11:57:56 GMT

Hello!

I'm having troubles trying to define adapter properties using environment variables (I'd like to use env variables instead explicit path declarations in order to improve project portability). As an example I have the following simple project:

As you see it just read streams using a CSV input stream adaptor with certain properties (by declaring variables explicitly like this, the project works properly as expected).

To get this more portable I'm trying to define the 'dir' parameter as an environment variable. To get that, I've modified the CCL file by defining a property set as follows:

... and then, declaring the properties in the corresponding CCR file as follows:

As you see, one of these properties (the 'dir' name) is now an environment variable, so I've also declared that variable on my Windows operating system:

... but now the project is not working and I cant figure out what is wrong (I can't see error traces regarding this). I've been trying different possibilities: as you see I've declared the variable at user level and also at system level, and also I've been playing with 'C:/TEMP' instead of 'C:\TEMP' and other things like that... but without positive results.

Am I doing something wrong...? Could somebody help with this...?

Thanks a lot in advance.

Pd.- Related with this: Is it possible in some way to read environment variables using CCL functions...?

Re: Adapter Property Sets

Former Member — Thu, 11 Jun 2015 08:33:09 GMT

I've found a solution to the problem: it seems that it is necessary to define environment variables according the host operating conventions. So for MS-Windows it should be something like '%ENV_VARIABLE%' instead of '${EN_VARIABLE}'.

For this specific case we have to declare:

<Property name="dir">%SAP_ESP_STREAMS_INPUT_DIR%</Property>

instead of

<Property name="dir">${SAP_ESP_STREAMS_INPUT_DIR}</Property>

... that's all

Re: Adapter Property Sets

Former Member — Thu, 11 Jun 2015 17:23:31 GMT

Hi Ignacio,

Regarding your question of:

"Pd.- Related with this: Is it possible in some way to read environment variables using CCL functions...?"

It is not possible to read environment variables using CCL functions.

Thanks,

Alice

Re: Adapter Property Sets

Former Member — Thu, 11 Jun 2015 17:42:45 GMT

Another thought regarding some way to read environment variables using CCL functions - an indirect approach: have some shell script that dumps output of env to a file and then load that file into a window and access it like that from CCL.

Re: Adapter Property Sets

andrzej_kucharczyk — Thu, 11 Jun 2015 17:47:49 GMT

Hello Ignacio,

I am happy you were able to find a solution to the problem. As far as being able to do this directly from CCL by calling a built-in function no unfortunately we don't have that functionality. Using CCR is your best option.

Regards,

Andrzej.

Re: Adapter Property Sets

Former Member — Thu, 11 Jun 2015 17:49:09 GMT

Nice clue.

Thanks a lot Alice!