From: Scott Mead <scottm@openscg.com>
To: Ram DBA <postgresdbas@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Data replication to PostgreSQL
Date: Thu, 29 Dec 2016 12:28:38 -0500
Message-ID: <FFA4857A-7BC7-4AF4-90B4-D91AC1605764@openscg.com> (raw)
In-Reply-To: <CAGb7rSFg6yrriDsFrwgS1ECsO9fbDxWssbfxidXjo2TQStN4HQ@mail.gmail.com>
References: <CAGb7rSFg6yrriDsFrwgS1ECsO9fbDxWssbfxidXjo2TQStN4HQ@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
> On Dec 29, 2016, at 09:35, Ram DBA <postgresdbas@gmail.com> wrote:
>
> Hi team,
>
> We have an use case to copy the data from Salesforce to PostgreSQL environment but because of DDL changes that can happen to tables from Salesforce application side, replication would eventually fail. Do we have any open source tools that can also capture the DDL changes and replicate to PostgreSQL?
Are you using an export tool provided by salesforce, or a custom tool against their APIs?
Either way, you don't have access to their database, you should be dumping the data to a CSV and importing the CSV to postgres. It's been a while since I've monkeyed with it, There may be a new way of doing this, but I doubt it. As long as your export tool always creates a csv in the right format, you'll be fine. If you aren't ordering your columns or are using *, you'll never get a good read. Use the toon or API to create a consistent file each time in some standard format and you'll be as okay as possible.
--
Scott Mead via mobile
Skype : scottm.openscg
Gtalk : scottm@openscg.com
>
> Thank you in advance,
> Ram
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scottm@openscg.com, postgresdbas@gmail.com
Subject: Re: Data replication to PostgreSQL
In-Reply-To: <FFA4857A-7BC7-4AF4-90B4-D91AC1605764@openscg.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox