Forums

Find answers, ask questions, and connect with our
community all around the world.

Home Forum Omnis forum Database converter DF1, DF2 and DF3

  • Database converter DF1, DF2 and DF3

    Posted by Nate on March 31, 2020 at 11:16 am

    Hi Everyone
    I’m new to Omnis, I am designing a data warehouse and require to ingest data from the Omnis system .The IT department gave me access to a folder that has DF1, DF2 and DF3 data files.
    Is there anyway to convert these to CSV or My Sql. Due to our country lockdown will be difficult to get any approvals, so I require free solution.
    Much appreciated
    Nate

    Gary Ashford replied 7 months, 4 weeks ago 2 Members · 1 Reply
  • 1 Reply
  • Gary Ashford

    Member
    March 31, 2020 at 11:55 am

    Hi Nate.
    You can use an evaluation copy of Omnis Studio to copy the data from the Omnis data file into a MySQL database. Using the SQL Browser utility, you create an OMNISSQL session that connects to the data file (.DF1) and a MYSQL session that connects to your MySQL database. Open both sessions. You can then use drag and drop to copy whole tables directly over to MySQL. If you want continued access to MySQL after the trial period expires, it will require a standard developer license I believe.
    Gary

Log in to reply.