What do you want to automate
with Fivetran and Data Stores?
Prompt, edit and deploy AI agents that connect to Fivetran, Data Stores and 2,500+ other apps in seconds.
Trusted by 1,000,000+ developers from startups to Fortune 500 companies
Popular Fivetran and Data Stores Actions#
Add or update a single record in your Pipedream Data Store
Add or update multiple records to your Pipedream Data Store
Append to a record in your data store Pipedream Data Store. If the record does not exist, a new record will be created in an array format.
Check if a key exists in your Pipedream Data Store or create one if it doesn't exist.
Overview of Fivetran#
The Fivetran API enables automated, effortless replication of data from various sources into a cloud warehouse. By leveraging Fivetran in Pipedream, you can programmatically manage your Fivetran connectors, set up and control data pipelines, and trigger data syncs. Pipedream's serverless platform allows for the creation of workflows that can respond to HTTP requests, process events on a schedule, and interact with numerous other services to create complex automation solutions.
Connect Fivetran#
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
fivetran: {
type: "app",
app: "fivetran",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://api.fivetran.com/v1/users`,
headers: {
"Content-Type": `application/json`,
},
auth: {
username: `${this.fivetran.$auth.api_key}`,
password: `${this.fivetran.$auth.api_secret}`,
},
})
},
})
Overview of Data Stores#
Data Stores are a key-value store that allow you to persist state and share data across workflows. You can perform CRUD operations, enabling dynamic data management within your serverless architecture. Use it to save results from API calls, user inputs, or interim data; then read, update, or enrich this data in subsequent steps or workflows. Data Stores simplify stateful logic and cross-workflow communication, making them ideal for tracking process statuses, aggregating metrics, or serving as a simple configuration store.
Connect Data Stores#
export default defineComponent({
props: {
myDataStore: {
type: "data_store",
},
},
async run({ steps, $ }) {
await this.myDataStore.set("key_here","Any serializable JSON as the value")
return await this.myDataStore.get("key_here")
},
})Trusted by 1,000,000+ developers from startups to Fortune 500 companies