Create a Salesforce Reader application
To start using the Salesforce Reader in Striim apps, you can create an application in the following ways:
Striim Wizard in the Flow Designer
Striim Flow Designer
Striim TQL
Creating a Salesforce Reader application using the wizard
Log in to a Striim instance.
Click Create an App from the Apps menu.
Select Salesforce as the source.
Specify your target and click Get Started.
The Salesforce Reader wizard starts.
In Name, enter a name for the app, then select a namespace from the Namespace drop-down.
The default namespace is the application name.
Click Save.
The wizard advances to the next step. You can specify connecting using a connection profile, or manually enter the connection properties in the wizard (described in steps 7-10).
For the API Endpoint, specify the URL used to access Salesforce services. For example, https://ap2.salesforce.com
Select Authenticate using Auth Token or Authenticate using User Credentials, as suited to your use case.
(To authenticate with OAuth authentication token) Specify an auth token that you obtain after creating a connected app in Salesforce.
(To authenticate with OAuth username and password) Specify the credentials for a Salesforce user account, with permissions to access objects:
Username
Password
Consumer Key,
Consumer Secret
Security Token.
Select Create schemas on the target before moving the data if you want the app to create the source schema for all selected tables at the target.
Click Next.
The wizard validates the authentication information and displays the results.
Click Next.
The wizard displays a list of objects available on the Salesforce instance.
Select the objects to ingest and click Next. Select only objects for which the previously specified token has permissions or the application will fail with an "Insufficient permission to access the metadata" error.
Configure your target.
Click Next.
The wizard displays summary information.
Click Save & Run.
The application is saved and begins running.
Creating a Salesforce Reader application using the Flow Designer
Creating a Salesforce Reader application using TQL
The following TQL will read from the Business__c sObject and create an appropriate typed stream:
CREATE SOURCE SFPoller USING SalesforceReader ( sObjects: 'Business__c', authToken: '********', apiEndPoint: '<your organization's endpoint UEL>', mode: 'InitialLoad', autoAuthTokenRenewal: 'false' ) OUTPUT TO DataStream; CREATE TYPE OpStream_Type ( Id String KEY, Name String, POSDataCode__c String, Currency__c String ); CREATE STREAM OpStream OF OpStream_Type; CREATE CQ CQ1 INSERT INTO OpStream SELECT data[0],data[1],data[2],data[3] FROM DataStream;