cancel
Showing results for 
Search instead for 
Did you mean: 

Adding a python module for XIQ-SE scripting and workflows

Adding a python module for XIQ-SE scripting and workflows

Jave
Contributor

Hi,

Trying to access a distant SQL database from a workflow, I'm unable to import relevant python module. Is this natively possible or should I installed additionnal python module ? And if yes, how ? Older post talk about former XMC, but seems not to be effective in XIQ-SE.

Regards.

Jave

2 ACCEPTED SOLUTIONS

Robert_Haynes
Extreme Employee

Officially I do not think there is a means to import modules in either Python or Jython as used by XMC/XIQ-SE.

XMC/XIQ-SE includes python2.7/python3 command line interpreters but primarily uses Jython - a Java-based python interpreter for its GUI-based Python script executions.

While it's likely possible to tweak the system to use pip, etc to import modules for either I do not think formally this is supported.

 

To add formal support would be a product enhancement / feature request.

View solution in original post

Zdeněk_Pala
Extreme Employee

You may consider using the build-in driver. more details in the XIQ-SE licensing calculation workflow:

from com.ziclix.python.sql import zxJDBC

try:
    cnxn = zxJDBC.connect(url,emc_vars["dbUser"], emc_vars["dbPassword"], driver)
    mycursor = cnxn.cursor()
    mycursor.close()
    cnxn.close()
except:
    status = emc_results.Status;
    emc_results.setStatus( status.ERROR )
    emc_results.put("workflowMessage","MySQL Database access issue, check the password in Variables!")
    wf_error("MySQL Database access issue, check the password in Variables!")
else:
    wf_info("MySQL Database access OK.")
Regards Zdeněk Pala

View solution in original post

5 REPLIES 5

Zdeněk_Pala
Extreme Employee

You may consider using the build-in driver. more details in the XIQ-SE licensing calculation workflow:

from com.ziclix.python.sql import zxJDBC

try:
    cnxn = zxJDBC.connect(url,emc_vars["dbUser"], emc_vars["dbPassword"], driver)
    mycursor = cnxn.cursor()
    mycursor.close()
    cnxn.close()
except:
    status = emc_results.Status;
    emc_results.setStatus( status.ERROR )
    emc_results.put("workflowMessage","MySQL Database access issue, check the password in Variables!")
    wf_error("MySQL Database access issue, check the password in Variables!")
else:
    wf_info("MySQL Database access OK.")
Regards Zdeněk Pala

External SQL use example: Import credentials from MySQL to local repository

 

Regards Zdeněk Pala

Hi @Zdeněk_Pala ,

I had actually seen your workflow working through system calls but I was not aware of this built-in driver: thank you very much, it meets my needs !

Regards,

Jave

Robert_Haynes
Extreme Employee

Officially I do not think there is a means to import modules in either Python or Jython as used by XMC/XIQ-SE.

XMC/XIQ-SE includes python2.7/python3 command line interpreters but primarily uses Jython - a Java-based python interpreter for its GUI-based Python script executions.

While it's likely possible to tweak the system to use pip, etc to import modules for either I do not think formally this is supported.

 

To add formal support would be a product enhancement / feature request.

GTM-P2G8KFN