Questions

0
votes
1
answers
13 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
14 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
14 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
110 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
77 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
37 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
25 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
42 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
23 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.

0
votes
1
answers
21 views

Category: Questions

See sync logs

Hey, how do we see a log of modified rows / changes in prior syncs?   Thanks! ....

Created by Athena Alliance Athena Alliance 25 March 2020.

Latest by Mariia Zaharova Mariia Zaharova 26 March 2020.

0
votes
5
answers
33 views

Category: Questions

How to Split FIRST NAME from LAST NAME

Hi, I am setting up a syncronization between zoho and mysql, and it has been challenging finding an expression to split first name from last name that the system can ....

Created by Pedro Deleon Pedro Deleon 21 March 2020.

Latest by Mariia Zaharova Mariia Zaharova 24 March 2020.

0
votes
9
answers
53 views

Category: Questions

Duplicate insert error

Hello, I want to ask about our run 34278256 We have a joint table of ContactLeads, that doesn't have a primarykey or a unique identifier, but a combined one of ContactID ....

Created by NLC Ventures NLC Ventures 13 March 2020.

Latest by Mariia Zaharova Mariia Zaharova 24 March 2020.

0
votes
4
answers
214 views

Category: Questions

REST Metadata

Trying to setup a source connection via REST Api using a GET request from Callrail's /calls.json endpoint and unsure what needs to be included in the Metadata field. I know ....

Created by Joshua Harvey Joshua Harvey 15 January 2020.

Latest by Mariia Zaharova Mariia Zaharova 23 March 2020.

0
votes
2
answers
32 views

Category: Questions

Target Lookup Issue

I have tried setting up this target lookup and read all of the documentation but it is not working as expected. Every way I have setup it just creates a ....

Created by Michael Connelly Michael Connelly 12 March 2020.

Latest by Dmitriy Muzurov Dmitriy Muzurov 16 March 2020.

0
votes
6
answers
82 views

Category: Questions

URI for Nav OData web service

Hello Skyvia and community, I am trying to setup an import integration from a MS Navision instance based on an OData web service.  I am able to see the metadata ....

Created by Richard  Trum Richard Trum 03 March 2020.

Latest by Mariia Zaharova Mariia Zaharova 10 March 2020.

0
votes
1
answers
25 views

Category: Questions

Expression to combine incompatible data types

I need to concatenate name and Date of Birth for one of my fields. I am getting this error:     How can I format this to work? The data types ....

Created by Michael Macks Michael Macks 09 March 2020.

Latest by Mariia Zaharova Mariia Zaharova 10 March 2020.

0
votes
0
answers
9 views

Category: Questions

Payment Made - Still on trial

Hi  We have made payment, but are still on the trial version for integration. ....

Created by Andy Tyrer Andy Tyrer 09 March 2020.

0
votes
4
answers
92 views

Category: Questions

Error: Push Order Shipments to BigCommerce

We are facing an error to map our DB table field with BigCommerce Create Shipment integration. Because, BigCommerce API request parameter "items" type is array.   API reference: https://developer.bigcommerce.com/api-reference/orders/orders-api/order-shipments/createordershipments   How we can ....

Created by Australian NaturalCare Australian NaturalCare 18 February 2020.

Latest by Dmitriy Muzurov Dmitriy Muzurov 06 March 2020.

0
votes
5
answers
50 views

Category: Questions

No data replicated Zoho CRM - MySQL DB

Good afternoon, we have tried several attempts to make a replication between Zoho CRM and our MySQL db, however the query didn't return any results. Could you please provide some ....

Created by NLC Ventures NLC Ventures 26 February 2020.

Latest by NLC Ventures NLC Ventures 04 March 2020.

0
votes
1
answers
28 views

Category: Questions

AWS S3 File Location not working

Hi Team,  We are testing a free account to test imports from AWS S3 into our SQL Server. But when creating a connection for AWS S3 it come succesfull when ....

Created by Juan Rivera Juan Rivera 03 March 2020.

Latest by Mariia Zaharova Mariia Zaharova 04 March 2020.

Close