Skip to main content

Posts

Showing posts from June, 2014

How To Connect Sage 100 to Excel

Pull data directly from Sage 100 into Microsoft Excel for business intelligence analysis without any 3rd Party Add-Ins. By: Tekoa Software Sage 100 ERP MAS90 MAS200 data can easily be pulled directly into Excel.  Excel can perform this functionality without any third-party add-ins or tools.  Use the Excel built-in data tools to pull live Sage 100 ERP data into a spreadsheet, then analyzed the data and write reports using Excel. This allows you to use Excel to: Create Pivot Tables of Sage MAS data Quickly Filter and Sort Sage 100 data Easily Analyze data Build Excel Worksheets that reference live Sage 100 ERP data 1. Open a new Excel spreadsheet and go to the Data tab.  Select the From Other Sources dropdown and select From Data Connection Wizard. 2. Select ODBC DSN. 3. Select SOTAMAS90, which is the Sage 100 ERP ODBC driver name. 4. Login to Sage 100 using credentials that have access to the ODBC files you want. 5. Select any Sage 100 datafile nam

Sage 100 Web Integration Tool

Sage 100 Integration Tool from TEKOA Efficient, Cost Effective and Easy Sage 100 Data Integration www.TekoaERP.com TEKOA has an integration service available for Sage 100 software.   TEKOA allows ERP software owners to establish and manage ERP information relationships with other people, systems or devices and facilitates the transfer of business application data like orders, transactions and lists between ERP applications. The obvious benefit to data relationships between organizations is the ability to trade data back and forth and potentially eliminate manual data entry.  This transfer of information between companies and systems allows for the streamlining of business processes and increases the efficiency and accuracy of transactions between businesses. For example, with TEKOA you can receive new orders directly from your customer's ERP system, from a web site, from a mobile device or from another application and have that order automatically inserted into your