Questions
Category: Questions
View Full History of Replication Package?
Greetings: We have an urgent need to see the full history of the execution of replication package. At present, from the Skyvia UI only lets us view the history ....
Created by
Latest by
Category: Questions
Deleted Package
Dear Skyvia, I per accident deleted a package. Can I get this back? Thanks! Robbie ....
Created by
Latest by
Category: Questions
Fails to import data to salesforce
Hi there, I set up the connection from MySQL to SalesForce. My account is amit@safervpn.com. When we click the Run data import job it fails with error message but there ....
Created by
Latest by
Category: Questions
SkyVia Replication to a SQL Server / Azure SQL DB - Replicate to table in Schema Other Than dbo?
Greetings: Is there any way using SkyVia replication to specific the name of the database schema in which the replicated table should be placed? We have a need ....
Created by
Latest by
Category: Questions
Replication of Salesforce Object and Schema Changes
I am evaluating this tool for data replication from Salesforce to SQL Server database. I want to know if we make any Schema change in Salesforce object ( for example ....
Created by
Latest by
Category: Questions
Backup Set
Hello, I've been running three backups for over a month. I wanted to verify if it's possible to confirm that I'm backing up everything possible for each site. The sites ....
Created by
Latest by
Category: Questions
What happens when an specific execution of a replication package fails?
Greetings: We need a detailed explanation of what happens when a specific execution of a replication package fails? We need to understand what kind of fault tolerance / recoverability ....
Created by
Latest by
Category: Questions
Rolling up multiple rows into a single row and column
Hi, Can you assist me please? I am currently looking into the possibility of using Skyvia to extract data from our e-commerce site. I have constructed a sql query which retrieves all ....
Created by
Latest by
Category: Questions
Need one endpoint to verify OData v4 functionality with Microsoft Dynamics 365 virtual entities
Greetings, I am working with a client who has data in Azure SQL. They want to make this data available within Dynamics 365 (CRM). I proposed using the new "virtual ....
Created by
Latest by
Category: Questions
Error log for failed rows of Import package
I have some Import packages. Mainly they work properly, but sometimes there are a handful of failed rows. I don't see any errors in the Redshift database so it is ....
Created by
Latest by
Category: Questions
The remote server returned an error: (429) Too Many Requests
Setup a new account last night and started integrations between FreshBooks and QuickBooks today. Working through a few failure issues and fixing them, then running a new integration. We're starting ....
Created by
Latest by
Category: Questions
Unable to use SFTP connector in a job
We have a couple of jobs that point to the same SFTP location for exports. On one job, someone changed it from the SFTP to MyPC for testing, but when ....
Created by
Latest by
Category: Questions
Is Amazon RDS available?
Hello Your page for Google BigQuery states that it can integrate with Amazon RDS, but I cannot find the RDS connection in SkyVia. https://skyvia.com/connectors/google-bigquery Is an Amazon RDS connector available ....
Created by
Latest by
Category: Questions
QBO Integration
We have started using your solution to import items into QBO. We can not find how to set the TxnTaxDetail_TxnTaxCodeRefID on a sales receipt. This is a field that can ....
Created by
Latest by
Category: Questions
Can't connect to RedShift (Time Out Error)
Hi guys, I'm trying to connect to Redshift and I'm getting a Timeout error. Pls have a look at my settings and let me know what I'm doing wrong Thanks! ....
Created by
Latest by
Category: Questions
FROM clause in an UPDATE statement
Is there a way to include a FROM clause in an UPDATE statement? ....
Created by
Latest by
Category: Questions
Export Query to FTP Site
I have successfully created a query that formats the data the way I need it but I can't seem to find a way to automatically export the query results to ....
Created by
Latest by
Category: Questions
Cannot Find Correct Format for QuickBooks Deposit Line
I'm trying to sync MS CRM deposits with quickbook deposits. The quickbooks deposits pulls up a field called "Line" with a DT-NTEXT type. I've looked at both the quickbooks online ....
Created by
Latest by
Category: Questions
(400) Bad Request Error - single run
I am running a simple update of 200 records and haven't used Skyvia in 20+ days, yet I'm getting a (400 Bad Request Error), which is usually an API limit ....
Created by
Latest by
Category: Questions
Remove duplicates in CSV prior to upsert to Salesforce
Hi- How can I remove duplicates on an upsert with invoice line items. The invoice has to be upserted first, so there will be duplicate invoice numbers, and then the ....
Created by
Latest by
