What is Salesforce ELT? Salesforce ELT is the process of pulling data out of Salesforce (Extract), writing it into a destination in something close to its raw form (Load), and only then reshaping it into its final structure (Transform) using the compute power of the destination system itself, rather than a separate transformation engine sitting […]
Moving Heroku Postgres to Amazon RDS: What Actually Works When You Don’t Have Superuser
You’ve decided to move. You open the AWS Database Migration Service documentation, follow it carefully, and about twenty minutes in, you hit a wall: DMS wants a user with the REPLICATION role, and Heroku won’t give you one. That’s not a configuration mistake. Heroku Postgres doesn’t grant customers the superuser role, and it doesn’t let […]

