-
So let me understand this: You have a "dataware house" based on SQL Server 2005? You have a native Dynamics NAV 4.0 database? You want the SQL datawarehouse to automatically read data from the native NAV database? Looking at your first post, then it looks like you're using the standard...
-
Dear Erik, well I want to merge some navision transactions / bookings (multiple clients) with some data which is stored in an access database into to let us named it dataware house. First I try to use SSIS but it didn't work either... So I tried the linked server alternative for the navision data...
-
So let me understand this: You have a "dataware house" based on SQL Server 2005? You have a native Dynamics NAV 4.0 database? You want the SQL datawarehouse to automatically read data from the native NAV database? Looking at your first post, then it looks like you're using the standard...
-
Dear Erik, well I want to merge some navision transactions / bookings (multiple clients) with some data which is stored in an access database into to let us named it dataware house. First I try to use SSIS but it didn't work either... So I tried the linked server alternative for the navision data...
-
[quote user="p_d2k"]You mean I should isolate the SQLServer and install NAVISION Server seperately on another box and have users having NAVISION Client to this NAVISION Server which in turn would communicate with the SQLServer. That means a good change in the Architecture....hmmmm[/quote] Not...
-
[quote user="David Singleton"] I am curious about opinions on this. Obviously if you are an ISV developing Add-Ons for many clients, or if you are on Native then this does not apply but... We all know that moving from Native to SQL is a common process, but does anyone move the other way? My...
-
I am curious about opinions on this. Obviously if you are an ISV developing Add-Ons for many clients, or if you are on Native then this does not apply but... We all know that moving from Native to SQL is a common process, but does anyone move the other way? My guess would be "pretty unlikely"...
-
Hi and welcome to the User Group, I would love to know exactly what it is that you're trying to accomplish with this. Maybe there's a better way to do it.
-
Hi and welcome to the User Group, I would love to know exactly what it is that you're trying to accomplish with this. Maybe there's a better way to do it.
-
In light of my last post about LS Retail, I wanted to bump this for more opinions. Thanks.