Questions
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
Category: Questions
SQL Server Connection Forcibly Closed
Hello, While I am successfully able to connect to the SQL Server, I am getting the following error - Login failed for user 'skyvia'. A connection was successfully established with the ....
Created by
Latest by
Category: Questions
Endpoint url response is 404 not found
Hi I created a new endpoint url and when I hit the url it responds with 404 not found ....
Created by
Latest by
Category: Questions
Replicate - Replicate the Replication Package Execution Tables?
Greetings: My organization would like to be able to perform task in SQL Server, which we are using as a destination for SkyVia replication, when a particular package is ....
Created by
Latest by
