All Connectors ⋅ Microsoft SQL Database Microsoft SQL Database Supports: Microsoft SQL 2005 - Current 3 Minute Video View Live Demo Microsoft SQL Database Connector Overview Frequently Asked Questions Overview SmartConnect for SQL There are thousands of applications that run on top of a SQL server database. SmartConnect makes connecting these applications with all your other business systems an enjoyable task. Integrations can be one way or two way with data coming from and/or writing back into your SQL database. SQL integrations do not require any knowledge of SSIS but rather the ability to locate a SQL table. You are able to select any table, any view or any stored procedure as a data source for a SmartConnect map. You can then write directly back into those SQL tables or to a stored procedure as your destination. The stored procedure option is ideal if you have access to a procedure that contains important business logic for the tables you are updating. Updating SQL tables directly is very powerful but you must also be careful to ensure you are updating only all of the correct fields. Real Time Triggers A SQL based SmartConnect map can triggered real time. SmartConnect creates these triggers for you in SQL so you do not need to be a trigger expert. Real time triggers, scheduled maps or manual maps allow you to ensure that your integration fits in perfectly with your business process. If you need to have an invoice created in your ERP instantly when a record is updated in SQL – that is done with a real time SQL trigger. Frequently Asked Questions Can I use a custom SQL table as a data source? Yes. You are able to use any SQL table as a data source. If you have a custom table, a custom application or any application for which there is no specific connector you can always connect to it with the SQL connector. Can I pass data into a stored procedure? Yes. This is simply achieved by choosing the stored procedure as your destination and mapping the fields to the columns of that procedure. When the map runs, that procedure is executed with the mapped data. If SQL is my source what can I use as a destination? All of our data sources and destinations are mix and match. You can match any source with any destination. So yes, you could write to GP, NAV, Salesforce, Excel, XML or to a web service destination. I know you have specific connectors for GP and NAV - but I know the tables through 20 years’ experience – can I go direct to these tables with SmartConnect? Yes, you can. Reading direct from the tables is a perfectly acceptable method if you know where all the necessary data is. Writing direct to an ERP’s tables is certainly possible but not recommended. By going direct you bypass the business rules of the ERP which may cause larger data issues later on. See For Yourself Signup for the Webinar Do More with MIcrosoft SQL + SMARTCONNECT Build Custom Apps Use SmartConnect as the API engine when creating apps with a SQL backend. Excel Add-in Don't under estimate the power of spreadsheets. Push changes directly to SQL. Real-time Triggers SmartConnect utilizes Real-Time SQL triggers, without the need for a developer. Replicate Cloud Data Pull cloud based data into a local SQL database for backup, reporting or manipulation. CONNECT DYNAMICS CRM TO ALL OF YOUR BUSINESS APPS See how SmartConnect gets Dynamics CRM working together with other platforms including: Salesforce CRM Dynamics GP Xero Cloud ERP Dynamics NAV Web Services Database (ODBC) Dynamics CRM Flat File / Folder Excel Add-In View All Connectors FREE EBOOK DOWNLOADThe 10 Commandments of Data Integration READ IT NOW Free 30 Day Trial Get Started Now © 2016 SmartConnect by eOne Solutions. All Rights Reserved.