Adding a python module for XIQ-SE scripting and workflows

[Jave]

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

[Robert_Haynes · Accepted solution]

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.

[Zdeněk_Pala · Accepted solution]

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.")

[Zdeněk_Pala · Accepted solution]

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.")

[Zdeněk_Pala]

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

[Jave]

Hi,

After upgrade to latest version of XIQ-SE, I have now this error for scripts using mysql JDBC driver:

driver [com.mysql.jdbc.Driver] not found

but it runs correctly using "org.postgresql.Driver".

How can I correct this ? Is it related to XIQ-SE database migration from mysql to postgres ?

Regards.

[Robert_Haynes]

I would imagine so. All things MySQL are being removed as a result of the migration. Do you need mySQL for the purpose of the workflow since you've upgraded SE to 24.7+?