using NoSQL database with SSRS

I have a web application that uses ssrs 2016 for reports.  I am looking at moving the sql database to a nosql database, but don't know how to maintain the reports I have created.  Any ideas?
dan hendersonAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Russell FoxDatabase DeveloperCommented:
I know I'm six months late to this party, but I was just reading up on SQL Server 2019 and it has the ability to query MongoDB and Hadoop directly. Otherwise, you're probably looking at creating an application that takes the NoSql data and puts it into a relational db for reporting purposes.

You can also look into other reporting products like Tableau that have NoSql connectors.

My last idea is to start using an "event sourcing" system where transactions are put into an event bus and multiple listeners can do things with those events, updating both your NoSql db and a relational, reporting db. It's a big change to your environment, but event sourcing has some major advantages in DR and auditing.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dan hendersonAuthor Commented:
thanks for the answer.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.