SFDC – Using a timestamp literal in a where clause

Working with timestamp literals in the Infosphere SFDC Connector soql is much like working date literals.  So, here a quick example which may save you some time. SOQL Timestamp String Literals Where Clause Rules Basically, the timestamp pattern is straight forward and like the process for dates, but there are some differences. The basic rules … Continue reading SFDC – Using a timestamp literal in a where clause

What is an ERP?

What does ERP mean? ERP Means "Enterprise Resource Planning" What is an ERP? An ERP is business software application or series of applications, which facilitate the daily operations of business. An ERP an be commercial-off-the-shelf (COTS) applications (which may or may not be customized) or custom built (home grown) by the business and/or assemblages of … Continue reading What is an ERP?

Salesforce – Useful Links

  Here are few SFDC link, which I have found to be useful. Salesforce Developers Home, Developer Documentation, Force.com SOQL and SOSL Reference https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_select_date_functions.htm IBM Knowledge Center InfoSphere Information Server, InfoSphere Information Server 11.5.0, Connecting to data sources, Enterprise applications, IBM InfoSphere Information Server Pack for Salesforce.com https://www.ibm.com/support/knowledgecenter/en/SSZJPZ_11.5.0/com.ibm.swg.im.iis.ds.entpak.salesf.doc/topics/SalesforcePackOverview.html Salesforce Developers Home, Technical Library, Workbench https://developer.salesforce.com/page/WorkbenchContinue reading Salesforce – Useful Links

SFDC Salesforce Connector – Column Returns Null values, when SOQL Returns Data in Workbench

Recently, encountered a scenario, which is a little out of the norm while using the SFDC Connector.  Once the issue is understood, it is easily remedied. The problem / Error SOQL run in Salesforce workbench and column returns data The DataStage job/ETL runs without errors or warnings The target column output only returns null values … Continue reading SFDC Salesforce Connector – Column Returns Null values, when SOQL Returns Data in Workbench

What does CRM Mean?

  What is CRM? CRM (customer relationship management) is a type of ERP application, which are used to facilitate sales, marketing, and business development interactions throughout the customer life cycle. What does a CRM Application do? A CRM application capabilities, broadly, encompass: Marketing Integration Lead management, email marketing, and campaign management Sales Force Automation Contact management, … Continue reading What does CRM Mean?

SFDC – Using a date literal in a where clause

I found working with date literal, when working with the Infosphere SFDC Connector soql, to be counterintuitive for me.  At least as I, normally, as I use SQL.  I spent a little time running trials in Workbench, before I finally locked on to the ‘where clause’ criteria data pattern.  So, here a quick example. SOQL DATE … Continue reading SFDC – Using a date literal in a where clause