Tickets Tagged With:sql-server
Category: Feature Requests
Consider allowing hyphens in table name prefixes (SQL Server)
Hi - Our SQL Server target table prefixes are based on our project codes and names, like: 201-8080-01-Zambia-ABC ... Since Skyvia does not allow hyphens in the prefixes (and for ....
Created by
Latest by
Category: Questions
Import package from BigCommerce not importing data to SQL Server
We have a Import package that is fetching data from BigCommerce and importing to SQL Server. After running the package we can see that it succeeds, and we see the ....
Created by
Latest by
Mariia Zaharova
12 January 2023.
Category: Bug Reports
When adding Sugar CRM's "Contacts" object to a replication package, getting Unexpected SugarType
I created a connection to a Sugar CRM account. I am using it to create a replication package to replicate information from Sugar to SQL Server. I succesfully added Accounts, ....
Created by
Latest by
Mariia Zaharova
28 April 2022.
Category: Questions
Salesforce Record Id not being written back
Hi, I have a synchronization in place with Salesforce as Source and SQL Server as Target. When I add a row to a table in SQL Server a corresponding record ....
Created by
Latest by
Category: Questions
Skyvia Agent - TLS 1.2 and 1.3 support
I got a message from our clients server manager telling me they will update their servers. They will disable SSL 2.0, SSL 3.0, TLS 1.0 and TLS 1.1 Instead ....
Created by
Latest by
Category: Questions
Will Salesforce MFA requirement affect my SQL replication connection?
https://help.salesforce.com/s/articleView?id=000352937&type=1 Salesforce will require multi-factor authentication. How does this affect my Salesforce to SQL Server replication OAuth 2.0 connection. I use the web service not the installed agent. ....
Created by
Latest by
Category: Questions
Changing name of target table in a Replication Package
Is there a way to modify the target table name when setting up a replication? I am replicating multiple tenants in Pipedrive to a single database and because the primary ....
Created by
Latest by
Mariia Zaharova
11 January 2022.
Category: Bug Reports
Agent that Connects to SQL Server is Failing to Connect
Hi, I'm testing a proof of concept implementation of Skyvia's Salesforce - SQL Server synchronization capability. As part of this I've downloaded and configured an agent on a machine that sits ....
Created by
Latest by
Category: Questions
Synchronization creates new row rather than update old row
I have set up synchronization to move data from a website (mysql) to sql server and vice versa. When data is updated on the website, instead of syncing that data ....
Created by
Latest by
Category: Questions
Sync Package error Zoho to SQL Server, suspect destination column is to small.
I have encountered an error while running one of my sync packages that syncs data from Zoho to a table in SQL Server. The sync has run trouble free for ....
Created by
Latest by
Category: Bug Reports
Skyvia does not allow me to pull more than 2048 records, then it errors out.
https://app.skyvia.com/#/29060/packages/123786/debug Source Connection is Marketing Cloud using a Data Extension. Target is a SQL server 2016 connecting through an Agent. We are using the new runtime. It ....
Created by
Latest by
Category: Questions
SQL Transport Layer Error
Hello Support Team!I'm having an issue with Skyvia importing data into SQL and the issue seems to be inconsisntently happening. Today most of the automatic (Scheduled) package runs were successful ....
Created by
Latest by
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
Latest by
Mariia Zaharova
26 February 2021.
Category: Bug Reports
What's the maximum number of column's to select ?
Hey, I have raised a ticket yesterday and with your help have resolved it, but I just have a question about whats the maximum number of coulmun's we can select ....
Created by
Latest by
Mariia Zaharova
11 February 2021.
Category: Bug Reports
Getting and error while replicating the data from Hubspot to SQL server
Hi all, I'm replicating the data from hubspot to SQL server and all other tables have replicated to the SQL server,but 'Deals" table is giving me an error(Screenshot attached below), ....
Created by
Latest by
Mariia Zaharova
10 February 2021.
Category: Bug Reports
Not able to map DT_I4 to DT_WSTR
While importing, whenever I try to map an integer field from SQL to string field in Salesforce, system says invalid type map. ....
Created by
Latest by
Mariia Zaharova
10 August 2020.
Category: Bug Reports
Object reference not set to an instance of an object. - Import SQL to Salesforce
When importing from the SQL Server to Salesforce, the import package always fails with the error. Object reference not set to an instance of an object. ....
Created by
Latest by
Mariia Zaharova
08 August 2020.
Category: Bug Reports
An item with the same key has already been added.
While exporting a table from sql-server to sftp task always fail stating "An item with the same key has already been added."Please Check. No tasks are working. ....
Created by
Latest by
Mariia Zaharova
07 August 2020.
Category: Bug Reports
Getting A Task Was Cancelled on Salesforce and Azure SQL Server connections
I'm trying to edit and create some tasks that are transferring data between SF and Azure SQL Server but when I click the add task or edit task buttons the ....
Created by
Latest by
Mariia Zaharova
14 July 2020.
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
Latest by
