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.
- Create an application integration.
- Drag an SAP ASE (Sybase) Adapter into the integration as a trigger connection.
- Configure the SAP ASE (Sybase) endpoint with the required details for inbound
polling.
- Drag a Marketo Adapter into the integration canvas as an invoke connection.
- 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.
- On the Basic Info page, provide an endpoint name.
- On the Action page, select Import Bulk Data.
- On the Operations page, select the Import Lead operation, and select the Leads object.
- Review your selections on the Summary page, and click Done.
- In the mapper, perform the required mappings to import bulk data into Marketo.
- Drag another Marketo Adapter below the first Marketo Adapter and configure it with the Final Submit operation.
- On the Basic Info page, provide a name.
- On the Action page, select Import Bulk Data.
- On the Operations page, select the Final Submit operation in the Select Operation field.
- Review your selections on the Summary page, and click Done.
- Activate the integration.