Questions

0
votes
3
answers
169 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
52 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
40 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
69 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
51 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
33 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
71 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
82 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
301 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
61 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
163 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
39 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
17 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
148 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
78 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
42 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.

0
votes
2
answers
98 views

Category: Questions

Error accessing AWS

Hello. When we're trying to connect to aws s3 we're receiving the error  Error accessing AWS. Error: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS ....

Created by KS AK KS AK 21 February 2020.

Latest by KS AK KS AK 03 March 2020.

0
votes
1
answers
25 views

Category: Questions

Payment has been provided - still trial

Hello, We have provided the payment for Data integration package. Please contact me via aleksei.volkov@datacom.com.au - I provide you the payment details. ....

Created by Aleksei Volkov Aleksei Volkov 03 March 2020.

Latest by Mariia Riabushenko Mariia Riabushenko 03 March 2020.

0
votes
2
answers
67 views

Category: Questions

QuickBooks credentials require manual refresh

Hello,   Every week, my weekly scheduled package's QuickBooks connector fails. I manually login and then it runs fine.    This has started happening a few weeks ago after working ....

Created by Andrew Mondy Andrew Mondy 23 January 2020.

Latest by Dmitriy Muzurov Dmitriy Muzurov 02 March 2020.

0
votes
1
answers
74 views

Category: Questions

half my records imported

I got Shopify talking to MySQL transferring records.  Only half of the records transferred.  I downloaded the csv log.  (BTW the csv is formatted poorly and does not show correctly ....

Created by Sigmundt Kappel Sigmundt Kappel 27 February 2020.

Latest by Dmitriy Muzurov Dmitriy Muzurov 02 March 2020.

Close