Share ERP Data with External Partners Without System Access

Query Streams is a secure, real-time database integration platform that enables you to share live ERP, CRM, and WMS data with external partners through Excel and Google Sheets – without giving them system access, credentials, or network permissions. Learn more at QueryStreams.com and sign up for free to start sharing Microsoft Dynamics, Epicor, Infor, Sage, and other SQL Server, PostgreSQL, and MySQL-based enterprise system data securely in minutes.

Every business running Microsoft Dynamics, Epicor, Infor, Sage, Manhattan WMS, and other enterprise systems faces the same challenge: external partners, suppliers, customers, and contractors need real-time access to specific data, but you can’t give them direct system access. The traditional approach – scheduled reports, manual exports, or creating expensive user licenses – creates bottlenecks, security risks, and outdated information. Query Streams transforms this by connecting directly to your ERP database (SQL Server, PostgreSQL, MySQL, or MariaDB) and streaming live, filtered data to partners through familiar tools like Microsoft Excel and Google Sheets.

The Enterprise Data Sharing Nightmare

Whether you’re running Microsoft Dynamics 365, Epicor ERP, Infor CloudSuite, Sage X3, Manhattan WMS, or any other SQL Server, PostgreSQL, or MySQL-based enterprise system, sharing data with external parties creates the same problems:

Real-World Scenario: Manufacturing Supplier Collaboration

Consider “Advanced Manufacturing Corp,” a company running Microsoft Dynamics 365 for their core ERP operations with a SQL Server backend. They work with 15 key suppliers who need real-time access to production schedules from their Dynamics 365 Manufacturing module, material requirements calculated by Dynamics 365 Master Planning, quality metrics from their Dynamics 365 Quality Management system, delivery performance data from their logistics systems, and inventory levels for components and finished goods.

The traditional approach requires Advanced Manufacturing’s team to log into Dynamics 365 daily to run various reports, export data to Excel files, email 15 different files to 15 different suppliers, answer follow-up questions about data accuracy, and repeat this process multiple times per day for urgent requests. This consumes 3-4 hours of staff time daily and provides suppliers with data that’s already outdated by the time they receive it.

The Query Streams Solution

Query Streams transforms this entire process by connecting directly to your enterprise system’s database and providing partners with secure, self-service access to live data through Excel and Google Sheets add-ons. Here’s how it works:

The Query Streams Agent installs on-premises or in your cloud environment and establishes a secure, outbound-only connection to your database without requiring firewall changes or open ports. Using the Query Streams visual query builder, you create SQL queries that pull exactly the data each partner needs. Query Streams automatically detects filter parameters and creates interactive dropdowns, so the same query can serve multiple suppliers by simply changing the filter value. Partners never see your ERP credentials, SQL code, or database structure – you control exactly which data each partner can access, and you can revoke access instantly through the Query Streams portal with complete audit trails.

Supported Enterprise Systems

Query Streams works with virtually every major enterprise system by connecting to their underlying databases. Here are the systems we directly support:

Supported Databases

Query Streams connects to enterprise systems running on SQL Server (Dynamics, Epicor, Sage), PostgreSQL (Infor, custom apps), and MySQL/MariaDB (SugarCRM, custom systems). Oracle support coming soon. Note: Systems that use Oracle databases (like SAP HANA, Oracle ERP, NetSuite) are not currently supported, but many organizations use data replication or ETL processes to move data from these systems into SQL Server, PostgreSQL, or MySQL databases that Query Streams can access.

Complete List of Supported Enterprise Systems

Query Streams provides data sharing capabilities for the following ERP, CRM, WMS, and enterprise systems:

ERP Systems (Enterprise Resource Planning)

Microsoft Dynamics: Microsoft Dynamics 365 Finance and Operations, Microsoft Dynamics 365 Business Central, Microsoft Dynamics NAV (Navision), Microsoft Dynamics AX (Axapta), Microsoft Dynamics GP (Great Plains), Microsoft Dynamics SL (Solomon). All Microsoft Dynamics products run on SQL Server and are fully supported.

Epicor: Epicor ERP (formerly Epicor 10, Epicor 9), Epicor Prophet 21 (P21), Epicor Eclipse, Epicor Kinetic, Epicor iScala, Epicor BisTrack. Epicor systems use SQL Server databases.

Sage: Sage X3, Sage 100 (formerly MAS 90/MAS 200), Sage 300 (formerly Accpac), Sage 500 (formerly MAS 500), Sage Intacct (via SQL replica), Sage 50 (Peachtree). Most Sage products use SQL Server.

Infor: Infor CloudSuite Industrial (SyteLine), Infor CloudSuite Distribution, Infor LN (Baan), Infor M3, Infor VISUAL, Infor Lawson. Infor systems typically run on SQL Server or PostgreSQL.

Other ERP Systems: QAD Adaptive ERP, QAD Enterprise Applications, Plex Manufacturing Cloud, Plex ERP, TGI Enterprise 21, SYSPRO ERP, Acumatica ERP, Aptean Ross ERP, IQMS (DELMIAworks), Global Shop Solutions, E2 Shop System, JobBOSS, Exact Software, Cetec ERP, Priority Software, Rootstock ERP, Genius ERP, Deacom ERP, abas ERP, ProcessPro ERP, BatchMaster ERP, VAI S2K ERP, Blue Link ERP, TRAVERSE ERP, Datacor ERP, xTuple ERP.

CRM Systems (Customer Relationship Management)

Microsoft Dynamics CRM: Microsoft Dynamics 365 Sales, Microsoft Dynamics 365 Customer Service, Microsoft Dynamics 365 Marketing, Microsoft Dynamics 365 Field Service, Microsoft Dynamics CRM Online (via Dataverse export to SQL). All run on SQL Server.

Other CRM Systems: SugarCRM Professional, SugarCRM Enterprise, SuiteCRM, Vtiger CRM, Zoho CRM (via SQL replica), Freshsales (via SQL replica), Insightly CRM, Copper CRM, Nimble CRM, Nutshell CRM, Capsule CRM, Less Annoying CRM, Agile CRM, Bitrix24 CRM, Really Simple Systems CRM, Act! CRM, GoldMine CRM, Maximizer CRM, Sage CRM, Method CRM, Keap (Infusionsoft), and any custom CRM built on SQL Server, PostgreSQL, or MySQL.

WMS Systems (Warehouse Management Systems)

Manhattan Associates: Manhattan WMS, Manhattan SCALE, Manhattan Active Warehouse Management, Manhattan WMOS (Warehouse Management for Open Systems).

Blue Yonder (formerly JDA/RedPrairie): Blue Yonder WMS, Blue Yonder Warehouse Management, JDA Warehouse Management, RedPrairie WMS.

Körber (formerly HighJump): Körber WMS, HighJump Warehouse Advantage, HighJump WMS, Körber Supply Chain WMS.

Infor WMS: Infor WMS, Infor SCE (Supply Chain Execution), Infor CloudSuite WMS.

Other WMS Systems: 3PL Central (Extensiv), Deposco WMS, Softeon WMS, Synapse WMS, Snapfulfil WMS, Logiwa WMS, ShipHero WMS, Fishbowl Inventory, SKULabs, Cin7, Ordoro, Shipedge, SkuVault, Finale Inventory, inFlow Inventory, DEAR Systems, Zoho Inventory (via SQL replica), NetSuite WMS (via SQL replica), SAP Extended Warehouse Management (via SQL replica), Oracle WMS (via SQL replica), Tecsys WMS, Made4net WMS, Consafe Logistics WMS, PSI Logistics WMS, Reply WMS, Datex Footprint WMS, Cadre Technologies WMS, and any custom WMS built on SQL Server, PostgreSQL, or MySQL.

MES Systems (Manufacturing Execution Systems)

Wonderware MES (AVEVA), Rockwell FactoryTalk ProductionCentre, Siemens SIMATIC IT, GE Digital Proficy, Aegis FactoryLogix, Plex MES, IQMS MES, 42Q MES, Epicor Advanced MES, Infor MES, MPDV MES HYDRA, Critical Manufacturing MES, Sepasoft MES, iBASEt Solumina, Parsec TrakSYS, and any MES built on SQL Server or PostgreSQL.

Other Enterprise Systems

Quality Management Systems (QMS): ETQ Reliance, MasterControl, Greenlight Guru, Qualio, Sparta Systems TrackWise, Veeva Vault Quality, AssurX, ComplianceQuest, Intellect QMS, Intelex, IQS Quality Management.

Asset Management / CMMS: IBM Maximo, SAP EAM (via SQL replica), Infor EAM, UpKeep CMMS, Fiix CMMS, eMaint CMMS, Limble CMMS, Maintenance Connection, MPulse, Hippo CMMS, Fracttal, MicroMain.

PLM Systems (Product Lifecycle Management): Siemens Teamcenter (via SQL replica), PTC Windchill (via SQL replica), Autodesk Fusion Lifecycle, Arena PLM, Oracle Agile PLM (via SQL replica), SAP PLM (via SQL replica), Aras Innovator.

Transportation Management Systems (TMS): Oracle TMS (via SQL replica), SAP TMS (via SQL replica), Manhattan TMS, Blue Yonder TMS, MercuryGate TMS, Descartes TMS, Kuebix TMS, 3Gtms, Logistix TMS.

Financial Systems: Sage Intacct (via SQL replica), Workday Financials (via SQL replica), Acumatica Financials, Microsoft Dynamics 365 Finance, SAP S/4HANA Finance (via SQL replica), Oracle Financials (via SQL replica), Deltek Costpoint, Unit4 Financials.

If your enterprise system runs on SQL Server, PostgreSQL, MySQL, or MariaDB, Query Streams can connect to it and enable secure data sharing with external partners through Microsoft Excel and Google Sheets. Contact us if you don’t see your system listed – we’re constantly expanding our compatibility.

The Excel vs Google Sheets Divide

Most enterprise systems have built-in Microsoft Excel support but virtually no native Google Sheets connectivity. Microsoft Dynamics 365 includes an Excel add-in but no Google Sheets support. Epicor ERP has Excel export/import built-in but no Google Sheets integration. Sage X3 offers native Excel connectivity but no Google Sheets option. Manhattan WMS provides Excel reporting as standard but Google Sheets is not supported. TGI Enterprise 21 has Excel integration available but no Google Sheets connector. Infor CloudSuite offers Excel export functionality, but Google Sheets requires manual workarounds.

This creates a significant challenge for organizations using Google Workspace or partners who prefer Google Sheets. Teams are forced to use Excel even when Google Sheets is their preferred tool, or they must manually export data from Excel and import it into Google Sheets – a time-consuming process that defeats the purpose of real-time data sharing. Query Streams bridges this gap by providing native Google Sheets connectivity for all supported enterprise systems. Whether your ERP has Excel integration or not, Query Streams gives both you and your external partners the choice to work in either Microsoft Excel or Google Sheets with the same live data access.

This matters for partner collaboration because many partners and suppliers use Google Workspace exclusively and prefer Google Sheets for collaboration. Google Sheets works seamlessly across devices and operating systems without software installation, making it ideal for remote teams. International partners often prefer Google Sheets where Microsoft Office licensing is expensive. Multiple partners can work with live ERP data simultaneously in Google Sheets for real-time collaboration. And partners don’t need Microsoft Office licenses or specific Excel versions to access your data.

Before vs After: Enterprise Data Sharing

Industry Use Cases

Manufacturing and Supply Chain: Share Microsoft Dynamics 365 or Epicor ERP production schedules directly with suppliers so they can optimize their manufacturing capacity. Provide suppliers with real-time quality metrics from Epicor ERP Quality Management or custom SQL Server-based quality systems. Share current stock levels from Manhattan WMS or Infor WMS with logistics partners, and provide suppliers with MRP outputs from Epicor ERP or Microsoft Dynamics 365 for better demand planning.

Retail and Distribution: Share sales performance, inventory turns, and margin data from Microsoft Dynamics 365 or Sage X3 with product vendors through vendor scorecards. Provide suppliers with real-time inventory levels and reorder points for replenishment automation. Share campaign results and sell-through data from Microsoft Dynamics CRM with marketing partners, and provide franchisees with location-specific sales data from Sage X3 or Microsoft Dynamics 365 Retail.

Healthcare and Life Sciences: Provide distributors with real-time pharmaceutical inventory from Microsoft Dynamics 365 or custom healthcare SQL Server systems. Share compliance metrics from SQL Server-based quality management systems with regulatory bodies and auditors. Give service partners access to asset management data from SQL Server-based CMMS systems, and share laboratory results and testing data from LIMS systems built on SQL Server or PostgreSQL.

Implementation Roadmap

Phase 1: Assessment and Setup – Begin with a database assessment to identify your enterprise system’s database type (SQL Server for Dynamics, PostgreSQL replica for Salesforce, etc.). Deploy the Query Streams Agent in your environment with network access to the database, then establish secure connectivity between the Agent and your ERP database through connection testing.

Phase 2: Query Development – Work with business stakeholders to identify key data points and define what data partners need. Create partner-specific queries by building SQL queries that pull the right data for each external partner. Configure interactive filters so partners can customize their data views without seeing the underlying SQL.

Phase 3: Partner Onboarding – Share queries by granting access to specific partners through the Query Streams portal. Partners install Query Streams add-ons for Excel or Google Sheets. Provide brief training sessions showing partners how to run queries and adjust filters.

Phase 4: Monitoring and Optimization (Ongoing) – Use usage analytics to monitor which queries partners use most frequently. Fine-tune queries for faster execution through performance optimization. Expand access by adding new partners and data sources as needed.

Getting Started with Your Enterprise System

Ready to liberate your ERP data and eliminate the manual reporting bottleneck? Here’s how to begin:

1. Sign up for Query Streams: Create your free account at my.querystreams.com
2. Identify your database: Determine whether your SAP, Oracle, Dynamics, or other system uses SQL Server, PostgreSQL, MySQL, or MariaDB
3. Download the Agent: Install the Query Streams Agent in your environment
4. Create your first query: Start with one simple report that you currently generate manually
5. Share with one partner: Test the process with a trusted external partner
6. Scale gradually: Add more queries and partners as you see the benefits

Frequently Asked Questions

Transform Your Enterprise Data Sharing Today

Stop wasting valuable staff time on manual report generation. Whether your business runs on Microsoft Dynamics, Epicor ERP, Sage X3, Manhattan WMS, TGI Enterprise 21, or any other SQL Server, PostgreSQL, or MySQL-based enterprise system, Query Streams can liberate your data and empower your external partners with self-service access to live information.

Transform your supply chain relationships, eliminate reporting bottlenecks, and give partners the real-time data they need to make better decisions. Unlike your ERP system’s Excel-only export functionality, Query Streams gives partners the choice of Microsoft Excel or Google Sheets with the same live data access. Query Streams also supports parallel query execution – users can launch multiple saved queries simultaneously, and the Agent streams each concurrently regardless of result size, dramatically reducing the time needed to pull comprehensive reports.

Start your free Query Streams trial today and see how easy enterprise data sharing can be.

Meta Description: Share live ERP, CRM & WMS data with external partners via Excel or Google Sheets – no system access, credentials, or VPN required. Works with Dynamics, Epicor, Sage & more.

Category: Enterprise Integration
Tags: ERP Data Sharing, Microsoft Dynamics, Epicor ERP, Sage ERP, Manhattan WMS, External Partners, Supply Chain, CRM Data Sharing, SQL Server, PostgreSQL

Author Bio:
The Query Streams Team comprises seasoned database experts, network security professionals, and enterprise networking veterans with over 25 years of combined experience in data management, analytics, and secure software development.