I am extending data warehouse with the use of OLE DB Provider for
Commerce Server.
I have come across several issues:
1. List of data types that I can use is rather limited (it can be
found in do***entation).
For example, I can't create a nvarchar(100) column - only
nvarchar(96) or nvarchar(112). This table will be synchronized with
external system, and there it is varchar(100). So, I shall potentially
have some problems with it.
Zip code cannot be just char(5) - only nvarchar(8).
State cannot be just char(2) - only nvarchar(8).
And so on.
2. When creating a new class, a table is automatically generated
for it. This table does not fully correspond with the class definition -
for example, all columns are nullable and there is no primary key.
Of course, this misscorrespondence is not critical for storing
objects (for example, we can store no-nullable values in a nullable
column). But it seems strange to me...
On the other hand, I can create tables for my objects manually and
work with them with the use of SQL.
What benefits do I gain when using OLE DB Provider for Commerce
Server for extending dw?
--
Yours faithfully,
Alexander Yushchenko
|
