RavenDB 4 SQL ETL Connection String

[Jordan Brown]

Do you have documentation on how to format a MySQL connection string for a SQL ETL task? All the connection string links I see in the docs point to a "todo-update-me-later" page.

I tried using a connection string that worked in 3.5, like this:

Persist Security Info=False;Server={Server};Port={Port};Database={Database};Uid={User};Pwd={Password};CharSet=utf8mb4

When I paste this into a new task in studio and test connection, I get an error:

Connection test failed: System.ArgumentException: Keyword not supported: 'port'. at System.Data.Common.DbConnectionOptions.ParseInternal(Dictionary`2 parsetable, String connectionString, Boolean buildChain, Dictionary`2 synonyms, Boolean firstKey)

When I try to create a task programmatically via SqlEtlConfiguration / AddEtlOperation, I get this error:

Raven.Client.Exceptions.RavenException: System.NotImplementedException: Factory 'MySql.Data.MySqlClient' is not implemented yet

Thanks in advance for any help you can provide.

[Oren Eini (Ayende Rahien)]

What build are you using? 

The standard MySQL .NET connection string should work.

Something like this:

Server=myServerAddress;Port=1234;Database=myDataBase;Uid=myUsername;
Pwd=myPassword;

Hibernating Rhinos Ltd  

Oren Eini l CEO l Mobile: + 972-52-548-6969

Office: +972-4-622-7811 l Fax: +972-153-4-622-7811

 

--
You received this message because you are subscribed to the Google Groups "RavenDB - 2nd generation document database" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ravendb+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Arkadiusz Palinski]

SQL ETL to MySQL is supported from 4.1. Raven 4.0 supports sending data to MS SQL only (that's why you got NotImplementedException). You can download version 4.1 nightly from:

https://ravendb.net/download#dev/nightly

To unsubscribe from this group and stop receiving emails from it, send an email to ravendb+u...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "RavenDB - 2nd generation document database" group.

To unsubscribe from this group and stop receiving emails from it, send an email to ravendb+u...@googlegroups.com.

[Arkadiusz Palinski]

Note that in RavenDB 4.1 you'll need to choose SQL factory:

[Jordan Brown]

Do you have an ETA for releasing 4.1 stable? We are trying to migrate from 3.5 to 4 since only provisional licenses are available for 3.5. Our infrastructure depends on SQL replication / MySQL, so this would be a showstopper for us.

[Oren Eini (Ayende Rahien)]

Planned for August

To unsubscribe from this group and stop receiving emails from it, send an email to ravendb+unsubscribe@googlegroups.com.