September 12, 2023 at 2:26 pm
Hello I have a mysql data source and I want to use it as data source to my analysis service…
I could connect it through ssis and ssrs using odbc data source but I face a hard time finding odbc or ado.net data source in my ssas… can anyone help me with steps and photos how to connect to mysql data base
September 12, 2023 at 5:41 pm
Step 1 - check the docs:
things to note:
ODBC data sources are not supported for multidimensional solutions
AND if you want to connect to other databases, you need an "An OLE DB provider".
So a quick google for MySQL OLE DB brings me to this link:
https://stackoverflow.com/questions/56767350/wants-to-connect-oledb-with-mysql-in-ssis
Specific to SSIS, but the basics are the same. That should get you up and running.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply