Sage 100

Consulting and Upgrades

  • Home
  • Services
  • Contact

How To Set Firewall Options for Sage 100 Advanced and Premium

October 28, 2020 by Wayne Schulz

Sage 100 Advance and Premium both use a service enabled on your server which allows for managing some of the processing.

This requires that your workstations have the ability to connect to the server. Sometimes there are issues with higher security sites where the firewall might block some traffic.

Sage has a detailed knowledgebase article 105259 listing the detailed configuration changes you may need to make to your firewall so Sage 100 can connect.

In addition they’ve published this video that walks you through the steps of configuring your firewall. As always, we advise you consult with your network support professional prior to adjusting any of your network security preferences.

Filed Under: Sage 100 ERP Tagged With: advanced, firewall, Premium, sage 100

Sage 100cloud – Providex ( PVX ) vs SQL – Pros And Cons

December 13, 2018 by Wayne Schulz

As Sage 100 users migrate to  Sage 100cloud we are often advising them to consider whether a move to a SQL database may be of benefit to their operations.

One of the key benefits of the Sage 100cloud subscription is the ability to use any of the following flavors of Sage 100cloud with no additional charge for changing the underlying database driving Sage 100cloud:

  1. Sage 100cloud Standard  – Providex based
  2. Sage 100cloud Advanced – Providex based – runs in a client-server type environments
  3. Sage 100cloud Premium – SQL backend – runs on Microsoft SQL server

What’s The Best Option For Sage 100cloud: Providex or SQL?

Below is a condensed version of the pros and cons of changing your Sage 100cloud to a back-end SQL database. Typically we recommend considering this switch when you:

  1. Have significant database sizes (> 500 MB) and expecting to continue growing
  2. Noticeably slow reporting – especially with externally connected reports/queries
  3. 10+ users on the system concurrently (now or expected in the future)

Your end users don’t need to know anything about SQL. About the only thing they’ll notice is if they use the SOTAMAS90 for external reporting they will have to change drivers in favor of a connection to the SQL tables.

Benefits of SQL for Sage 100 and Sage 100cloud

  • No premium for premium (a true benefit of Sage 100cloud subscription)
  • External reports based on SOTAMAS90 pretty easy to convert to Premium
  • Customers notice a speed increase in external reporting (true value added)
  • Virtually all 3rd party ISV solutions work with Premium
  • Reporting via external tools/connections can be significantly faster
  • Straightforward to set up Sage 100cloud on Premium
  • The prior penalty for SQL speeds in native Sage screens seems mostly gone
  • Data File Display & Maintenance (DFDM) goes away but you can download a free DSD SQL DFDM
  • Skilled users can use SQL tools for query/changes (recommend locking users out of write capabilities)

Disadvantages of SQL for Sage 100 and Sage 100cloud

  • Need to be comfortable setting up a SQL server
  • Some customers reluctant to invest in a new server to maintain (especially if they don’t have on-staff IT person)
  • Sage has limited info about how to configure the SQL server
  • Easy to use SQL tools to change data without Sage 100cloud which could result in lost data if not performed by a qualified person
  • WO, MRP users can’t use Premium as of December 2018 (due Q1 2019)
  • Tricks you may do with Providex such as swapping in or out single data files are difficult/impossible with Premium
  • Cannot simply insert a new license key – a system upgrade will be required which involves migrating existing data to a new installation of Sage 100cloud Premium

 

If you are considering a move to Sage 100cloud Premium ( aka SQL ) then consult our summarized guide to selecting and configuring Microsoft SQL for Sage 100 Premium.

The use of SQL is a popular selection for growing Sage 100cloud customers with significant reporting requirements now or in the future.

For more information contacts us or give your Sage 100cloud partner a call.

Filed Under: Sage 100 ERP, sage 100cloud Tagged With: Premium, providex, sage 100cloud, upgrade

Data File Display and Maintenance (DFDM) for Sage 100 Premium Available Now

March 1, 2017 by Wayne Schulz

 

DSD Business systems have released a free Sage 100  Premium – Data File Display and Maintenance. The new utility actually works for all versions of Sage 100 (Standard, Advanced, and Premium) but is most helpful to those on the Premium (aka SQL) versions which previously did not offer a Data File Display and Maintenance (aka DFDM) utility and instead required consultants and users to use SQL Management Studio to manipulate data files.

This utility is available for Sage 100 v2013 or higher. It adds the ability to select the database (aka company code) as well as the table name from a drop down list. Standard DFDM required that you manually browse through a sometimes confusing path to locate tables manually while the Premium version of Sage 100 included no DFDM and instead required you to use SQL Management Studio.

The utility is free to users on Sage 100 v2013 or higher. Download it from DSD Business Systems – here.

Filed Under: Sage 100 ERP Tagged With: dfdm, dsd business systems, Premium, SQL Management Studio

Access Sage 100 in the cloud today. 3rd party applications supported Available 24/7 from anywhere. Dedicated hosts

Call 1-888-244-6559 (toll-free)

Search Our Site

Sage 100 News

  • Can Sage 100 Premium ( SQL ) Be Migrated Back To Non-SQL ( Providex?)
  • Sage 100 2022 Requires New Activation Key for Production Management Installation
  • Sage Releases Sage 100 v2022
  • What File Prerequisites are Required by Sage 100 v2021?
  • Error #0 Sage 100 – When Printing Registers After Microsoft Update
  • Is Sage 100 Compatible With Microsoft Windows Server 2022?
  • What’s New in Sage 100 Version 4.4 to 2021
  • What Is The Most Recent Product Update For Sage 100?
  • What’s Coming in Sage 100 2022?
  • Enhance Your Sage 100 Warehouse Processing With ScanForce WMS

Contact Us

Schulz Consulting
Connecticut Office
Phone: 860.657.8544
Email Us
Available remotely nationwide.
We are a local branch of DSD Business Systems Connecticut.

Copyright © 2022 · Parallax Pro Theme on Genesis Framework · WordPress · Log in