DSXchange

Just wanted to share ... for version 8.7X, technote 1986339 has guidance on this issue. This technote may not be relevant to newer versions.

Thanks. As advised by IBM, this issue was fixed by making following configuration changes: 1. For the Run time operations: Edit the file /opt/IBM/InformationServer/Server/DSComponents/binSALESFORCEJCConnector.ini on the Engine Tier to replace the line: /Usage/Java/ConnectorOtherOptions(force)=-Dcom....

Eric, Thank you. This information saves us from going on a fishing expedition :-). Salesforce configuration may be stored in /opt/IBM/InformationServer/Server/DSComponents/bin/SALESFORCEJCConnector.ini. What are the values under "XMLProperties" section of above mentioned file in your insta...

There isn't a special sandbox install of datastage in our shop. Testing of config changes will need all users to be out of the box, so earliest this testing can be scheduled is over the (long) weekend :-(. Prior to that we are planning for the "test" by taking advantage of collective wisdo...

See this post.

Hmm. DataStage jobs with Saleforce connector connecting to sandbox are failing. Default config values in DataStage 11.5.0.1 are SSL_TLS: 1. In /opt/IBM/WebSphere/AppServer/profiles/InfoSphere/properties/ssl.client.props #------------------------------------------------------------------------- # Thi...

Do contact IBM support for this issue.

Calculation of 14 business days is certainly not simple.

Leveraging Date Dim is the best way to go. However if you only want to exclude weekend (Saturday and Sundays and), then you can use 14 calendar days in your calculation.

Depending on the size of source and target data, this requirement can be met with multiple designs. For a "reasonable size" of target, see Change Capture and Change Apply stages in Parallel Job Developer's Guide.

"Business days" is specific to the organization. If you have a data dimension already built then it would probably be accounting for state, national, company specific holidays and other non business days, so use it. If you only want to exclude weekend (Saturday and Sundays and), then 10 bu...

You are welcome. There are no separate binaries that one needs to download/install for these packs. See following excerpt from our communication with IBM

All Packs are automatically installed along with DataStage except the packs which are still chargeable add ons namely SAP and SAS.

This link may be helpful.

Wait For File Activity stage looks for a specific filename and does not support wildcards. See this discussion.

Also see this developerworks article.

(Assuming that the application creating the excel file cannot drop it on the DataStage/Unix box) Mount/share the source directory on DataStage box. Subsequently use a filewatcher to trigger other activities of your job. Filewatcher can be implemented using your scheduling tool or Wait For File Activ...