Cloud integration for the mid-market.
SmartConnect gives you the ability to connect to your data in your systems, files, databases and via web services from both on premises and cloud applications.
If you’re using a file as your source, simply select your file path and SmartConnect will pull in the columns and data from that source file. SmartConnect can work with many file types – XML, TXT, CSV, TabDilimited, PipeDelimited, Excel, and options are built into easily create your schema file if it’s not already defined.
If you’re connecting a system with a database or directly to a database, you have an easy interface within the SmartConnect Query Builder to simply select the tables and fields, join tables, and restrict data that you need to pass into your map(s).
Select your destination.
Specify where you’d like to generate new data. Choose from the connections you’ve configured to create data in your on-premise applications, cloud applications, or in a file.
Take control of your integration with triggers.
SmartConnect’s intuitive mapping interface has transformed the integration process from a developer experience to an end-user friendly tool set.
Getting started with SmartConnect.com is as easy as logging in. Try it free for 30 days.
Transform your data.
Integration is complex by nature. Rarely are you presented with a perfect set of data. SmartConnect understands that during an integration there are many actions you may need to take before any integration begins. SmartConnect makes this process very simple by providing some easy-to-use tools:
|Library of Functions||Date Formula||Next Number Calculations||Pre-run Validation|
|Calculations||Translation Tables||Entity Tables||Page Lookup|
|SQL Lookups||.Net Scripting||Restrictions||Set Relationships|
SmartConnect allows you to view progress, see what’s been successful and fix what hasn’t. In the SmartConnect Process Errors interface, easily view errors for the transaction lines that failed during your integration(s) –perhaps that's just 5 lines out of 10,000.
Also, see the details in your data for the transaction lines that failed, edit them inline, re-process those transaction lines, and save the changes to a file.
Easily fix errors in both the SmartConnect Windows client and the webclient. The SmartConnect Error Processing allows you to easily see the individual documents that failed, edit them, save changes to a file, and re-process those documents (transaction lines).
Include other processing steps when they need to happen. For example, when something fails, send an email to notify your team.