Posts Tagged ‘Tech Tuesday’
Tech Tuesday: Popdock Gateways FAQ
The Popdock Gateways are very useful in connecting your on-premise data to Popdock. Rather than opening a direct connection to your server, they operate as a web service that Popdock can access. Here are some of the more common questions we get while setting up a Gateway:Q: How secure are the Gateways?A: The Popdock Gateways…
[Read More]
Tech Tuesday: A Complete Guide to Popdock for Business Central
Popdock is a powerful tool that can empower Business Central users to do more with their ERP. Data can be accessed from any standard, custom, or ISV table. Once the data is retrieved, Popdock can merge, join, calculate, and even color code the data before displaying it back inside Business Central or any other app…
[Read More]
Tech Tuesday: Error in SmartConnect for D365 Business Central – Column does not belong to table.
An issue commonly encountered in SmartConnect for D365 Business Central is the error message “Column <Column> does not belong to table.” Typically, this error occurs when there is a difference between the fields in the table in the Business Central (BC) table and the service that sits on top of it. This discrepancy can happen when…
[Read More]
Tech Tuesday: Setting up OAuth for Salesforce in SmartConnect
SmartConnect 21 now comes with the feature to use an OAuth connection for your Salesforce connector which is a great way to keep your data and connection secure. 1. In Lightning Experience – In the Setup, enter App in the Quick Find box and select App Manager. Click New Connected App.2. In Salesforce Classic –…
[Read More]
Tech Tuesday: New Feature Spotlight – Integration Groups and Sorting in SmartConnect.com
Integration Groups and Sorting in SmartConnect.com are just a few new features that have been added recently, and this article will explain how to set up and use some of these new options.Why would you use Integration Groups? Integration groups are great for organizing larger implementations. You can create as many as you want and…
[Read More]
Tech Tuesday: Creating a Summarize List by States Between Two Systems
Popdock – A Tale of Two StatesIn my recent testing, I ran into a real-world problem with data formatting that you’re probably facing right now. You’re asked to create a list of customer balances by State which must include customer data from two different systems. No problem, you think, take the lists from both systems,…
[Read More]
Tech Tuesday: SmartConnect Purchase Order Map Error
If you are running a purchase order map and receiving an error that says “370 /* Subtotal (SUBTOTAL) does not match the line item totals” we have an easy fix for you. The Microsoft eConnect SDK has this field marked as required, as it used to be required in older versions of eConnect. The SmartConnect…
[Read More]
Tech Tuesday: Setting up the NetSuite Connector in SmartConnect.com
NOTE: SuiteSignOn is no longer supported by Netsuite and is not an available authentication type in SmartConnect. Token Based Authentication will be the only option, so any existing connections will need to be changed to Token Based Authentication.Setup for Token Based AuthenticationEnable Token Based AuthenticationIn NetSuite, Navigate to Setup>>Company>>Enable Features. Click the Suite Cloud tab…
[Read More]
Tech Tuesday: Executing SmartConnect 2018 Maps from SQL
There are many ways to execute a SmartConnect map; through the interface, scheduled, called by the web service, etc. But one method that also works which isn’t talked about as much is executing a map directly from SQL. The SQL code below covers both the initial setup needed to run maps in this manner as…
[Read More]
Tech Tuesday: SmartConnect 21 Import Process
The import process for SmartConnect 21 is a bit different than it was in SmartConnect 2018. This article will show how the import process works in SmartConnect 21.NOTE: You can NOT import exports of SmartConnect 2018 integrations into SmartConnect 21. Only exports from SmartConnect 21 can be imported.The first step to importing in SC 21…
[Read More]