News

Send and Receive Text Messages with Starfish ETL

Using our new Twilio connector, you can use Starfish ETL to orchestrate the sending and receiving of text (SMS) messages. You can also send and receive picture (MMS) messages! Starfish can retrieve messages that are sent to your Twilio number and from there the possibilities are endless. Open support tickets, facilitate sales, customer notifications.. How will you embed texting into your business?

You can also use the Twilio connector to read a historical list of voice calls and to initiate an outbound call for use with their robust automated outbound phone call system. Upgrade to Starfish ETL 3.7 and try it out.

Starfish ETL Named One of Chicago’s Best Business Softwares

G2 Crowd recently listed Starfish ETL among Chicago’s top-rated business software programs based on user satisfaction and market presence. The top companies were determined using G2 Crowd’s first Chicagoland GridScape, which uses real-time visualization of business software products to evaluate each offering.

The system plugged in more than 700 user satisfaction reviews from business professionals. It also used vendor size, social impact, and market share to determine each company’s market presence. G2 Crowd noted that “only products with 10 or more validated reviews were included on the GridScape, as to have a large enough sample size for satisfaction ratings.”

If you visit this page, you can see the scatterplot of companies they assessed. Starfish ETL is among the “high performers” in customer satisfaction.

Here’s G2 Crowd’s ranking of the ten companies:

  1. Sertifi
  2. Sprout Social
  3. Steelbrick CPQ (Disclaimer: Steelbrick is a sister company of G2 Crowd)
  4. SurePayroll
  5. DialogTech
  6. NumXL
  7. ExpressPigeon
  8. Geofeedia
  9. Starfish ETL
  10. Personify Live

Reference: http://www.prnewswire.com/news-releases/who-is-top-in-chicago-tech-g2-cr...

Starfish ETL (Extract, Transform, Load) is a premiere import/export suite of tools that provides seamless integration of data from one database to another, whether hosted, on-premise, or in the cloud. The system is able to integrate with virtually any program from QuickBooks to JD Edward. It can also migrate data between systems without losing or jumbling the valuable information. Migrating without data lose and integrating systems among departments help streamline business processes by connecting employees.

This was G2 Crowd’s first Chicagoland Gridscape. The GridScape tool highlights tech companies of all sizes, including small and growing ones, in the Chicagoland area. As it expands, the information collected will help software purchasers make more informed evaluations of local software businesses.

To learn more about the capabilities of Starfish ETL, visit www.starfishetl.com.

SQLite Xref Support

Starfish now supports using a SQLite database for Cross-Reference (Xref) tracking. This has the advantage of allowing you to read and write an xref in the same job. In addition, if you initialize the xref in append mode, it will append new items to the list but also update records that already exist. With the file system xref lists, records would be duplicated instead of updated. You can initialize the xref and use the append/overwrite checkbox to choose the behavior of the xref list upon write. You can also use database xref lists without initializing them. The default behavior of an un-initialized database xref list is append mode. To enable using the SQLite database, edit the C:\inetpub\wwwroot\StarfishEngine\Web.config file and change UseDatabaseXref to True.

Find more information about Cross-Reference (Xref) tracking in the wiki. We also added a page on how to access newer .accdb Access databases.

If you ever have any questions or topics you want to see on the Wiki, let us know.

New Starfish Installer

We have created a new installation bundle for the Starfish Engine.

StarfishETL uses a SOAP interface that is dependent on Microsoft Internet Information Services (IIS). Starfish requires IIS to be configured and additional folder security permissions be set. Previously users were required to configure IIS manually and set the appropriate folder security permissions. This process was somewhat complex and prone to issues.

We recognized that a lot of issues that our customers were seeing were related to this installation so we set about creating a more robust installation package that would remove the risk of installation failure by removing these manual setup requirements.

The version of StarfishETL that is available for download from our website now uses this new installation bundle.

Users need to install IIS on the machine that is running the Starfish Engine but the new installation bundle handles all the IIS configuration automatically.

Use your File System like a Data Source

New with the latest release of Starfish ETL, you can now treat the files on your hard drive like a data source. Have you ever had to migrate attachments that were simply stored in a structured folder system with no other information? The new File System connector will allow you to set a folder which will be scanned recursively. Each file found will be treated like a row of Origin data.

You'll have information like the subfolder name, file size, including extended information such as version, author and more. Using file operations already built into Starfish ETL, you can then move/copy these files, convert the format and save them in a database, or save them as attachments against records in your CRM system. Give Starfish ETL 3.4 a try now.

Dynamics CRM 2013/2015 Support Added

We've added a number of new features in the latest updates to Starfish ETL version 3.2, including:

  • Support for Microsoft Dynamics CRM 2013 on-premise or on-demand
  • Improvements for calling SQL Server stored procedures
  • Added multi-tenant support to the Scheduler service (to support multiple engines on the same server)
  • Powerful functions to extract the text from files like Word Documents & PDF's
  • Many other bug fixes...

You can view the complete changelog here.

Just a reminder... after installing Starfish ETL, remember to run the "Check for Updates" option to make sure you're not missing out on the latest functionality.

Starfish ETL first to support SugarCRM's new REST interface!

Get a jump start on your next SugarCRM data integration or migration project using Starfish ETL 3.1. Ours is the first (and only) ETL tool on the market with a connector to SugarCRM's newly revamped REST API. It's faster, easier to use and more powerful than the previous SOAP-based API, making it a great improvement for working with data imports & exports. You'll need SugarCRM 7.0 (in beta as of writing this). Full support for oauth2 login, all modules including custom, setting links/relationships. Give the new connector a test drive now.

Supports the powerful new json-based query language. Screenshot shows a sample connection to the Contacts module using a filter.

Announcing Lotus Domino/Notes Connector

Now with Starfish ETL 3.1 you can connect to any IBM Lotus Domino database (NSF file). You can set up integrations with your CRM/ERP system, or migrate data in or out of Notes. Capable of reading and writing to Lotus Notes Mailboxes, Calendars and Tasks. Our connector uses the underlying native data communication methods so security/ACL is enforced throughout. Breath new life into your IBM Lotus investment with Starfish ETL!

Or if you're considering migrating to a different system, we can help! We also have connectors to Exchange, Google/Gmail, Traditional Email (IMAP/POP3) - Try using Starfish ETL to move all your historical data.

Technology Evaluation Centers Provides Insight on Starfish ETL’s Data Migration and Integration Application

Starfish ETL is given a detailed analysis by Technology Evaluation Centers, covering platform benefits, product background and structure, core target markets, and initiatives for the future of the CRM data migration and integration product.

Des Plaines, IL — July 30, 2013 —In the recent Spotlight Report published by Technology Evaluation Centers (TEC), TEC Research Analyst Jorge García covers Technology Advisors’ Starfish ETL data integration and migration platform benefits, product background and structure, core target markets, and exciting initiatives for the future. The Starfish ETL (Extract Transform Load) Suite is Technology Advisors’ integration and migration tool for CRM data.

TEC’s report, titled Starfish ETL Spotlight Report: Simple and Effective CRM Data Integration and Migration, provides a background of Technology Advisors and gives a detailed analysis of Starfish ETL’s general structure, technical and functional expertise, key features, and benefits and considerations. The “Key Features” section includes full descriptions of Starfish ETL’s data migration and transformation capabilities, data mapping process, and pre-built map functionality, along with screenshots of these features.

“It was important to us to get this thorough analysis from an independent research organization like TEC,” said Technology Advisors CEO Sam Biardo. “We believe that the full insight into Starfish from this report will be a very beneficial asset to both customers inquiring about data solutions and us as a vendor.”

“Starfish ETL provides an attractive combination of narrowed expertise for CRM data migration and integration with a collection of easy yet effective transformation tools for reliable data migration,” says García in the report. He goes on to say, “Starfish ETL provides many organizations with an effective integration solution tailored for the non-technical user with an affordable price tag.”

About Technology Advisors
Technology Advisors helps businesses increase sales and marketing productivity and improve their profitability. As a global business and technology consulting company, Technology Advisors specializes in the development of Customer Relationship Management (CRM) process and technology strategies and solutions that make businesses successful, and offers Consulting, Project Management, Support, and Training. Since 1991, the company has enabled over 2,000 businesses to achieve real business results from their CRM initiatives. Headquartered in Des Plaines, IL, Technology Advisors specializes in the Financial Services, Property, Healthcare, Manufacturing, Construction and Professional Services.

For more information, visit http://www.techadv.com, call 1-847-655-3400 or 1 877-TAI-4CRM (toll free in the U.S.) or email info(at)techadv(dot)com.

About TEC
Technology Evaluation Centers (TEC) is the leading advocate for the enterprise software purchaser. Over 2 million decision-makers visit TEC's Web site each month to use the unique decision support system, TEC Advisor™, to access information on hundreds of software solutions and to download objective research and evaluation reports. TEC helps private- and public-sector organizations choose the best enterprise software solutions for their unique business needs—quickly, impartially, and cost-effectively.

About Jorge García
Jorge García is a senior business intelligence (BI) and data management analyst for TEC. He has more than 20 years of experience in all phases of application development, database and data warehouse (DWH) design, as well as 9 years’ experience in project management, covering best practices and new technologies in the BI/DWH space.

Prior to joining TEC, García was a senior project manager and senior analyst developing BI, DWH, and data integration applications with Oracle and SAP Business Objects. He has also worked on projects related to the implementation of BI solutions for the private sector, including the banking and services sectors. He has had the opportunity to work with some of the most important BI and DWH tools on the market.

Easily Integrate your systems with Google Apps

We're happy to release another new connector for Starfish ETL - now you can easily set up systems integrations with Google Apps!  Starfish ETL now has the ability to read all mailboxes and folders from a Gmail account. In addition to mail messages, you can also read and write Calendars, Events, Contacts, Contact Groups, and Documents. With all this functionality, setting up an ongoing sync between Google and your cloud-based CRM system will be cinch! Grab the latest verison of Starfish ETL now. Not technically savvy but need your Google data accessible from your CRM or other in-house system? Not a problem - tell us what you're looking for. Our team of experienced service professionals will quickly provide a quote for any size migration or integration project.

Tons of enhancements to Starfish ETL!

We've been really busy behind the scenes adding features and fixing bugs. Go ahead & apply updates to Starfish ETL today. Here's a rundown of some of the new things we've added in version 2.9...

  • Further improved C# scripting support speed & stability.
  • Starfish now provides a "Stage Action" variable for each stage in your job. This variable can contain "Insert", "Update" or "Delete" - very useful on Update/Insert jobs when you need to evaluation just which course was taken so you can run other conditional logic.
  • Added retry attempts in the case of timeouts or connectivity errors for lookups.
  • Added the ability to point a stage at the Origin. This one is huge - it actually allows you to update a record in your Origin connection. This means now you can perform a series of operations in your Destination, then go back and easily flag a record as "processed" in your Origin, or update a field with the external system's ID in the case of integration work.
  • Added support for uploading attachments to Sage CRM over Web Services. They said it couldn't be done! Well, check it out.. now you can load attachments easily both on-premise and against SageCRM.com environments.
  • Updated Salesforce.com API to the latest (version 26) for improved querying functionality & more.
  • Added better license caching support & fixed validation errors for some Eurpoean countries.
  • Made many improvements to the NetSuite connector for better support of custom fields & record types.

If you have any questions about any of these improvements, don't be shy - join us in the forums or let us know how we can help with your next migration/integration project..

Upload Attachments to SalesLogix using SData

Announcing an important new feature, you can now create and upload attachments within SalesLogix when using the SData connector. What's the significance? Previously you were able to migrate data for all entities except for attachments when using SData. You could import attachments if you had an On Premise deployment of SalesLogix, but if you used the Cloud Edition we could not move attachments. Now thanks to an update in the SData protocol, we can now move all of your files to the Cloud, allowing for more complete migrations from other systems including ACT!, Goldmine, Salesforce and other CRM systems.

Starfish ETL™ is the only ETL tool on the market that supports Sage SData and attachments for SalesLogix.  Give it a try right now!

Pages