且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何在Microsoft SQL Server Analysis Services中使用MySQL作为数据源?

更新时间:2021-12-25 21:38:28

获取MySQL( 6.3.5 ).net连接器(来自MY SQL) 编辑连接字符串(在设计器中的连接字符串中粘贴),以使其具有新的"SQL SERVER MODE = True"选项.

Get the MySQL ( 6.3.5 ) .net connector ( from MY SQL ) Edit the connection string ( in the designer paste in the connection string ) so that it has the new "SQL SERVER MODE=True" option.

显然,它会影响性能-但是您该怎么办

Apparently it affects performance - but what can you do

我的示例连接字符串...(省略了密码和用户ID)

My sample connection string...(passwords & userids omitted )

server = svr215;用户ID =;密码=;持久安全信息= True;数据库= dw; sql server模式= true

server=svr215;User Id=;password=;Persist Security Info=True;database=dw;sql server mode=true