topic ¿How do i connect to a .DAT database? in QlikView https://community.qlik.com/t5/QlikView/How-do-i-connect-to-a-DAT-database/m-p/310130#M114513 <HTML><HEAD></HEAD><BODY><P>Good afternood everyone. </P><P></P><P>We are currently extracting information directly from a SQL database. Obviously, we have no problem doing this. The problem came when we tried to connect into a database, which is in .DAT format. ¿There are some kind of OLEDB/ODBC connector, special for a .DAT database? ¿How we can extract the tables?</P><P>¿There's a more simpler way to do that, a .DAT extraction?</P><P></P><P>Thanks in advance!!!</P><P></P><P>EDIT: My bad. We tought that the .DAT were databases, but they're tables. Each .DAT is a table. Anyway, we tried to extract them directly from the Data From Files - Table Files, but QlikView camn't read them. Supossedly, the system generates the .DAT files, but it generates them with a lot of garbage. ¿Anyone hs ever tried to extract a .DAT file? ¿Do you know if this is a QlikView Problem?</P><P></P><P>El mensaje fue editado por: edermachado</P></BODY></HTML> Wed, 22 Feb 2012 21:43:58 GMT 2012-02-22T21:43:58Z ¿How do i connect to a .DAT database? https://community.qlik.com/t5/QlikView/How-do-i-connect-to-a-DAT-database/m-p/310130#M114513 <HTML><HEAD></HEAD><BODY><P>Good afternood everyone. </P><P></P><P>We are currently extracting information directly from a SQL database. Obviously, we have no problem doing this. The problem came when we tried to connect into a database, which is in .DAT format. ¿There are some kind of OLEDB/ODBC connector, special for a .DAT database? ¿How we can extract the tables?</P><P>¿There's a more simpler way to do that, a .DAT extraction?</P><P></P><P>Thanks in advance!!!</P><P></P><P>EDIT: My bad. We tought that the .DAT were databases, but they're tables. Each .DAT is a table. Anyway, we tried to extract them directly from the Data From Files - Table Files, but QlikView camn't read them. Supossedly, the system generates the .DAT files, but it generates them with a lot of garbage. ¿Anyone hs ever tried to extract a .DAT file? ¿Do you know if this is a QlikView Problem?</P><P></P><P>El mensaje fue editado por: edermachado</P></BODY></HTML> Wed, 22 Feb 2012 21:43:58 GMT https://community.qlik.com/t5/QlikView/How-do-i-connect-to-a-DAT-database/m-p/310130#M114513 2012-02-22T21:43:58Z