Latest ads

Premium Land with House for Sale
- anil1961
- Updated: Today at 10:15 AM
AWS Certified Solutions Architect-Associate + AWS Certified Cloud Practitioner
- Sanjeewani95
- Updated: Wednesday at 8:16 PM
🚀 එක පැකේජ් එකයි - මාසෙටම Unlimited Internet! 🌐
- sayuru bandara
- Updated: Tuesday at 10:57 AM
🎬 CapCut Pro 1 Month Access! LKR 600
- sayuru bandara
- Updated: Tuesday at 10:55 AM
🚀 Google One AI PRO Plan (Gemini Pro Activation) – 18 Months Access! LKR 2200
- sayuru bandara
- Updated: Tuesday at 10:53 AM

Reply to thread

Message: <blockquote data-quote="HAneo" data-source="post: 24616740" data-attributes="member: 17432"><p><span style="color: Green"><span style="font-size: 15px">I didn't know that you were using hana dude. </span></span></p><p><span style="color: Green"><span style="font-size: 15px">SSRS - SQL Server Reporting Services just for SQL server.</span></span></p><p><span style="color: Green"><span style="font-size: 15px">one of my client were using hana and he refuse to move to another DB. </span></span></p><p><span style="color: Green"><span style="font-size: 15px">So what i did was , when i need to generate report i get data from hana and put it in SQL server. all the schema's are redefined and match one to one. then i run SSRS from SQl server side using that data and show it in angular side using Ngr report viewer . </span></span></p><p><span style="color: Green"><span style="font-size: 15px"></span></span></p><p><span style="color: Green"><span style="font-size: 15px">Cons:</span></span></p><p><span style="color: Green"><span style="font-size: 15px">this will take out the load to main SAP database. cus we copied all the data from SAP to SQL at night time using a job.</span></span></p><p><span style="color: Green"><span style="font-size: 15px"></span></span></p><p><span style="color: Green"><span style="font-size: 15px">also we had a method to compere row count  of each mapped table and we sync only if row counts are not same.Also every table we have a column call IsNotSyncedOrChanged (int) it will indicate the sync records of a given table. using that flag we can copy only changed records.</span></span></p><p><span style="color: Green"><span style="font-size: 15px"></span></span></p><p><span style="color: Green"><span style="font-size: 15px">i don't know this will help in your organization cus it's entirely up to Architect to decide this move. but trust me it remove main Sap DB some 60% pressure. </span></span></p><p><span style="color: Green"><span style="font-size: 15px"></span></span></p><p><span style="color: Green"><span style="font-size: 15px">Any thing tell me will help</span></span></p><p><span style="color: Green"><span style="font-size: 15px"></span></span></p><p><span style="color: Green"><span style="font-size: 15px"></span></span></p></blockquote><p></p>

Verification: Dahaya deken beduwama keeyada?

Top Bottom