Re: question about mining external databases and exporting mining models into pmml

Hello

Yes, it is possible to mine external databases, as long as those databases
have a provider that we can work with (OLE DB provider or .Net data
provider).
In particular, I think Oracle has both an OLE DB provider and a managed
provider. In Analysis Services, you should create a data source object using
the Oracle provider (say, OLE DB), then continue just like in the SQL Server
/ Access case.

On the second question: models' PMML may be exported with a statement like:
SELECT MODEL_PMML FROM [Model].PMML

SELECT * FROM [Model].PMML returns some extra information (such as size of
the PMML document, etc)

The feature is implemented for Clustering models and decision trees models
that:
- contain a single tree (a single predictable attribute)
- perform classification (and not regression)
Also, the feature may work for various plug-in algorithms



--
--
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Please do not send email directly to this alias. It is for newsgroup
purposes only.

thanks,
bogdan

<ziga> wrote in message
news:f5a528f2-5222-42ab-9ffb-efa3f329bf94@xxxxxxxxxxxxxxxxxxxxxxx
Hello!

Is it possible to mine external databases (for example Oracle) directly
through data source (ole db adapter) without having the copy of the same
database on sql server database engine. I tried to mine ms access database
directly from file (mdb) and it worked. I am asking this because I read
somewhere, that you need a copy of external database on sql server engine.

And another question about exporting mining models into pmml file. I found
only the way to create mining model from pmml but not the opposite way to
create pmml model from analysis services mining model. Is it possible to
export the model?

Thanks,
Ziga


.

Relevant Pages
Quantcast