 | 1 | initial version |
Hello Unmet!
I am just curious if there is an alternate way of opening a .sql file other than writing an Open Studio reporting measure or using Dview. I would like to manipulate the .sql data via Pandas in python but upon some research, I've found that that would require a remote database connection?
In other words, Is there a way to open an existing .sql file in python, make queries to the E+ data tables, and then use that data?
Any guidance would be appreciated!
| | 2 | retagged |
Hello Unmet!
I am just curious if there is an alternate way of opening a .sql file other than writing an Open Studio reporting measure or using Dview. I would like to manipulate the .sql data via Pandas in python but upon some research, I've found that that would require a remote database connection?
In other words, Is there a way to open an existing .sql file in python, make queries to the E+ data tables, and then use that data?
Any guidance would be appreciated!
