collegeimprovements
Hi ElixirCommunity,
We have a data-centric elixir project.
Currenlty we are using ecto-3, ecto_sql with postgres and oracle.
We need to fetch a lot of data from mssql but currently there is no adapter ready for ecto-3.
However, there is an adapter which relies on ecto-2 and support mssql.
Is there any way to use that adapter in same project ?
If not, what is the best way to fetch data from MSSQL database and use that data for api-calls or transferring that data to other dbs.
Where Next?
Trending in Questions
Other Trending Topics
Latest on Elixir Forum
Sponsor Spotlight
Elixir, Erlang & messaging conferences from Code Sync. Next up: ElixirConf US (10–11 Sep) & Code BEAM Europe (21–22 Oct), Haarlem + online.
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #library
- #deployment
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #elixirconf
- #channels
- #exunit
- #discussion
- #code-sync
- #podcasts
- #javascript
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #blog-post
- #elixirconf-us
- #elixir-ls
- #ai
- #phoenix_html
- #iex
- #graphql
- #genstage
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #api
- #forms
- #hex
- #security
- #metaprogramming
Our Sponsors
Build Elixir applications with speed and confidence.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Error tracking, logs, uptime, and Just Enough APM. Built for developers.
Elixir, Erlang & BEAM conferences from Code Sync - join us in 2026!
Practical resources that improve the lives of professional developers.
Bringing learning, work and compliance together since 1987.
**Building the future of software with AI, trust, and human connection.**
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"
Showing Posts 1 to 4- Show Best Posts
- Show All (oldest first)
- Show All (newest first)
Fl4m3Ph03n1x
If you want to connect to MSSQL, this article may be of relevance to you: GitHub - findmypast-oss/mssqlex: Microsoft SQL Server Adapter for Elixir · GitHub
Once you have a driver that works in place, there are many things you can do. Recently I just heard in Elixir Mix Daniel Serrano using Flow to read in parallel from a DB.
Link to Flow
I also know some people like GraphQL and the author of Search is rather active in this forum, as well as a really nice guy too ! (which I could remember his username, i’m sure someone will!)
So you have quite a number of options, it all depends on how much time you’re wiling to invest.
kokolegorille
The author of the graphql book is @benwilson512
collegeimprovements
Thanks for reply @Fl4m3Ph03n1x,
Our current apis are graphql-apis only
It’s great.
The only problem we are facing is - how to make mssql work!!!
One possible option is to downgrade everything to
ecto-2which doesn’t feel rightAnd I’m unable to make adapter work with
ecto-3andecto-sqlAny example implementation or reference about
ecto-sqlandmssqlortdswould help a lot.Fl4m3Ph03n1x
We don’t use mssql here nor ecto, so I am afraid I can’t be of much help. I did find a couple of articles that may help you out:
If this still doesn’t help, I recommend you create an issue in the github projects and ask the authors for some guidance or examples.
Reading the test files usually helps as well:
https://github.com/findmypast-oss/mssqlex/blob/master/test/mssqlex/query_test.exs