topic Re: Unable to add UDF to qlik in Qlik Replicate

Unable to add UDF to qlik

kareem15 — Wed, 04 Dec 2024 01:14:05 GMT

Hi team ,

I had complied a UDF and generated dll and .so file . when I followed the steps from Document , i couldn’t see my UDF in qlik under expression builder>>functions>>UDF .

need some help on this . please let me know if additional details needed

followed this .
https://help.qlik.com/en-US/replicate/November2023/Content/Global_Common/Content/SharedEMReplicate/Customize%20Tasks/user_defined_transformations.htm#:~:text=the%20Expression%20Builder-,User%2Ddefined%20transformations,%3CINSTALL_DIR%3E%5Caddons%5Csamples%5CMyTransformation,-Information%20note

Re: Unable to add UDF to qlik

DesmondWOO — Wed, 04 Dec 2024 04:39:23 GMT

Hi @kareem15 ,

Thank you for reaching out to Qlik Community.

We have a sample program, MyTransformation.sln, located in the addon folder. Please build it and you will get a dll file. If successful, you should find "prefix_with(X, Y) under "User defined".

If problem persists, please attach your addons_def.json.

Regards,
Desmond

Re: Unable to add UDF to qlik

kareem15 — Wed, 04 Dec 2024 16:21:23 GMT

Thank you for the suggestion , let me try that

Re: Unable to add UDF to qlik

kareem15 — Wed, 04 Dec 2024 16:25:24 GMT

Do we need to Build the code at the place where Qlik is installed?
in my case Qlik is installed in VDI (remote)
can I build the code in my local and move the Dll file to specific folder and find UDF in qlik ?

Re: Unable to add UDF to qlik

john_wang — Fri, 06 Dec 2024 08:56:05 GMT

Hello @kareem15 ,

The UDTF can be compiled on any Windows machine. However, due to module dependencies, ensure the module is built in Release (not Debug) mode. Once the compilation is complete, copy and distribute the resulting DLLs to the appropriate Replicate machines.

The similar discussion can be found at Qlik replicate sample Functions not showing up in UI.

Hope this helps.

John.

Re: Unable to add UDF to qlik

kareem15 — Fri, 06 Dec 2024 19:15:08 GMT

thank you for Response .
I am using MAC and i generated dll using below command :

gcc -shared -O2 -o MyTransformation.dll MyTransformation.c \
-I/opt/homebrew/opt/openssl@3/include \
-L/opt/homebrew/opt/openssl@3/lib -lssl -lcrypto

and copied the dll to - D:\Program Files\Attunity\Replicate\addons\samples\MyTransformation
and restarted the qlik service , still I could not see UDF in qlik
sharing screenshots and addons_def.json below

addons_def.json:

{
"addons":
[
{
"name": "MyPasswordProvider",
"type": "STARTUP",
//"lib_path": "samples\\MyPasswordProvider\\MyPasswordProvider.dll",
//"lib_path": "samples/MyPasswordProvider/MyPasswordProvider.so",
"init_function": "ar_addon_init"
},
{
"name": "MyTransformation",
"type": "STARTUP",
"lib_path": "samples\\MyTransformation\\MyTransformation.dll",
//"lib_path": "samples/MyTransformation/MyTransformation.so",
"init_function": "ar_addon_init"
},
{
"name": qlik_encryption
"type": "STARTUP",
"lib_path": "samples\\MyTransformation\\qlik_encryption.dll",
//"lib_path": "samples/MyTransformation/qlik_encryption.so",
"init_function": "ar_addon_init"
}
]
}

Re: Unable to add UDF to qlik

kareem15 — Fri, 06 Dec 2024 19:15:49 GMT

As I am mac user , do i need to generate .so file and use that instead of DLL ?

Re: Unable to add UDF to qlik

Heinvandenheuvel — Sat, 07 Dec 2024 02:33:02 GMT

"As I am mac user , "

Personally I would never ever use a MAC to build a Windows target executable, but that's me. KISS.

Google response to "mac gcc for windows execution" ===>> "To use a Mac's GCC compiler to compile code that will run on Windows, you need to perform a "cross-compilation" by installing a Windows-targeting toolchain on your Mac, typically using a package like MinGW (Minimalist GNU for Windows) or Cygwin which provides a Windows-compatible environment on your Mac, allowing you to compile code that will run on a Windows system" ... Followed by detailed instructions on using -m64 and pointing to Windows libraries.

Unfortunately our post does not give any indication whether something like that is being used.

hth,

Hein.

Re: Unable to add UDF to qlik

kareem15 — Tue, 10 Dec 2024 17:30:03 GMT

I switched to windows and build in release mode .
below are the screenshots based on steps for mentioned above :

dll got generated in below folder and we moved it to sample\mytransformation

My repcmd log file :

Re: Unable to add UDF to qlik

kareem15 — Tue, 10 Dec 2024 17:31:30 GMT

Still cannot see the UDF , any further help will be appreciated

Re: Unable to add UDF to qlik

kareem15 — Tue, 10 Dec 2024 19:55:22 GMT

My Build Config :

Re: Unable to add UDF to qlik

kareem15 — Thu, 12 Dec 2024 02:20:52 GMT

Issue is resolved now , thank you for the support

Re: Unable to add UDF to qlik

john_wang — Thu, 12 Dec 2024 02:33:39 GMT

Thanks for the update @kareem15 . Would you please share the final solution?

Regards,

John.

Re: Unable to add UDF to qlik

kareem15 — Thu, 12 Dec 2024 16:11:46 GMT

Issue is with the addons_def.json file .
I made below changes in my json and it worked

Re: Unable to add UDF to qlik

john_wang — Fri, 13 Dec 2024 01:25:29 GMT

Thank you so much for the cliarification! @kareem15