Open Forum

Expand all | Collapse all

Business Central SaaS - Database Access best practices?

  • 1.  Business Central SaaS - Database Access best practices?

    Posted Feb 11, 2020 11:32 AM
    We are on NAV 2018 and looking to move to Business Central SaaS as I'd like to get out of the business of managing servers and databases.

    Today we have some integrations that pull data direct from the database

    What are best practices in Business Central SaaS and are there any third party products that can build a SQL datawarehouse of our data from web services?

    Thank you

    ------------------------------
    Benji Jasik
    Generate Capital
    ------------------------------


  • 2.  RE: Business Central SaaS - Database Access best practices?

    SILVER CONTRIBUTOR
    Posted Feb 12, 2020 12:40 PM
    I'm preparing a presentation on this very subject for NAV Europe ( and I'll be giving it at NAV Focus in Denver as well). If you'd like a copy (it should be ready in 2 weeks)
    Also, you might check out Cdata.com.  I haven't worked with the software yet.  But it's a series of tools to make integrations to SaaS easier.

    Here's the presentation topic:

    Since databases became common with ERP systems over 20 years ago, developers could always say trust that whatever else happened, they would always have SQL.  But now, that's not the case.   With the advent of SaaS in general and Cloud-Based Business Central in particular, life isn't so simple.  You now need to know about things like "ODATA and "APIs".  In this presentation, we'll explain how these new approaches work. And even, how you can get this data back into SQL Server (if you really want to.)



    ------------------------------
    Adam Jacobson
    President
    Red Three Consulting, Inc.
    Bronx NY
    ------------------------------



  • 3.  RE: Business Central SaaS - Database Access best practices?

    Posted Feb 12, 2020 02:45 PM
    Adam, I'd love to see a copy of your presentation.

    We currently use Streamsets to integrate data from others systems and consume APIs and it works well.  We move data from cloud systems into Snowflake with Streamsets.

    Ideally I'd like to replicate some of our current NAV database structures into Snowflake but using web services so it's supported going forward once we move to SaaS and I don't know the best way to do that.   Also happy to move the data from Business Central to Sql Server and from there to Snowflake, but I need a pipeline that can be supported and works.

    ------------------------------
    Benji Jasik
    Generate Capital
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role