Tickets Tagged With:postgresql

0
votes
10
answers
105 views

Category: Questions

Synchronization Integration won't allow Target to Source "Id" column synchronization

Hello there. I have successfully synced a SFDC object/table to a table in a PostgreSQL database. I added a new primary-key column (named "_id") and am able to sync records back ....

Created by Jacob Widmer Jacob Widmer 11 October 2018.

Latest by Mariia Zaharova Mariia Zaharova 4 weeks ago.

0
votes
1
answers
7 views

Category: Questions

Problems importing to Postgresql using auto-generated id

Hi, I would like to import new rows into a Postgresql table where the primary key uses uuid_generate_v4() to generate unique Id's. The problem is that Skyvia requires me to map ....

Created by Elena O'Neil Elena O'Neil 18 February 2019.

Latest by Mariia Zaharova Mariia Zaharova 19 February 2019.

0
votes
4
answers
43 views

Category: Questions

Sync job failure - Value does not exist or does not match filter criteria.

Hey there, I have an error that's cryptic and non-explanatory when I insert a value into my PostgreSQL database and then run a data sync job to (ideally) have it ....

Created by Jacob Widmer Jacob Widmer 11 October 2018.

Latest by Mariia Zaharova Mariia Zaharova 12 October 2018.

0
votes
1
answers
29 views

Category: Questions

Salesforce and Syncing - "... It does not have 'IsDeleted' column."

Hey there,Attempting to sync the RecordType table of a SFDC org to a table I've created in a Postgres database. Unfortunately getting the error: Table cannot be used in synchronization. ....

Created by Jacob Widmer Jacob Widmer 04 October 2018.

Latest by Mariia Zaharova Mariia Zaharova 05 October 2018.

0
votes
8
answers
100 views

Category: Questions

Bi-directional synchronizing Salesforce with PostgreSQL

Hey there,I am attempting to create a "clone" more or less of a few different tables from Salesforce in an external Postgres database. The synchronization tool sounds like it's exactly ....

Created by Jacob Widmer Jacob Widmer 08 August 2018.

Latest by API User Reporting API User Reporting 15 August 2018.

0
votes
5
answers
310 views

Category: Questions

Accessing Postgresql on Heroku

Hi I'm looking at exporting data from a Postgresql database hosted on Heroku, unfortunately, the DB is set to require SSL but Heroku don't make the certificate details available. When I ....

Created by Ben Long Ben Long 09 May 2018.

Latest by Mariia Zaharova Mariia Zaharova 11 May 2018.

0
votes
1
answers
65 views

Category: Questions

Clear or erase a table completely before syncing

I have a table in PostgreSQL which I want to keep sync'd with MailChimp. I currently use the UPSERT operation and it works okay. But when subscribers are removed from MailChimp, ....

Created by Michael Fielding Michael Fielding 18 November 2017.

Latest by Mariia Zaharova Mariia Zaharova 20 November 2017.

Close