Extract Bulk Data from an SAP ASE (Sybase) Database and Import it into a Marketo Application

The SAP ASE (Sybase) Adapter enables you to extract a large volume of data from the SAP ASE database. For example, you can extract Leads and Custom Objects data from an SAP ASE database and import it into a Marketo application.

To do so, you need to create a table with columns such as FirstName, LastName, Company, email, phoneNumber, title, and status flag in the SAP ASE (Sybase) database.

This use case describes how the SAP ASE (Sybase) Adapter extracts a large volume of leads data and imports it into the Marketo application. Configure an SAP ASE (Sybase) Adapter trigger endpoint and select the polling operation. Configure a Marketo invoke endpoint to import leads data into Marketo using the import bulk data operation. This implementation pattern provides an overview of the steps.

1. Create an app-driven orchestrated integration.
2. Drag an SAP ASE (Sybase) Adapter into the integration as a trigger connection.
3. Configure the SAP ASE (Sybase) endpoint with the required details for inbound polling.
   1. On the Basic Info page, provide a name for the trigger endpoint connection.
   2. On the Polling page, import the table from which to poll and send data into Marketo.
   3. On the Polling Strategy and Options page, enter the required details as follows:
      • Logical Delete Field: Select a field (column) in the root database table to logically poll.
      • Read Value: Specify the value to indicate a row has been read (for example, PROCESSED or READ).
      • Unread Value: Specify the value to indicate the rows to process.
      • Rejected Value: Specify the value to indicate rejected records.
      • Polling Frequency (Sec): Set the polling frequency (in seconds) for new records.
   4. Review your selections on the Summary page, and click Done.
4. Drag a Marketo Adapter into the integration canvas as an invoke connection.
5. Configure the Marketo endpoint with the required operation on the Operations page. For this example, import bulk data is selected, which is invoked when there is a new record in the table that needs to be imported into the Marketo application.
   1. On the Basic Info page, provide an endpoint name.
   2. On the Action page, select Import Bulk Data.
   3. On the Operations page, select the Import Lead operation, and select the Leads object.
   4. Review your selections on the Summary page, and click Done.
6. In the mapper, perform the required mappings to import bulk data into Marketo.
7. Drag another Marketo Adapter below the first Marketo Adapter and configure it with the Final Submit operation.
   1. On the Basic Info page, provide a name.
   2. On the Action page, select Import Bulk Data.
   3. On the Operations page, select the Final Submit operation in the Select Operation field.
   4. Review your selections on the Summary page, and click Done.

   The completed integration looks as follows.
   
   

8. Activate the integration.
   1. Click Home > Integrations > Integrations.
   2. Go to the row of the integration to activate.
   3. Click Activate to activate the integration.
   4. If needed, check the Enable Tracing check box. The Include Payload check box is displayed.
   5. If needed, check the Include Payload check box.
   6. Click Activate. The integration is deployed.

The integration is invoked when a new lead record is created in the SAP ASE (Sybase) database and the same record details are imported into the Marketo application.