DSP Expert

1. Community
2. Data Questions & Discussion
3. Has anyone updated a custom WebApp built for Outlook 2003 to be compatible with Outlook 2010?

PWadekar: Recompile and minor re-structuring worked for outlook integration with DSP.

• View comment
• DSP Expert
• May 23, 2018 12:02
• 0 votes

1. Community
2. Data Questions & Discussion
3. Has anyone connected to or extracted data from Revel Systems Point Of Sale ?

CBermingham: I haven't worked with Revel POS, but since this post has been open for so long I will take a shot. If you have not found any way to connect via ODBC, Revel advertises an Open API for u...

• View comment
• DSP Expert
• May 18, 2018 14:29
• 0 votes

1. Community
2. Data Questions & Discussion
3. Is there a BOA Function to check a previous record?

EWeldon: Hi Abigail, SQL has functions for this starting with 2012: LAG (for the previous record): https://docs.microsoft.com/en-us/sql/t-sql/functions/lag-transact-sql?view=sql-server-2017  LEAD...

• View comment
• DSP Expert
• May 16, 2018 14:54
• 0 votes

1. Community
2. Data Questions & Discussion
3. Why is Excel Integration upload taking so long to upload records?

ASliney: Do you have auditing turned on? Even with only minimal record counts, auditing causes the Excel integration to time out. From the server you can look at the timeout messages in the server ...

• View comment
• DSP Expert
• May 15, 2018 14:43
• 0 votes

1. Community
2. Data Questions & Discussion
3. Why is Excel Integration upload taking so long to upload records?

EWeldon: Hey Brad, has the page changed recently? Have drop downs been added? Excel Integration is based off the Horizontal View, so if you have User Security in the Hor view, exponential amount of...

• View comment
• DSP Expert
• May 15, 2018 14:24
• 0 votes

1. Community
2. Data Questions & Discussion
3. Is there any SAP documentation on how to set up the required authorization objects in SAP?

KVandergriend: BOA Support would have those details in the URL below, but I don't see that object. I would enter a ticket so the documentation can get updated. https://support.syniti.com/hc/en-us/a...

• View comment
• DSP Expert
• May 14, 2018 11:44
• 0 votes

1. Community
2. Data Questions & Discussion
3. How do you set up a job to download a zip file directly from a URL onto a DSP server?

PCardoso: Great question Kurt, but this data is publicly available (https://www.canada.ca/en/health-canada/services/drugs-health-products/drug-products/drug-product-database/what-data-extract-drug-...

• View comment
• DSP Expert
• May 07, 2018 23:28
• 0 votes

1. Community
2. Data Questions & Discussion
3. How do you set up a job to download a zip file directly from a URL onto a DSP server?

KVandergriend: My first concern is that the link provided appears to be public. How is this client data being secured?

• View comment
• DSP Expert
• May 07, 2018 10:21
• 0 votes

1. Community
2. Data Questions & Discussion
3. How do manual rules value mapping have to be formatted in Excel so it can be uploaded to ADM?

JDanos: You can do a couple of things for this: Provide a spreadsheet to them that you can then manually translate, OR create a dspMigrate process to import the mapping to translate as best can be ...

• View comment
• DSP Expert
• May 04, 2018 11:06
• 0 votes

1. Community
2. Data Questions & Discussion
3. How do you extract data after its loaded into PRD S4H, scramble it for privacy reasons, and move/push to a pre-production environment?

Fschuler: Hello Marcos, This would be a use case for the SAP Test Data Migration Server: https://blogs.sap.com/2014/07/13/sap-test-data-migration-server-tdms-data-scrambling/ Best regards, Frank

• View comment
• DSP Expert
• May 02, 2018 12:04
• 0 votes