Warehousing basics (OpenInsight)
At 11 MAY 2001 11:22:05AM Monroe County wrote:
We're trying to develop a data warehouse based on MS SQL 7.0 (soon to be upgraded to 2000). We would like to start filling this warehouse with data collected in AR tables. We'd like to use Open Insight as the data-pump.
We're extreme beginners - and so I have a number of questions that aren't covered by the documents online:
1. If the data we want to pump from LH tables is on a novell network server, and the SQL server is on a Windows 2000 server, which network driver do we use?
2. We want the Open Insight software on a network server, but which one is best for it to reside on?
3. Would a connection between the AR data and the SQL server constitute a user?
4. The production data has an AR application on the front of it - do we need to be worried about how this application may or may not affect the data 'spilling' out the backend to the SQL server?
Maybe this is enough to start- thanks for your help
At 15 MAY 2001 11:31PM winwin/revelation support wrote:
]]1. If the data we want to pump from LH tables is on a novell network server, and the SQL server is on a Windows 2000 server, which network driver do we use?
The OI driver MUST match the Arev driver or you will experience data corruption.
Thus, if Arev Front end is server from Novell, then the OI should use the Novell Driver too.
]]2. We want the Open Insight software on a network server, but which one is best for it to reside on?
It should sit on the same kind of network as the Arev.
]]3. Would a connection between the AR data and the SQL server constitute a user?
OpenInsight accessing the AR tables is a user. The ODBC connection to the server will not be another user.
]]4. The production data has an AR application on the front of it - do we need to be worried about how this application may or may not affect the data 'spilling' out the backend to the SQL server?
I'm not sure I understand the question. OI can read the data while Arev is updating the same tables, unless the Arev programmers put Exclusive locks on the tables. You may need to worry about concurrency and or referential integrity.
Hope this helps
Bob