We run our DataWareHouse in Microsofts Datacenter, Azure. Our agent has outgoing traffic to the following IP addresses:
52.138.224.1
13.74.104.113
13.69.233.136/29
13.74.105.192/29
52.138.229.72/29
52.146.133.128/27
All traffic takes place at Port 1433 TCP.
SQL rettigheder.
For at kunne læse data på din SQL Server skal IFACT brugeren have følgende rettigheder
Datareader Denne role tillader at vores bruger kan hente data ud.
Viewstate Denne role tillader at vores bruger kan hente metadata ud om tabeller og kolonner. Denne er ikke altid oprettet pr. std. Sådan opretter du Viewstate rollen:
USE databasens-navn-her CREATE ROLE [db_ViewState] GRANT VIEW DATABASE STATE TO [db_ViewState]