Does scribe support using Amazon RDS or Azure SQL as internal database source

[Manoj Chaurasia]

.

[Manoj Chaurasia]

I successfully set connection to azure SQL in ODBC Data Source manager, but get "[sql-DMO]SQL Server sqlserverscribe.database.windows.net must be upgraded to version 7.0 or later to be administered by this version of SQL-DMO." trying to create internal Database.

Some another error is present for AWS RDS with MS SQL.

IS it possible to use these sources to host Scribe insight internal data base

[Per Billing]

I got it to work with an Azure SQL after an upgrade of the ODBC drivers, but last I checked it is not supported by Scribe. And it is not a good idea. Even if I got it to work, it did not work well. The Azure SQL is to slow. I got really strange connection errors with the MS CRM adapter (after cheching it was timeouts from SCRIBEINTERNAL) and the preformance overall was really bad. So just installing a SQL express on the AZURE server hosting insight multiplied the preformance by 10-20 times.

[Manoj Chaurasia]

Hello Per, Thank you for replay about Azure, but also I would be happy if anybody could tell about experience with Scribe internal database on Amazon RDS too...

[Nils Frohloff]

Is using Azure SQL for Scribe Insight a supported scenario Maybe with a managed instance Or Single DB Or do we have to deploy an Azure VM with SQL Server