Questions

0
votes
4
answers
51 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
40 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
42 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
99 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
120 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
226 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
59 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
96 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
81 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
61 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
60 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
153 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
45 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
30 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
61 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
47 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.

0
votes
3
answers
139 views

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 Ashish Tergaonkar Ashish Tergaonkar 23 January 2018.

Latest by Mariia Zaharova Mariia Zaharova 29 January 2018.

0
votes
1
answers
16 views

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 Keith Garosshen Keith Garosshen 26 January 2018.

Latest by Mariia Zaharova Mariia Zaharova 29 January 2018.

0
votes
6
answers
44 views

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 API User Reporting API User Reporting 19 January 2018.

Latest by Mariia Zaharova Mariia Zaharova 25 January 2018.

Close