Questions

0
votes
2
answers
26 views

Category: Questions

Cannot get started

I want to used Skyvia Querey to add Jira data to Google Sheets. I created a Skyvia account and installed the add-on from Google Store but now I'm stuck. If I go ....

Created by Steve Rohde Steve Rohde 07 May 2020.

Latest by Steve Rohde Steve Rohde 08 May 2020.

0
votes
1
answers
19 views

Category: Questions

Zoho CRM synchronization

Hello, My Zoho account is located in an Australian DC. So when I try to connect my Zoho account to skyvia an "Invalid client" error is returned. For this to ....

Created by Michael thiriet Michael thiriet 29 April 2020.

Latest by Mariia Zaharova Mariia Zaharova 29 April 2020.

0
votes
1
answers
66 views

Category: Questions

No expression editor and how to add todays date in an integration

Hi, it says in the documentation that when creating an integration I can use expression, and then click to get up an expression editor. That does not work as I ....

Created by Peter Alvestal Peter Alvestal 23 April 2020.

Latest by Mariia Zaharova Mariia Zaharova 24 April 2020.

0
votes
6
answers
44 views

Category: Questions

Replicating from Salesforce to MS Azure MS SQL Database

I am trying to replicate Salesforce data to a Microsoft Azure SQL Database. I have set up connection and target correctly as both when tested connection succeeds. However when I ....

Created by Charles Cabato Charles Cabato 15 April 2020.

Latest by Mariia Zaharova Mariia Zaharova 22 April 2020.

0
votes
1
answers
21 views

Category: Questions

SalesForce Query

Hi,   I'm getting "You have reached a limit of queries." after I ran around 5 queries, can you please advice on what would be the issue?  Regards, Sameh ....

Created by Sameh ELSOKKARY Sameh ELSOKKARY 18 April 2020.

Latest by Mariia Zaharova Mariia Zaharova 21 April 2020.

0
votes
1
answers
22 views

Category: Questions

Skyvia can help to import CSV files from Azure blob (file) storage to salesforce ?

Skyvia can help to import CSV files from Azure blob (file) storage to salesforce ? ....

Created by Sanjeeva Gajula Sanjeeva Gajula 17 April 2020.

Latest by Mariia Zaharova Mariia Zaharova 17 April 2020.

0
votes
1
answers
18 views

Category: Questions

Backup Files not creating -

Hi,   Our invoice has suddenly stopped working since your upgrade.  We have also stopped getting our data exported every night.  I left a message few days ago in your ....

Created by Vinny Vinny 17 April 2020.

Latest by Mariia Riabushenko Mariia Riabushenko 17 April 2020.

0
votes
2
answers
31 views

Category: Questions

Update Target Values ONLY if Blank

Hi, In an update mapping, is it possible to specify to update the target value with the source value ONLY if the target value is blank? I don't want to ....

Created by Jennifer Good Jennifer Good 14 April 2020.

Latest by Jennifer Good Jennifer Good 16 April 2020.

0
votes
3
answers
317 views

Category: Questions

HubSpot Contacts to Microsoft Dynamics Leads Synchronization

I was able to successfully sync HubSpot contacts to Dynamics 365 contacts, but when I attempt the same synch with HubSpot contacts to Dynamics LEADS, I am returning an error ....

Created by Scott Harris Scott Harris 13 April 2020.

Latest by Mariia Zaharova Mariia Zaharova 16 April 2020.

0
votes
1
answers
16 views

Category: Questions

multiple users refreshing Google Sheets

We have a few users who all share a Google Sheet. I've just built some queries in Skyvia to pull in data from a PgAdmin database and am able to ....

Created by Dana Meroniuk Dana Meroniuk 15 April 2020.

Latest by Mariia Zaharova Mariia Zaharova 15 April 2020.

0
votes
1
answers
11 views

Category: Questions

Scheduling

Hi,  I am creating a schedule where a) Occurs once a day at 80 AM (central time). b) Starting on 10th April 2020 at 80AM.  the scheduler did not run. ....

Created by Alex Ramos Alex Ramos 10 April 2020.

Latest by Mariia Zaharova Mariia Zaharova 13 April 2020.

0
votes
1
answers
12 views

Category: Questions

Do you have a real time event

Hello Dear Skavia Support, My name is Iryna. We want to suggest to our client to use Skyvia. But we have one question. Do you have a real time event ....

Created by Priya Jethwa Priya Jethwa 09 April 2020.

Latest by Mariia Zaharova Mariia Zaharova 09 April 2020.

0
votes
1
answers
12 views

Category: Questions

unable to connect to the zoho people

unable to connect to the zoho people ....

Created by ECS Financials ECS Financials 06 April 2020.

Latest by Mariia Zaharova Mariia Zaharova 07 April 2020.

0
votes
2
answers
79 views

Category: Questions

Need to concatanate data types "DT_WSTR" and "DT_NTEXT"

Trying to concatanate "DT_WSTR" and "DT_NTEXT" in to a single DT_NTEXT field via an expression. but get the following error. The data types "DT_WSTR" and "DT_NTEXT" are incompatible for binary operator "+". ....

Created by Brian Price Brian Price 30 March 2020.

Latest by Brian Price Brian Price 06 April 2020.

0
votes
3
answers
67 views

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 robert fisher robert fisher 19 March 2020.

Latest by Dmitriy Muzurov Dmitriy Muzurov 02 April 2020.

0
votes
1
answers
34 views

Category: Questions

SQL source login failed for user

Hello,   We had to restore our SQL database and since the restore we cannot connect to the source.   Error 'Login failed for user 'xxx'.    Can you explain what permissions ....

Created by Troy Theobald Troy Theobald 01 April 2020.

Latest by Dmitriy Muzurov Dmitriy Muzurov 02 April 2020.

0
votes
1
answers
21 views

Category: Questions

Support for Salesforce JWT Bearer Flow Connection

Do you support Salesforce connection using JWT Bearer (cert), see below connection option? https://help.salesforce.com/articleView?id=remoteaccess_oauth_jwt_flow.htm&type=5 ....

Created by Panneer Subramanian Panneer Subramanian 02 April 2020.

Latest by Mariia Zaharova Mariia Zaharova 02 April 2020.

0
votes
1
answers
38 views

Category: Questions

Salesforce Odata error when 'Validate External Object: DW_Customers

I am new to Odata setup within Skyvia, and need to know what this error means:   EXTERNAL_OBJECT_EXCEPTION: We encountered an error while querying the external data. Contact your administrator. ....

Created by Rackspace Admin Rackspace Admin 27 March 2020.

Latest by Dmitriy Muzurov Dmitriy Muzurov 31 March 2020.

0
votes
1
answers
20 views

Category: Questions

Schedule an SQL query

Hello, We would like to schedule daily extracts from Salesforce have a couple of questions please: 1- Can we relabel the fields on the export package e.g. Field Location__c to ....

Created by Ramtin Sohrabian Ramtin Sohrabian 30 March 2020.

Latest by Dmitriy Muzurov Dmitriy Muzurov 30 March 2020.

Close