Posts Tagged ‘Data Source’

SmartConnect Office Hours

SmartConnect Office Hours Recap for May 3rd, 2019

Thanks for joining the SmartConnect Office Hours last Friday, May 3rd, 2019.  Here is a quick summary of what we covered:Our topic for the day was FTP Data Sources. We focused on pre-map tasks to download a file, security, and backing up a file. Some of the questions asked included:  Would this same process be used to retireve JSON?How…

[Read More]
Tech Tuesday

Use the SmartConnect Change Tracking Table as your Data Source

Use the SmartConnect Change Tracking Table as your Data Source The great thing about a SmartConnect Changes Only integration is that it sets up the SQL Trigger and tracking table for us. To make the process in SmartConnect work, we have to have a field that marks the change table as processed. This extra field,…

[Read More]

The Microsoft Jet database engine could not find the object

We are using the Bulk Data Load Data Source Type and Text File Data Source. We can select our file but when we try the preview we get the error message “ERROR [42S02][Microsoft][ODBC Text Driver] The Microsoft Jet database engine could not find the object ‘Customers.2015.12.13.csv’. Make sure the object exists and that you spell…

[Read More]

Data source name not found and no default driver specified

When attempting to use a SQL resource in SmartConnect, receiving an error that says “Data source name not found and no default driver specified”.  This would include things such as  1.  GP change data source 2.  MSSQL change data source 3.  MSSQL lookup columns.   On SmartConnect 2016 and lower, all three of these items…

[Read More]

Real Time SQL data source in SmartConnect

Attempting to create a real time SQL data source in SmartConnect.  During registration of the trigger, receiving a SQL error that says:Msg 6257, Level 16, State 1, Line 1CREATE ASSEMBLY for assembly ‘eOne.SmartConnect.MSSQLServerRealTime’ failed because the assembly is built for an unsupported version of the Common Language RuntimeThe MSSQL real time data source only works…

[Read More]

Tech Tuesday: Differences in Real-Time and Change Sources

For today’s Tech Tuesday our Senior Technical Consultant, Chris Hanson, discusses the difference between the change based data sources and the real-time data sources within SmartConnect. Both of the options have their own advantages and uses when you are setting up integrations on your system. Change based data sources are always handled at the SQL…

[Read More]

Input string was not in a correct format.

When running a map, receiving an error that says, “Input string was not in a correct format.” for each record being imported, and nothing actually imports.The error indicates an incorrect format was used in a field on the SmartConnect map. For example, a field that expects an integer format is receiving a string, or a…

[Read More]

RECENT POSTS


Use the REST Connector to parse nested Value Arrays
SmartConnect email task fails with error: An invalid character was found in the email header
Does SmartConnect import into Avalara Avatax software
Could not initialize a collection when launching SmartConnect
ERROR [HY000] [Microsoft][ODBC Excel Driver]General error Unable to open registry key when you open a SmartConnect map.

POPULAR POSTS


SSL Security error using OLEDB Connection
Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))
This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms
The server process could not be started because the configured identity is incorrect.
Using WINSCP and a task to upload or download files from an SFTP site

CATEGORIES

ARCHIVES

open all | close all

TAGS

Business Central CRM D365 Business Central Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News error Error Message Events Excel Excel Report Builder Extender Flexicoder GP integration Map Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships partners Popdock release Reporting SalesForce SalesForce.com SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training