There is very little documentation that I can find on how to connect the Azure marketplace SAS Viya (Pay-as-you-go) with the Azure SQL within the same subscription. Please could someone share the steps required. ... View more

I am trying to configure either an ODBC or OLE DB connection between Power BI and SAS GRID 9.4 M6. I have struggled to find content online to help. Therefore, I thought I'd share what steps I have done but also I'm a little bit stuck.   OLE DB I have successfully connected to my environment after installing the OLE DB drivers from November 2018. The connection string is the following:    provider=sas.IOMProvider;data source=iom-name://SASApp - Logical Workspace Server;sas port=0;sas protocol=2;sas metadata user id=<userid>;sas metadata password=<password>;sas metadata location=iom://<SAS Metadata Server Address:8561 I guess the good thing is that I can connect and can see the default SASHELP and MAPS libraries. Problems: I cannot see any other tables. How do I expose additional data? There are pre-assigned libraries in the metadata but none are exposed to the OLE DB. I can see these libraries in other SAS tools (SAS Studio etc). I have tried adding the following at the end of the connection string. None of the tables in that library were visible. SAS Workspace Init Script="LIBNAME libref 'path'"; Question: What am I missing to expose this data?     ODBC I managed to configure the ODBC for SAS drivers on my laptop after installation to connect to the SAS/SHARE server running on the environment. I had a similar results to the OLE DB where I was only getting SASHELP and MAPS libraries. My system admin looked to add additional libraries within SAS/SHARE to expose them to PowerBI but now I am getting the following error: Error Message: Container exited unexpectedly with code 0xC0000374. PID: 7536. Used features: Odbc.DataSource/SASDRV32.DLL/09.04.0000/SAS/9.04.01M6P110718. My system admin can see that the connection is being created as before and there's no error messages in the logs. I've tried to search for a resolution for this code without finding one. Question: Does anyone have any suggestions? ... View more

Hello all,   In my team's processes we are expected to add the status handling option to all jobs and have it send an entry to a dataset.   We are now left with a large amount of these datasets where we do nothing with. I've had a search on this forum and on the web and I can't find any examples of what people do with these datasets after they are created.   Initially, we thought that it would provide a good quality audit trail of how data is processed and we might then start using them for reconciliations between ETL layers. However, in the years of us creating these datasets, we have never used them at all.   I'm wondering "Whats the point?" and thinking if I can't find a use, I'll start to remove them.   Please can people share some uses of these datasets?     ... View more