Access Pulse Database for reporting via Python

Has anyone tried to access Pulse DB from python library. We are trying to connect via psycopg2 but not able to. the DB opens fine with the browser via same username/password and port.

When we try via python it seems to error out

*import psycopg2*
  • conn=psycopg2.connect(database=“jdbc:h2:docs”, user = “reader”, password = “”, host = “xxxxx”,port=“xxxxx”)*

  • cur = conn.cursor()*

  • docs = cur.execute(‘Select * from Migrationpackage’)*

  • print(docs)*

image

1 Like

hi @shallabh.khera,

We have not tested python connectors to connect to the Database. are you using the H2 ODBC driver provided here:

Regards,

Erik

1 Like

Apologies for a late response - we had been able to use ODBC connection and used pyodbc library :slight_smile:

Appreciate your support.

Hi @ecarmona

Some Qs:

  1. Further to this we are trying to build a check required by our audit team to confirm that the pro and rux changes deployed on TM1 have gone through Pulse package migration. we have found that if the dimension is included in package the Migrationpackage table has the data in “items” column but if package only contains process to be promoted the column “items” is empty {}

Before creating the package
- confirmed that instance configuration is correctly setup
- Run documentation for instance XYZ, completes successfully

Crate Package
- Select Source - Manual
- Select Instance - XYZ
- Import documentation - checked
- Check Process radio button - and select a process, create package
Nothing comes up in Items column in “MigrationPackage” table
- Include dimension and may or may not include process
Objects come up in Items column in “MigrationPackage” table

  1. We would also like to know how to retrieve Pulse DB password programmatically as we will be building postgreSQL ODBC connection via our automated build pipeline.

  2. Our current Ver of Pulse that we are using - 5.8.0 - would like to understand when(tentatively) can we expect release of ver 6.0 (even Beta would be helpful)

1 Like