What Programming Language Are the Functions Most Similar To?

Posted October 6th, 2008 by ddeveaux

We were looking to build some advanced functions using the pre built query builders but have been having trouble finding people with specific DataTools knowledge. What programming languages would be most similar to the DataTools functions (when transforming data) so we can lessen the learning curve someone may have with this?

‹ Data UpLoader to CSV Text Moving data from SalesForce to MySQL ›

RE: What Programming Language Are the Functions Most Similar To?

On October 6th, 2008 jterrell said:

Hi ddeveaux,

If you are referring to the RIFL scripting language, it is very similar to Visual Basic. You may recognize many of the built-in functions. However, based on over 25 years of data conversion, data migration, and data transformation experience, we have also built some additional functions that perform commonly-encountered data transformations.

If you are referring to the ability to to write query statements on the Source Connection tab and/or the Target Connection tab, the query language you will need to use must "match" the selected connector. For example, if you are writing a query statement on the Source Connection tab to do a table join and filter the source records that are read into the Map Designer from Microsoft SQL Server, your query language must use the SQL Server syntax.

- Jo