I am in the middle of a migration project of a DW from MSSQL to Netezza and I am stuck in a problem which I'm positive it's ridiculous to solve, but I have failed hardly on trying to do so. I was hoping you guys could enlighten me up regarding this issue.
Part of this migration is to refactor the applications that queried MSSQL to query Netezza now, and I am currently trying to redeploy and test the SSAS Cubes using Netezza as one of it's data sources to retrieve data and process the dimensions.
I have already set the DS properties properly using Netezza OLEDB driver and connected successfully via "Test Connection". Also, on Visual Studio, I was able to edit the named query of the desired dimensions and run them without any errors.
But my problem now is that whenever I deploy the solution and try to process this dimension in SQL Management Studio I keep getting the
"Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'RDW_DS'"
I've been told this error might be related to my ImpersonationMode. When I change the data source to the original MSSQL DW and use my Windows domain account, it works perfectly, but since AD isn't federated in the Netezza PDA appliance, I am using the admin user/pass credentials.
Do you guys have any suggestion on how to handle this problem?
Thanks in advance, Enrico
I somehow found a way to get it working! I had to install the NZ .NET Driver to get the NZOLEDB driver to work properly, then I could run the processing using my windows domain user with privileges on the MSSQL server as ImpersonationMode.