Questions
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. ....
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 ....
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 "+". ....
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 ....
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 ....
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 ....
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. ....
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 ....
Category: Questions
See sync logs
Hey, how do we see a log of modified rows / changes in prior syncs? Thanks! ....
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 ....
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 ....
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 ....
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 ....
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 ....
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 ....
Category: Questions
Payment Made - Still on trial
Hi We have made payment, but are still on the trial version for integration. ....
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 ....
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 ....
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 ....