The complete details about the presentation are located on the repo's wiki.
This assumes you're comfortable with setting up python and connecting to CAS via swat. If you're a little unsure, I'd recommend looking at the Official SWAT Documenation
I'm also assuming that you're connecting to a SQL Server DB. You may have to create your own connection class tha generates the needed connection object.
-
Clone Repo
git clone https://github.com/willhaley-bne/SASUGF-2020-Python-Viya-Limited-Resources -
Set Up Python Environment (developed on 3.7)
cd SASUGF-2020-Python-Viya-Limited-Resources
python -m venv venv
source venv\bin\activate
pip install -r requiremnets.txt -
Update Code with your connection information
url = None
user_name = None
password = None
port = Noneserver = None
username = None
password = None
driver = '/opt/microsoft/msodbcsql/lib64/libmsodbcsql-13.1.so.9.2' -
Update Example Report with your own information
source_sql = ''
cas_table_name = ''
caslib = '' -
Make sure your have the CAS_CLIENT_SSL_CA_LIST environment variable set
-
Run the script
python app.py --report ExampleReport
You should now see the data in your CAS library.