Tickets Tagged With:sql-server

0
votes
3
answers
21 views

Category: Questions

Import job with sql server as source, to get incremental (delta) data changes using LAST_RUN

After initial data sync with SQL Server as source, we are trying to use an import job to pick up delta (new/changed) data. We are comparing the dateUpdated column (datetime datatype ....

Created by robert fisher robert fisher 3 weeks ago.

Latest by Dmitriy Muzurov Dmitriy Muzurov 3 days ago.

0
votes
4
answers
58 views

Category: Questions

Error: Push Order Shipments to BigCommerce

We are facing an error to map our DB table field with BigCommerce Create Shipment integration. Because, BigCommerce API request parameter "items" type is array.   API reference: https://developer.bigcommerce.com/api-reference/orders/orders-api/order-shipments/createordershipments   How we can ....

Created by Australian NaturalCare Australian NaturalCare 18 February 2020.

Latest by Dmitriy Muzurov Dmitriy Muzurov 06 March 2020.

0
votes
2
answers
14 views

Category: Questions

Create Record and Sync

How to question I use an import integration to create records in SalesForce. After this is complete I need SalesForce to update the original SQL data source with the new ....

Created by Ken Banks Ken Banks 25 February 2020.

Latest by Ken Banks Ken Banks 28 February 2020.

0
votes
2
answers
21 views

Category: Questions

Using SQL Server Views

I have a daily package that runs and part of it adds any recently Invoiced Orders to a custom module in zoho crm. I have noticed that it misses quite ....

Created by Ryan Mirto Ryan Mirto 25 February 2020.

Latest by Ryan Mirto Ryan Mirto 28 February 2020.

0
votes
5
answers
36 views

Category: Questions

Upsert to SQL Succeeds, but no data exists?

Hello,   I created a table in SQL that mirrors my Zendesk table (organization). I set the ID column as primary key not null identity, and enabled identy insert. When ....

Created by Ben West Ben West 18 December 2019.

Latest by Dmitriy Muzurov Dmitriy Muzurov 20 December 2019.

0
votes
1
answers
161 views

Category: Questions

Determining identical records during initial sync

I want to setup bi-directional integration between SalesForce and MS SQL Server. The amount of data is very large so we would like to import data beforehand from Source to ....

Created by Vlad Shmulskyi Vlad Shmulskyi 16 May 2019.

Latest by Dmitriy Muzurov Dmitriy Muzurov 17 May 2019.

0
votes
1
answers
188 views

Category: Questions

Unable to connect to SQL Server

Hi All, We are trying to connect to our local database (SQL Server) but even after setting the TCP/IP and Firewall as given in documentation it is not working. Please ....

Created by Darshan Bhattad Darshan Bhattad 09 May 2019.

Latest by Simon Bubnov Simon Bubnov 10 May 2019.

0
votes
2
answers
190 views

Category: Questions

Trying to map invalid data type sql to dynamics 365

1. If I pull data from sql and exported to excel, upload it to skyvia and do upsert to dynamics 365, works fine. If I try to do it straight ....

Created by Andy Le Andy Le 03 April 2019.

Latest by Andy Le Andy Le 04 April 2019.

0
votes
3
answers
196 views

Category: Bug Reports

Large Salesforce tables Replication Fails

My salesforce replication job's are failing to sync for the first time. I've copied details below on the tables affected. I have a lot of records in the tables and ....

Created by Steve Tempest Steve Tempest 07 January 2019.

Latest by Mariia Zaharova Mariia Zaharova 10 January 2019.

0
votes
1
answers
182 views

Category: Questions

Unable to synchronize records between Salesforce and SQL Server

Hello, I'm having trouble getting the syncronization integration between my salesforce account and a table on my sql server to actually syncronize records. I am trying to send salesforce contacts ....

Created by Jeff Monian Jeff Monian 11 July 2018.

Latest by Mariia Zaharova Mariia Zaharova 12 July 2018.

0
votes
3
answers
208 views

Category: Bug Reports

Not able to edit certain Tasks

Hi , We have 10 taks that have the same source (SQL Table) and destination (SFDC object) - The only change is the data selectio criteria.  We were able to edit ....

Created by Michael Kumaraswamy Michael Kumaraswamy 08 December 2017.

Latest by Simon Bubnov Simon Bubnov 13 December 2017.

0
votes
1
answers
301 views

Category: Bug Reports

Insertion Failed because the database is full database or disk is full

  Ran into this issue today. " An exception has occured during data processing , the message returned from the provider is : Insertion failed because the database is full ....

Created by Michael Kumaraswamy Michael Kumaraswamy 11 December 2017.

Latest by Simon Bubnov Simon Bubnov 13 December 2017.

0
votes
14
answers
2.1K views

Category: Questions

Transport Level error when loading 343230 records into Salesforce

I am running a package to import 343230 records into Salesforce. After inserting about 50000 records it gives the following error.   A transport-level error has occurred when receiving results ....

Created by Michael Kumaraswamy Michael Kumaraswamy 16 November 2017.

Latest by Michael Kumaraswamy Michael Kumaraswamy 09 December 2017.

0
votes
8
answers
559 views

Category: Questions

Upsert operation for importing Product2 and PriceBookEntry

We are trying to import Product2 and PriceBookEntry data from a single table in SQL server. It will be a weekly scheduled job. The insert operation works fine. But How ....

Created by Marina Seredova Marina Seredova 30 October 2017.

Latest by Mariia Zaharova Mariia Zaharova 10 November 2017.

0
votes
1
answers
220 views

Category: Questions

Skyvia and SQL Server

 I went through the instructions to conect SQL Server, but I am still having issues. Can someone help walk me through the process, or even dial in to my computer ....

Created by Brad Ferch Brad Ferch 08 November 2017.

Latest by Mariia Zaharova Mariia Zaharova 09 November 2017.

0
votes
16
answers
253 views

Category: Bug Reports

Import job not running

We are trying to run an import job consisting of 3 tables - Table A is parent of Tables B and C. TIll yesterday it was working fine. But today it ....

Created by Marina Seredova Marina Seredova 25 October 2017.

Latest by Mariia Zaharova Mariia Zaharova 07 November 2017.

0
votes
4
answers
499 views

Category: Questions

Unable to create New Connection to SQl Server

Hi Team, I have configured my SQL server properly as per the documentation you provided. I am using SQL Server 2014 Express. But while creating connection, I am getting below ....

Created by Niraj Ganani Niraj Ganani 27 October 2017.

Latest by Niraj Ganani Niraj Ganani 27 October 2017.

0
votes
4
answers
575 views

Category: Questions

Unable to connect to AWS Sql Server for replication from NetSuite

I'm trying to evaluate your replication software using NetSuite as source. For the destination I just created a new AWS SQL Server instance, and set it to be publicly accessible. ....

Created by Ed Zanelli Ed Zanelli 27 October 2017.

Latest by Mariia Zaharova Mariia Zaharova 27 October 2017.

0
votes
4
answers
710 views

Category: Questions

Can't Connect to SQL Server 2014 Express

what am I doing wrong?  I tried EVERYTHING to create a connection to the SQL Server 2014 Express on my development machine running under Windows 10 and I keep getting ....

Created by Marianne Seggerman Marianne Seggerman 03 September 2017.

Latest by Marianne Seggerman Marianne Seggerman 11 September 2017.

0
votes
2
answers
645 views

Category: Questions

Connection to SQL Server.

I get an error when I want to connect to SQL Server. The connection data is provided by the hosting.   Where should I write the connection port? Should the ....

Created by Ivan Ivan Ivan Ivan 28 August 2017.

Latest by Ivan Ivan Ivan Ivan 28 August 2017.

Close