Logo
Menu
  • logo
  • Products
    • prod-logo prod-logo prod-logo prod-logo prod-logo prod-logo prod-logo prod-logo prod-logo prod-logo
  • Digital Transformation
    • Modern Workplace

      • Application Modernization
      • Microsoft 365
        • Teams Apps and Solutions
        • Power Platform
        • SharePoint Portals
      • ServiceNow
        • ServiceNow Advisory Services
        • ServiceNow Implementation Services
        • ServiceNow Optimization Services
      • Salesforce
      • Robotic Process Automation (RPA)
    • Data Science

      • Data Strategy
        • Snowflake
        • Synapse
        • Databricks
        • Power BI
        • Managed Services
      • ML & AI
    • Cloud & DevOps

      • Cloud Strategy & Planning
        • AWS Cloud Solutions
        • Azure Cloud Solutions
      • CloudOps
      • DevOps
    • Mobility

      • Mobile App Development
      • XR App Development
    • Integration

      • Boomi
      • MuleSoft Solutions
  • ServiceNow
    • ServiceNow Advisory Services
    • ServiceNow Implementation Services
    • ServiceNow Optimization Services
  • Salesforce
  • Cyber Security
    • IAM & Cyber Security
    • Identity Access Management
    • Privileged Access Management
    • Cyber Security
    • Data Security
    • Monitoring & Detection
  • Microsoft Technologies
    • Microsoft 365
    • Teams Apps & Solutions
    • Power Platform
    • SharePoint Portals
    • Azure Cloud Solutions
    • Microsoft CSP Offerings
    • Unified Support
  • Insights
    • Blogs
    • Success Stories
CLOSE

Migration of data from SAP to Microsoft SharePoint 2014

  • July 1 2021
  • Sagaya
Reading Time: 3 minutes

See how we helped an Organization to make business decisions effectively using COGNOS BI reporting.

Cardone is a leading provider of new and re-manufactured automobile parts and products. With over 44 years of existence, Cardone has grown over 80 product lines and 46,000 SKUs of automotive hard parts.

BUSINESS CHALLENGE

Migration of data from SAP to Microsoft SharePoint 2014

  • Cardone has their sales, purchase, and finance inventory data stored in to the AS400 midrange system.
  • The business team required analytics for reporting and decision purpose without altering their existing set-up.
  • IT team decided to use a standalone Microsoft SQL Server to accomplish the MSBI (Microsoft Business Intelligence) without disturbing the existing EDW.
  • The data required for analytics and report building has to be made available in SQL Server for building SSIS, SSAS and SSRS.
  • A batch program has to be created that pulls the previous day updates from SAP to SQL Server.

HOW AVASOFT HELPED?

Built batch jobs (SSIS) to move data from existing database to Microsoft SQL Server with the help of MSBI Process.

  • Created Multi-Dimensional Cubes (MDX) using SSAS and avoiding scripts for these in the future.
  • Worked with Business teams to analyze existing report and build new reports. SSRS was used that aligned with business objectives, including reducing and optimizing the existing reports.
  • Monitored jobs and worked with client teams that needed this details.
  • Tested reports for design, layout and data which needs to be in line BO reports.
  • Deployed all above mentioned as packages in the client environment and used SharePoint as the user front end for this.

TECHNOLOGY STACK

VALUE ADDITIONS TO CUSTOMER

  • Cost saving by providing MDX code instead of SQL scripts.
  • Provision to accommodate complex multidimensional Adhoc reports.
  • Used existing infrastructure and licenses and provided complex solutions..
  • Data transformations in future can be done effectively using the ETL framework.

BUSINESS GAIN

  • Ability to drill down all reports at year, month and day levels with more visibility for department users.
  • Build ETL frameworks that can be re-used in the future.
  • Reduced coding needs in future on SQL scripts by creating MDX queries.

BUSINESS NEED

  • Department wise reporting.
  • Analytics for business users.
  • Standardization of reports.

VERTICAL INDUSTRIES

  • Re-manufacturing(automotive products)

Interested to know more?

Call Us : +1 732 737 9188

Email Us : sales@avasoft.com

Book a Meeting: Schedule Now

Share
Follow by Email
Facebook
fb-share-icon
Twitter
Follow Me
Tweet
LinkedIn
Share
Instagram
Previous Post Next Post

Partner with us!

Calendar-icon

Connect with our experts!

+1 732 737 9188

sales@avasoft.com

Book a Demo

Recommended by our team

  • From-monolithic
    How we achieved 40% reduction in leasing application maintenance cost with application modernization
  • Integrating-Service-portal
    Integrating ServiceNow Service Portal & SharePoint Portal into a unified Employee Center
  • Salesforce Interaction
    Unified employee portal solution for energy service provider using ServiceNow

Please enter your email to continue reading.

    Shape

    Products

    • Slack Migration
    • G Suite Migration
    • Tenant to Tenant Migration
    • SharePoint Migration
    • IBM Connections Migration
    • Lotus Notes Migration
    • Filedoc
    • Policy Management
    • Booshaa
    • Tivasta

    Digital Transformation

    Modern Workplace

    • Application Modernization
    • Microsoft 365
      • Teams Apps and Solutions
      • Power Platform
      • SharePoint Portals
    • ServiceNow Platform Solutions
    • Salesforce Solutions
    • Robotic Process Automation

    Data Science

    • Data Strategy
      • Snowflake
      • Azure Synapse
      • Databricks
      • Power BI
      • Managed Services
    • ML & AI

    Cloud

    • Cloud Strategy & Planning
      • AWS Cloud Solutions
      • Azure Cloud Solutions
    • CloudOps
    • DevOps

    Mobility

    • Mobile App Development
    • XR App Development

    Who We Are

    • About Us
    • Clients & Partners
    • Insights
    • Success Stories
    • Trainings
    • Subsidiaries
    • Press & Media
    • Careers
    • Contact Us
    msft-gold-partner awsconsultingpartner 9001-ISO 27001-ISO

    Sales

    mail sales@avasoft.com

    phone +1 732 737 9188

    Career

    mailcareer@avasoft.com

    phone +91 950 007 8300 | phone +91 950 002 0440

    Privacy Policy

    © Copyright 2023 AVASOFT. All Rights Reserved.

    • social-icon
    • social-icon
    • social-icon
    • social-icon
    • social-icon
    We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept All”, you consent to the use of ALL the cookies. However, you may visit "Cookie Settings" to provide a controlled consent.
    Cookie SettingsAccept All
    Manage consent

    Privacy Overview

    This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
    Necessary
    Always Enabled
    Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.
    CookieDurationDescription
    cookielawinfo-checkbox-analytics11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
    cookielawinfo-checkbox-analytics11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
    cookielawinfo-checkbox-functional11 monthsThe cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
    cookielawinfo-checkbox-functional11 monthsThe cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
    cookielawinfo-checkbox-necessary11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
    cookielawinfo-checkbox-others11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
    cookielawinfo-checkbox-others11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
    cookielawinfo-checkbox-performance11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
    cookielawinfo-checkbox-performance11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
    viewed_cookie_policy11 monthsThe cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.
    Functional
    Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features.
    Performance
    Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
    Analytics
    Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.
    Advertisement
    Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.
    Others
    Other uncategorized cookies are those that are being analyzed and have not been classified into a category as yet.
    SAVE & ACCEPT