A technology-based financial service company, PayPal facilitates online payments between customers and merchants worldwide. The PayPal platform offers secure, affordable, and convenient online financial services, making e-commerce transactions easy and secure for millions of consumers and merchants globally. Customers can link their credit or debit card or their bank account to their PayPal account to make online purchasing simpler and safer.
Starburst Data is a data access and analytics company that offers a cloud-native, SQL-based query engine called Presto. Their mission is to enable organizations to access and analyze data across various sources efficiently and at scale. Starburst Data provides an enterprise-grade platform that leverages the power of Presto to query data residing in different databases, data lakes, and cloud storage systems, eliminating data silos and accelerating insights. With a focus on performance, security, and ease of use, Starburst Data empowers businesses to unlock the value of their data, enabling faster decision-making and advanced analytics capabilities.
![](https://cdn.prod.website-files.com/605e01bc25f7e19a82e74788/64aeb8af6351d4930c019cb5_Set%20up%20a%20source.jpg)
1. Open the Airbyte platform and navigate to the "Sources" tab on the left-hand side of the screen.
2. Click on the "Add Source" button and select "PayPal Transaction" from the list of available connectors.
3. Enter a name for the connector and click on the "Next" button.
4. Enter your PayPal API credentials, including the Client ID and Secret, in the appropriate fields.
5. Click on the "Test" button to ensure that the credentials are valid and that the connection to PayPal is successful.
6. Once the test is successful, click on the "Save" button to save the connector and add it to your list of sources.
7. You can now use the connector to extract data from your PayPal transactions and integrate it with other data sources in Airbyte.
8. To configure the connector, you can select the specific data fields that you want to extract from your PayPal transactions and set up any necessary filters or transformations.
9. Once the connector is configured, you can schedule regular data syncs to ensure that your data is always up-to-date and accurate.
![](https://cdn.prod.website-files.com/605e01bc25f7e19a82e74788/64aeb8b079061e146f038ab9_Set%20up%20a%20destination.jpg)
1. First, navigate to the connectors page on Airbyte and select the Starburst Galaxy destination connector.
2. Next, enter the required credentials for your Starburst Galaxy account, including the host, port, database name, username, and password.
3. Once you have entered your credentials, click on the "Test Connection" button to ensure that the connection is successful.
4. If the connection is successful, you can then configure the settings for your destination connector, including the table name, schema, and any additional options.
5. After configuring your settings, you can then run a sync to transfer data from your source connector to your Starburst Galaxy destination.
6. You can monitor the progress of your sync and view any errors or warnings that may occur during the transfer process.
7. Once the sync is complete, you can then view your data in your Starburst Galaxy database and use it for analysis or other purposes.
![](https://cdn.prod.website-files.com/605e01bc25f7e19a82e74788/64aeb8afa62171f49ab6c6c5_Set%20up%20a%20connection.jpg)
With Airbyte, creating data pipelines take minutes, and the data integration possibilities are endless. Airbyte supports the largest catalog of API tools, databases, and files, among other sources. Airbyte's connectors are open-source, so you can add any custom objects to the connector, or even build a new connector from scratch without any local dev environment or any data engineer within 10 minutes with the no-code connector builder.
We look forward to seeing you make use of it! We invite you to join the conversation on our community Slack Channel, or sign up for our newsletter. You should also check out other Airbyte tutorials, and Airbyte’s content hub!
What should you do next?
Hope you enjoyed the reading. Here are the 3 ways we can help you in your data journey:
What should you do next?
Hope you enjoyed the reading. Here are the 3 ways we can help you in your data journey:
Ready to get started?
Frequently Asked Questions
PayPal Transaction's API provides access to a wide range of data related to transactions processed through the PayPal platform. The following are the categories of data that can be accessed through the API:
1. Transaction details: This includes information about the transaction amount, currency, date, and time.
2. Buyer and seller information: This includes details about the buyer and seller, such as their names, email addresses, and PayPal account IDs.
3. Payment status: This includes information about the status of the payment, such as whether it has been completed, pending, or refunded.
4. Payment method: This includes information about the payment method used, such as credit card, PayPal balance, or bank transfer.
5. Shipping information: This includes details about the shipping address and shipping method used for the transaction.
6. Tax and fee information: This includes details about any taxes or fees associated with the transaction.
7. Refund and dispute information: This includes information about any refunds or disputes related to the transaction.
8. Custom fields: This includes any custom fields that were included in the transaction, such as order numbers or product descriptions.