DSP Expert

1. Community
2. Data Questions & Discussion
3. What is the process to change SAP GUI Client to support UTF-8?

Change the SAP GUI Client to support UTF-8 by navigating to the settings for the System Entry in SAP Logon and editing the "Upload/Download Encoding" section. 

• View comment
• DSP Expert
• March 06, 2018 10:02
• 0 votes

1. Community
2. Data Questions & Discussion
3. Can someone help me run Collect on a postgreSQL DB?

EWeldon: One additional note on this: the Create syntax should stay in T-SQL because it's executed in the DSP environment. The SELECT portion should be written in PostgreSQL syntax.

• View comment
• DSP Expert
• February 28, 2018 14:06
• 0 votes

1. Community
2. Data Questions & Discussion
3. Can someone help me run Collect on a postgreSQL DB?

EWeldon: Hi Josh, it is most likely coming from the table Design. In Collect, Navigate to the table. Click on Vertical View. Click the General Information tab. Click View Design. Click the "SQL" i...

• View comment
• DSP Expert
• February 28, 2018 14:03
• 0 votes

1. Community
2. Data Questions & Discussion
3. Where do we configure source path (DSW_Source_FilePath) for files to be imported in DSP?

VGazquez: Hi Ramgopal, Go to: Admin >Data Sources >DSW_Source_FilePath > Vertical view. You can technically change the path, as long as DSP can reach it. But, I would suggest to keep it as because ...

• View comment
• DSP Expert
• February 13, 2018 06:54
• 0 votes

1. Community
2. Data Questions & Discussion
3. Where do we configure source path (DSW_Source_FilePath) for files to be imported in DSP?

TEmpson: The standard path is configured in the data source. The path must be reachable by CranSoft or you will not be able to see the sources

• View comment
• DSP Expert
• February 13, 2018 06:54
• 0 votes

1. Community
2. Data Questions & Discussion
3. Where do we configure source path (DSW_Source_FilePath) for files to be imported in DSP?

KVandergriend: Admin >Data Sources >DSW_Source_FilePath > Vertical view. It is best if the path is on a drive that has sufficient space, and not the C drive.

• View comment
• DSP Expert
• February 13, 2018 06:54
• 0 votes

1. Community
2. Data Questions & Discussion
3. What is the implication of GL account not being extended to a company code (SKA1 not extended to SKB1)?

KDestacamento: GL account not extended to a company code cannot be used for posting a transaction. Transactional data are posted at the company code level, which is why GL accounts should be extend...

• View comment
• DSP Expert
• February 08, 2018 11:30
• 0 votes

1. Community
2. Data Questions & Discussion
3. How can I identifying 'Corrupted' Extracted Data?

VGazquez: Hi Andy, this is in addition to previous answers. The collation has two purposes: Relates to the bit pattern and code page Specifies how character data is sorted and compared (language, ...

• View comment
• DSP Expert
• February 07, 2018 13:32
• 0 votes

1. Community
2. Data Questions & Discussion
3. How can I identifying 'Corrupted' Extracted Data?

JDanos: I always like to ensure that any language packs are installed on the servers that are used in the process, including SQL and APP. The other suspects are the actual drivers themselves and lo...

• View comment
• DSP Expert
• February 07, 2018 11:49
• 0 votes

1. Community
2. Data Questions & Discussion
3. How can I identifying 'Corrupted' Extracted Data?

DanDowney: In Collect, go to the Vertical View of the Target Source. Change the SAP Settings Language to 1 (Chinese). Then use BOA RFC to download the data. It will display correctly in the sdb.

• View comment
• DSP Expert
• February 07, 2018 12:05
• 0 votes