Showing posts with label Microsoft dynamics crm. Show all posts
Showing posts with label Microsoft dynamics crm. Show all posts

Tuesday, August 5, 2014

Tech Tuesday: SmartConnect Web Service Destination

This week's Tech Tuesday is from our Senior Technical Consultant, Chris Hanson, who has provided a video demonstration on SmartConnect's web service destination! 

This week we are looking at using the web service destination within SmartConnect, which allows for integrations that can be setup to systems or web sites that use web services as their primary means for communication. The setup for the web service destination is a two step process where the web service connection has to be defined initially and then after that it can be used in any map you setup. There is also an option to use a web service as a data source which we will cover in a future article to illustrate how to pull data out from them as well. 


Want more SmartConnect info? Email sales@eonesolutions.com!

Tuesday, July 8, 2014

Tech Tuesday: Identifying the Source Company in a SmartConnect Real-Time Map

This week's Tech Tuesday is from our Senior Technical Consultant, Chris Hanson, who will show us the easiest method to tracking the Source Company in a Real-Time Map.

One of our features in SmartConnect is a real-time data source that allows maps to automatically execute when a certain event is triggered. When using a GP real-time source you can setup that source once to be used across every GP company if needed. The issue is then how you can identify which company the event/data comes from as that is not tracked by default within the source.

The easiest method to track the source company is to use the DB_NAME() function that is built into SQL. That statement can be added to any SQL based data source (real-time or otherwise) in order to identify the database the data is coming from as it will return the current database if no parameter is passed into it.

For a real-time map, that function would be added within the query builder when setting up the source. In the screenshot below, DB_NAME() was added as an expression with the Alias for that result set to SourceCompany so it is easy to identify when looking through the columns while building the actual mapping. 



The result of that function should return the SQL name of the database/company that the data is coming from. So if we were using the Fabrikam company to test this map, it would have TWO set as the value when triggered from that company. That value can then be used in restrictions, tasks, or other additional columns as needed to ensure the data is processed correctly when the map runs.

Have something you'd like to see covered in a Tech Tuesday article? Send them in to sales@eonesolutions.com!

Friday, June 27, 2014

SmartConnect 2014 releases today!

It's here... SmartConnect 2014!
We are very excited to release SmartConnect 2014 today!

This release will work for any of the following versions of Dynamics GP(10, 2010, 2013, 2013 R2), Dynamics CRM (4, 2011, 2013, online) and all the more generic connectors (SalesForce.com, Web Services, Text Files, XML, SQL,etc).


SmartConnect 2014 has some really great features added along with several fixes. Below are a few of the really exciting features along with the download below:
http://www.eonesolutions.com/Products/Downloads


SQL Server Realtime Triggers – This feature allows you to run a SmartConnect map and use the data from the just saved record in SQL Server. Any SQL table can have this added.

Microsoft Dynamics CRM Bulk Destination – As larger datasets need to be sent to Dynamics CRM the load on the CRM Webservice can be reduced by using the Bulk Destination for CRM and sending more data in one document.

Microsoft Dynamics CRM Entity Lookup Enhancements – Entity Lookups allow you to work with Microsoft Dynamics CRM data without needing to know the complexities of the GUIDs or needing an intermediary datastore to synchronize Dynamics CRM data. We have enhanced this feature set allowing you to use other calculated fields and transformations in the lookups.

SalesForce.com Entity Lookup Enhancements – Entity Lookups allow you to work with SalesForce data without needing to know the complexities of the GUIDs or needing an intermediary datastore to synchronize SalesForce data. We have enhanced this feature set allowing you to use other calculated fields and transformations in the lookups.

Rolling Column New Features (Next Document Numbers) – We have added most document types and now you can even have multiple in a specific map. Custom Rolling Columns are available globally now instead of just on a specific map. Additionally, you can pass in data source fields and calculated fields in determining the correct document type.

Disable/Enable all tasks – Quickly enable/disable all tasks when testing maps. This can be very useful when you have a process like sending an email or updating a SQL table on the success or failure and you only want that to run when the map is ready for production. 


Enhanced Transformation Abilities – I really love this feature. We have basically allowed you to use the transformation fields (Calculated Fields, Lookups, Translations, etc.) everywhere inside of the application. When you look at SmartConnect as an ETL tool you can see that this adds another level of robustness when delivering any solution for your business needs.

Thanks,
Chris Dew
Director of Product Management


Do you have any questions regarding the latest release of SmartConnect 2014? Email us at sales@eonesolutions.com and we would be happy to help!

10 Facts About Upgrading from Integration Manager to SmartConnect

We have seen an increase of customers making the upgrade from Integration Manager to SmartConnect. Over 2,000 Dynamics GP customers have already made the switch for their integration needs.

Curious to know why so many people have made the switch? We've made it easier for you to see the benefits of upgrading to SmartConnect in the video below:



Interested in upgrading or simply purchasing SmartConnect? Email us with any questions at sales@eonesolutions.com and we would be happy to assist you!

Tuesday, June 24, 2014

Tech Tuesday: Creating a Task in SmartConnect to get a file from an FTP site

This weeks Tech Tuesday is from our very own Chris Dew, our Director of Product Management, who will explain how to create a task in SmartConnect to get a file from an FTP site.

We get quite a few customers that want to take files from a FTP site and utilize this file as the source of their data when running a map inside of SmartConnect. Today I have created a sample Task script that will allow you to grab a file in a Pre Map Task and then use it for the integration.

First you can simply click on the Tasks button in any existing map, and then choose a new task called run script. This is where you can now copy the script below and paste into this window (like in the image below).



=================================================================

'EXAMPLE OF HOW TO USE FtpWebRequest

        'Configuration
        Const localFile As String = "C:\Users\Administrator\Downloads\ftpREADME.txt"
        Const remoteFile As String = "/README.txt"
        Const host As String = "ftp://ftp.swfwmd.state.fl.us/pub/"
        Const username As String = "anonymous"
        Const password As String = "email@email.com"

        'Create a request
        Dim URI As String = host & remoteFile
        Dim ftp As System.Net.FtpWebRequest = CType(System.Net.FtpWebRequest.Create(URI), System.Net.FtpWebRequest)
        'Set the credentials
        ftp.Credentials = New System.Net.NetworkCredential(username, password)
        'Turn off KeepAlive (will close connection on completion)
        ftp.KeepAlive = False
        'we want a binary
        ftp.UseBinary = True
        'Define the action required (in this case, download a file)
        ftp.Method = System.Net.WebRequestMethods.Ftp.DownloadFile

        'If we were using a method that uploads data e.g. UploadFile
        'we would open the ftp.GetRequestStream here an send the data

        'Get the response to the Ftp request and the associated stream
        Using response As System.Net.FtpWebResponse = CType(ftp.GetResponse, System.Net.FtpWebResponse)
            Using responseStream As IO.Stream = response.GetResponseStream
                'loop to read & write to file
                Using fs As New IO.FileStream(localFile, IO.FileMode.Create)
                    Dim buffer(2047) As Byte
                    Dim read As Integer = 0
                    Do
                        read = responseStream.Read(buffer, 0, buffer.Length)
                        fs.Write(buffer, 0, read)
                    Loop Until read = 0 'see Note(1)
                    responseStream.Close()
                    fs.Flush()
                    fs.Close()
                End Using
                responseStream.Close()
            End Using
            response.Close()
        End Using
return true
=================================================================

The only configuration that needs to be done is at the very top where you determine four things:
1) The name and location you want to put the file on your network
2) The name of the remote file
3) FTP Site
4) Username
5) Password

Have fun with this one and use your imagination on other scripts you can use. If you have a suggestion for a new script please let me know.

chris.dew@eonesolutions.com

Thanks,
Chris Dew

Interested in SmartConnect? Please email us at sales@eonesolutions.com and we would be happy to assist you!

Wednesday, June 18, 2014

Props to SmartConnect

We are always on the lookout for satisfied (and possibly-not-quite-satisfied) so that we can continue to improve our software and go above and beyond the expectations of our clients. It has recently been brought to our attention that the Markovich Report - a blog by one of our SmartConnect users, was written praising SmartConnect and labeling it his choice integration tool for Microsoft Dynamics GP & CRM.

After listing the other integration options (i.e. Scribe, Connector from Microsoft, writing it yourself) he states,  
"Or you could eliminate all of that nonsense and time wasting and just use SmartConnect from eOne. In fact, you should definitely do that. SmartConnect has changed my life at work."
He also gave this tid bit:
"Side note: this was done without me really knowing much about the CRM tables or how the CRM web services really work. What I found was this: it’s not really necessary. eOne has done all of the heavy lifting for me initially and it’s just up to me to decide what information I want to sync."
So big props to SmartConnect for taking on all the heavy lifting for Joe and for offering many more options to integrate between GP and CRM. Also a big thank you to Joe for your kind words and feedback regarding eOne SmartConnect, we appreciate it!

For the full blog you may view it here.


Do you have a story about how SmartConnect has benefited you? If so we'd LOVE to hear it, please email your story to us at sales@eonesolutions.com!

Tuesday, May 27, 2014

Tech Tuesday: How to Determine if eConnect is Installed or Running on a Machine.

We try to cover questions and issues in our Tech Tuesday articles that we see frequently to equip you before you even think of the question, allowing you to use our products more efficiently and seamlessly. This week our Support Guru, Dave Youngquist, will walk you through determining if eConnect is installed or running on a machine for SmartConnect.

1. Press the Windows + R keys on your keyboard (will open the Run command)

2. Type in services.msc and click the OK button

3. The Services window will open. Scroll down until you see an entry that says “eConnect for Microsoft Dynamics GP 20XX Integration Service”. It may say 2010 or 2013 depending on the version of Microsoft Dynamics GP you are on.  


4. SmartConnect requires that the eConnect runtime be installed on every machine that has SmartConnect installed on it. If you do not see it listed in Services, it is not installed. Rerun the SmartConnect installer, and pick a version of eConnect to install on the machine.  eConnect 10 is for GP 10, eConnect 2010 is for GP 2010, and eConnect 2013 is for GP 2013. 

5. If eConnect appears in this window, then look in the column that says “Status” make sure that the status is set to “Started”. If the status is not set to started, then right click on the eConnect for Microsoft Dynamics GP 20XX Integration Service and select “Start” from the drop down menu. 

6. Watch the service for about 15 seconds. It should start and stay started. If it starts, and then stops within 15 seconds it means either the password is wrong, or the user is not a local machine administrator. 


7. To retype the password, right click on the eConnect service, and select Properties from the drop down menu. In the properties window, go to the “Log On” tab.  


8. Retype the password there and click OK. After clicking OK, right click on the service again and tell it to start again. 

9. If the service still stop, you need to make sure the service user is in the local machine administrators group. In the screenshot above, the user is “eonedemo\Administrator”

10. Click on the Windows + R keys again and in the Run command type in lusrmgr.msc


11. In the Local Users and Groups window, double click on Groups, then double click Administrators. Make sure the service account you found in step 7 is in the Administrators group. If they are not, they need to be added.   


12. After adding them to the Administrators group, right click on the service and select Start.  The service should start and stay running this time. 


Do you have any product features you'd like us to feature on our next Tech Tuesday article? If so please email me at danielle.erickson@eonesolutions.com.