AWS RDS SQL Server data source

b6e00bd4 0f67-49f9-b309-2ee4406124ab on 05 Jul 2020 22:59:41

RE: AWS RDS SQL Server data source

yes this needs to be over SSL too and support direct queries otherwise we won't use it!

714cbefe c748-463d-9eff-d86ddbbcf8f2 on 05 Jul 2020 22:58:51

RE: AWS RDS SQL Server data source

Shame there isn't any movement with this. I hope the small number of votes doesn't mean it's not important.

834077d1 1024-47c3-8510-ac1417b232f6 on 05 Jul 2020 22:58:03

RE: AWS RDS SQL Server data source

any update here

b6e00bd4 0f67-49f9-b309-2ee4406124ab on 05 Jul 2020 22:54:08

RE: AWS RDS SQL Server data source

Please add direct query too, otherwise the Enterprise gateway will have to run on a schedule to sync the data. Direct query is something most BI Visualization tools have out of the box, it's strange PowerBI doesn't.

31401fa9 dd42-42e4-a549-b7d1f336f861 on 05 Jul 2020 22:53:07

RE: AWS RDS SQL Server data source

You can leverage the on-prem connector offered by DataDirect's Hybrid Connectivity Services. With their patented on-premises connector technology, you won't have to open any ports. This Data API gateway offers secure access to on-prem data sources using standard OData or ODBC connections.

30c37280 3906-426d-b1d6-bb7df319e348 on 05 Jul 2020 22:46:02

RE: AWS RDS SQL Server data source

I just really need this, for real.

11edcb86 e4b8-4374-88f6-07f1c3e2b624 on 05 Jul 2020 22:43:21

RE: AWS RDS SQL Server data source

I can connect to RDS SQL Server by using SQL Server option and Direct Query. However a pro license is required when you "publish to web" from the desktop version.