[Typo3-shop] Feature: Linking shop to external db

[Franz Holzinger]

Hi Ådne,

Typo3 has already a DBAL (database abstraction layer).
http://typo3.org/documentation/document-library/doc_core_inside/Introduction-007fde5ccf/?encryptionKey=&cHash=71a1b43ea7

This has been used by tt_products but not by zk_products. I will 
implement this later, when the new tt_products has proved to work 
together with the bring in of zk_products. So if you do not use the 
zk-extension you need to look if DBAL does already supports MSSQL. I 
guess it does.

Or you write a shell script which copies the data from the external 
database to the Typo3 database.

Franz


Ådne Hovda schrieb:
> One of our clients has a Navision system with all their products in an 
> MSSQL-db.
> 
> How can it be possible to fetch prices, in-stock status and other data 
> from another database and integrate this into the product-listing?
> 
> Would the better solution be to be able to replace the price-field or 
> maybe _any_ field from the tt_products table with a sql-query? (now, 
> that would be nice...)
>