>>>> Yes. I was aware of that setting. But wouldn't the user be able to simply change that setting? <<<<
In the world of Windows, you can deploy what is called Windows group policy that prevents users from making such a change (or to require a password to allow for a change) - not just for ODBC parameter but for any other areas in Windows clients as well. Please consult a Windows system admin expert on this matter.
Original Message:
Sent: Thu November 02, 2023 04:33 PM
From: Elden Fenison
Subject: MS Power BI
Yes. I was aware of that setting. But wouldn't the user be able to simply change that setting?
You can set the "read-only" attribute in IBM i Access ODBC Setup: Server tab --> Connection Type attribute as shown below. This attribute has been around since very early ODBC driver from AS/400 time.
------------------------------
Elden Fenison
Original Message:
Sent: Wed November 01, 2023 10:16 PM
From: Satid Singkorapoom
Subject: MS Power BI
Dear Elden
You can set the "read-only" attribute in IBM i Access ODBC Setup: Server tab --> Connection Type attribute as shown below. This attribute has been around since very early ODBC driver from AS/400 time.
------------------------------
Chance favors only the prepared mind.
-- Louis Pasteur
------------------------------
Satid S.
Original Message:
Sent: Wed November 01, 2023 11:36 AM
From: Elden Fenison
Subject: MS Power BI
Thank you Andy. I was able to get the ODBC connection working. My boss (who has little IBM i experience) has specified we should make this connection using a "read-only" user. I've never heard of such a thing on the IBM i. Don't really know how I'd do that. We are not doing any kind of granular security on our i. I wonder if ODBC is already read only by definition?
Hi ! Yes we use it in my company.
you can use the oledb driver Or the odbc driver that can be downloaded from « access client solution » download page.
If you use oledb, you can use the db2 driver from powerbi data sources. I had some problems with this.
I prefer using odbc which is more convenient to configure, I didn't find any limitations
I hope it helps
------------------------------
Elden Fenison
Original Message:
Sent: Wed November 01, 2023 02:53 AM
From: Andy Malo
Subject: MS Power BI
Hi ! Yes we use it in my company.
you can use the oledb driver Or the odbc driver that can be downloaded from « access client solution » download page.
If you use oledb, you can use the db2 driver from powerbi data sources. I had some problems with this.
I prefer using odbc which is more convenient to configure, I didn't find any limitations
I hope it helps
------------------------------
Andy Malo
CAFAT
New-Caledonia
Original Message:
Sent: Mon October 30, 2023 07:36 PM
From: Elden Fenison
Subject: MS Power BI
Has anyone had experience getting Microsoft Power BI to work with the IBM i? Can you provide any tips?