Deleted
Deleted Member
Posts: 0
|
Post by Deleted on Sept 3, 2013 6:44:53 GMT
In the tutorial videos, rather than link to an existing sql database, they linked to an excel spreadsheet for the Contact List. While that's great, it seems to me that one would not want to rely on excel to store data in. My question, does OS store data in their own sql files as Alpha does with dbf files or will I have to convert dbf to sql? Alpha will export to excel and I can then read the files but will OS convert the excel to sql?  Thanks a bunch, Ken |
|
|
|
Post by Admin on Sept 3, 2013 10:41:28 GMT
Outsystems connects with any SQL database, or with an Oracle database. Both should be setup on installing the platform, from the Service Center. I am not sure, but I believe that if you do not point towards an already existing database, it will install a variety of its own. But there are many docs on the forum about installing the platform. However, installation is not a breeze as I found out. It seems rather complex.
|
|
Deleted
Deleted Member
Posts: 0
|
Post by Deleted on Sept 3, 2013 13:02:55 GMT
Thanks for the good news. I can hardly wait.
|
|
Deleted
Deleted Member
Posts: 0
|
Post by Deleted on Sept 14, 2013 8:08:37 GMT
Using the Excel data bootstrap function can also be a nice bridge to importing data from Alpha Five (if you have the bad luck to come from there). One way of doing that is to export data from your DBF tables to excel, and use the excel data bootstrap function in OutSystems to import the data into your SQL database. Just did that in the app I am developing with Outsystems and it works like a charm!
However, you can also export from Alpha directly to your SQL database if you have an active DAO connection link. If not, you can create one. But that's another subject.
|
|
Deleted
Deleted Member
Posts: 0
|
Post by Deleted on Sept 24, 2013 7:08:23 GMT
So, the moral of the story is to export it to excel and then import it from excel into OS, correct?
|
|
Deleted
Deleted Member
Posts: 0
|
Post by Deleted on Sept 24, 2013 9:24:16 GMT
Well, that works flawless and takes little work. But you have to do it table by table.
Advantage also is, that you are much more in control what data gets into your tables since you can have a look at the data content each time halfway the process: once exported and before imported, you can look at the data.
I am sure there are more ways to do it, like for instance use the Alpha Five database upgrade scripts that will create your SQL tables for you. It all depends on your situation what is the best way to go. If you have only few tables, I wouldn't be bothered by creating a connection string and what not. I would simply export to excel and use the bootstrap method. If you have MANY tables, well, things can be rather different then.
|
|
