Questions

0
votes
8
answers
59 views

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 API User Reporting API User Reporting 12 February 2018.

Latest by Mariia Zaharova Mariia Zaharova 09 March 2018.

0
votes
1
answers
28 views

Category: Questions

Deleted Package

Dear Skyvia, I per accident deleted a package. Can I get this back? Thanks! Robbie ....

Created by Shaz Shahrom Shaz Shahrom 05 March 2018.

Latest by Mariia Zaharova Mariia Zaharova 06 March 2018.

0
votes
5
answers
37 views

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 Amit Bareket Amit Bareket 05 March 2018.

Latest by Mariia Zaharova Mariia Zaharova 06 March 2018.

0
votes
4
answers
44 views

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 API User Reporting API User Reporting 28 February 2018.

Latest by Mariia Zaharova Mariia Zaharova 02 March 2018.

0
votes
1
answers
26 views

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 ROHIT JAIN ROHIT JAIN 01 March 2018.

Latest by Mariia Zaharova Mariia Zaharova 02 March 2018.

0
votes
1
answers
36 views

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 Infusion Admin Infusion Admin 21 February 2018.

Latest by Simon Bubnov Simon Bubnov 21 February 2018.

0
votes
8
answers
77 views

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 API User Reporting API User Reporting 12 February 2018.

Latest by Mariia Zaharova Mariia Zaharova 20 February 2018.

0
votes
1
answers
72 views

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 James Bradbury James Bradbury 19 February 2018.

Latest by Mariia Zaharova Mariia Zaharova 20 February 2018.

0
votes
5
answers
187 views

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 Tim Dutcher Tim Dutcher 02 February 2018.

Latest by Mariia Zaharova Mariia Zaharova 16 February 2018.

0
votes
3
answers
42 views

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 vincent esterly vincent esterly 14 February 2018.

Latest by Mariia Zaharova Mariia Zaharova 16 February 2018.

0
votes
1
answers
51 views

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 Kevin Bush Kevin Bush 15 February 2018.

Latest by Mariia Zaharova Mariia Zaharova 16 February 2018.

0
votes
13
answers
79 views

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 Skyvia Integration Skyvia Integration 22 January 2018.

Latest by Mariia Zaharova Mariia Zaharova 14 February 2018.

0
votes
1
answers
51 views

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 Lachlan Arthur Lachlan Arthur 09 February 2018.

Latest by Mariia Zaharova Mariia Zaharova 09 February 2018.

0
votes
2
answers
56 views

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 Rob Murphy Rob Murphy 30 December 2017.

Latest by Mariia Zaharova Mariia Zaharova 08 February 2018.

0
votes
5
answers
95 views

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 Philippe Taillefer Philippe Taillefer 06 February 2018.

Latest by Mariia Zaharova Mariia Zaharova 08 February 2018.

0
votes
1
answers
34 views

Category: Questions

FROM clause in an UPDATE statement

Is there a way to include a FROM clause in an UPDATE statement? ....

Created by Kenneth Garron Kenneth Garron 06 February 2018.

Latest by Mariia Zaharova Mariia Zaharova 07 February 2018.

0
votes
3
answers
42 views

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 Patrick Wambach Patrick Wambach 27 January 2018.

Latest by Mariia Zaharova Mariia Zaharova 02 February 2018.

0
votes
1
answers
21 views

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 Allison Harden Allison Harden 01 February 2018.

Latest by Mariia Zaharova Mariia Zaharova 02 February 2018.

0
votes
1
answers
51 views

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 Jay Kilian Jay Kilian 01 February 2018.

Latest by Mariia Zaharova Mariia Zaharova 02 February 2018.

0
votes
1
answers
42 views

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 Richard Potter Richard Potter 30 January 2018.

Latest by Mariia Zaharova Mariia Zaharova 31 January 2018.

Close