DSP Expert

1. Community
2. Data Questions & Discussion
3. Has anyone worked with SAP single sign-on and Integrate?

JSlagle: You will need to get a password assigned to your SAP User ID for proper Integrate usage.

• View comment
• DSP Expert
• June 20, 2017 09:46
• 0 votes

1. Community
2. Data Questions & Discussion
3. Has anyone built a WebApp to track code promotion requests from DEV > QA > PROD?

EWeldon: Check out CTSx, which manages and tracks code promotions between environments: https://boaunited.jiveon.com/docs/DOC-13514

• View comment
• DSP Expert
• May 03, 2017 15:49
• 0 votes

1. Community
2. Data Questions & Discussion
3. Has anyone created Integrate sessions that can be scheduled to run on a nightly basis?

EWeldon: Hey Dan, This can be scheduled via Automate. You may have to make the WebApp Event Public, then it will show up in the Interfaces page. Once it's there, you can schedule it.

• View comment
• DSP Expert
• May 03, 2017 12:48
• 0 votes

1. Community
2. Data Questions & Discussion
3. Does anyone have experience using SD_CUSTOMER_MAINTAIN_ALL?

PCardoso: You will definitely not be able to update this field at the same time that sensitive fields are being updated. Confirmation needs to happen using a different User ID. I have never updated...

• View comment
• DSP Expert
• April 29, 2017 16:32
• 0 votes

1. Community
2. Data Questions & Discussion
3. What ports needs to be open for fire wall settings to allow SSMS to open a connection to SQL Server without using remote desktop on the network?

SShah: SQL Server default port: 1433. You can very the port using following path: 1. Login to (RDP) to Database Server 2. Open SQL Server Configuration Manager 3. Check Property of the TCP/IP 4. Te...

• View comment
• DSP Expert
• April 11, 2017 11:31
• 0 votes

1. Community
2. Data Questions & Discussion
3. Can someone solve this 'flexible' WHERE Clause?

PTowe: If I understand the question correctly, it's just a simple where statement: SELECT B.ProjectID, B.boaUserID, B.[Count] FROM B INNER JOIN A ON B.boaUserID = A.UserID Where viewzeroRecords=1 o...

• View comment
• DSP Expert
• April 11, 2017 07:03
• 1 vote

1. Community
2. Data Questions & Discussion
3. Is there a way to set up integrated authentication where the browser asks for the network ID and password every time a user signs in to the DSP?

KVandergriend: No. This would require that DSP have read access to the corporate logins/passwords, which they should never allow. And this is not needed anyway, since the user has already entered t...

• View comment
• DSP Expert
• March 31, 2017 11:16
• 0 votes

1. Community
2. Data Questions & Discussion
3. Has anyone encountered any "gochas" in DSP with a BODS upgrade?

JCohen: There "shouldn't" be an issues from the DSP side. Make sure they upgrade to the version that is in the support band for DSP 6.5.6 (IPS 4.1 SP8, DS 4.2 SP7, and IS 4.2 SP7). The certificatio...

• View comment
• DSP Expert
• March 23, 2017 10:12
• 0 votes

1. Community
2. Data Questions & Discussion
3. Can someone help me read the status for fields whose MODIF in TMODU is greater than 100?

AOttone: The SQL sentence that Angel sent you works fine because SAP stores the position of field in FAUS2 in TMODU.MODIF plus 90. The TMODU.MODIF value ranges are 001-050 for T004F.FAUS1 and 091-1...

• View comment
• DSP Expert
• February 21, 2017 08:27
• 0 votes

1. Community
2. Data Questions & Discussion
3. Can someone help me read the status for fields whose MODIF in TMODU is greater than 100?

AGarcia: Here is an example for FIELD status group = '3000'. Yours could be different: SELECT dbo.TMODU.TABNM, dbo.TMODU.FELDN, dbo.T004F.FSTAG, dbo.T004F.BUKRS, dbo.TMODU.MODIF, dbo.T004F.FAUS1, d...

• View comment
• DSP Expert
• February 21, 2017 06:15
• 1 vote